Importing Databases

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