ERROR 2006 (HY000) at line 348: MySQL server has gone away
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…
mysql
MySQL
MySQL Installation MySQL User Management MySQL Optimize MySQL Backup/Restore MYSQL Commands MySQL Utils MySQL GUI MySQL Errors
Configuring MySQL .my.cnf
vi ~/.my.cnf Add following content [client] user = root password = “DBPASSWORD” [mysqladmin] user = root password = “DBPASSWORD” [mysqldump] user =…
InnoDB: space header page consists of zero bytes in tablespace
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…
myisamchk: Argument list too long
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…