InnoDB error, please help

Comments

• Falzo Member

  May 2016

  no.
• david_W Member

  May 2016

  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..
• LiteServer Member, Patron Provider

  May 2016

  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
• Falzo Member

  May 2016

  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
• danigeamanu Member

  May 2016

  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
• danigeamanu Member

  May 2016

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