Posted by: Anonymous Coward
on December 28, 2004 08:07 PM
I use "mysqlhotcopy" (requires perl-DBD-MySQL and perl-DBI to be installed) myself - it just takes a snapshot of the database (using locking) into another filestore tree (which could be on NFS if you wanted). To restore, shut down MySQL if it's still running, move the live tree (/var/lib/mysql) out of the way, re-install the MySQL RPMs if you need to (setting the DB root password), move the backup tree into the live tree and start MySQL again - not rocket science<nobr> <wbr></nobr>:-)
What's wrong with mysqlhotcopy?
Posted by: Anonymous Coward on December 28, 2004 08:07 PMHere's my cron line:
#