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 its corrupt.

Recommended Answers

If binlog is enabled maybe you can access the previous queries and reload the old/new database:

But if everything was replaced, due for example to a Windows restore point, then it …

Jump to Post

All 2 Replies

Repairing tables with mysqlcheck or another variant to learn helpful topics about mysql databases

https://social.msdn.microsoft.com/Forums/en-US/fb94219c-fbf8-455d-b912-5544be11f186/how-to-fix-my-sql-database?forum=sqldataaccess
http://www.sqlservercentral.com/Forums/Topic1618894-2893-1.aspx

But in case your corruption can't be overcome, then I would suggest you more powerful instrument for such cases https://mysql.recoverytoolbox.com/ Recovery Toolbox for MySQL

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.