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; 
  • 1 Utilizadores acharam útil
Esta resposta foi útil?

Artigos Relacionados

DO YOU SUPPORT MYSQL?

Yes. All of our servers support MySQL.

HOW CAN I ACCESS MY DATABASE ONLINE?

Login your contorl panel, click on the phpMyAdmin/phpPgAdmin icon, then use the following...

WHY IN PHPMYADMIN THERE IS AN ERROR MESSAGE "YOU HAVE NO PRIVILEGES"?

The only privileges that your database does not have are CREATE and new databases. If you wish to...

CAN I MANAGE MY DATABASE CREATED THROUGH THE HOSTING CONTROL PANEL FROM MY LOCAL COMPUTER?

Access to the MySQL and PostgreSQL servers has been restricted on all shared hosting plans. If...

HOW CAN I EXPORT A DATABASE USING PHPMYADMIN?

Log into phpMyAdmin from your Control Panel->Website Manager section using your Database...