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

Post a comment