0

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 (http://127.0.0.1/wordpress).

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?

Thanks.

Improve this question
5
  • 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
    Commented Apr 28, 2016 at 6:58
  • I didn't get any broken link.
    – Sathish
    Commented Apr 28, 2016 at 7:06
  • I think serialized data not returning properly after replacing new url.
    – Sathish
    Commented 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
    Commented Apr 28, 2016 at 7:09
  • sorry unfortunately Its not working for me
    – Sathish
    Commented Apr 28, 2016 at 7:32

1 Answer 1

Reset to default
2

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
Improve this answer
3
  • thanks. I tried 3rd but it not working for me. i will try remaining
    – Sathish
    Commented 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
    Commented 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
    Commented Apr 28, 2016 at 9:04

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.