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
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