There are two ways to import a database to phpMyAdmin. You can either use the phpMyAdmin or SSH command. If you are not familier with terminal commands we recommend you stick to the phpMyAdmin way. 

Through phpMyAdmin:  

When using phpMyAdmin you can easily go to the import tab, choose the file you want import and click finish.

Through SSH:

When using terminal for importing a database all you have to do is upload the database dump to the server using rsync or sftp. Once the file is located on the server you insert your information into this command: 

mysql -u USERNAME -p DATABASENAME < FILENAME.sql

After filling inn your information, you are asked to enter the database password. After filling in the correct password, the server will do the rest. 

Did this answer your question?