Backup MySQL databases with mysqlhotcopy

9
If you want to make a hotcopy from your SQL database instead of a dump to a text file, you can use the mysqlhotcopy tool. This tool locks a table, copy it and than unlocks it again.

Link: Debian-Administration.org