How to Backup a MySQL Database using phpMyAdmin

  • Sabrina
  • MySQL

In this article, you will learn how to back up a MySQL database using phpMyAdmin.

Here is how to back up a MySQL database using phpMyAdmin:

  1. Log in to cPanel.
  2. Click on the “phpMyAdmin” option from the “Databases” section.
    databases
  3. Chose the “Databases” tab.
    select databases
  4. Select the Databases, then select the structures you wish to backup and click on the “Export” button.
    Export
  5. Select the “Custom” option under the “Export Method”.
    custom
  6. Scroll down and find the “Output” option, and chose the type of “Compression”.
    compression
  7. Click on the “Go” button.
    Go
  8. Once the backup process is complete, you will have a copy of your database saved on your computer in the format you chose.
    save
  9. It is recommended to regularly back up your database to ensure that you have a copy of all your data in case of any unforeseen circumstances.

This was the simplest method for using phpMyAdmin to back up a MySQL database. Contact our support staff if you require additional assistance; they will support you in any time of need.

 

 

Tagged: