Tips & Tricks

Nov 23 2012

Import large database to mySQL

There are really many approaches on how to import a 500MB database. Some use mysql command line, some use GUI clients. What I found out to be the quickest way is to log in to mysql console, create a database and execute source command:

$ mysql -u root
 
mysql > create database my_db;
Query OK, 1 row affected (0.00 sec)
 
mysql > use my_db;
Database changed
 
mysql > set names utf8;
Query OK, 0 rows affected (0.00 sec)
 
mysql > source path_to_big_sql_dump.sql
....

select all

One Response to Import large database to mySQL

Igor Sidorenko says:

November 23, 2012 at 8:14 pm

Will it more quickly than:
$ mysql -u root my_db < path_to_big_sql_dump.sql

?

Leave a Reply Cancel reply