How to create a database dump using phpMyAdmin in Plesk

This guide explains how to create a database dump using phpMyAdmin in Plesk.

Follow the steps-

1. Access the database by logging in to your Plesk control panel.
2. Navigate to Websites & Domains, and select the domain name associated with the database you want to dump (e.g., example.com).
   
   
3. Click on Databases in the left menu.
   
   
4. Locate the specific database name and click on it.
5. Click on phpMyAdmin in the top right corner. This will launch the phpMyAdmin interface for the selected database.
   
   
6. Click on the Export tab from the top menu in phpMyAdmin-
   1. Tables- Choose the specific tables you want to include in the dump. Leave it unchecked to export the entire database.
      
   2. Format- Select SQL as the format for the dump file.
      
   3. Output- Choose Save as file.
   4. Compression- Select none (unless you want the file compressed).
      
      
7. Configure export settings in the Structure section, and make sure both Structure and Data checkboxes are selected.
   
   
8. For Add DROP TABLE / DROP VIEW, check the box if you want the script to drop existing tables with the same names during import (useful for overwriting data).
9. Choose either Add comments or No comments based on your preference.
10. Download the dump by clicking the Go button at the bottom of the page.
11. You will be prompted to save the generated SQL file containing the database dump. Choose a secure location on your local machine to save the file.

This way, you can create a database dump using phpMyAdmin in Plesk. If you encounter any problem in this process, feel free to seek assistance from our support team. They are available 24×7.