As you may aware, when your xml size is over 2M, wordpress may encounter certain difficulties of importing and exporting. This site has over 300 posts and the size of xml is more than 2M. So how I could do the backup option?
1. Of coz, back up your database.
2. Let us work on the portable file - xml. Try export file in the manage page, see if it can sucesfully download the file. If you get 0 bit size file, then you are in trouble.
3. Do not worry. As you may see, you have options to export by different authors. So the way is to use authoer id as a filter to export file. You can export files and do some dirty works at database site, but if you want to have a clean xml file to easy transport so somewhere else, you may wanna follwo this instruction.
4. create several other blog users and record their blog user id. You can see that in your database table. Then you have to assign posts to different id and try to evenly distributed to each one, then you are lowing the chance to get big size file. Two ways to assign user a) front end, assign one by one, then you do not need to even tough the database. Man, this will take really long time and patience to do this job. b) database. Just update the user_id of the post table, limit with certain number, like 200.
5. export posts by id one by one. Now you should successfully export smaller size xml files.
6. import one by one and merge to the same bloger user id as you want.
Now, mission accomplished. This one is guaranteed to work. I have done this job on this blog.
Just found, actually there are some memory issue. What you may wanna do is to increase your memory allocated to your site. Please refere to http://my.textjourney.com/eric/2008/09/30/wordpress-memory-exhaust-problem/ This will tell you how.
