0

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?

5

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
| improve this answer | |
1

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.

| improve this answer | |
  • you sir surely knows everything. are you a God or something? – Belmark Caday Mar 27 '13 at 18:32
  • wait how do i limit it? like your code. i did the converting in the export tab in phpmyadmin – Belmark Caday Mar 27 '13 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. – Triskelion Mar 27 '13 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. – ransom bot Mar 28 '13 at 4:46

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.