Recently I was backing up a large MySql database (several hundred megabytes), using the awesome MySqlHotCopy script, when I started getting the following error:
DBD::mysql::db do failed: MySQL server has gone away at mysqlhotcopy line 528.
I have no clue what that error means. mysqlhotcopyworked great on all of my other smaller databases. I did a little searching on my old friend google, and after sniffing around a bit, I came up with a resolution to the problem… the script was timing out, so I just had to increase the allowed time in the /etc/my.cnf file.
Here are the steps I took
add these lines to the file:
interactive_timeout = 3600
wait_timeout = 3600
I ran mysqlhotcopy again, and everything worked and the backup was made.