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.
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.
Give us your feedback on this article
Did this help you?
Want to speed up your site, easily?
Set up your site on Servebolt, free of charge for 60 days, and see for yourself how fast it can be on our extremely fast hosting.
A faster site converts better, ranks better on Google, and is better for the climate.