Support » Fixing WordPress » Where are media file locations stored in the database?

  • Resolved Clicknathan

    (@clicknathan)


    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?

Viewing 1 replies (of 1 total)
  • 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)

Viewing 1 replies (of 1 total)
  • The topic ‘Where are media file locations stored in the database?’ is closed to new replies.