Richard G
Verified User
Lately I've seen some errors when doing the custombuild update. Today I was able to scroll back almost enough and could see which database it was.
It has a ton of errors when doing the mysqldump and eventually fails.
This is part of the error code which I could retrieve from my SSH screen.
and a lot more of these, but if I try to put them in the post here, I get a forum error, odd enough.
Anyway much more of the same and this is at the end:
Last time also the error was "server has gone away" while mysql was not stopped yet and other databases are dumped correctly after this error, so it does not seem a server issue.
It seems only this database. I tried the check option from within DA on this database which says OK on all tables except this one:
so that does not support check.
When trying the repair option it does this:
I do see the database has 2 users, but I think one isn't used anymore (I checked the wp-config file).
When trying to reproduce the error using da_admin and the da_admin password for mysql via commandline mysqldump, this error appears:
When checking a dump of 13mb is created, however, most likely not complete.
Same happens when using the user credentials.
How can I fix this issue?
It has a ton of errors when doing the mysqldump and eventually fails.
This is part of the error code which I could retrieve from my SSH screen.
Code:
Dumping database krco_wp979
mysqldump: Error 2013: Lost connection to server during query when dumping table `wp_wfconfig` at row: 226
mysqldump: Couldn't execute 'SELECT engine, table_type FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'wp_wfcrawlers'': Server has gone away (2006)
mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': Server has gone away (2006)Anyway much more of the same and this is at the end:
Code:
mysqldump: Got error: 2006: "Server has gone away" when selecting the database
mysqldump: Couldn't execute 'UNLOCK TABLES': Server has gone away (2006)
BACKUP OF krco_wp979 FAILED!Last time also the error was "server has gone away" while mysql was not stopped yet and other databases are dumped correctly after this error, so it does not seem a server issue.
It seems only this database. I tried the check option from within DA on this database which says OK on all tables except this one:
Code:
krco_wp979.wp_wfls_role_counts check note The storage engine for the table doesn't support checkWhen trying the repair option it does this:
I do see the database has 2 users, but I think one isn't used anymore (I checked the wp-config file).
When trying to reproduce the error using da_admin and the da_admin password for mysql via commandline mysqldump, this error appears:
Code:
mysqldump: Error 2013: Lost connection to server during query when dumping table `wp_wfconfig` at row: 226When checking a dump of 13mb is created, however, most likely not complete.
Same happens when using the user credentials.
How can I fix this issue?