backup directadmin : mysqldump error

pppplus

Verified User
Joined
Dec 19, 2008
Messages
528
Hi

When I want to backup from directadmin, I have these error on all databases :

Error while backing up database admin_Liens
Error while backing up database admin_Liens: The sql file is 0 bytes in size: /home/admin/admin_backups/admin/backup/admin_Liens.sql
mysqldump error output: mysqldump: Got error: 1045: Access denied for user 'da_admin'@'localhost' (using password: YES) when trying to connect

When I run mysqldump manually, with da_admin user, there are no problem. It is just when I want to run from directadmin backup.
I run last version of DA. There was no backup before, because admin of this server never used it.

Do you have an idea about this problem ?
 
This one : Admin Backup/Transfer (address : serveurxxx:2222/CMD_ADMIN_BACKUP)

After, I take option CRON or NOW (same error)

thanks for your help
 
Check ownership/permissions of your mysql files. That's all I can think of.

Jeff
 
Thanks

I reverify, and all is ok. All permissions are the same than other VPS in the same server.
And no problem in other VPS.
 
Try this.
Go to: /usr/local/directadmin/conf
create a file there called my.cnf and add this:
Code:
[client]
user=da_admin
password=thepassword_here

Does it work then?
 
Thanks.
This file is already here with same permissions than the other VPS.
 
I've found the problem !!!

It is because I've a bad password in /root/.my.conf

That a little ... stupid ? or like a small bug.

Thanks for your help
 
Well... it's not a bug. Normally there is no .my.conf in /root so you might wonder how that got there and where you need it for.

Edit: Sorry. I know how it got there but I ment to say you normally don't need it there. If you forget about it, then it can cause these kinds of problems.:)
 
Last edited:
It is usefull to have .my.cnf to use with tuning-primer or mysqltuner.
But "normally", I have to put the good one password...

I'm not sure it's a good idea that directadmin take password in this file, and not in his own files. But it is a detail.

Thanks for all people trying to help me, with my stupid error.
 
You're welcome. And it's not a stupid error. Anybody can make mistakes or sometimes forget about a setting they made elsewhere. Happens to everybody.:)

Anyway, good to see it's solved.
 
Back
Top