Basic Backup of MySQL

From the /usr/local/mysql/bin directory you can use the following command:

./mysqldump –add-drop-table databasefilename > backup.sql