[wp-hackers] images in MySQL Wordpress databases?

[Dion Hulse (dd32)]

The URL's you're refering to are most likely within post content? If
so, The URL is stored within the HTML of the post itself.
If you move between domains, the recomended way is to use the
Export/Import process which takes care of changing paths.
However, in this case, you can simply do a search/replace for the old
url, and replace with the new url. A plugin such as Search and
Replace: http://wordpress.org/extend/plugins/search-and-replace/ or
using direct SQL replacements is the normal way to update those
details.

On 7 August 2011 22:22, John Black <immanence7 at gmail.com> wrote:
> 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
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>