问题描述
我想在PC上重新安装Windows，我想在MySQL中备份数据库.我有大约30多个数据库.有什么简单的方法可以备份内容并在以后还原它?
I wanna reinstall windows on my PC i wanna backup my Databases in MySQL. I have around 30 plus databases. is there an easy way to back up the content and restore it later ?
推荐答案
您可以使用mysqldump -A为所有数据库生成sql转储.
You can use mysqldump -A to do generate sql dumps for all databases.
参考: http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
或者，您也可以只复制实际数据目录.
Alternatively, you can also just copy the acutal data directory.
抱歉，没有具体说明，正如其他人指出的那样，这仅适用于ISAM.对于innodb，您需要使用mysqldump或其他实用程序(例如phpMyAdmin)进行备份.
apologies for not being specific, as others have noted this will work only ISAM. For innodb, you'll need to backup using mysqldump or another utility such as phpMyAdmin.
这篇关于备份Mysql数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！