Backup database errors

[solcomputers]

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]

Hi,

There are few possible reason of this error:

1. Permission and ownership on tables files in /var/lib/mysql is not correct, ideal ownership should be to mysql user and permission 660.
2. table not exist, can be checked using below commands.
3. table created in uppercase, set lower_case_table_names as per your application requirement.
4. 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]

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]

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:

InnoDB Corruption Repair Guide

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:

System Administration Services | cPanel Forums

Thank you.