I had a nightmare recently with a site. The hosting provider had a server failure and commissioned a replacement pretty quickly. But they could only restore my site to a 2 week old copy. That included SQL which for WP was fine, its not updated that regularly. However the other SQL DB’s were also 2 weeks old and there are non WP DB’s.
I use updraft plus to backup WP and also third party DB’s. The backups go off to other servers, so I have the data.
However, on the two week old restored site, Updraft plus is now running 2 weeks old and ‘unaware’ of the newer backups. Given the time I had to get these db’s back, I was in a bit of a mess and it was the middle of the night on a weekend.
Long story short, I want to replicate my site and DB’s to backup server, but not using a plugin on the site itself. I want to either pull a copy, or use a third server to move them. My backup server will then have a working copy all the time that I can failover the DNS to (there’s other mechanisms I can use to redirect users when needed).
I’m asking for one site but actually its a whole bunch of them.
Edit, the hosting co. have now restored all my data but for 6 hours we really struggled. We do have seperate SQL backups that are third party but they run every 6 hours and updraft runs incrementals every 15 mins, and we really wanted to not lose those 6 hours. The main issue is that an old restoration of the site really messes with the plugins. So backing up WP “with itself” is really not ideal situation. The third party idea is more resilient.
[ad_2]
Learn how to script using the command line. You’ll want to look into commands like `mysqldump`, `zip` and `scp`
That said, what you’re doing is known as a hack/band-aid approach. Creating a fail over site for a basic WP site isn’t common, it’s almost unheard of. WP is extremely resilient, and quite simple to fix if something goes wrong – *assuming* you have a reliable hosting. You should be focusing on why your site is going down and fixing that problem. Moving to a better host would be a smart first step. And also learn how to backup and restore properly – updraft has everything you need so learn how to use it.