Click here to Skip to main content
15,878,959 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi to all!!

I have a big problem which regards to my MySQL Database.
I want to recover all the data from my database but the problem is that i cannot find it.

For you guys to understand, here's the scenario

I have a computer which has the Windows XP 64 bit OS and contains the MySQL Database which is being corrupted and I installed a new Windows XP 64 bit but never formatted the old OS.

My question is that:

How can i run the old MySQL Database and get the backup of the data?

Take note: My OS is Windows XP 64bit

Thanks for the help guys....
Posted

1 solution

obviously the first thing you should do is backup your system now - lest anything else you do exacerbates the issue

I'd read this https://dev.mysql.com/doc/refman/5.1/en/windows-installation-layout.html[^] and see if you can find any of the data files, OR, do a disk search for my.ini and have a look at that - iirc that file outlines where the data is stored... once you can ascertain if the data is there somewhere you can go on - this has a few hints on recovering for ISAM and InnoDB files, different OS, technique should be the same http://stackoverflow.com/questions/484750/restoring-mysql-database-from-physical-files[^]

Im guessing you dont have a restore point or backup before you re-installed the OS ?
Did you install the OS into the same location as the original ?
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900