Backup database errors

I keep getting these errors on my server. "The backup process completed, but 6 errors occurred." This might have been because of unplanned downtime last year when the motherboard was replaced. In /var/lib/mysql/ I appear to be missing the relevant .ibd files but have .frm files. How can I restore the database tables going ahead?


The backup process encountered the following errors:

[2018-02-11 02:05:22 +0100] granalac_svcs: mysqldump: Got error: 1146: Table 'granalac_svcs.gas_wfNet404s' doesn't exist when using LOCK TABLES

warn [pkgacct] granalac_svcs: mysqldump: Got error: 1146: Table 'granalac_svcs.gas_wfNet404s' doesn't exist when using LOCK TABLES

[2018-02-11 02:44:48 +0100] solcomps_wp1: mysqldump: Got error: 1146: Table 'solcomps_wp1.scb_wfHoover' doesn't exist when using LOCK TABLES

warn [pkgacct] solcomps_wp1: mysqldump: Got error: 1146: Table 'solcomps_wp1.scb_wfHoover' doesn't exist when using LOCK TABLES

[2018-02-11 03:12:09 +0100] cbfmradi_cp: mysqldump: Got error: 1146: Table 'cbfmradi_cp.cp_wfBadLeechers' doesn't exist when using LOCK TABLES

warn [pkgacct] cbfmradi_cp: mysqldump: Got error: 1146: Table 'cbfmradi_cp.cp_wfBadLeechers' doesn't exist when using LOCK TABLES

24x7server

February 12, 2018 04:09

Hi, There are few possible reason of this error:

Permission and ownership on tables files in /var/lib/mysql is not correct, ideal ownership should be to mysql user and permission 660.
table not exist, can be checked using below commands.
table created in uppercase, set lower_case_table_names as per your application requirement.
table is corrupt, repair the table.

For example: root : ~> # mysql mysql> use cbfmradi_cp mysql> show tables; Check if table cp_wfBadLeechers exists. Also, use --skip-lock-tables parameter with mysqldump to skip lock tables, check if that dumps the database properly..

solcomputers

February 12, 2018 16:51

Hi, 1. mysql is the owner of /var/lib/mysql, permission is 0751. 2. The tables appear to exist when running show tables against the affected databases. 3. Think this is ok. 4. I've already tried repairing the database tables with phpmyadmin without success. These databases were all converted to InnoDB a while ago and I have the .frm files for them, but not the .ibd files. Can I recreate the tables from the .frm files?

cPanelMichael

February 14, 2018 19:49

These databases were all converted to InnoDB a while ago and I have the .frm files for them, but not the .ibd files. Can I recreate the tables from the .frm files?

Hello, You could try repairing InnoDB using the guide at: However, if data was lost, it's possible you may need to recreate those tables with help from the developers of the scripts they are associated with. We provide a list of companies offering system admin services if you need help doing that: Thank you.

Backup database errors

Comments

Didn't find what you were looking for?