Info ~ travel musings for the masses

I have been trying to tackle this issue for a while now and I still have not come up with a good solution.

My requirements are to backup MySQL databases that reside on multiple servers and then download the backup files (*.sql) to a local machine so that they can be burned to a CD.

The two solutions that I have come up with are:

  1. A Python script that runs the commands from a local machine.
  2. A Shell script that runs on the remote machines to backup the databases and a script that runs on the local machine to download the backups

My problem is deciding which way is more efficient and easier to use. Since we are usually adding sites at a rate of about 2 a month I need to be able to edit a config file with all of the new database’s information so that it can be backed up as well.

Anyone dealt with this before? Ideas? (e-mail me: s [AT] badice [DOT] com


No comments yet.

Leave a Reply

Basic HTML is allowed. Your email address will not be published.

Subscribe to this comment feed via RSS

This site uses Akismet to reduce spam. Learn how your comment data is processed.