Backing up tons of MySQL databases…

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

Holiday Spice Pepsi

After learning about Holiday Spice Pepsi I had to pick some up. The plan was to get a 12 pack of it and try it out but the local grocery store only had it being sold as a single in a bottle. I picked one up and gave it a try…

My first impression was that it was “different”. It was not bad, it just had a different flavor that I was not used to. As I continued drinking it I realized that it reminded me of the smell of Pine-Sol. Other than that I thought it was pretty good. You can taste the cinnamon and ginger, which I know does not sound good to most people but I thought it was.

So if you are in the mood for something different try it out. It will only be around till New Years.

The Rest of the Week

Rain will be around the rest of the week. It is not pouring rain or anything like that, it is a steady, depressing drizzle. I walked home from school in it and by the time I got to my block I was soaked. I enjoyed it but I do not think I can take 4 more days of it. I feel like I am back in Houston except it is cold…

My week will consist of me studying as much as possible so that I can enjoy Thanksgiving weekend with my family. I am meeting with a professor tomorrow to discuss taking an independent studies class that would allow me to free up a spot in my schedule for lunch because as it stands right now I go for about 6 hrs. straight a day with no lunch break.

I’ve made some time over the last few days to play America’s Army. My connection at home sucks so I usually go to a friend’s house to play. It is weird to play again, but it is nice.