Link to home
Start Free TrialLog in
Avatar of Kosta Kondratenko
Kosta Kondratenko

asked on

Moving blog posts with featured images

Hi,

I am trying to move my blog posts with featured images from my old site to my new site. I have tried to do this with Wordpress' built in Import/Export tool however it has only imported the blog posts without the featured images attached.

Please note that I don't have the option during export to export the images:
https://screenshots.firefox.com/b2wfEFNJBaOhzJSs/www.headstudios.com.au

What I would like to do is the following:
- Export the current blog posts along with the featured images (please note I have uploaded all the images into the new site's uploads folder)
- Overwrite the current blog posts (the blog posts are correct - I just want to make it so they point to the featured images - so I would need to just update them)

Thanks
Avatar of Kosta Kondratenko
Kosta Kondratenko

ASKER

One more thing - I've just checked phpmyadmin and the _thumbnail_id is in the postmeta field for the blog posts it seems.

So the only issue is that there is no media files in the dashboard that are setup to link to the uploads folder (the uploads folder has all the images all ready).

My question is - how can I export then import just the Media connections (photo ID and the path).

Thank you.
ASKER CERTIFIED SOLUTION
Avatar of Terry Woods
Terry Woods
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi Terry,

Thanks - this is actually the same article I was reading (I don't see the export media files).

In either case I have imported the attachments manually into the wp_posts table so trying to do that now.. the only issue is that they have imported with the following in the guid column:

http://headstudios.com.au/wp-content/uploads/2015/02/desat-gb_macbook.jpg

What I really wanted to do was change that to be:

http://headstudios.com.au/hsfast/wp-content/uploads/2015/02/desat-gb_macbook.jpg

Do you know what type of MySQL query I would have to write to do the update for just the attachments?
Problem solved! I did the update and then used a thumbnail regenerator :)
Thanks for the input Terry