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

2025/5/15 4:16:33 来源：https://blog.csdn.net/fen_fen/article/details/147922000 浏览: 次关键词：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;