How to 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:
mysql -u root -p
Enter the MySQL/MariaDB root user's password, then create the database:
CREATE DATABASE [database name];
For example, to create a database named my_db the command is:
CREATE DATABASE my_new_db;
Once this is done, log out of the client:
quit;
SSL certificates from IONOS
Protect your domain and gain visitors' trust with an SSL-encrypted website!
You can now import the database file with the command:
mysql -u [username] -p [new database name] < [.sql dump file name]
For example, to import a .sql dump file named my_db-10-01-2016.sql into the my_new_db database, the command is:
mysql -u root -p my_new_db < my_db-10-01-2016.sql
$1 Domain Names
Register great TLDs for less than $1 for the first year.
Why wait? Grab your favorite domain name today!
Related articles
How to Backup Databases with MySQLDumper
“Data is the new oil!”. So when it comes to online businesses, loss of data means loss of capital. Important and sensitive data should be backed up at regular intervals. Thanks to free programs such as MySQLDumper you can create MySQL database backups in minutes! Once installed, you can use the software to automatize and administer backups.
How to Reset the MySQL or MariaDB Root Password
Learn basic MySQL/MariaDB disaster recovery and preparedness: How to reset the root MySQL/MariaDB password.
How to install and use MySQL/MariaDB
MySQL/MariaDB is one of the most popular relational databases. Under Linux, it is easy to install and manage via the terminal. Find out how to install Mysql with this article’s step by step instructions. We will also show you the basic commands so that you can create your first custom database. What are you waiting for?
