There are two ways to import databases to MariaDB/MySQL. You can either use the phpMyAdmin, or by using the terminal command
mysql over SSH.
If you are not familiar with terminal commands you stick to the phpMyAdmin way.
Database Import with PhpMyAdmin
When using phpMyAdmin you can easily go to the import tab, choose the file you want import and click finish.
Database Import from the Command Line
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 can run the following command (replace USERNAME, DATABASENAME and FILENAME):
mysql -u USERNAME -p DATABASENAME < FILENAME.sql
When hitting enter, you are asked to enter the database password. After filling in the correct password, the server will do the rest.
Are there unanswered questions you have? Please submit your comments and we’ll get them answered!
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.