Keywords: Drupal - Windows - How to - Other
We are trying to import a table to our Database with phpmyadmin
It works perfect, for any table (.sql file) smaller than 80M but we got this error for any file over 80M. I need to import a table of 400M. This is the error we saw in apache2/logs/error.log
[php7:warn] [pid 13716:tid 1252] [client 127.0.0.1:49868] PHP Warning: POST Content-Length of 91076947 bytes exceeds the limit of 83886080 bytes in Unknown on line 0
We still get the same error when we change php.ini values
upload_max_filesize = 2G
post_max_size = 2G
max_execution_time = 600
I think chenging this values in php.ini does not affect the use of phpmyadmin. I try to reduce this values to 5M and when I try to Import a 20M .sql file... it works anyway!
We are working in a Bitnami Windows Local Host drupal stack.
For developing purposes, We could migrate to local host other drupal sites with no problems, but when we arrive to a big drupal site we got errors usisng phpmyadmin import and also with Back Up and Migrate Module.
Any help will be really appreciated! it´s been some days we spent looking and reading for any solution but we were nos lucky.
Thanks for your help