Nixtree.com - 24x7 Technical Support & Server Management

Posted: **Fri Apr 27, 2018 4:15 am**

Hello,

My server is installed with cPanel, when I tried to export MySQL database from PHPmyadmin it shows the below error. It seems something denying me to export the db, please would you help me to resolve this error.

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

Posted: **Sat Apr 28, 2018 4:17 am**

Hello Yang,

You need to increase the max_input_vars in this file resolves the error when exporting a database that has more than 1000 tables.

For CPanel server: Increase values on

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

If you are using Cloudlinux and cagefs, you may also need to update cagefs to load the new value with this command.

Code: Select all

cagefsctl --force-update

If that doesn't work, you may need to rebuild the cagefs with this command.

Code: Select all

cagefsctl --reinit

Also cPanel forum recommends to run the below commands, Changes to /usr/local/cpanel/3rdparty/etc/php.ini will persist but will always need the following run afterward.

Code: Select all

/usr/local/cpanel/bin/install_php_inis
/scripts/restartsrv_cpanel_php_fpm

Nixtree.com - 24x7 Technical Support & Server Management

Unable to export mysql db from phpmyadmin

Unable to export mysql db from phpmyadmin

Re: Unable to export mysql db from phpmyadmin