Backup Error

[ORiN]

I am getting this lately during daily backups. I checked for the table but it really doesn't exist anymore.

Error while backing up database admin_inspireo
mysqldump error output: mysqldump: Got error: 1146: Table 'admin_inspireo.wp_wfNet404s' doesn't exist when using LOCK TABLES

Any help is much appreciated.

 

[zEitEr]

Hello,

Check in SSH whether or not you have any files with that name

CentOS:

ls -la /var/lib/mysql/admin_inspireo/wp_wfNet404s*

Debian:

ls -la /home/mysql/admin_inspireo/wp_wfNet404s*

and/or try to run this:

mysqlcheck --defaults-extra-file=/usr/local/directadmin/conf/my.cnf --auto-repair --optimize --all-databases;

More reading: http://www.linux.org/threads/resolving-mysql-error-1146-table-doesnt-exist-when-doing-backup.2480/

 

[ORiN]

Hello,

Check in SSH whether or not you have any files with that name

CentOS:

ls -la /var/lib/mysql/admin_inspireo/wp_wfNet404s*

Debian:

ls -la /home/mysql/admin_inspireo/wp_wfNet404s*

and/or try to run this:

mysqlcheck --defaults-extra-file=/usr/local/directadmin/conf/my.cnf --auto-repair --optimize --all-databases;

More reading: http://www.linux.org/threads/resolving-mysql-error-1146-table-doesnt-exist-when-doing-backup.2480/

Thanks, Alex.

Managed to remove the tables using the link you provided.