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.


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.


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.


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.


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