0

I have this MySQL database named capsule_corporation_database.

Then, I have this my.cnf file in my home directory:

~/.my.cnf

[client]
host=localhost
user=trunks
password=mai
database=capsule_corporation_database

Attempt to mysqldump

mysqldump > copy_of_capsule_corporation_database.sql

The backup did not pursue and logged the below message:

Warning: mysqldump: ignoring option '--databases' due to invalid value 'capsule_corporation_database'

What does it mean and how to resolve it?

0

In order to fix this issue, just move the database parameter from client to mysql in my .cnf

i.e

$ cat ~/.my.cnf
[client]
host=localhost
user=trunks
password=mai

[mysql]
database=capsule_corporation_database

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.