Andreas, if you are only using MyISAM tables, the included mysqlhotcopy
script may work for you. We used it at my previous employer with good
results. We would run it to create a snapshot of our data files every
day, then run a network backup utility that backed up the snapshot (but
did not access the live data files).
Other folks have recommended mysqldump, which is also a good solution,
but could potentially take a long time to restore into the database,
depending on your data.
Andreas Widerøe Andersen wrote:
> I have a few FreeBSD servers running various web/database things and I'm
> looking for a good a reliable backup script that I can run through a
> cronjob. I'm currently running the latest version of mysql323, but will
> upgrade to version 4.1 soon aswell as upgrade most of the servers to the
> latest FreeBSD version.
> Any good suggestions to a script that will back up my databases and make
> things ready for an easy restore if I need to?