Importing 45MB xml file containing posts and comments

  • Hello,

    I have re-designed my wordpress site and am ready to go live on a new server. I exported the xml file containing all of the posts/comments, and when trying to upload it, it says there is a 25MB max. The file is 45MB. I changed the max_upload and max_post size in the php.ini file, but it still errors out saying that the file is either empty or the file size is to large. Is there any way to get the posts/comments from my old site into this new installation and get around this problem??

    Thanks!

Viewing 5 replies - 1 through 5 (of 5 total)

  • php.ini or php5.ini? Also, is the downloaded file compressed?

    But here is a workaround that requires exacting notes and attention to detail…

    A) Use your host provided backup tool. Restore using host tool (to a new db). ?? If host allows a DB of this size they should also be able to restore it. If not, get new host.

    My main point above is that if your new host environment cannot handle this size DB import, what happens in a year or 2? Many hosts limit their ‘free’ MySQL DB sizes…45MB is rather large…consider purging old or obsolete content.

    Thread Starter sf23103

    (@sf23103)

    Thanks for the reply. It doesn’t seem like its the host that is limiting it, but the tool
    That allows for the importing of the downloaded XML file. In WP it even says there is a 25MB limit.

    I’m not super familiar with how the database works, but if I restore it will it mess up my new theme that I designed?

    Are you using phpMyAdmin for both export and import? What did you use for export from old site? How are you importing?

    Thread Starter sf23103

    (@sf23103)

    I’m not sure if it’s considered a plugin, but I was exporting from the admin panel under tools, and then importing to the new site using the import feature under the same tab.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Importing 45MB xml file containing posts and comments’ is closed to new replies.