mysql数据库备份

1.备份表数据
SELECT INTO…OUTFILE格式：

SELECT * FROM 数据表名

                  INTO OUTFILE 'D:/FILE/myfile1.txt'

                                               FIELDS  TERMINATED BY ' , '

                                               OPTIONALLY ENCLOSED BY ' " '

                                               LINES TERMINATED BY ' ? ';

2.恢复表数据

LOAD DATA …INFILE语句是SELECT INTO…OUTFILE语句的补语

LOAD DATA INFILE 'D:/FILE/myfile1.txt'

                      INTO TABLE 数据表名

                                              FIELDS  TERMINATED BY ' , '

                                              OPTIONALLY ENCLOSED BY ' " '

                                              LINES TERMINATED BY ' ? ';


3.用mysqldump备份数据库

使用客户端的方法如下：

打开DOS终端，进入mysql的BIN目录，路径为：C:\Program Files\MySQL\MySQL Server 5.1\bin，后面介绍的客户端命令都在此处输入

mysqldump -hlocalhost -uroot -p123456 xscj >F://xscj.sql
就可以了。

这个是在我电脑上的操作：