How do I export a database with Plesk?

Exporting a database with Plesk is done via the phpMyAdmin utility, which Plesk calls "DB Web Admin" or just "Webadmin".

Accessing phpMyAdmin
  1. Start by accessing Plesk through the Client Centre.
  2. If you have more than one subscription, be sure to select the correct one using the dropdown at the top of the panel
  3. Under the Websites & Domains tab (default) choose Databases
  4. Look for your database in the list and click the "Webadmin" button to the right. If there is no webadmin button for the database, see below for a solution.
This will log you in to the phpMyAdmin utility automatically. Skip down to "Exporting the database to a file" if everything went smoothly up until this point.

No Webadmin Button?

If you don't see a Webadmin button for the database, this means there is no database user associated with the database. Without a user account to access the database, you can't view it! To fix this, create a new database user assigned to the database you are attempting to export. Here's how:
  1. Be sure you're looking at your list of databases by following steps 1-3 above.
  2. Click the Users tab
  3. Choose Add New Database User
  4. Enter a username and generate a password.
  5. Be sure to select the correct database in the list otherwise the Webadmin button will still not appear.
  6. Click OK to save changes
  7. Click on the Databases tab at the top left to go back to your list of databases
You should now be able to click through to Webadmin.

Exporting the database to a file

Simple Method

To export the database, choose the "Export" button in the toolbar across the top of the page. You can keep the export method at "Quick" and the Format at "SQL" to make things simple and click Go to obtain your database export, however this will not compress the database contents and therefore could take some time to download.

Advanced Method (with Compression)

If you wish to obtain a compressed download of the database, choose Custom for the export method and scroll down. All tables should be selected by default -- there's no need to change this. Ensure "Save output to a file" is selected (it should be) and set Compression to Zipped if you're on Windows or gzipped if you're on a Mac or Linux OS (gzipped is often better compression, but files are usually not recognized by Windows without a third party app).

Unless you know what you're changing, leave all other settings at their default, scroll down and click Go. You will now have a compressed full export of your database!
  • 0 Users Found This Useful