I just movde my site from a dev subdomain, to the root. I have extensive amounts of data saved in custom meta fields which I created with the WpAlchemy class. All of this data is not appearing in the site (back or front end), although it appears to be in the database.

This happened right after attempting to use the search replace plugin to change any lingering urls. This attempt ended in Fatal error: Out of memory. I noticed everything was gone, so I swapped out the db for my backup (after doing a manual search-replace for my subdomain). This produced the same result.

I think I've read somewhere that data serialization (am I getting this right?) can mess up this kind of thing. Is that whats happening to me here?

What steps should I take to get the site up and running ASAP. Currently it is live, and terribly broken :-(

1 Answer 1


Been there done that. Try this: https://interconnectit.com/products/search-and-replace-for-wordpress-databases/ Its a search and replace tool that you put in your WordPress root and just run it from mydomain.dev/searchreplacedb2.php

It fixes the serialization problem when you want to change the url:s to the live one.

  • hmmm... I'm always reluctant to download plugins NOT from the official WP repo... Commented Jun 25, 2012 at 20:50
  • its not a WordPress specific plugin, its a MySQL search and replace plugin. Commented Jun 25, 2012 at 20:51
  • ah yes, just reading up on that now.. thanks. Actually, I think I used this a couple years ago when first getting into WP Commented Jun 25, 2012 at 20:51
  • It should fix the lost data problem, tell me if it does. Commented Jun 25, 2012 at 20:52
  • Glad it worked for you too. Commented Jun 25, 2012 at 21:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.