DirectAdmin Admin Backup/Transfer problem

[streamservice]

Hello,

When I try to create backups (using the Admin Backup/Transfer in the admin level) I get a few errors when there is a database. When the user doesn't have any database it works correctly, but when it has a database I get the error below (via the message system):

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

I did verify that the information in /usr/local/directadmin/conf/mysql.conf and /usr/local/directadmin/conf/my.cnf is correct (using the login details in these files to test them using mysqldump and mysql).

What could the issue be? If I should test certain things: please mention them so I can test it.

OS: Debian 4.0
DirectAdmin version: 1.34.4
MySQL version: 5.x

If this topic should be somewhere else on the forum, please move it. If DirectAdmin staff needs access to the server to check what the problem is: please mention it or contact me directly so I can give the details.

Some other stats (just because it could be the problem):

             total       used       free     shared    buffers     cached
Mem:          2048       1475        572          0         80        998
-/+ buffers/cache:        397       1650
Swap:         2047          0       2047

For as far as I can see I have RAM enough (database is below 100MB).

Filesystem            Size  Used Avail Use% Mounted on
/dev/xvda1             50G   41G  6,9G  86% /
tmpfs                 1,1G     0  1,1G   0% /lib/init/rw
udev                  1,1G   36K  1,1G   1% /dev
tmpfs                 1,1G  4,0K  1,1G   1% /dev/shm

6GB disc space should be enough for the backup I think, the user account is below 1GB in size.

Thank in advance for the help.

 

[nobaloney]

Unfortunately I can't help you with your problem without logging into your server, but I wanted to correct a misconception you may have.

DirectAdmin staff doesn't search these forums looking for problems to solve. If you've purchased a license from DirectAdmin you can check here to see if support is included with your license.

Otherwise you may want to hire commercial support from me or someone else. To contact me for support please see the information below in my siglines, and note that I do not respond to private messages nearly as often as I do to email.

Jeff

 

[streamservice]

Hello Jeff,

I did think they do read these forum once in a while to look for thing to respond to. But I'll send them an email about this server.

Regards, Mark

 

[floyd]

I believe they only respond to things in the forum when somebody brings it to their attention. They do not read the forum in general, only specific posts.

 

[streamservice]

Thanks to DirectAdmin support it is solved now. I didn't think it could be a problem, but the problem was that the password for da_admin (MySQL user) did contain a '#'. After changing this (in the config files and in the MySQL user list).