- January 16th, 2012
- Write comment
Don’t like how the mysqldump command keeps reading the .my.cnf and outputting the following warning/error:
mysqldump: ignoring option '--databases' due to invalid value 'dbname'
It’s been reported as a bug to mysql devs, but they keep saying it is by design, and working as intended. Here’s how you should structure the .my.cnf to avoid it:
This way the “mysqldump dbname” doesn’t return that hideous error message and “mysql dbname” also works like a charm.