mysql删除表前备份

mysqldump -u username -p database_name table_name > backup_file.sql

SELECT * INTO OUTFILE '/path/to/backup/file.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '
'
FROM table_name;

mysqldump -u username -p database_name table_name | gzip > backup_file.sql.gz

mysqldump --single-transaction -u username -p database_name table_name > backup_file.sql

mysqldump --lock-tables=false -u username -p database_name table_name > backup_file.sql

# 备份单个表
mysqldump -u username -p database_name table_name > backup_table.sql

# 备份整个数据库
mysqldump -u username -p database_name > backup_database.sql

# 压缩备份文件
mysqldump -u username -p database_name table_name | gzip > backup_table.sql.gz