Open phpMyAdmin in Plesk and import/export a database

phpMyAdmin is a web interface for managing MySQL/MariaDB databases. On GARMTECH hosting you can open phpMyAdmin directly from Plesk for each database.

Open phpMyAdmin

1. Log in to Plesk.
2. Go to Databases.
3. Find the required database and click phpMyAdmin (sometimes it is called WebAdmin).

Export a database (backup)

1. In phpMyAdmin, select the database on the left.
2. Open the Export tab.
3. Choose:
   • Quick for a fast full export, or
   • Custom if you need to select tables or enable compression.
4. Format: SQL. Optional: enable gzip compression.
5. Click Go to download the .sql (or .sql.gz) file.

Import a database

1. Create the database and user in Plesk first (Databases → Add Database). Assign the user to the database.
2. Open phpMyAdmin for the target database.
3. Go to Import and select your .sql, .zip or .gz file.
4. Character set: usually utf8 / utf8mb4 (leave default if you are not sure).
5. Click Go and wait until the import completes.

If the import fails

• File is too large / timeout: try uploading a .gz export, or temporarily increase PHP limits in Plesk (upload size and execution time).
• “#2006 MySQL server has gone away”: usually means the import is too large or takes too long. Split the SQL file into smaller parts and import in chunks.
• You see table prefix conflicts: import into an empty database, or remove existing tables first (only if you are sure you no longer need them).

Related articles

• Create a database and user in Plesk (MySQL/MariaDB)
• Increase PHP limits in Plesk (upload_max_filesize, memory_limit, execution time)
• Create and restore backups in Plesk (Backup Manager)