How to import large SQL data in phpmyadmin?

Whenever we try to import large SQL data into PHPMyAdmin, it takes too much time in processing also most of the time having trouble importing it.

Here is a simple solution for this, Just break large SQL data into small files and import these files in PHPMyAdmin. Here is the syntax for that. You can use it on Mac and Linux.

split -l 1000 largesqlfile.sql sqlfile-

In this syntax -l 1000 tells to split data after every 1000 line. "largesqlfile.sql " is the filename of large data. You can you use the complete path of the file. "sqlfile" is generated small files.