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