"How to backup MySQL

This is more for me, than anything. It is useful for anyone using MySQL databases, though.

Here is the command you run in a shell client, to backup your MySQL database.

/usr/local/bin/mysqldump --complete-insert --add-drop-table --lock-tables --user=USERNAME --password=PASSWORD DATABASE_NAME > FILENAME.sql

Obviously replace USERNAME, PASSWORD, DATABASE_NAME, and FILENAME with the proper values."