Import and Export on MySQL

1. outfile 命令导出表数据

   SELECT @@secure_file_priv;
   SELECT * FROM wiki.table1 INTO OUTFILE '/var/lib/mysql-files/wiki_table1'
    FIELDS TERMINATED BY '---';

2. mysql 命令导出表数据

   mysql -ujove -pjove -e 'select * from wiki.table1' > /backup/wiki_table1
   mysql -ujove -pjove --xml -e 'select * from wiki.table1' > /backup/wiki_table1.xml
   mysql -ujove -pjove --html -e 'select * from wiki.table1' > /backup/wiki_table1.html

3. 备份表结构

   mysqldump -ujove -pjove -d wiki table1 > /backup/wiki_table1.sql

Restore

1. 先使用 mysqldump 恢复表结构

   mysql -ujove -pjove wiki < /backup/wiki_table1.sql

2. 导入数据

   LOAD DATA INFILE '/backup/wiki_table1' INTO TABLE '/var/lib/mysql-files/wiki.table1'
    FIELDS TERMINATED BY '---';