How to increase phpmyadmin import file size in xampp localhost

To increase the PHPMyAdmin import file size in XAMPP on your localhost, follow these steps:

Step 1: Modify php.ini

• Open XAMPP Control Panel.

• Click Config next to Apache and select PHP (php.ini).

• Find and update the following values:

upload_max_filesize = 100M
post_max_size = 100M
memory_limit = 256M
max_execution_time = 300
max_input_time = 300

(You can set 100M or a larger value based on your needs.)

Step 2: Modify config.inc.php (Optional)

• Open C:\xampp\phpMyAdmin\config.inc.php.

• Add or modify this line:

 $cfg['ExecTimeLimit'] = 300; 

Step 3: Restart Apache Server

1. Go to XAMPP Control Panel.

2. Stop and Start Apache and MySQL.

Step 4: Verify in PHPMyAdmin

1. Open phpMyAdmin (http://localhost/phpmyadmin).

2. Click Import and check the new Max: file size limit.

Now, you should be able to import larger SQL files.

How to downgrade php version in xampp?