Starting from CafeTran Espresso 2016 Ichiro - update 19, there exists an option to store and recall translation memories via the popular client-server MySQL database. This is a recommended solution for a central database system serving numerous clients on the network or with the storage and recall of very large translation memories consisting of several million segments.
1. Download from here and install MySQL database for your operating system.
2. Locate the Java driver file under MySQL database installation directory. The file's name is mysql-connector-java-5.1.39-bin.jar and it is usually located in Connector.J 5.1 folder. The driver's version number may differ.
3. Run CafeTran and then drag and drop mysql-connector-java-5.1.39-bin.jar file onto the Dashboard panel. Alternatively, you can install the driver file via CafeTran's Help > About > Install update button.
4. Create a new database as per MySQL tutorial instructions.
5. In CafeTran, go to Edit > Preferences > General tab > Database connection: and select MySQL from the drop-down list. Then click the "Database connection:" button and edit the following fields:
- User name (provide your database user name)
- Password (provide your database password)
- Connection URL (substitute "my_database_name" part of the URL with your real database name and change the host and/or port number if necessary)
- It may be necessary to append "&serverTimezone=UTC" to the Connection URL (for the latest MySQL database version)
On Linux operating system, you can use MariaDB database as MySQL replacement. The Java driver/connector .jar file to download starts with 'mariadb-java-client' name.
The localhost:3306 is the default value for the host and port number of your MySQL database installation.
- If you connect to MariaDB database on Linux operating system, change the Driver class name from: com.mysql.jdbc.Driver org.mariadb.jdbc.Driver
6. Press OK and restart CafeTran. Total Recall should be ready to work with MySQL database.