Database table corrupt – can’t access backend
-
Hello,
I was doing CSV product upload on my site and it crashed during the upload. Now I can’t access the backend and at some stage I was able to log in but the backend was extremely slow. The website’s frontend is fine though, loads very fast, but the admin panel takes few minutes to load, sometimes doesn’t load at all and shows an MySQL error or Internal Database Error instead, getting these errors while trying to log in:
Warning: Error while sending QUERY packet. PID=xxxxxx in /xxxxx/xxxxxx/public_html/wp-includes/wp-db.php on line 1879
Warning: mysql_query(): MySQL server has gone away in /xxxxx/xxxxxx/public_html/wp-includes/wp-db.php on line 1879
Warning: mysql_query(): Error reading result set’s header in /xxxxx/xxxxxx/public_html/wp-includes/wp-db.php on line 1879
Warning: Cannot modify header information – headers already sent by (output started at /xxxx/xxxxxx/public_html/wp-includes/wp-db.php:1879) in /xxxx/xxxxxx/public_html/wp-includes/pluggable.php on line 1179
I did the check of the db tables in phpMyAdmin and one of the tables shows “corrupt” another one “Table is marked as crashed and last repair failed” and the third one “Found xxx keys of xxxxxxx”. That happened most likely after the unsuccessful csv upload. I am attaching printscreen of the db check results. Please let me know if I can safely try to repair the database through phpMyAdmin, I do not want to make it worse. If the db repair won’t help what steps should I take to regain admin panel access in that situation?
-
I run the mysqlcheck on this particular table and got the same result as doing this on phpmyadmin
warning : Table is marked as crashed and last repair failed
error : Found xxx keys of xxxxxxx
error : Corrupt
BTW: I used this command:
mysqlcheck -c dbname dbtable -u user -p
What should I do next? Is there any other command I could use?
- The topic ‘Database table corrupt – can’t access backend’ is closed to new replies.