Monday, December 21, 2015

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.