Errors while restoring MySQL dbs
Hi folks,I configured my server to backup all accounts every day using cpanel. one day, a customer asked me to restore yesterday's backup. everything went ok except some mysql dbs.
While trying to figure out the reason, I found there were errors in dumping some mysql tables as stated in the cron daemon email.
Here are some errors taken from the cron email.
Code:
Grabbing mysql dbs.../usr/bin/mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `post` at row: 11874 Grabbing mysql dbs.../usr/bin/mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `pmtext` at row: 184 Grabbing mysql dbs.../usr/bin/mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `template` at row: 234
should I run a cron to check all mysql dbs before running the backup script?
Regards,
Bueno