Is there a secret to migrations ???? I have been pulling my hair out for most of today. I build on localhost on my machine and then migrate to hosting (aka prod).
With the first site I lost my custom colors and some other settings. I have also lost my widgets in the right-sidebar. . Yuck…. I would bet its somewhere in the DB possibly serialized – nice.
I went to the second site and did what I did for the first site. Exported my localhost db , imported into new db on host, ran the 5 sql replacement statements – what a mess – pages gone. So – I tried using a migration plugin – still a mess. And – I am So very carefull. I have migrated other sites with no issues. Hm…. I sure hope I dont lose too much more hair – Why do I always seem to get the fun stuff ????? Any suggestions except to run away ???
Don’t pull your hair out…been there done it myself in the past 🙂
Anyway, if this method you have done worked with previous projects of yours, try to duplicate what you’ve done before. It may also depend on how your live server is setup and MySQL as well. However, using a plugin to migrate can be easy or messy, depends on how good the plugin is, so you may want to find an alternative one. Make sure you keep your local site intact without changes until you get your live site up. I did a quick google search and people do experience problems doing this kind of migration, but see if this helps:
Just successfully migrated the site to a diff domain name – the trick is to use the interconnecit script. I did try some other plugins to do search and replace and they hosed my DB. Be sure and verify the htaccess because mine was pointing back to the site I had migrated from – fixed it to the new domain and wahoo – success I am happy camper for today until whatever else happens. :silly:
After several hours of pulling my hair out as well, I found a great plugin that does the entire job for you database and all — including changing the domain if you need to — All-in-One WP Migration. :woohoo: Just thought I would share in case anyone else has trouble.