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;
Be secure. Buy an SSL certificate.
  • Secures data transfers
  • Avoids browser warnings
  • Improves your Google ranking

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 yours today!
  • Simple registration
  • Premium TLDs at great prices
  • 24/7 personal consultant included
  • Free privacy protection for eligible domains
Was this article helpful?
We use cookies on our website to provide you with the best possible user experience. By continuing to use our website or services, you agree to their use. More Information.