Need to manually migrate a WordPress site or take a quick snapshot of your database? The built-in phpMyAdmin interface is the perfect tool for standard database operations.
Exporting a Database (.sql)
- Go to Databases in your Plesk left menu.
- Locate the database you want to backup and click on phpMyAdmin. A new tab will open.
- In phpMyAdmin, ensure your database is selected on the left pane, then click the Export tab at the very top.
- Keep the Export method as "Quick" and the Format as "SQL".
- Click Go (or Export). Your browser will download an `.sql` file containing all your tables and data.
Importing a Database
- Access phpMyAdmin for the target database.
- Click the Import tab at the top.
- Click Choose File and select your downloaded `.sql` file.
- Scroll to the bottom and click Go (or Import). Let the process finish—do not close the tab!
File Size Limits: If your `.sql` file is larger than the maximum upload limit (usually around 128MB or 256MB), phpMyAdmin might fail. For massive databases, use the Import Dump / Export Dump buttons directly inside the Plesk Databases screen instead!
