[FIXED] How to import sql file of size more than 500MB to cpanel phpmyadmin

Issue

I have .sql file of 550MB, tried to import with phpmyadmin in cpanel. It gives an error of max file size. Can anyone give me idea for this. Thanks in advance.

Solution

1. Make a Remote SQL connection with the server,

   it can be via:

   

   Or via SSH account.

2. Open that connection from a client app like MySqlWorkbench or from terminal.

3. Run the script file directly, rather than open it.

Answered By - Wajih