I have developed the one wordpress site with custom theme,

Here I used the custom customizer options.

Then site completed on my local machine I mean localhost (

Now the problem is I tried to transfer my site to live domain (http://wordpress.bla.com).

How I tried to transfer files?

1) exported the database from localhost/phpmyadmin and changed the oldurl to new url using ctrl+f.

2) then transfered files through ftp.

After live site opens without logo, header menu, and custom customizer data. but DB having these values.

What I expect from you guys?

How to avoid these losing theme options?

I tried many times and checked all the old url was changed to new url in DB.

But I didn't get theme options values in new url.

please suggest me to avoid these losing theme options?


  • If you get broken links see what urls are trying to load. This will give you a better idea of what needs to be search/replaced in your target deploy.
    – Z. Zlatev
    Apr 28, 2016 at 6:58
  • I didn't get any broken link.
    – Sathish
    Apr 28, 2016 at 7:06
  • I think serialized data not returning properly after replacing new url.
    – Sathish
    Apr 28, 2016 at 7:07
  • 1
    You might have corrupt DB entries then. Try a clean seacrh replace using a tool like wp-cli or interconnectit.com/products/…
    – Z. Zlatev
    Apr 28, 2016 at 7:09
  • sorry unfortunately Its not working for me
    – Sathish
    Apr 28, 2016 at 7:32

1 Answer 1


You can not replace the URL in the database using ctrl+f or any other "direct" method. You have to do a search & replace in the whole database in a way capable of keeping the validity of serialized data.

There are several tools to do that serialized seach & replace. For example:

  1. Plugins like Better Search Replace, Velvet Blues Update URLs or All-in-One WP Migration.
  2. WP-CLI's search-replace
  3. Search and Replace for WordPress Databases Script
  • thanks. I tried 3rd but it not working for me. i will try remaining
    – Sathish
    Apr 28, 2016 at 8:59
  • I've used all of them with sucess; most often second and third. The plugin I know more is All-in-one WP Migration. You may be not using it well.
    – cybmeta
    Apr 28, 2016 at 9:01
  • 1
    Anyway, the answer is not what tool to use; the answer is do the search&replace in the whole database and keeping validity of serialized data. The suggested tools are just that, suggestions.
    – cybmeta
    Apr 28, 2016 at 9:04

Your Answer

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

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