Media Uploader data location in the database – reporting what I found out

Hi all, I think this is resolved… just reporting in.

and checking out something I think I have figured out… am working on the draft install of my employer’s website, currently MODx I am porting to WordPress. I am setting up a page with pdf’ed press releases, previously uploaded thru the Media Uploader, using also the Relocate Upload plugin to a new folder, not the default “uploads” location.

It’s important to be using the Media Uploader so that others besides myself can update the site.

I realized late that I had uploaded the files to a miss-named folder, can’t change this thru the uploader easily so I was working on the database. Where in the database is the Uploader data?

WP experts, is this thinking correct:

Finally occurred to me that the Uploader data is interspersed among the posts in which one has uploaded to the Media Library… rather than one single location. Yes?

To change my links to the pdfs, I downloaded the database (using Drop Table checked, in PHPmyAdmin) and did a search/replace for the URL section

/new/pdfs/ changed to /new/pdf/

and then imported the database. This was much easier than messing around with the post and uploader list.

All is now as I want it to be, and now I also know what to do to update these links when I finally get around to moving the new WP site to replace that which exists in the root directory.