[wp-hackers] images in MySQL Wordpress databases?

[John Black]

I've been migrating a site, and well, something isn't right. The original site was in a subdirectory. The new site is at root. All the text works (I think), and I've deleted the .htaccess file and recreated it by renewing the permalinks. But still, for images that go in posts, I have the directory in their path, so they call fail.

Where in the MySQL database are image paths stored? There are many hundreds, but if it's easy I feel I might be best to just change their path in the database itself.

Any advice? Any pointers?

Thanks so much,
John