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

Was this answer helpful? 0 Users Found This Useful (0 Votes)