PHPMYADMIN import file size

I got a problem when trying to import SQL file using PHPMyAdmin. my PHPMyAdmin allow import file with max size 2M, actually my SQL file has 16MB. You can solve this problem by editing the php.ini file.

If you running linux with apache2 and PHP 5,  use command sudo gedit /etc/php5/apache2/php.ini

If you have running XAMPP, \xampp\apache\bin\php.ini

Find the upload_max_filesize and change the value to 32MB. If your file bigger than 32MB, change it as what you need. Then Restart your apache server :

It’s quite simple how to start / restart / stop the apache web server. Open your console and use this command.

Start sudo /etc/init.d/apache2 start

Restart : sudo /etc/init.d/apache2 restart

Stop : sudo /etc/init.d/apache2 stop

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s