How to import sql file of size more than 500MB to cPanel phpMyAdmin
I have .sql file of 550MB. I 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
Make a Remote SQL connection with the server,
it can be via:
Or via SSH account.
Open that connection from a client app like MySqlWorkbench or from terminal.
Run the script file directly, rather than open it.