phpMyAdmin’s upload limit in XAMPP is controlled by PHP settings and by phpMyAdmin’s own config. To increase the maximum import file size, update PHP’s upload limits and, if needed, phpMyAdmin configuration and Apache settings. Steps below assume Windows XAMPP; the file paths are the XAMPP defaults — adjust for macOS/Linux installations.

1) Stop Apache and MySQL
- Open the XAMPP Control Panel and stop Apache (and MySQL if you prefer).

2) Edit php.ini (PHP configuration)
- Open: wzxhzdk:1/php/php.ini
- Locate and change these directives to your desired limits (example: 200M):
- upload_max_filesize = 200M
- post_max_size = 210M
- memory_limit = 512M (ensure this ≥ post_max_size)
- max_execution_time = 300 (increase if large imports take long)
- max_input_time = 300
- Save php.ini.

3) Edit Apache’s httpd.conf or httpd-vhosts.conf (if using wzxhzdk:2 or proxy)
- Usually not required for typical setups. If you use mod_fcgid or have proxy limits, adjust accordingly (rare for default XAMPP).

4) Adjust phpMyAdmin settings (optional)
- Open: wzxhzdk:3/phpMyAdmin/config.inc.php
- Not usually necessary; phpMyAdmin reads PHP limits. But to increase allowed import size shown in the interface or impose limits, add or edit:
- $cfg['UploadDir'] = 'upload'; (enables server-side import from phpMyAdmin/upload directory)
- To import files larger than PHP limits use the UploadDir method (server-side):
- Create folder: wzxhzdk:4/phpMyAdmin/upload
- Place large .sql/.zip files there.
- In phpMyAdmin import UI, choose the “Upload directory” option.

5) Restart Apache
- Use XAMPP Control Panel: start Apache (and MySQL).

6) Verify changes
- Create a PHP info page: save this as wzxhzdk:5/htdocs/info.php:
wzxhzdk:0

• Open http://localhost/info.php and confirm upload_max_filesize and post_max_size reflect new values.
• Open phpMyAdmin import page — the “Max: …” value should be updated.

7) Alternatives for very large imports
- Use command line MySQL client (recommended for big files):
- Open a terminal/Command Prompt, then:
mysql -u root -p database_name < C:\path\to\largefile.sql