mysqldump -u [[USERNAME]] -p[[PASSWORD]] [[DATABASENAME]] > [[DATABASENAME]].sql ## Or if you'd like it to have the date timestamped on the filename :D mysqldump -u [[USERNAME]] -p[[PASSWORD]] [[DATABASENAME]] > `date +%Y%m%d`.[[DATABASENAME]].sql