My site has almost 600 posts. I moved it to a new web server - same domain name. Since I am not very familiar with databases I chose to do this via the importer rather than by moving the database.
First I moved all the media files to the new server via ftp before I started this process. I then exported the xml file and imported it to the new installation. I discovered that while the media files show on the front end, only some of the images imported as expected. The featured image is missing and there are no images associated with most posts.
I studied things a bit more and then went into the old database and exported the wp_posts and wp_postsmeta tables. I selected the CSV version. I then replaced these two tables in the new install in hopes that it would solve my problem. I muddled my way through this, but finally figured things out.
My issue is that more of the images are showing, but still, not all of the posts are showing their featured images and some of my posts that use galleries are missing the images.
Can anyone provide guidance here? Where do I go from here?