SHARE

Step by step guide to upload large files to phpmyadmin

When you try to upload a large size database file on phpmyadmin then the error comes “You probably tried to upload a file that is too large” . This error is due to , by default phpmyadmin file upload size is too short .

Error: You probably tried to upload a file that is too large
Error: You probably tried to upload a file that is too large

What changes are required

To solve this error when user click on the documentation ,he/she refereed to do some changes . Referred changes are as follows

post_max_size 
upload_max_filesize 
max_execution_time 
max_input_time
memory_limit 

Make changes or increase limits in upper referred codes to increase file size . These changes are done in php.ini and phpmyadmin congif.default.php file

Enable large file upload
Enable large file upload

Changes in php.ini

To do these changes you need a code editor such as notepad++ . In notepad go to xampp folder then go to php folder . Open php.ini file to edit it . Find each string in this file and change the value of it .

Edit php.ini
Edit php.ini

For example click on Ctrl+F and type post_max_size in the find field and click enter . Find this string in the file and change the value which is may be 8M to replace with 750M. As this change values of all strings . Changed values of string are as follows .

post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M 

After change the values save file .

Edit config.default.php

After do changes in php.ini , go to phymyadmin folder and then go to libraries  . Locate file config.default.php and open it in notepad++ .

Find following string in the file

/**
* maximum execution time in seconds (0 for no limit)
*
* @global integer $cfg['ExecTimeLimit']
*/
$cfg['ExecTimeLimit'] = 300;

Change value of ExecTimeLimit = 300 to 0

/**
* maximum execution time in seconds (0 for no limit)
*
* @global integer $cfg['ExecTimeLimit']
*/$cfg['ExecTimeLimit'] = 0;

Save this file . Close xampp control panel and then restart it . Go to phpmyadmin and try to upload large size database to it .Now your problem is solved .