How do I import a MySQL database using phpMyAdmin?

If you have a .sql file and want to import it into your MySQL database using phpMyAdmin, follow this quick and easy guide.

Step 1: Log in to cPanel

1. Visit your cPanel login URL:
   https://yourdomain.com:2083
2. Enter your username and password.

Step 2: Access phpMyAdmin

1. Inside the cPanel dashboard, scroll to the Databases section.
2. Click on phpMyAdmin.

Step 3: Select the Target Database

1. Once phpMyAdmin opens, look at the left sidebar.
2. Click the name of the database you want to import data into.

💡 If you haven’t created a database yet, go back to cPanel → MySQL Databases to create one.

Step 4: Import the SQL File

1. Click on the Import tab at the top menu.
2. Click Choose File and select your .sql file from your computer.
3. Keep the format as SQL.
4. Click the Go button at the bottom.

Step 5: Wait for Import to Complete

• If the import is successful, you’ll see a green success message.
• If there’s an error, double-check:
  • The file is a valid .sql file.
  • The database is empty (or supports overwrite).
  • File size is within server upload limits (usually 50–100MB).

Troubleshooting Tips

Error: File Too Large

• Use SSH or MySQL command-line for large databases.

Error: Unknown Collation

• Open the .sql file in a text editor.
• Search and replace unsupported collations (e.g., utf8mb4_0900_ai_ci) with a supported one like utf8mb4_general_ci.

Verify the Imported Database

1. Browse tables using the left panel in phpMyAdmin.
2. Confirm your data has been imported correctly.

Need Help?

If you’re facing any issues, feel free to contact our support team or open a ticket.