While exporting Magento database from xampp (using PhpMyAdmin).I am getting error .sql file. and also getting a warning message during export start.

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.

enter image description here

How can export a Magento database when I'm getting an error like this?

Magento version : Magento ver.

2 Answers 2


Export from command line if you have having issues with exporting from phpMyAdmin.

backup/export: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

restore: # mysql -u root -p[root_password] [database_name] < dumpfilename.sql

Similar question on StackOverflow


Add the following lines to php.ini file,

max_input_vars = 5000
suhosin.request.max_vars = 5000
suhosin.post.max_vars = 5000

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.