Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

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 :-(

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

Been there done that. Try this: http://interconnectit.com/124/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.

share|improve this answer
    
hmmm... I'm always reluctant to download plugins NOT from the official WP repo... –  Zach L Jun 25 '12 at 20:50
    
its not a WordPress specific plugin, its a MySQL search and replace plugin. –  Pontus Abrahamsson Jun 25 '12 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 –  Zach L Jun 25 '12 at 20:51
    
It should fix the lost data problem, tell me if it does. –  Pontus Abrahamsson Jun 25 '12 at 20:52
    
It does appear to fix everything! Thank you. –  Zach L Jun 25 '12 at 20:57
show 1 more comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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