Until now I have been accessing databases using the wildcard %, however my host recently closed wildcard access and I now have to access using SSH.
SQLyog works fine with SSH in the GUI and I can access the database.
When I use the wizard to set up the backup in the first screen I select to use an existing connection which it accepts and lets me select the database required on the server.
However the scheduled backup always fails with the message
ERROR: 2003 Can’t connect to MySQL server on ‘localhost’ (0) Error in connection.
Same happens when I run the task from Scheduled Jobs.
I have tried deleting all the files (connection profile and sja tasks) and creating again from the wizard, but that makes no difference.
The strange thing is that I can set up another profile to a different server/domain and SSH works fine for scheduled backups.
Could this be a server issue, though I can’t see why if the GUI works ok with that profile why the scheduled backup should not work.
I am attaching a copy of the xml file created by the wizard, I have masked the sensitive information.
Thanks