Page 1 of 1

MySQL Error When Running a Backup

Posted: 18 Oct 2017 16:21
by kcargin
First of all, this is probably not a bug. I just need help.

When I run "sudo /usr/local/sbin/EFA-Backup -backup" I get the following error:
mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `bayes_token` at row: 2384678

Any suggestion on how to truly get 100% backups? I assume that the bayes_token table is corrupt - is there a solution to repair this table or is it needed?

Thanks in advance for your assistance!

- Kaleb

Re: MySQL Error When Running a Backup

Posted: 19 Oct 2017 06:18
by pdwalker
Look through your mysql logs and see if you can pull out the error message related to this.

I suspect corruption of your mysql database.

Re: MySQL Error When Running a Backup

Posted: 20 Oct 2017 15:27
by kcargin
Found this line at the end of my mysqld.log file:
2017-10-20 7:57:24 140631717247744 [ERROR] mysqld: Table './efa/tokens' is marked as crashed and should be repaired

Re: MySQL Error When Running a Backup

Posted: 20 Oct 2017 16:42
by pdwalker
So you'll need to do a table repair to correct the problem. One the issue is fixed, you should be able to run your backups to completion.