MySQL命令行导出数据(docker版本)

MySQL命令行导出数据(docker版本)

1、登录数据库

$mysql -h 10.1.1.143 -u root -p

2、用命令行从MySQL导出数据(无标题)

#查看导出时可以存储的路径
mysql> SHOW VARIABLES LIKE 'secure_file_priv';
+------------------+-----------------------+
| Variable_name    | Value                 |
+------------------+-----------------------+
| secure_file_priv | /var/lib/mysql-files/ |
+------------------+-----------------------+
1 row in set (0.00 sec)
#执行导出命令，文件路径按上述填写，表名称按实际填写
mysql> SELECT * INTO OUTFILE '/var/lib/mysql-files/uses2.csv'
    -> FIELDS TERMINATED BY ','
    -> ENCLOSED BY '"'
    -> LINES TERMINATED BY '\n'
    -> FROM demo_cg.USERS;
Query OK, 2 rows affected (0.01 sec)

SELECT * INTO OUTFILE '/var/lib/mysql-files/users2.csv' FIELDS TERMINATED BY ','  ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM demo_cg.USERS;

3、从Docker容器中导出数据文件

#查询容器

$docker ps

#导出  docker cp  容器id

$docker cp 7836b2d411e8:/var/lib/mysql-files/users2.csv /home/

查看数据文件内容

$cat users.csv