MySQL Database Backup – Part 3 – Remote Backup using RSYNC

nbeam published 9 years ago in Database Administration, Database Backups, Linux, MySQL, RSYNC, Shell Scripting, SSH. Tags: , , , , , ,

1

This is the final article (I think…) on MySQL database backup. In my previous article I discussed how to craft a very efficient script for automated LOCAL backup of your MySQL databases. But that isn’t the whole story. What happens if your server burns to the ground… or more likely the hard drive gives up […]

Bash Script for Quick Restore of Multiple Databases

nbeam published 9 years ago in Apache, Database Administration, Database Backups, Linux, MySQL, Shell Scripting, Web Administration. Tags: , , , ,

1

As I am now hosting about 8 different sites I was wanting to make restoring from backups a bit easier and less manual. The ultimate goal is to login to my second server and have it up and running with as few key-strokes as possible. Scripting was the answer. It took me several hours of […]