本文介绍了如何从物理文件还原MySQL数据库的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
安装新的xampp
从以下位置复制您的旧数据库文件夹
xampp \ mysql \ data \ databasefolder粘贴到正在运行的xampp文件夹中
C:\ xampp \ mysql \ data
在那之后停止mysql和apache服务,然后备份您正在运行的xampp文件ib_logfile0,ib_logfile1和ibdata1并存储在安全的地方
然后从旧版本复制相同文件(ib_logfile0,ib_logfile1和ibdata1)
xampp \ mysql \ data \并粘贴到正在运行的xampp服务器C:\ xampp \ mysql \ data \
启动mysql和apache服务打开CMD Fire命令
C:\ xampp \ mysql \ bin> mysqldump -u dbusername -p dbpassword dbname> D:\ exportdb.sql
停止mysql和apache服务并恢复主ib_logfile0,ib_logfile1和ibdata1文件(检查步骤3)
然后再次启动服务并打开 localhost/phpmyadmin/并从D导入数据库备份: \ exportdb.sql
现在您的备份正在工作:)
Install new xampp
Copy your old database folder from
xampp\mysql\data\databasefolder to Paste in your running xampp folder
C:\xampp\mysql\data
After that stop mysql and apache service then backup your running xampp files ib_logfile0,ib_logfile1 and ibdata1 and store in safe place
Then Copy same file (ib_logfile0,ib_logfile1 and ibdata1) from old
xampp\mysql\data\ and paste in your running xampp server C:\xampp\mysql\data\
Start mysql and apache service Open CMD Fire command
C:\xampp\mysql\bin>mysqldump -u dbusername -p dbpassword dbname>D:\exportdb.sql
stop mysql and apache service and restore your main ib_logfile0,ib_logfile1 and ibdata1 file (check Step 3)
after than again start service and open localhost/phpmyadmin/ and import database backup from D:\exportdb.sql
Now your backup is working :)
不幸的是,我在Windows机器上卸载了Xampp,/xamp/mysql/data文件夹中大约有50个数据库.我没有备份脚本,但是有Xamp/mysql/data文件夹的副本.如何使用该数据目录还原MySQL数据库.
Unfortunately I uninstalled Xampp in my windows machine, there are about 50 databases in /xamp/mysql/data folder. I have not taken backup script, but I have a copy of Xamp/mysql/data folder.How can I restore MySQL Databases using that Data Directory.
预先感谢
推荐答案我找到了解决方法
更多推荐
如何从物理文件还原MySQL数据库
发布评论