Export MySQL databases

Follow these steps to export the entire MySQL database, or export selected tables of the database, to a file and download it to your computer.

  1. Access your database via PHPMyAdmin: Web & Classic | cPanel | Plesk
  2. In the phpMyAdmin home page, select the database that you want to export.
    select database to export
  3. From the tabs at the top of the page select Export.
    click export tab
  4. To export the entire database, continue with the next step.

    To export only specific tables in the database, below Export method select Custom - display all possible options, and in the Tables list select only the tables you want to export. Leave all other options set to their default values.

  5. Click Go. You'll be prompted to open or save the file.
  6. Click OK. The database or table from the database is exported as an SQL file.

More info

Was This Article Helpful?
Thanks for your feedback. To speak with a customer service representative, please use the support phone number or chat option above.
Glad we helped! Anything more we can do for you?
Sorry about that. Tell us what was confusing or why the solution didn’t solve your problem.