importing a large sql file into mysql

Question

can u tell me how to import a 30mb of sql file in mysql.I am using ubuntu.

Shakti Singh · Accepted Answer · 2011-04-16 06:30:47Z

13

You have to run the following command

mysql -u <user> -p<password> dbname < filename.sql

Another alternate is also a command

log in to mysql using mysql -u <user> -p

mysql > use db_name;
mysql > source filename.sql;

answered Apr 16, 2011 at 6:30

Shakti Singh

86.7k21 gold badges142 silver badges156 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

+1. It took me 10 seconds to import a 22MB file using CLI, whereas it was taking around 2 minutes to do the same thing via phpMyadmin

is this method recommended for 600 MB+ mysql files?

DJafari · Accepted Answer · 2011-04-16 06:48:42Z

0

answered Apr 16, 2011 at 6:48

DJafari

13.6k8 gold badges46 silver badges69 bronze badges