How to import a database using phpMyAdmin

How to import a database using phpMyAdmin

phpMyAdmin allows you to import SQL files into your database.

Before you start

• Create the database first if it does not already exist.
• Make sure you have a recent backup.
• Check that your SQL file is not larger than the upload limit.

Steps

1. Log in to cPanel.
2. Open phpMyAdmin.
3. Select the database from the left menu.
4. Click the Import tab.
5. Choose your SQL file.
6. Click Import.

If the import fails

Large databases may need to be imported in smaller parts or through command line access if available. Contact support with the error message.