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.

  1. First, log in cPanel 
  2. Next, file manager > public_html > php.ini open this file on cPanel editor  
  3. 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

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