When using phpMyAdmin you can easily go to the import tab, choose the file you want import and click finish.
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.
Published on: 04 / 01 / 2018