#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2013
    Posts
    1
    Rep Power
    0

    Innodb database recovery after server hard drive failure


    Hi all

    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.

    Thanks

    Rob
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2013
    Posts
    1
    Rep Power
    0

    MySQL table recovery


    Originally Posted by robshanksgbr
    Hi all

    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.

    Thanks

    Rob
    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

IMN logo majestic logo threadwatch logo seochat tools logo