Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


InnoDB error, please help
New on LowEndTalk? Please Register and read our Community Rules.

All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.

InnoDB error, please help

xrzxrz Member

Is there a way to fix?
in mysql.log:

2016-05-03 21:22:08 27939 [Warning] InnoDB: Cannot open table blah/bleh from the internal data dictionary of InnoDB though the .frm file for the table exists.

Comments

  • FalzoFalzo Member

    no.

  • david_Wdavid_W Member

    If you have a backup, may need to drop and re-create the table.

    BTW - LET is not a good place for this kind of question..

  • LiteServerLiteServer Member, Patron Provider

    Does MySQL start? Or goes the service in some sort of loop?
    In case MySQL refuses to start, you can try InnoDB recovery mode. If it starts that way, take a dump (backup) of the database in question. When you're able to create a database dump, stop MySQL and remove the innodb files regarding that specific database manually (I'd recommend to move the file to a temporarily location in cast you need them again).
    Try to start MySQL. If that works, create a new database and import your database dump that you created earlier.

    More info about InnoDB recovery mode:
    http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html

  • FalzoFalzo Member

    http://lmgtfy.com/?q=Cannot+open+table+from+the+internal+data+dictionary+of+InnoDB+though+the+.frm+file+for+the+table+exists

    first hit: http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html

    read!

    In the error log you can find a message like this:

    >

    InnoDB: Cannot find table test/child2 from the internal data dictionary

    InnoDB: of InnoDB though the .frm file for the table exists. Maybe you

    InnoDB: have deleted and recreated InnoDB data files but have forgotten

    InnoDB: to delete the corresponding .frm files of InnoDB tables?

    >

    This means that there is an orphan .frm file without a corresponding table inside >InnoDB. You can drop the orphan .frm file by deleting it manually.

    Thanked by 1raindog308
  • Do you have any backup for that server?
    If yes, put back the files from backup to the mysql folder. After that edit the file /etc/my.cnf and add the line: innodb_force_recovery = 4

  • Can you give us the last part from your mysql err file?

Sign In or Register to comment.