I have one SQL file which contains database and is 450+ MB. I tried phpMyAdmin, however phpMyAdmin does not support the import of such large files.
Can anyone suggest way or command to import it through command line.
There are multiple ways to do this.
Here's one way:
mysql -u root -p)
Create database testimport_db;
Here's a screenshot:
Note: If you get the path of your sql fle wrong. Then use absolute path instead. Related post
mysql -uroot -p[your_password] database_name < sql file
If you want to run this as background process in LINUX then put an
& at the end like below:
mysql -uroot -p[your_password] database_name < sql file &