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.
Unable to export mysql db from phpmyadmin
Moderator: Staff
-
- Posts: 0
- Joined: Fri Apr 27, 2018 4:07 am
cPanel Server Management
@ 30$ Onwards
@ 30$ Onwards
Re: Unable to export mysql db from phpmyadmin
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.
If that doesn't work, you may need to rebuild the cagefs with this command.
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.
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
Code: Select all
cagefsctl --reinit
Code: Select all
/usr/local/cpanel/bin/install_php_inis
/scripts/restartsrv_cpanel_php_fpm
Aaron N
Linux Support Engineer.
Nixtree Solutions LLP
Managed Full Server Backups
https://www.nixtree.com/managed-backups.php
Follow us on : https://twitter.com/nixtree
Linux Support Engineer.
Nixtree Solutions LLP
Managed Full Server Backups
https://www.nixtree.com/managed-backups.php
Follow us on : https://twitter.com/nixtree