Reseller backup messes up everything

[dannyman1234]

Hello,

The reseller backup does not work for me.

In reseller level I go to: "Manage User Backups"

There I see 4 of my users some of them have 1 database and others have more:

user1
user2
user3
user4

Then in Step 1: Who
select only 1 user:
Then I get the following error:

Error while backing up database user1_data
mysqldump error output: mysqldump: Got error: 1044: Access denied for user 'user4'@'localhost' to database 'user1_data' when selecting the database

The name "user4" is the name of another user it should use "user1" as a user for this database. Why it uses "user4" ???
The database connection works fine in the mysq management setup.

It does archieve the files for user1, which is seen in the "restore backup" section in step 3.
The location is: /home/admin/user_backups/user1.tar.gz


The strangest thing is that user2 works partially fine. It makes connection and dumps the databases and archieves the files but:
1 - the archieved files are not seen in the "restore backup" section in step 3.
2 - The location is different then user1
/home/admin/user_backups/user2/user2.tar.gz

Why is it different? where can I change the path? I would like to use the username as an extra folder, but then you can not restore the files, since it is not seen.

Then here comes another strange thing. the log of user2 (which has different domains), it also dumps the database of user3 I did not select that user. That is what the log said, but in fact that database is not dumped at all.

What I want:
- I would just like to make a backup of all my files and databases per user and be able to restore them, the same as in user-level. There it works fine, but, it would be nice i can use it in a cronjob in reseller-level.

Hope someone can please help me with this.

Regards

Danny

 

[DirectAdmin Support]

Hello,

For mysqldumps, it should be using the da_admin User. If it's using some other User, then likely there is a my.cnf or .my.cnf somewhere overriding things. The usual suspect is /root/.my.cnf. If you have this file, delete it.. or at a minimum, edit it to remove any username overrides. Beyond that, look for other my.cnf files on your system. The only ones you should have will be:
/etc/my.cnf
/usr/local/directadmin/conf/my.cnf

Use:

locate my.cnf

to search your system for other my.cnf files.

Regarding backup options, we do hope to implement this at the Reseller/Admin Level backups in a future DA version, allowing only the items you want in the backup.

John