It is difficult to import schema and data from large size sql file using phpymyadmin. Because it will fail due to memory limitation or time out setting.
In this case we use commandline feature for mysql to process the large sql file.
We can use like below
mysql> SOURCE /path/to/file.sql;
For doing this we should have access to the mysql server. But practically it is not possible to have direct access to mysql server all times Because most of the servers will be available in remote machine only.
So I am looking for any feasible solution to achieve it thro' web UI itself (i-e similar to phpmyadmin). If anyone knows any appropriate solution you can share it here thro' comments.
You can refer this for more details.