I am trying to import a very big CSV file into my Drupal 7 site using the Feeds module, but I get the following error:
Warming: POST Content-Length of 40245470 bytes exceeds the limit of 8388608 bytes in Unknown on line 0
How can I fix this?
Add a comment
|
2 Answers
8388608 bytes is 8MB, not 8GB. 40245470 bytes is < 40MB.
Your PHP settings are limiting the maximum POST content length to 8MB, which is why you're getting the error.
To fix, edit your php.ini file and add/update these lines:
post_max_size=50M
upload_max_filesize=50M
Not many things could handle this. For importing massive amounts of information from an external database, you are better off to do it using Feeds and Feeds Database. Even then you will probably be best to do it progressively in chunks.
If you are intent on using csv files, then export them from your original database using limited queries and create several files:
SELECT ......... LIMIT 100 OFFSET 0;
SELECT ......... LIMIT 100 OFFSET 100;
and so on until you have all the information.
answered Mar 27, 2013 at 18:30
-
you sir surely knows everything. are you a God or something? Commented Mar 27, 2013 at 18:32
-
wait how do i limit it? like your code. i did the converting in the export tab in phpmyadmin Commented Mar 27, 2013 at 18:33
-
Unless you can use a query editor, I don't believe you can do this through phpmyadmin. Although the program simplifies a number of routine tasks, it does not have a lot of support for the less common ones. I have always used the command line interface with mysql, so I do not know much about phpmyadmin. Commented Mar 27, 2013 at 19:45
-
dev.mysql.com/downloads/workbench provided your mysql host has an open port would negate that, phpmyadmin can also open local files (if configured for it) so ftp could negate that. Be careful if it's a shared host though you may make someone mad if you don't limit it a bit. Commented Mar 28, 2013 at 4:46