I was getting the following errors when I was trying to restore a Request Tracker MySQL database in linux (Ubuntu to CentOS).<\/p>\n
ERROR 2006 (HY000): MySQL server has gone away
\nNo connection. Trying to reconnect…
\nConnection id: 10
\nCurrent database: rt4<\/p>\nERROR 2006 (HY000): MySQL server has gone away
\nNo connection. Trying to reconnect…
\nConnection id: 11
\nCurrent database: rt4<\/p>\nERROR 2006 (HY000): MySQL server has gone away
\nERROR 2006 (HY000): MySQL server has gone away
\nNo connection. Trying to reconnect…
\nConnection id: 12
\nCurrent database: rt4<\/p><\/blockquote>\nThese errors came later in the restore:<\/p>\n
ERROR 1231 (42000): Variable ‘time_zone’ can’t be set to the value of ‘NULL’
\nERROR 1231 (42000): Variable ‘sql_mode’ can’t be set to the value of ‘NULL’
\nERROR 1231 (42000): Variable ‘foreign_key_checks’ can’t be set to the value of ‘NULL’
\nERROR 1231 (42000): Variable ‘unique_checks’ can’t be set to the value of ‘NULL’
\nERROR 1231 (42000): Variable ‘character_set_client’ can’t be set to the value of ‘NULL’
\nQuery OK, 0 rows affected (0.00 sec)<\/p>\nERROR 1231 (42000): Variable ‘collation_connection’ can’t be set to the value of ‘NULL’
\nERROR 1231 (42000): Variable ‘sql_notes’ can’t be set to the value of ‘NULL’\n<\/p><\/blockquote>\nTo get the database restored, I had to change the maximum allowed packet setting.<\/p>\n
The best way to do that is to add the following line to the [mysqld] section of the my.cnf (CentOS: \/etc\/my.cnf or Ubuntu: \/etc\/mysql\/my.cnf):<\/p>\n
max_allowed_packet = 16M<\/p><\/blockquote>\n
Then, restart your MySQL service.
\nUbuntu: service mysql restart
\nCentOS: service mysqld restart<\/p>\nNow, I did this on both of my servers, then I could use my regular backup script and the setting would be picked up by the my.cnf. However, you can do the backup with option enabled if it is not in your my.cnf by using something like the following:<\/p>\n
mysqldump $thedb –user=”myid” –password=”$SQLPWD” –max_allowed_packet=16M > $thedb.sql<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"
I was getting the following errors when I was trying to restore a Request Tracker MySQL database in linux (Ubuntu to CentOS). ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect… Connection id: 10 Current database: rt4 ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect… Connection [&hellip<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[343,342,340,341,248,98],"class_list":["post-1012","post","type-post","status-publish","format-standard","hentry","category-documentation","tag-343","tag-342","tag-backup","tag-error","tag-mysql","tag-restore"],"share_on_mastodon":{"url":"","error":""},"_links":{"self":[{"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/posts\/1012","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1012"}],"version-history":[{"count":1,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/posts\/1012\/revisions"}],"predecessor-version":[{"id":1013,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/posts\/1012\/revisions\/1013"}],"wp:attachment":[{"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1012"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1012"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1012"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}