Log into phpMyAdmin from your Control Panel -> Website Manager section using your Database Username and Database Password. Once you are inside the phpMyAdmin click the import button and select the database which you would like to import.

Note: You might have to make some slight modifications to your database.sql file prior to 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.

−− CREATE DATABASE ‘username_db’ DEFAULT CHARACTER SET XXXX COLATE XXXX;

−− USE username_db;

Note: If your database backup/dump is too big and you are unable to import it using phpMyAdmin, try importing it via SSH.


Keep reading