Command Line To Import Large .sql [How To]

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


Leave a Reply