Command Line To Import Large .sql [How To]

2010-08-20

I have been searching for the solution to import Large Mysql around 200 MB. I tried various method including Bigdump.php But didnot worked for me. Finally I got the Solution.I have the shell access so I can execute command line. There is just a one command enough to import huge .sql file.

mysql -u username -p password database_name < filename.sql

In similar way if you want to export sql you can do it from shell.

mysqldump -u USER -p PASSWORD DATABASE > filename.sql