4

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

Improve this question

2 Answers 2

Reset to default
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

Improve this answer
2

Add the following lines to php.ini file,

max_input_vars = 5000
suhosin.request.max_vars = 5000
suhosin.post.max_vars = 5000
Improve this answer

Your Answer

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

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