By default, PhpMyAdmin in a CPanel server imposes an upload limit of 50MB. So importing a SQL file larger than 50MB may time out.
1. Login to the with SSH and root
2. Search the path of php.ini (Generally its located in /usr/local/lib/php.ini)
3. Search for “upload_max_filesize” and increase the value as per the requirements
You may also want to change values of max_execution_time and memory_limit.
upload_max_filesize = 250MB
post_max_size = 500MB
memory_limit = 512MB
max_execution_time = 3600