Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
tips-topic
Dealing with serialized data when migrating your WordPress site
Avatar
Brad Siegfried
Member
sp_UserOfflineSmall Offline
Nov 6, 2012 - 1:06 pm

I recently migrated my WordPress site to a new server with a new URL.  Trying to do a simple text search and replace on a database export to change from myoldsite.org to thenewsite.org will cause problems with serialized data.  Because serialized data has an explicit length specified, both the data and the length must be changed.

This site offers some good explanation of serialized data in WordPress:

http://wpgarage.com/tips/data-.....wordpress/

This site has a great utility that I used successfully to search and replace serialized data:

http://interconnectit.com/124/.....databases/

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Nov 6, 2012 - 1:33 pm

That's useful and a great tip. Thanks for posting.

There should not be many instances of the url in serialised arrays but I know there are some. I keep all of my test websites to the same name length for this very reason.

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17363
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625