备份Mysql数据库 [英] Backup Mysql Databases

问题描述

我想在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数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！