Site5 Q&A » mysql database recovery in wampserver2

mysql database recovery in wampserver2

In: SQLite Asked By: bentez [2

] Tags: sql

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.

4 Answers Answer this Question Now

Nov 17, 2015

Answer #1

Hello,

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?

Answered By: jdavey [359

]

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.
http://www.sqlservercentral.com/Forums/Topic1619584-2893-1.aspx

Answered By: rasmussen [2

]

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.

Answered By: Corey Mahon [12

]

Answer #4

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

Answered By: bentez [2

]

Answer this Question

You must be Logged In to post an Answer.

Not a member yet? Sign Up Now »