mysql - 如何避免在 mysqldump 备份上出现 "use "语句？

Question

我正在使用这个命令语法:

mysqldump -u<username> -p<password> --no-create-db --databases mydatabase > /var/backups_DB/MyDatabase-$(date +"%d-%m-%Y-%H:%M:%S").sql

但是我找不到如何防止在生成的文件中插入“use mydatabase”这一行。 我应该使用哪个选项？

Answer 1

没错。删除 --databases...

https://www.computerhope.com/unix/mysqldum.htm

--databases
-B
Dump several databases. Normally, mysqldump treats the first name argument on the command line as a database name and following names as table names. With this option, it treats all name arguments as database names. CREATE DATABASE and USE statements are included in the output before each new database.