MySQL: Database Backup #1

$ mysqldump db_name --opt -uROOT -pPASS > backup_file.sql

see also: http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html