How do I export a database with Plesk?
- Start by accessing Plesk through the Client Centre.
- If you have more than one subscription, be sure to select the correct one using the dropdown at the top of the panel
- Under the Websites & Domains tab (default) choose Databases
- 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.
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:
- Be sure you're looking at your list of databases by following steps 1-3 above.
- Click the Users tab
- Choose Add New Database User
- Enter a username and generate a password.
- Be sure to select the correct database in the list otherwise the Webadmin button will still not appear.
- Click OK to save changes
- Click on the Databases tab at the top left to go back to your list of databases
Exporting the database to a file
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
What is the path and version of Perl, MySQL, etc? (Views: 1929)
How do I import a Database with Plesk? (Views: 17954)
Do I have access to phpMyAdmin? (Views: 1521)