Hi, List,
Recently I got a very rare database issue, it says:
- Error: Couldn't read status information for table clients_copy ()
- mysqldump: Couldn't execute 'show create table `clients_copy`': Table 'adm_retail.clients_copy' doesn't exist (1146)
- Error: Couldn't read status information for table dt_mx_emp ()
- mysqldump: Couldn't execute 'show create table `dt_mx_emp`': Table 'adm_retail.dt_mx_emp' doesn't exist (1146)
- Error: Couldn't read status information for table materialized_views ()
- mysqldump: Couldn't execute 'show create table `materialized_views`': Table 'adm_retail.materialized_views' doesn't exist (1146)
- Error: Couldn't read status information for table adm_data_mo ()
- mysqldump: Couldn't execute 'show create table `adm_data_mo`': Table 'adm_retail.adm_data_mo' doesn't exist (1146)
- Error: Couldn't read status information for table temp ()
- mysqldump: Couldn't execute 'show create table `temp`': Table 'adm_retail.temp' doesn't exist (1146)
- Error: Couldn't read status information for table area ()
Actually all these tables are existed, but no matter what I did on them like check and repair, mysql says
doesn't exist, I've tried the following ways to fix it:
1, restart the database
2, check the myisam table status, all looks fine, but the innodb ones are messing.
3, google around - got no luck
Anyone here can give me a hand please? Appreciated for any input as it's really an urgent issue