如何恢复MySQL数据库 [英] How do I recover MySQL Database
问题描述
大家好!
我的MySQL数据库存在很大的问题。
我想恢复所有的来自我的数据库的数据,但问题是我找不到它。
你们明白了,这就是场景
>
我有一台装有Windows XP 64位操作系统且包含MySQL数据库的计算机,该数据库已损坏,我安装了新的Windows XP 64位但从未格式化旧操作系统。
我的问题是:
如何运行旧的MySQL数据库并获取数据备份?
请注意:我的操作系统是Windows XP 64位
感谢帮助人....
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....
推荐答案
显然你要做的第一件事就是现在备份你的系统 - 以免你做的任何事情加剧了这个问题
我请阅读 https://dev.mysql.com/doc/refman/5.1/en/windows-installation-layout.html [ ^ ]并查看是否可以找到任何数据文件,或者,磁盘搜索my.ini并看看--Iirc该文件概述了数据的存储位置...一旦你可以确定数据是否存在于你可以继续的地方 - 这有一些关于恢复ISAM的提示和InnoDB文件,不同操作系统,技术应该是相同的 http://stackoverflow.com/questions / 484750 / restoreoring-mysql-database-from-physical-files [ ^ ]
我猜你在重新安装操作系统之前没有恢复点或备份?
你有没有?将操作系统安装到与原始操作系统相同的位置?
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 ?
这篇关于如何恢复MySQL数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!