MySQL 提供了多种方式将数据保存到文件中,以下是几种常用的方法:
# 导出整个数据库
mysqldump -u username -p database_name > backup.sql
# 导出特定表
mysqldump -u username -p database_name table1 table2 > tables_backup.sql
# 导出结构不包含数据
mysqldump -u username -p --no-data database_name > schema.sql
-- 将查询结果导出到文件
SELECT * INTO OUTFILE '/path/to/file.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM your_table;
-- 注意:需要MySQL服务器有写入权限的目录
mysql -u username -p -e "SELECT * FROM database_name.table_name" > output.txt
-- 将表数据导出为CSV
SELECT * FROM your_table
INTO OUTFILE '/tmp/your_table.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';
您需要哪种具体的导出方式?或者您有特定的导出需求吗?