Import a MySQL/MariaDB Database

In order to import a MySQL/MariaDB database file, you will first need to create an empty database. Log in to the MySQL/MariaDB client with the command:

Enter the MySQL/MariaDB root user's password, then create the database:

For example, to create a database named my_db the command is:

Once this is done, log out of the client:

You can now import the database file with the command:

For example, to import a .sql dump file named my_db-10-01-2016.sql into the my_new_db database, the command is: