How to Backup your WordPress Database

To backup is to export the tables of your database to your local storage.

You will need access to your phpMyAdmin.

Ideally, login to your cPanel should be able to have access to phpMyAdmin.

  1. Login to phpMyAdmin through the cPanel
  2. From the left menu, select the database to export.
  3. On the top menu from the main frame page, select “Export” to navigate
  4. Exporting tables from “YourSelectedDataBase” database
  5. Select “Quick – display only the minimal options”.
  6. Format: Select “SQL” from the drop-down menu.
  7. Click “Go”.
  8. The exporting process should save the file to your designated Folder or Desktop.
  9. Filename extension is *.sql.