[resolved] Where are media file locations stored in the database? (2 posts)

  1. Clicknathan
    Posted 7 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
    Posted 7 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.

About this Topic