...
Leave mysql shell prompt with
exit;
Configure MySQL
| Anchor | ||||
|---|---|---|---|---|
|
In general you will find the mysql configuration in "/etc/mysql/my.cnf" or a similar file.
Not allowed SQL Modes
The following SQL Mode must not be set: ONLY_FULL_GROUP_BY, NO_ZERO_IN_DATE, NO_ZERO_DATE, STRICT_TRANS_TABLES
To achieve this, you can add / change the following setting to your mysql configuration file:
sql_mode = "NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"See http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html for further information.
Binary Logging and unprivileged DB users
If you are connecting translate5 with an unprivileged (non root) user to the Database, please ensure that no binary logging or the less safe option "log_bin_trust_function_creators" is set.
To set it just add
log_bin_trust_function_creators = 1 to your mysql config file.
See https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html for further information.
InnoDB files per table
Also it It is recommended to enable the mysql config innodb_file_per_table so that each Table is stored in an own file. This is very useful if you plan to import many huge projects.
You find Instructions for that in the MySQL documentation and in the cpanel forum.
MySQL gone away errors on import
It is also recommended to increase the config value max_allowed_packet to a higher value if you try to import bigger files, especially when you receive MySQL gone away errors on import.
...