Aug 28, 2016
Import Large Files with PHPMyAdmin
I tried to import large sql file today. But I was getting an error saying there was a keyword error on line "SET Foreign_KEY_CHECKS=ON". Changing the MySQL settings worked. This is what I changed, exactly -
In xampp\php\php.ini post_max_size = 8M -> 750M upload_max_filesize = 2M -> 750M max_execution_time = 30 -> 5000 max_input_time = 60 -> 5000 memory_limit = 8M -> 1000M In xampp\mysql\bin\my.ini max_allowed_packet = 1M -> 500M
Link: http://stackoverflow.com/questions/33698579/phpmyadmin-import-error-mysql-server-has-gone-away-unrecognized-keyword
