MySQL 导出数据
用 mysqldump 备份，或用 SELECT ... INTO OUTFILE 导文本。
Key Pointsmysqldump 是逻辑备份首选；INTO OUTFILE 适合把查询结果导成 CSV。
mysqldump
Shell
# 导出整个库
mysqldump -u root -p shop > shop.sql
# 只导出结构
mysqldump -u root -p --no-data shop > shop_schema.sql
# 导出单表
mysqldump -u root -p shop users > users.sqlOutput
-- MySQL dump 10.13 Distrib 8.0.x
-- Dump completed导出为 CSV
SQL
SELECT id, username, age
INTO OUTFILE '/var/lib/mysql-files/users.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM users;INTO OUTFILE only writes to server directories allowed by secure_file_priv, the file is owned by mysql, and never overwrites. For cross-machine export, mysqldump is the usual choice.mysqldump
Shell
# 导出整个库
mysqldump -u root -p shop > shop.sql
# 只导出结构
mysqldump -u root -p --no-data shop > shop_schema.sql
# 导出单表
mysqldump -u root -p shop users > users.sqlOutput
-- MySQL dump 10.13 Distrib 8.0.x
-- Dump completed导出为 CSV
SQL
SELECT id, username, age
INTO OUTFILE '/var/lib/mysql-files/users.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM users;INTO OUTFILE 只能写到服务端有写权限的目录（受 secure_file_priv 限制），且文件归 mysql 用户所有、不会覆盖已有文件。跨机器导数据更常用 mysqldump。