Page 1 of 1

Can't dump database, Couldn't read status!

Posted: Thu Dec 10, 2015 12:49 am
by cluppeer
Hi guys,

I got a problem with cron job auto backup. I even tried to drop the table on phpmyadmin, but no luck. It shows the name of table left column, and right column does not show the table. Repairing tables working for all except "wp_wfNet404s".
Written below:

Can't dump database admin_blabla
Error: Couldn't read status information for table wp_wfNet404s ()
mysqldump: Couldn't execute 'show create table `wp_wfNet404s`': Table 'admin_blabla.wp_wfNet404s' doesn't exist (1146)

I will be glad if anyone can help me.

Thanks

Re: Can't dump database, Couldn't read status!

Posted: Thu Dec 10, 2015 1:02 pm
by cluppeer
any solution?

Re: Can't dump database, Couldn't read status!

Posted: Fri Dec 11, 2015 11:47 pm
by cluppeer
so nobody has this problem before?
awesome vesta!

Re: Can't dump database, Couldn't read status!

Posted: Mon Dec 14, 2015 7:47 am
by skurudo
cluppeer wrote:any solution?
Main idea:

Code: Select all

mysqlcheck --repair

Re: Can't dump database, Couldn't read status!

Posted: Mon Dec 14, 2015 7:50 am
by skurudo
cluppeer wrote:so nobody has this problem before?
awesome vesta!
It's local problem on your server.
VestaCP honestly tryed to backup your database, but you need check and repair it first.

Re: Can't dump database, Couldn't read status!

Posted: Thu Feb 11, 2016 5:43 am
by restless
You can try deactivating Wordfence and deleting the Wordfence tables.
If the table 'wp_wfNet404s' can't be deleted through phpmyadmin, you can use mysql from the command line and delete the offending tables manually.
  • Manually from CLI
  • Connect into your server via SSH
  • Run mysql
  • Backup database
  • mysql>use admin_blabla;
  • mysql>DROP TABLE wp_wfNet404s;
I had an issue with 'wp_wfVulnScanners' as well, so I had to drop that table manually too.

Re: Can't dump database, Couldn't read status!

Posted: Sun Mar 13, 2016 1:30 pm
by cluppeer
thanks for the answer bro..