Increase PHPmyAdmin Import File Size in XAMPP

If you want to import / restore MYSQL database backup using phpMyAdmin just follow the below steps,

If you want to import / restore MYSQL database backup using phpMyAdmin just follow the below steps,

By default file import size is 128MB in XAMPP latest version, you need to increase?.

Step 1 : Open your phpMyAdmin on browser and click on "Import" Icon, can see the import file size is (Max 128MiB)


Probably  need to make two changes in php.ini configure file.

Step 2 :  Open your php.ini file from the XAMPP by any text editor (vim, vi, gedit and etc), file location is  /opt/lampp/etc

# vim /opt/lampp/etc/php.ini

Need to find and modify the configurations, post_max_size & upload_max_filesize.

1 2	post_max_size=512M

and

1 2	upload_max_filesize=512M

Step 3 : Once you have modified in php.ini file restart your XAMPP and refresh that same page on browser.

1 2 3 4 5 6 7 8

# /opt/lampp/lampp restart Restarting XAMPP for Linux 1.8.3-4... XAMPP: Stopping Apache...ok. XAMPP: Stopping MySQL...ok. XAMPP: Stopping ProFTPD...ok. XAMPP: Starting Apache...ok. XAMPP: Starting MySQL...ok.

Note : This chnages also acceptable in Windows and restart your XAMPP.