I’m upgrading wordpress, the software that runs this blog and want to note the commands to backup the database.

mysqldump --add-drop-table -h localhost -u blog_user -p blog > backup102107.sql

After entering my mysql password, it should dump the entire blog database.

Also, make a copy of /usr/local/www/blog.