How to backup WordPress Database

Backing up your WordPress database is very important to help you survive and restore  your WordPress blog or website upon hacker attacks!. It is very easy and simple to backup of your WordPress database.

wordpress-logo

Generally, you can accomplish backup through two approaches;

If you do not have direct shell access to your server or you are not so friendly with commands, you can opt for WordPress plugins that can do the job for you!.

Few WordPress plugins for database backup are;

And, if you have direct shell access and comfortable with commands, you may use the mysqldump command for getting the copy of your entire wordpress database, eg;

mysqldump -u <databaseuser> -h <hostname> -p<password>  <database_name>  > /home/user/wordpress-db-backup-16APR13.sql

You may use an FTP client for copying the backup file to your local desktop or laptop. And, do not forget to keep multiple copies of this backup file preferably in Google Drive, Dropbox, SkyDrive etc!.

Leave a Reply

Your email address will not be published. Required fields are marked *