Showing posts with label Not Uploaded or Import in phpMyAdmin Panel. Show all posts
Showing posts with label Not Uploaded or Import in phpMyAdmin Panel. Show all posts

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;

Python Blitz Bits: Zippy Snippets & Spark Projects for Instant Coding Wins

  Python Blitz Bits: Zippy Snippets & Spark Projects for Instant Coding Wins