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 .
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
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 .
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 .
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 .