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.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Comments
no.
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..
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
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!
>
>
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?