I tried to set up a reciprocal scheduled backup between two machines.
I have two machines, ns1 and ns2. Both of them are set under virtualmin->Backup and Restore->Scheduled Backups to backup all servers and subservers and all "features and settings" to the reciprocal server. Both are set to email me on failure of the backup.
Interestingly, I noticed the following oddity:
On ns2, there is a file called "virtualmin.tar.gz". Thus, this file is part of a backup made by ns1. I received no failure email from ns1, but the filesize of this file is 0 bytes. Is this a problem?
On ns1, there is NO file called "virtualmin.tar.gz". Thus, the backup made by ns2 failed. I received the expected failure email from ns2. The critical portion states:
Dumping MySQL database theDatabase…
… dump failed! mysqldump: Got error: 1049: Unknown database ‘theDatabase’ when selecting the database
When I installed the domain with the problem, I accepted the default db name. I later installed my own db called "someOtherDatabase" and must have deleted "theDatabase". I need to a) tell the backup to quit looking for "theDatabase" and b) tell the backup to start looking for "someOtherDatabase".
How might this be done?