Export MySQL Database using phpMyAdmin

How can I download a copy of my MySQL database?

In this article we show you how you can quickly and easily export your MySQL database using phpMyAdmin.

Steps to export your MySQL database using phpMyAdmin

  1. Login into your Ecenica cPanel control panel. See Where do I login to my hosting control panel
  2. Click phpMyAdmin
  3. Select the database you wish to export from the left menu.
  4. Click the Export tab.
  5. Select Quick or Custom. Quick let’s you download a .sql file of your database immediately. Custom gives you more control over the export file and export options.
  6. Select the format for your export file. SQL is the most common and default option.
  7. Click Go.

Your web browser will begin the download of your database export file. The time it will take to export and download your file depends on your internet connection and the size of your database.

The maximum file size you can download is 100MB. If you want to export a larger SQL file we recommend exporting your MySQL database using SSH.