in Projects, Programming, Technology

MySQL: Hot Copy Backup

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

Write a Comment

Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.