Friday, August 4, 2023

Big Size MYSQL Upload XAMPP phpMyAdmin Panel

XAMPP Apache + MariaDB + PHP 

Main Problem Is That Big Size MYSQL File Not Uploaded or Import in phpMyAdmin Panel.

Solving Technique Here :-

Try these different settings in C:\wamp\bin\apache\apache2.2.6\bin\php.ini

Find:
post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M

Change to:
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M

And add this to C:\wamp\bin\mysql\mysql5.0.45\my.ini:

max_allowed_packet = 200M

Set Only 3 Parameters from php.ini file of your server

A. max_execution_time = 3000000 (Set as per your requirment)

B. post_max_size = 4096M

C. upload_max_filesize = 4096M

Edit C:\xampp\phpMyAdmin\libraries\config.default.php Page

$cfg['ExecTimeLimit'] = 0;