Jan
16
MySQL: Hot Copy Backup
Filed Under (Uncategorized) by admin on 16-01-2008
This is an alternative to mysqldump. It locks tables but should be faster and thus more suitable for taking an online backup.
# perform an online backup into /backup/location
$ mysqlhotcopy -u root -p password database_name /backup/location
# perform an online backup into /backup/location
$ mysqlhotcopy -u root -p password database_name /backup/location
