Support Forum

Advanced Search
Forum Scope


Forum Options

Minimum search word length is 3 characters - maximum search word length is 84 characters
Dealing with serialized data when migrating your WordPress site
Brad Siegfried
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 to 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:

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

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.

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: 633
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 615
Members: 17335
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10105
Posts: 79544