Backing Up WordPress Database

To use command line backup of a WordPress site.

Locate you wp-config.php file.   Find the DB configuration for you DB with “grep DB_ wp-config.php”.  If your password is encrypted, you will need to know it.

Use the output to run mysqldump,  “mysqldump –opt –user=<DB_USER> –password=<DB_PASSWORD> –host=<DB_HOST <DB_NAME>  > <BACKUPFILE>”

Leave a Reply