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.
Dan
Andreas Widerøe Andersen wrote:
Hi,
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?
Thanks!
Andreas
--
Dan Buettner
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
