Backing up the WordPress Database

At some point you need to be able to back up your blog. Since WordPress uses a MySQL back end I had to figure out how to back up a MySQL database. It turns out that this is a fairly simple thing to do. You just use the mysqldump utility. The command to backup a database is:

mysqldump –user=<user_name> –password=<pwd> <database_name> > <backup_file>

e.g.

mysqldump –user=root –password=***** blog >c:\backups\blog.bak

Leave a Reply