Error while backing up database

[zEitEr]

Checked! Password is correct.
But mysqldump does not want to work with --defaults-extra-file=

mysqldump --defaults-extra-file=/usr/local/directadmin/conf/my.cnf database

but it works with da_admin, added manually:

mysqldump -uda_admin -p database

What's wrong?

 

[zEitEr]

Fixed.
I've found /root/.my.cnf with not empty root password for mysql

Now it works.

Thanks, John.

 

[DirectAdmin Support]

What's the version of mysqldump you're using? and what's the path, eg:

which mysqldump

try using the full path, specific to your OS, in case there is another one there.

Also, try manually adding a [mysqldump] section to your my.cnf when manually testing, in case the version of mysqldump you've got isn't accepting the [client] section.

Note that the da my.cnf file is re-written over each time it's run, so if you do need to make any permanent changes, an "chattr" would have to be run on it, to lock it at the system level (or chown it to root may work as well, as it's written as diradmin)

John

EDIT:

I've found /root/.my.cnf with not empty root password for mysql

ok, good to hear.

 

[ClayRabbit]

Very inaccurate update
If we have /root/.my.cnf with

[client]
password=***

then backups broken with errror:

mysqldump: Got error: 1045: Access denied for user 'da_admin'@'localhost' (using password: YES) when trying to connect

 

[ClayRabbit]

Is it necessary to run mysqldump under root uid?