How to Import a MySQL Database using phpMyAdmin?
To import a mysql database in cpanel using phpMyAdmin, follow the steps provided below.
Step 1: Login to Control Panel providing your username and password.
Step 2: Enter php in the search box. From the search results, select phpMyAdmin under Databases.
Step 3: In the phpMyAdmin window, select a database and click Import option from the top menu.
Step 4: Select Browse option and select File.
Note: Your file must be in .sql format. It can also be a compressed file (.sql.zip) format. The file size should not exceed 50MB.
Step 5: Once after uploading file, click Go. The file will be imported under the database.