I have keys setup between my servers so I can ssh without a password, so if you get that setup, these are my scripts...
On the cloud server:
#!/bin/sh
cd /var/www/databases
mysqldump -u root --password=mypasswordthanksaj > thanksaj.sql
mysqldump -u root --password=mypassword literaryworksbyaj > literaryworksbyaj.sql
mysqldump -u root --password=mypassword builtbyart > builtbyart.sql
rsync -chavzP --stats /var/www/* root@50.203.224.9:/var/www/
**On the local server: **
#!/bin/sh
cd /var/www/databases/
mysql -u root --password=mypassword thanksaj < thanksaj.sql
mysql -u root --password=mypassword literaryworksbyaj < literaryworksbyaj.sql
mysql -u root --password=mypassword builtbyart < builtbyart.sql
So I export the MySQL databases to /var/www/databases as .sql files and then rsync them to the local server. The local server imports said files into its local databases. I use cron to schedule all this.
Local server:
0 6,18 * * * /home/aj/scripts/aj-import-wordpress-dbs >> /srv/samba/share/import_wordpress_dbs.log 2>&1
Cloud server:
0 5,17 * * * /home/user/scripts/aj-sync-wordpress >> /var/log/aj-logs/sync_wordpress.log 2>&1
Then I use Unitrends to backup the local server. 🙂
We'll see how this works!
Thanks,
A.J.
