importing a large sql file into mysql

can u tell me how to开发者_开发百科 import a 30mb of sql file in mysql.I am using ubuntu.

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;

Use BigDump.php