for completeness, there is also 'mysqldump' that can be used to make a backup of a mysql database over the mysql connection.

And with the risk of completely getting off topic, you can also run mysqlservers in a slave-master replication setting so you have a 'hot backup' server ready in case you need one. I refer to the mysql documentation for how to set this type of thing up.