[wp-hackers] images in MySQL Wordpress databases?

[Braydon]

Nice one, this will be useful, run into issues with this all the time.

I really wish all images would be shortcodes if they are in the Media 
Library so their URLS are not baked in.

On 08/07/2011 05:26 AM, Dion Hulse (dd32) wrote:
> 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
>>
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>
> !DSPAM:4e3e84a8281561410093335!
>