Backup your WordPress Database

Posted on March 19th, 2011

Before you proceed with any changes, be sure to backup your database. It is a good practice to always backup your database before making any major changes. This ensures that even if anything were to go wrong, you would still be able to restore it.

If you decide to backup your WordPress database manually, follow these steps:

  1. Login to your phpMyAdmin.
  2. Select your WordPress database.
  3. Click on Export at the top of the navigation.
  4. Select the tables you want to backup, or select all tables to backup the whole database.
  5. Select SQL to export as .sql extension.
  6. Check the “Save as file” checkbox.
  7. Choose compression type, select gzipped to compress the database to a smaller size.
  8. Finally click Go, and a download window will prompt you to save your backup database file.