MySQL Forums
Forum List  »  InnoDB

Recovery
Posted by: steve IMHOF
Date: July 15, 2016 06:01AM

Hey all.

Been struggling for 24 hours. mysql crashed on my server during the night. Not sure why. 2gb of Ram and small websites. 250mb swap on my vps.

I did a clean install on my centos 7 system of mysql. And I saved all of my databases in the /var/lib/mysql directory by renaming the dir to /var/lib/mysqlold. I copied all the old directory into the new mysql directory. Mypgpadmin shows all the tables and data. But I cant access the data on my websites.

This is what the error log shows;
2016-07-15 07:33:41 21045 [Warning] InnoDB: Cannot open table 1waytofindout/magsales_bestsellers_aggregated_yearly from the internal data dictionary of InnoDB though the .frm file for the table exists.

I feel like I am close since I can see all the tables and data in phpmyadmin.

Any guidance would be really appreciated.

Options: ReplyQuote


Subject
Views
Written By
Posted
Recovery
1534
July 15, 2016 06:01AM
936
July 15, 2016 10:12AM
728
July 15, 2016 12:35PM
796
July 15, 2016 12:50PM
803
July 15, 2016 12:51PM
890
July 15, 2016 12:16PM
1172
August 23, 2016 12:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.