Guest Posted June 19, 2009 Share Posted June 19, 2009 Hi, A couple of our databases seem to have emptied overnight... In phpMyAdmin they dont have the (x) with the amount of tables after their name - only on a few dbs though. In /opt/lampp/var/mysql/mybrokendatabase (we use lampp) there are all the files, in total taking up the correct amount of space. Is there any way I can correct whatever has gone wrong here? Didn't find much on Google, seems mainly how to empty/drop databases... Thanks, Josh Quote Link to comment Share on other sites More sharing options...
GingerRobot Posted June 19, 2009 Share Posted June 19, 2009 Well...the obvious question is: do you create regular backups? Quote Link to comment Share on other sites More sharing options...
Guest Posted June 19, 2009 Share Posted June 19, 2009 Yes, but not nightly. I've got it mostly back from a backup, but theres the odd row here and there that changed yesterday. I was really wondering if I can salvage any of it from all the .frm .MYD .MYI etc files I have for it. Hopefully someone may have had this problem before and know a way to sort it? Quote Link to comment Share on other sites More sharing options...
fenway Posted June 22, 2009 Share Posted June 22, 2009 Well, you can run check tables and see what's going on... but make backups first. Quote Link to comment Share on other sites More sharing options...
Guest Posted June 22, 2009 Share Posted June 22, 2009 I used check tables etc, and found the error to be it couldn't find the correct .frm files - but they were still there. I tried resetting the permissions - this worked, but only when I set full permissions for everyone, which led me to think maybe mysqld had been started as the wrong user, but lampp manages that so im not sure... Anyway, it works now. Thanks for the suggestions! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.