Knowledgebase

HOW CAN I IMPORT A DATABASE USING PHPMYADMIN?

Log into phpMyAdmin from your Control Panel -> Website Manager section using your Database Username and Database Password.
For phpMyAdmin 3 click the Import button.
For phpMyAdmin 2 click the 'SQL' square button and a dialog box will prompt with an option to browse for a SQL file of your database and click on the 'Go' square button.

Note: You should make some slight modifications to your database.sql file prior the import. You need to remove the CREATE DATABASE and USE commands at the first lines of your database.sql file. The lines in question are shown below. Be advised that for phpMyAdmin 3 you need to remove the CREATE DATABASE line and update the USE command so it uses your MySQL User listed in the MySQL Manager section of your Hosting Control Panel.

−− CREATE DATABASE 'username_db' DEFAULT CHARACTER SET XXXX COLATE XXXX;
−− USE username_db;