3

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

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

2

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, privacy policy and cookie policy

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