25 May, 2009
mySQL Database Search & Replace With Serialized PHP [Updated]
Ever needed to migrate a database to a new server or website (especially with WordPress and other PHP applications) and been stuck because when you do a search and replace some of the data seems to get corrupted?
2 March, 2009
PHP Serialization Fix for WordPress Migrations (& other applications like Expression Engine)
Serialization of data loaded into an SQL table is a dreadful thing and makes WordPress migrations harder than they should be, but it happens and so we must deal with it. I’ve knocked up a rough and ready bit of code which does its best to resolve the problem.