Unable to export mysql db from phpmyadmin

Discussions related with hosting control panels used, which include cPanel, Plesk, Directadmin etc..

Moderator: Staff

Post Reply
Yang-Tze Ong
Posts: 0
Joined: Fri Apr 27, 2018 4:07 am

Unable to export mysql db from phpmyadmin

Post 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.


Aaron
Posts: 17
Joined: Mon Apr 11, 2016 8:59 am

Re: Unable to export mysql db from phpmyadmin

Post 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


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
If you are looking for assistance in server management, please get in touch with our support.
Post Reply