Cara menggunakan max_input_vars phpmyadmin

Dalam hal ini mungkin juga Anda sering melakukan import database dalam komputer lokal (localhost). Bila file database yang akan Anda unggah ke PhpmyAdmin terlalu besar, maka ada kemungkinan Anda akan mengalami masalah yang sama seperti Saya.

Dalam dokumntasi tersebut di katakan bahwa Saya harus melakukan seting pada file php.ini yang terdapat dalam xampp. Dalam file php.ini baris script yang harus saya edit atau rubah nilai angka dari upload_max_filesize, memory_limit dan post_max_size, misal tadinya hanya 2M Saya rubah jadi 200M, disini sebenarnya untuk nilainya Saya rubah jadi nilai tinggi dan ketika sudah selesai upload Saya rubah nilainya kembali seperti semula, Saya sarankan untuk melakukan backup terlebih dahulu script php.ini sebelum melakukan perubahan

Proses mengedit file php.ini juga sebenarnya pernah Saya lakukan pada  artikel Cara Mudah Memindahkan Artikel Blogger Ke WordPress dimana pada waktu itu juga Saya mengalami kesulitan untuk melakukan import file dari blogger ke wordpress, dan cara mengatasinya pun juga sama yaitu dengan cara mengedit file php.ini

Kesimpulan
Mengatasi Masalah Tidak Bisa Import Database di PhpMyAdmin bisa dilakukan dengan cara mengedit file php.ini pada xampp kemudian merubah nilai pada baris upload_max_filesize, memory_limit dan post_max_size

PLEASE SHARE

Ahmad Zaelani

At Bobcares, we are devoted to coming up with solutions for every query, big and small. Our Server Management Service is here to make your life easier.

Let’s take a look at how our Support Techs recently helped a customer increase the max_input_vars value in the PHP configuration file.

increase max_input_vars for phpMyAdmin

Have you come across a warning message while attempting to use phpMyAdmin to manage very large database tables?

Warning: a form on this page has more than 10000 fields. 
On submission, some of the fields might be ignored, 
due to PHP's max_input_vars configuration.

This warning message is in relation to the default max_input_vars value seen in the phpMyAdmin’s PHP configuration file:

# grep max_input_vars /usr/local/cpanel/3rdparty/php/73/etc/phpmyadmin/php.ini
max_input_vars = 10000

How to increase max_input_vars for phpMyAdmin

First, we have to locate the PHP configuration file. The location may differ according to the PHP version

/usr/local/cpanel/3rdparty/php/*/etc/phpmyadmin/php.ini

Then, we will increase the max_input_vars value and change the memory_limit line in the file via any text editor. According to our Support Techs, it is a good idea to increase the value incrementally. For instance, 10000, 20000, and so on as required.

Furthermore, it is advisable to manage the database via CLI for very large databases. Additionally, increasing the PHP values way beyond the default values may lead to new errors and even cause phpMyAdmin to be unresponsive.

[Need a helping hand? We are available 24/7.]

Conclusion

In brief, we learned How to increase max_input_vars for phpMyAdmin under the guidance of the skilled Support Engineers at Bobcares.

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.