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.
Jump to PostIf 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 …
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 will not work, you have to try to recover the replaced files, check:
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
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.