WordPress Mu Tips: How to Import and Export Large Blogs Without The Hassle of Splitting The Files Up

First, log in as a site administrator, then go to the blog you want to export from and choose manage -> export, and save your xml file.

Now log into the blog your importing to as a site administrator and choose manage -> import -> WordPress, and load up the xml file.

You probably get an error message like:

The uploaded file exceeds the upload_max_filesize directive in php.ini.

You could edit your php.ini, but I don’t recommend this because it’s the sledgehammer approach. You can probably use a little more finesse by simply editing your .htaccess file (assuming your web server allows .htaccess to override php.ini).

First try this.. edit:

/path/to/your_wordpress_mu_directory/.htaccess

Add these lines to the top (adjust the values how you need to):


php_value  upload_max_filesize  15M
php_value  post_max_size  15M
php_value  memory_limit  48M

If you have over ~1000 posts, you may also need to (temporarily) increase the amount of time php scripts are allowed to run before the web server kills the process. Here’s how you can set the maximum execution time of a php script as well as the http request time to (600 seconds) 10 minutes. Thank you Rosalyn Metz.

php_value max_execution_time 600
php_value max_input_time 600

Now try again. If you get the same problem, you will need to edit your php.ini or get your systems administrator / web hosting provider to do it for you. Some web server configurations don’t allow users to override php.ini with .htaccess.

If you are successful, you will probably get a different error:

This file is too big. Files must be less than 1500 Kb in size.

The good news is that this means you have already configured php to allow WordPress to import your large xml file, but you still need to configure WordPress Mu to allow this. When you install WordPress, MU… it creates a record for each blog setting a variable called “fileupload_maxk” to 1500. This is what is limiting you.

Here’s the SQL code you can use to fix it by changing the variable(s) for every mu blog to a higher number (in this case 15000 bytes, but you can change it to a higher or lower number.)

BE SURE TO PUT IN YOUR DATABASE NAME HERE:

UPDATE `__your_wordpress_mu_database_name_here__`.`wp_sitemeta`
SET `meta_value` = '15000'
WHERE (`wp_sitemeta`.`meta_value` = 1500)
AND (`wp_sitemeta`.`meta_key` like "fileupload_maxk");

When you create new blogs, they will still default to 1500. If you want to change this also, you must edit two files:

/path/to/your_wordpress_mu_directory/wp-includes/wpmu-functions.php

and

/path/to/your_wordpress_mu_directory/wp-admin/includes/mu.php

Just change:

get_site_option( 'fileupload_maxk', 1500 )

to

get_site_option( 'fileupload_maxk', 15000 )

(….. or some number of bytes you want instead of 15000.)

That’s it, you should be able to import wordpress blogs as large as you want now.

Tagged with: ,
Posted in uncategorized misfits
24 comments on “WordPress Mu Tips: How to Import and Export Large Blogs Without The Hassle of Splitting The Files Up
  1. Rajesh says:

    Thnx! It helped!!

  2. mark says:

    Im getting an error of Firefox can’t find the file at “blogpath”/wp-admin/export.php?author=all&submit=Download+Export+File&download=true.

    Is this due to the php.ini file not being able to handle the 20meg export?

  3. I inclination not concur on it. I regard as warm-hearted post. Specially the designation attracted me to be familiar with the sound story.

  4. Terrell Bosler says:

    Sharp looking page and some great content – do you guys have a facebook group or a twitter page?

  5. I just wanna say thanks for this information.Its really a big help to me because that was my problem for a long time but through this now i have my solution about my problem.you posted a great information.please do keeping on updating us keep it up!

  6. I have the problem too of getting to a blog and finding that I figure the conversation is already over hours ago. That’s the downside of putting the hour stamp on your comments by the way.

  7. exclusiveeat says:

    How did you make this template? I got a blog as well and my template looks kinda bad so people don’t stay on my blog very long.

  8. Huey Pariser says:

    Hello dude,i like Ones New website ideal a lot. achieve u have suggestion as my website? thanks for Ones New attention

  9. great luck for consumers

  10. Alittle says:

    Thnx! It helped!!

  11. Jarrett Charnley says:

    Wow that is an very interesting blog entry for me. I like your wordpress blog. Maybe you should write more articles of these type.

  12. arendaserviceilo says:

    Будущее в ваших руках. Отдельное спасибо за статью

  13. Kurye says:

    Good article from you. Thanks.

  14. for the large canvas, but I’m fatherly the new Zune, and plan this, as source as the superior reviews several written, improve you if it’s the reactionary prime for you.

  15. When 1 conceives the problem at hand, i’ve to agree with your finishes. You distinctly show cognition about this topic and i have substantially to learn right after reading your post.Several salutations and i will come back for any additional updates.

  16. Neal Trojak says:

    I’ve been checking your blog site for any even though now, appears to be like everyday I study some thing new 🙂 Thanks

  17. mircsohbet says:

    Good Thanks.

  18. Isaias says:

    Hiya, I am really glad I’ve found this info. Today bloggers publish just about gossips and web and this is actually frustrating. A good blog with interesting content, that’s what I need. Thanks for keeping this web site, I’ll be visiting it. Do you do newsletters? Can’t find it.

  19. Kailash says:

    thanks! it was useful!