MySQL备份与恢复

备份

The mysqldump client is a backup programoriginally written by Igor Romanenko. It can be used to dump a database or acollection of databases for backup or transfer to another SQL server (notnecessarily a MySQL server). The dump typically contains SQL statements tocreate the table, populate it, or both. However, mysqldump can also be used togenerate files in CSV, other delimited text, or XML format.

There are in general three ways to usemysqldump—in order to dump a set of one or more tables, a set of one or morecomplete databases, or an entire MySQL server—as shown here: 

shell> mysqldump [options] db_name [tbl_name ...]shell> mysqldump [options] --databases db_name ...shell> mysqldump [options] --all-databases

To see a list of the options your versionof mysqldump supports, execute mysqldump --help.

操作方法：

(1)    进入MySQL安装目录的bin目录下

(1)    使用mysqldump备份数据库

恢复

执行以下命令：

其中红框部分为MySQL安装路径

参考：

http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html