Directadmin Backup and restore

[REEDS]

Hey guys hopeing you can all assist with a quick one

Did backups for all sites in DA 1.27.4 and respore them to 1.31.0 and ALL sites that I restore that contains databases give errors like

Unable to restore database goldtouch_cube.sql to goldtouch_cube : ERROR 1045 (28000): Access denied for user 'goldtouch'@'localhost' (using password: YES)
Unable to restore database goldtouch_ezi.sql to goldtouch_ezi : ERROR 1045 (28000): Access denied for user 'goldtouch'@'localhost' (using password: YES)
Unable to restore database goldtouch_faq.sql to goldtouch_faq : ERROR 1045 (28000): Access denied for user 'goldtouch'@'localhost' (using password: YES)


If you go into DA and look at the database it shows there but has a users -1

Any ideas as I been working on this for 3 days now *sigh*

Chris

 

[vancocom]

Now I'm going from the assumption that this is a new server. If not, please disregard this post.

I recently had to restore several user's files, and I hit a permissions error. My problem was different than yours, but I learned that the restore is actually run by the user and not by admin.

Are the passwords on this system the same as the passwords on the one where you created the backups? Perhaps the databases on that server have a different password than what the databases being restored have? That's all I know to offer, and I hope it helps.

 

[Dr-Host]

When it restored your backup, it failed to restore your database users.

just recreate the user and associate it to your databases and everything will be ok