Some Database Backups not working after adding remote mysql host

Hi there,

3 days ago I’ve added a remote mysql server. Some websites’ databases need old mysql version,
so to preserve them before upgrading the main server from jessie to buster and mariadb.

Since then, I get “Partially completed backup of Virtualmin” mails, showing:

8 vhosts, where the databases are dumped as usual,
2 vhosts, where the databases have been moved to the remote mysql host,
4 vhosts with local databases: “… dump failed! mysqldump: Got error: 1045: Access denied for user ‘root’@‘localhost’ (using password: YES) when trying to connect”

This has been working flawlessly up to the introduction of the mysql remote host.

As the first failed dump comes after the two vhosts with remote database, my suspect is:
may be, the mysql password (variable?) is not changed back from remote mysql root user to local mysql root user?

Just activated debugging to file for virtualmin, hoping to see tomorrow something interesting there
after the nightly backup.

Thanx for your answer

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.