I'm struggling with a problem with backup and restores on one of our systems.. I can't seem to track down what's going on here and hoping someone can help without needing to open a support case.
When I do a backup of a virtual server (only Apache and MySQL configured for the virtual server) and do a restore, it always fails to connect to the MySQL database when trying to recreate it. I "untarred" the backup and checked the .backup/<username>_webmin file and it looks like the username/password is correct, but the output when trying to restore says that access denied when connecting to username @ localhost. I can use mysql to connect to the database from the shell just fine.
I even tried to create a whole new virtual server to test with. I did a default Drupal install, backup and restore. When it restored, it did the same thing. All the files were there in the home directory, I was just missing my MySQL data (database and user do exist).
The admin password and MySQL password are the same, and when I created the new server I left it that way as well.
I can then use the "execute SQL" option in Virtualmin to restore the database after I extract it from the tarball, but that's less than ideal.
Server is: Virtualmin 3.67 Pro and Ubuntu 8.04, fully patched.
Thanks for any help!