How to Backup Data in MySQL

To make a backup:

* mysqldump --user=username --password=password databasename >path/backupfilename