Site5 - Built For Designers & Developers MENU

mysql database recovery in wampserver2

[2 Grey Star Level]

Some how mysql database in wamp server 2 got replaced by older database and i am unable to restore the database to the location (before being replaced by old data) from the latest backup i have . is there any way i can restore the data to my required position.
Any way except restoring it from backup sql file as it’s corrupt.

Answer #1


The only way to restore the data that I can think of would be from a backup. You mention that one of the backup SQL files is corrupt – is this your only one?

Answers Answered By: jdavey [359 Blue Star Level]

Answer #2

If your sql files are corrupt, and you just don’t have any other backup then its not possible to restore.
If have binary logs enabled and not purged you may try to recover using them.
I’m a bit confused when you say: “unable to restore the database to the location ”
If by that you mean you’ve replaced data folder completely you may also try to watch out for data-recovery programs !!
There is another idea.
And yes…. make sure you backup everything now before attempting restorations….
Look also if this information will help you.

Answers Answered By: rasmussen [2 Grey Star Level]

Answer #3

Hi Rasmussen,

Thank you very much for these suggestions. However, one thing to keep in mind as this solution would require root access which all of our servers (with the exception of Unmanaged VPS) do not have. So, database restorations on our servers may require a backup restore as jdavey previously mentioned.

Answers Answered By: Corey Mahon [12 Grey Star Level]

Answer #4

Thank you all guys for your advice! The issue has been resolved.

Answers Answered By: bentez [2 Grey Star Level]

Answer this Question

You must be Logged In to post an Answer.

Not a member yet? Sign Up Now »

Money Back Guarantees
Click to verify BBB accreditation and to see a BBB report.