Page 1 of 1

Unable to export mysql db from phpmyadmin

Posted: Fri Apr 27, 2018 4:15 am
by Yang-Tze Ong
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.

Re: Unable to export mysql db from phpmyadmin

Posted: Sat Apr 28, 2018 4:17 am
by Aaron
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