This is what I need to do: I have a WordPress multi-site installed on one of my domains. That multi-site consists of about 6 different sites full of information. I want to combine all of those sites into one single WordPress installation. The challenge that I have is to export all of the posts, pages and custom post types of each of those sites to files as well as saving the images that was used for each post. I then need to remove the multi-site, install a single WordPress site and have all of that data imported into the new site. The 5000+ records is just for one of those sites, some of the other sites have more than 20000 records. I basically need to try and make the exporting and importing of the data seamless as I have one chance to make the switch. We are an online food and restaurant magazine and cannot really afford to have the site down for longer than one night (GMT+2). I am aware that the importing of the data will take a lot of time thus I'm making enough time to correct errors along the way during the importing process.
"This is what I had in mind: I am writing a script now to loop through the database tables to get all the records of posts and the related information like categories, tags and authors. I then want to save all of that info into XML files and the images in the same location. This process I want to repeat for all of the sites. The different sites use custom post types like recipes, products, listings etc. When I do the importing I need to replace all the images in the articles with it's new locations on the site.
I have found a pretty good import plugin for WordPress that allows me to import XML files into the site and it also allows me to upload the images to the media library. If this does not give me the desired results I will need to code an import script to do it myself. "
I had a look at a few of my options regarding exporting and importing data and the default WordPress export and import will not work. I have already tested it on a demo site and it keeps on giving me the results that I am not looking for. For eg. it imports menus and widgets which is not what I want as I am rebuilding that on the new single site. If I only export posts and pages the images do not get imported into the media library. I have tried many other plugins as well but in most cases I got the same results.
If you know of any other alternative way to do this please let me know. I am writing my own scripts to do the exporting and importing for now but if there is another way to get this done I would love to know how and will test it on a demo site as well.