July 15th, 2013, 03:34 AM
Join Date: Jul 2013
Time spent in forums: 31 m 30 sec
Reputation Power: 0
MySQL table recovery
Originally Posted by robshanksgbr
I have a server in which the hard drive failed and the only backup of the MySql installation and databases is via Windows back up.
I have run the recovery process and reinstalled MySql.
Now when I open a database and run 'show tables;' the tables are listed:
mysql> show tables;
| Tables_in_iptv |
| channel |
| lan |
| park |
| preferences |
| stb |
| streamer |
| theme |
7 rows in set (0.00 sec)
However, if I know 'select * from channel;' i get:
mysql> select * from channel;
ERROR 1146 (42S02): Table 'iptv.channel' doesn't exist
I have read a lot on Google but have been unable to fix using the method of copying ibdata1 file etc.
Does anybody have any hints or is anyone able to help? E.g. I'll send you the data folder you send my a sql dump file for suitable recompense?
Any help advice greatly received.
Well, MySQL database table is affected due to hard drive failure and you need to repair your data with SQL repair software. Alternate solution is to download Recover Data SQL repair software to repair original table corrupted during hard drive failure with error free application.
Recover Data Team