July 13th, 2013, 09:14 AM
Innodb database recovery after server hard drive failure
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.
July 15th, 2013, 02:34 AM
MySQL table recovery
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.
Originally Posted by robshanksgbr
Recover Data Team