Databases

Export MySQL Database using phpMyAdmin

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. Log in to Ecenica Dashboard
  2. Click Services > My Services.
  3. Click Manage next to your Ecenica web hosting service.
  4. Click phpMyAdmin.
  5. Select the database you wish to export from the left menu.
  6. Click the Export tab.
  7. 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.
  8. Select the format for your export file. SQL is the most common and default option.
  9. 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.

Was this guide helpful?

Need help with this?

Open a ticket and link to this guide so our team can see what you have tried.

View support tickets

Power your business with Ecenica Hosting

Built for WordPress and serious websites. Fast, secure and supported by real people in the UK.

Ecenica hosting services represented by a connected red route across London