2 of 3 mysql databases wiped out

2 of 3 mysql databases wiped out, mysql database tables "do not exist" all of a sudden (3 Replies, Read 3711 times)

bradley2083	January 30, 2014, 9:35 pm
Group: Member Post Group: Newbie Posts: 1 Status:	Hi, guys. I am working on a few sites locally using AMPPS. Yesterday, everything was working great. I started my mac this morning and went to fire up AMPPS and only Apache would run (mysql would not). I came across a solution to set innodb_force_recovery = 1 in the my.cnf file, which worked (I was then allowed to connect to mysql). I removed this line from the my.cnf file and resaved it and that is all great. BUT... Of my three databases, only one of them actually works. The table names appear within all three databases; however, within the two broken databases, if I click a table, there is no data and I receive an error that the table does not exist. When I look in the /ampps/var/ folder on my mac, I see the database folders for all three databases. The only difference I can see from the database that is working and the two that are not is that the one that is working has frm, MYD and MYI file types whereas the two broken databases only have frm and ibd. I have no idea what happened as it was working great yesterday and I did not change anything from my using ampps yesterday to today (I did notice a release for ampps today, are those updates automatic? if so, could that be it?). Would love any help you can provide on how I can restore my two broken databases, thank you!
IP: --

Users viewing this topic
	1 guests, 0 users.