[wp-hackers] Multiple versions of same install independently running on same server

[Kokarn]

Thanks for the good and informative answers.

Have seen those threads as well and i've also seen the interconnect IT
thing ported to be used for moving the wp db's to/from staging/production
but the script should work the same for two production sites. (
https://github.com/Ascerta/Wordpress-DB-clone )

Is the widget settings the only place where settings are saved like that?
If yes, then why?
The rest of wp seems to work perfectly fine without that sort of storing so
that could be something one could look into fixing in core to make it more
portable.

On 12 March 2012 15:27, Bill Dennen <dennen at gmail.com> wrote:

> > I can't imagine a case why it shouldn't work, I guess. Maybe a lack of
> > imagination, but an array or object serialized into a string stays a
> > string, so there shouldn't be a problem a regex can't handle (if this
> > could be said about *life* to...)
>
> Regular search/replace on an export from mysql will break serialized
> data. I've seen this mostly with widget settings. That is, you export
> the site data in mysql, do a search replace, reimport the data into
> mysql and… your widget settings are messed up.
>
> Serialized data does store the info as a string, but if also indicates
> the length of the various pieces of data. So, if your hostname changes
> and, most importantly, if the length of the hostname changes, any
> serialized data that incorporates the hostname would be corrupted with
> a simple search and replace.
>
> As mentioned in another thread, this tool works well, even with serialized
> data:
>
> http://interconnectit.com/124/search-and-replace-for-wordpress-databases
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>