Jump to content

[SOLVED] Databases empty?


Guest

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/162901-solved-databases-empty/
Share on other sites

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?

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!

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.