Kelsey
Kelsey

Reputation: 921

Accidently Emptied Tables in the Wrong Database (Using PHPMyAdmin for MySQL), Anyway to Restore Data?

As the title states, I accidently emptied tables in the wrong database. I did not export the database before I did this (stupid me). Is there anyway to restore the database to a previous date/version, so that I may obtain the emptied data back?

Upvotes: 0

Views: 1245

Answers (2)

Gil Bourgeois
Gil Bourgeois

Reputation: 11

Sorry for you, but you should automate your mysql backup (in this case you lose at worst one day of data). I use this script to do that : https://sourceforge.net/projects/automysqlbackup/ HTH

Upvotes: 1

Simon
Simon

Reputation: 794

There is no way to recover deleted data if you didn't make any backups. You could try to check the logs, but I doubt you will find anything. You have to be careful when handling important data.

Upvotes: 1

Related Questions