Hi everyone
Please advise me on the following scenario:
The hacker gets into the Live server and deletes all sql data.
One-way SQLyog sync will prevent Backup server to amend its data as this is one-way sync (Live -> Backup).
But the SQLyog configuration file (XML) is located on Live server and has all login details for Backup server.
My solution: run SQLyog on Backup server where Source is “live server” and target is “backup server(localhost)”.
In this case hacker wont get any access to Backup server as where wont be any XML configuration files on Live server.
Am I right?