Database wiped after losing power.

cephaloncody's profile image cephaloncody posted 1 month ago in General Permalink

Hello, I was editing my DBs lastnight for a game server i host. The power went out and after restarting HeidiSQL was wiped with only the default schema's visible. I tried restoring a backup and that has no effect, the databases are still gone.

Is there any way to get my DBs back... thanks.

ansgar's profile image ansgar posted 1 month ago Permalink

Did you host these lost databases on the system which was affected by the powerloss, or on a remote server?

Anyway, I can only guess. In case of MySQL or MariaDB, it's more likely you're mixing up the server with some other server, or you are using a username with limited privileges. MySQL and MariaDB are quite stable against data loss on a power-off.

gregbowers's profile image gregbowers posted 1 month ago Permalink

After a power outage, all your databases disappeared despite attempts to restore from backup. Here are steps you can take: ensure the correct data directory is selected, try database recovery tools, verify backup integrity, check database engine integrity, and seek professional help if needed. Hopefully, one of these steps will help recover your lost data.

Please login to leave a reply, or register at first.