By default, PhpMyAdmin in a cPanel server imposes an upload limit of 50MB. So, importing a SQL file larger than 50MB may time out. To increase the default upload limit, just follow these steps.
- First, log in cPanel
- Next, file manager > public_html > php.ini open this file on cPanel editor
- Search for upload_max_filesize and increase the value as per your requirements.
*Note: You may also want to change the values of max_execution_time and memory_limit.
upload_max_filesize = 250MB
post_max_size = 500MB
memory_limit = 512MB
max_execution_time = 3600
