upload mysql backup

[chielsen]

When i upload an mysql backup (.gz file) i get this:
Error Restoring database

Details

Unable to restore database admindrone_test : ERROR 1045: Access denied for user: 'username@localhost' (Using password: YES)

username = the user who's is trying to upload the backup

 

[fusionictnl]

Database already exists ? Rights on the database aren't setup for the user ?

 

[chielsen]

I created a database and added a user for it.

 

[jmstacey]

Just out of curiosity, did the new user you setup have the exact same username and password as the backup?

 

[chielsen]

Yes, but that shouldn't matter. There is no login data in the backup..
I don't know what is wrong, it is not only me who is having this.

 

[fusionictnl]

Have the sysadmin take a look at it.

 

[chielsen]

I'm the sysadmin.. It's just that directadmin doesn't do what it should.

And what i mean by others, are other people who run da on their server.

 

[fusionictnl]

Does the backup run under phpMyAdmin ?

I've restored a ton of databases through DA and never had any problems, users and resellers

 

[chielsen]

Yes i can upload the backup in phpmyadmin. The error i'm getting is about wrong password.
So DA is using a wrong password when trying to insert the backup.

 

[fusionictnl]

You probably changed the da_admin password from it's original installation password!

If so you'll have to change the /usr/local/directadmin/conf/mysql.conf with the correct user/pass

Still errors:
As described in the DA knowledgebase: http://help.directadmin.com/item.php?id=45

 

[chielsen]

Ok thanks, thats it!.

They should fix it, so when you change yourpassword it also updates this file.

 

[fusionictnl]

It won't as theres now checks how it is changed. If you change it in PhpMyAdmin, DA can't ever know if it is changed and WHAT the password is.