There was a problem loading the comments.

phpMyAdmin in Plesk

Support Portal  »  Knowledgebase  »  Viewing Article

  Print

Scenario:

You've moved example.com to a new hosting provider running Plesk, and now you need to import the MySQL database using phpMyAdmin, without using plugins — just like a real developer.


Step-by-Step: How to Use phpMyAdmin in Plesk


Step 1: Log in to Plesk

  • Open your browser and go to the Plesk login URL:

    https://yourdomain.com:8443
  • Enter your admin or client credentials.

65598213e0985d71dd35d00400364386f7fd9c8235129e5be919c8e360160063302ddff5119a5880?t=b938f99c1e2e89ded79f1b31219aea93


Step 2: Create a New Database (for your imported site)

  1. In the left sidebar, click “Databases.”

  2. Click “Add Database.”

  3. Fill in:

    • Database name: e.g., example_db

    • Database user: Create a user (e.g., example_user) and password

  4. Leave the default settings as-is and click OK.

You've now created an empty database, ready to import your data.

ef990df5258f401f1b57782b1545b84013d78a73d3e2f306701a411c7f89f03d39912abd33276371?t=876aafdefabaf4eb6fc51535f6601d26

 

064c9bfd65ce8f7ce36f10fa38eec4539fe6b063c08fea16a7c8bf0344dadb3eb72662ad963b39ce?t=71db6534975c11c2e7f33a00a9ba10c6


Step 3: Access phpMyAdmin

  1. Still under the Databases tab, find the database you just created.

  2. Click the "phpMyAdmin" link next to it.

💡 phpMyAdmin will open in a new browser tab. You're now inside the MySQL admin interface.

5036bbbe2fc1b2d2993fecb01cc9a56ccfe9ffb2954085dd1f10f2c4499367b4fb6a23b24b1de812?t=db55286c9d5ca2aa57ee3a8f2f15126a


Step 4: Import Your Old Database (.sql File)

  1. In phpMyAdmin, make sure you're on the correct database (you’ll see its name at the top left).

  2. Click the “Import” tab in the top menu.

  3. Click “Choose File” and upload the .sql backup from your old host.

  4. Leave the other options default and click Go.

After a few seconds (depending on size), you’ll see a success message.

497d086f6042a1994154eb1fa8682eb237b4914e8ec5ba0a550e8eff5f69b7cce625b1187bd93e9d?t=4c8a313f695758b7fa6733d25d8a6198


Step 5: Update Configuration File (if needed)

If your site (like WordPress) stores DB credentials in a config file, update them to match your new database.

For WordPress:

  1. Open wp-config.php

  2. Update:

     
    define('DB_NAME', 'example_db'); define('DB_USER', 'example_user'); define('DB_PASSWORD', 'your_password'); define('DB_HOST', 'localhost'); // usually stays localhost

Step 6: Test Your Website

Now visit:

http://example.com

If everything is correct — your site should load from the new hosting provider.


Bonus Tips

  • Use phpMyAdmin’s Export tab to back up your database before making changes.

  • If your SQL file is large (100MB+), use SSH + mysql CLI for importing.

  • Always use UTF-8 encoding to avoid charset issues when importing.


Share via
Did you find this article useful?  

Related Articles


Comments

Add Comment

Replying to  

CAPTCHA

On-Premise Help Desk Software by SupportPal
© Support Portal - WP Lighthost