WordPress.org

1. Clicknathan
   Member
   Posted 4 years ago #
   

   Howdy all!

   I'm trying to do a find/replace in MySQL to change the location of my image files.

   So while my site was on a test server, several people uploaded images via the Add Media uploader. Now they're all pointing at dev.oldsite.com/imagelocation.jpg and I want them to point to newsite.com/imagelocation.jpg - but I can't find any reference to them in the database.

   Anyone know where I might be able to find this info?

2. bennyp
   Member
   Posted 4 years ago #
   

   Couldn't find this easily on the net so I thought I'd add it here:

   They're in the wp_posts table with a post_type of "attachment".

   (At least for 2.7.1)

Topic Closed

This topic has been closed to new replies.