Dreams Never End
Posted on 8th August 2007
After promising a while ago to upload some of my code, I've created a new section on the site. Click the Code tab on the menu at the top and you'll see what I've done.
My first launch is the latest version of my dbdump.pl utility. I use it to backup my databases to remote servers. It supports MySQL and PostgreSQL at the moment, but potentially it could support others. At some point I'll get around to packaging other utilities too. If you find the code useful, please let me know.
|
File Under:
database
/ opensource
/ perl
|
History Never Repeats
Posted on 5th June 2007
It's always handy doing backups, but getting into the habit of doing them is another thing. I've mostly just used a simple bash script, run manually when I need to. Which isn't what I should be doing. Today I decided it was about time I organsied soemthing to officially backup the databases. At the moment I'm only backing up the MySQL databases, but will add the one postgresql DB once it's been rehosted.
Originally I was going to use automysqlbackup, which may well have worked, but looked a bit too much work to do a relatively simple job, only supported MySQL and didn't enable me to backup via ssh to multiple servers. As the data potentially contains private information, sending via email is not an option. So I wrote my own. The result is a program a tenth of the size of automysqlbackup, it's written in Perl, backs ups multiple sites to multiple servers and the only non-core module is Net::SCP :)
Once I've added the necessary PostgreSQL support and written some documentation, I'll put it online somewhere.
|
File Under:
backups
/ database
|
post to del.icio.us
