Backup configuration to same server with two MySQL versions

Application issues
1

I have a working setup with MySQL 8.0 and a MySQL 5.5 instance running on different ports.

I created two Backup Jobs in SQLBackupAndFTP for each instance. One for Port 3306 and one for 3307 (same IP address)
But when ever I make changes to one backup-job the settings gets replicated to the other backup job - causing one of the jobs to fail due to MySQL version conflicts.

Why is the connection config being overwritten by the other job ?

2

Hi,

This happens because both jobs use the same server name, so SQLBackupAndFTP treats them as the same connection.

To keep the connections separate, make the server names unique by adding a block comment, for example:

  • localhost /* MySQL8.0 */
  • localhost /* MySQL5.5 */

The comment is ignored by MySQL but allows SQLBackupAndFTP to store separate connection settings.

More details:

3

Perfect, works excellent.
Thanks

4

You’re welcome! Glad it worked.