1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Problem: WP admin side crashes after importing 14k articles from XML...

Discussion in 'Blogging' started by tpaolo, Oct 21, 2013.

  1. tpaolo

    tpaolo Regular Member

    Joined:
    May 28, 2009
    Messages:
    333
    Likes Received:
    45
    hi, friday I imported about 14k articles from a XML feed using Wp all Import plugin (it took 3/4 hours), after that I cound't enter to admin area because of a "memory allocation error" I could solved only removing some thousands of articles, however front-end side worked fine for visitors.

    Is there some hint, trick or plugin that can avoid me to get memory allocation error? Why front-end was Ok and admin-end not?
    Thanks for help.
     
  2. ice41

    ice41 Power Member

    Joined:
    Aug 18, 2012
    Messages:
    783
    Likes Received:
    248
    Occupation:
    Web Designer
    Location:
    Land of Pineapples
    Ask your hosting to upgrade your PHP memory limit to 64mb. That will solve your issue.
     
  3. tpaolo

    tpaolo Regular Member

    Joined:
    May 28, 2009
    Messages:
    333
    Likes Received:
    45
    I set it up to 2048M, yesterday I did the same and today admin shows a blank page, better than a "memory allocation error"...
     
  4. CyberSEO

    CyberSEO Senior Member

    Joined:
    Jul 14, 2011
    Messages:
    939
    Likes Received:
    256
    Occupation:
    programmer
    Home Page:
    Don't forget to restart your server.
     
  5. tpaolo

    tpaolo Regular Member

    Joined:
    May 28, 2009
    Messages:
    333
    Likes Received:
    45
    Hi, i restart it but blank admin page still loads...193MB of db, 100k posts, it shouldn't be a problem for WP and a dedi server
     
    Last edited: Oct 22, 2013
  6. imm088

    imm088 Registered Member

    Joined:
    Dec 26, 2012
    Messages:
    88
    Likes Received:
    27
    hey rebuilt your vps, edit php.ini and set max memory to 0(unlimited)
     
  7. tpaolo

    tpaolo Regular Member

    Joined:
    May 28, 2009
    Messages:
    333
    Likes Received:
    45
    how do I do it?
     
  8. jia4u

    jia4u Registered Member

    Joined:
    Dec 31, 2010
    Messages:
    55
    Likes Received:
    16
    there is a simple solution. export your database. install wordpress on your computer and use your plugin. after you have done that. then export the whole sql file to your server.

    hope it helps.
    jia4u
     
  9. imm088

    imm088 Registered Member

    Joined:
    Dec 26, 2012
    Messages:
    88
    Likes Received:
    27
    delete everything and install again the os
     
  10. imm088

    imm088 Registered Member

    Joined:
    Dec 26, 2012
    Messages:
    88
    Likes Received:
    27
    or install wp into a subdomain/folder and move it or allocate it in httpd.config in your main domain
     
  11. iglow

    iglow Elite Member

    Joined:
    Feb 20, 2009
    Messages:
    2,081
    Likes Received:
    856
    Home Page:
    wp is not good to handle such big files, but anyways this is fault of RAM on your server. propably shared is too small for it.
     
  12. tpaolo

    tpaolo Regular Member

    Joined:
    May 28, 2009
    Messages:
    333
    Likes Received:
    45
    no, thanks...I'm waiting an answer from server company too
     
  13. SEOWhat

    SEOWhat Regular Member

    Joined:
    Feb 7, 2013
    Messages:
    245
    Likes Received:
    73
    Occupation:
    Web designer, We Developer, SEO
    Location:
    EU
    ...and why not simply split that XML file into few smaller ones?
     
  14. tpaolo

    tpaolo Regular Member

    Joined:
    May 28, 2009
    Messages:
    333
    Likes Received:
    45
    this should be a great solution, however the best feature of wp allimport is importing data from external URL, in this case a Tradedoubler merchant feed, this is what I did