MySQL, some tables disapeared
Moderator: General Moderators
-
Starcraftmazter
- Forum Commoner
- Posts: 45
- Joined: Mon Apr 24, 2006 11:36 pm
MySQL, some tables disapeared
Hello.
In my phpbb forums database, I have woken up to find out that several (7 I think) tables have disappeared mysteriously.
They are phpbb_config ; confirm ; disallow ; forums ; forums_prune ; posts, and I haven't found the other one for some reason, but I'm in a bit of a rush.
Anywho, I thought the tables crashed or something, but phpmyadmin is being unbearably slow plus I don't know how to check, and for some reason couldn't find anything on the net about crashed tables/databases.
Anyway, I don't want to rush into anything, if the data can somehow be recovered.
I have root access to the serve, and a backup which is 9 days old.
Does anyone have any suggestions?
Thanks!
In my phpbb forums database, I have woken up to find out that several (7 I think) tables have disappeared mysteriously.
They are phpbb_config ; confirm ; disallow ; forums ; forums_prune ; posts, and I haven't found the other one for some reason, but I'm in a bit of a rush.
Anywho, I thought the tables crashed or something, but phpmyadmin is being unbearably slow plus I don't know how to check, and for some reason couldn't find anything on the net about crashed tables/databases.
Anyway, I don't want to rush into anything, if the data can somehow be recovered.
I have root access to the serve, and a backup which is 9 days old.
Does anyone have any suggestions?
Thanks!
-
Starcraftmazter
- Forum Commoner
- Posts: 45
- Joined: Mon Apr 24, 2006 11:36 pm
-
Starcraftmazter
- Forum Commoner
- Posts: 45
- Joined: Mon Apr 24, 2006 11:36 pm
- Ollie Saunders
- DevNet Master
- Posts: 3179
- Joined: Tue May 24, 2005 6:01 pm
- Location: UK
There are a lot of ways to hack a site besides getting a root password. If your install of phpBB was not 100% up to date then it could have gotten hacked by any number of known exploits. Same thing with phpmyadmin or anything else you might have running on your server.Starcraftmazter wrote: So I really would be in disbelief if anyone somehow hacked it.
If it was hacked, then consider your entire server tainted, you will need to get someone who knows their stuff to check it out to see if they just deleted the tables or got root. If you aren't sure you may need to rebuild it and keep it patched. Who knows, someone could be running a spam bot on it by now or something.
-
Starcraftmazter
- Forum Commoner
- Posts: 45
- Joined: Mon Apr 24, 2006 11:36 pm
Hey, that's a pretty good idea actually.ole wrote:and get PHP to use a database user that doesn't have permission to drop.It may be a good idea to move away from using the root account at all.
Server runs the latest version of everything, phpbb was updated to .22 numerous days prior to this happening.Begby wrote: There are a lot of ways to hack a site besides getting a root password. If your install of phpBB was not 100% up to date then it could have gotten hacked by any number of known exploits. Same thing with phpmyadmin or anything else you might have running on your server.