This depends on server activity and other needs. For servers with small tables and low activity the mysqldump utility should work fine.
Users with larger tables may want to look at the mysqlhotcopy utility
Users with very active servers may want to look at solutions such as LVM snapshots or configuring a replication slave for backup purposes.
This was first published in April 2006