Is it possible to export a MySQL database?

Category: MySQL

Yes, the easiest way to export a MySQL database is through phpMyAdmin. To do this:

  1. Login to cPanel.
  2. Click the phpMyAdmin icon.
  3. Using the left hand menu of phpMyAdmin, select the database you wish to export.
  4. Now that you’re viewing the particular database, click the Export tab.
  5. Choose your export method (Quick is generally the norm) and select the format to export it as (typically SQL); then click Go.
  6. This will give you a download prompt confirming where to download it to on your computer.

If your database is quite large (in excess of 100MB) it may time out during export. In the event of this occurring you may need to lodge a Support Request through your Synergy Wholesale System account to have the support staff conduct a mysqldump of the database. We kindly request you attempt an export through phpMyAdmin as your first port of call.