[wp-hackers] Subject: change siteurl at DB level

[David McDonald]

Yes, serialised data needs to be taken into account when changing the
site URL in a WP database.
This most likely is the cause of missing widgets, as I have found some
of the widget data to be serialised.

This script enables a search & replace including serialised data:

 http://spectacu.la/search-and-replace-for-wordpress-databases/

I have used it numerous times and from my experience it works very well.

Regards,

David McDonald
-------------------------------------------
Web Designer, Developer and Consultant

http://www.davidmcdonald.org/info
http://www.linkedin.com/in/davidmcdonald

Melbourne, Australia
Ph: 0403 332 140

Skype: davemelbourne
Twitter: http://twitter.com/davemac

> ------------------------------
>
> Message: 7
> Date: Tue, 24 Aug 2010 19:10:06 -0400
> From: Bill Dennen <dennen at gmail.com>
> Subject: Re: [wp-hackers] change siteurl at DB level
> To: wp-hackers at lists.automattic.com
> Message-ID:
>        <AANLkTim_XRP68Nx3EfR=+93e8D6zXLzM82cnmHDFwXF- at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Ah, this might explain why I lose widgets when doing an SQL export and
> find replace to rename blogs! I'm moving from
> somesite.com/somedirectory to somesite.com/newdirectory - and the
> length is different. I wondered why I lost the widgets when doing
> this! Thanks.
>
> On Tue, Aug 24, 2010 at 7:03 PM, Christopher Bratlien
> <chrisbratlien at gmail.com> wrote:
>> Jason, I believe your bash script has the chance to corrupt serialized data also, as Jerry brought up earlier.
>
>
> ------------------------------