When i try to restore a MySQL database, i get following error. [root@server2 ~]# mysql sok_wp < /var/www/sok_wp.sql ERROR 2006 (HY000) at line 348: MySQL server has gone away [root@server2 ~]# To fix the error, edit file /etc/my.cnf.d/my.cnf Add max_allowed_packet=64M Restart MySQL service mysql restart if using mariadb, run service mariadb restart MySQL
MySQL Installation MySQL User Management MySQL Optimize MySQL Backup/Restore MYSQL Commands MySQL Utils MySQL GUI MySQL Errors
vi ~/.my.cnf Add following content [client] user = root password = “DBPASSWORD” [mysqladmin] user = root password = “DBPASSWORD” [mysqldump] user = root password = “DBPASSWORD” Replace DBPASSWORD with your MySQL root password. Now set permission for this file to 600, so no user other than root can see it. chmod 600 ~/.my.cnf
On a server, starting MySQL i get following error [root@3blogger log]# cat mysqld.log 170102 21:34:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2017-01-02 21:34:02 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use –explicit_defaults_for_timestamp server option (see documentation for more details). 2017-01-02 21:34:02 0 [Note] /usr/sbin/mysqld (mysqld 5.6.24-72.2) starting as process 8048 … Read more
When repairing a large database, i got following error [root@server root]# myisamchk –silent –force –fast –update-state \ –key_buffer_size=64M –sort_buffer_size=64M \ –read_buffer_size=1M –write_buffer_size=1M /var/lib/mysql/databasename/*.MYI -bash: /usr/bin/myisamchk: Argument list too long To fix the error, run SOLUTION 1 find /backup/mysql/bizhat_s2 -type f -print0 -name ‘*.MYI’ | xargs -0 myisamchk –force –fast –update-state –key_buffer_size=64M –sort_buffer_size=64M –read_buffer_size=1M –write_buffer_size=1M SOLUTION … Read more