Export Theme Options from local to live

  • Resolved nacionarte

    (@nacionarte)


    8 years, 5 months ago

    Hi,

    I’ve tested exporting my currently local developing site to live site while using Pinnacle theme.

    After doing it I have fixed images and broken links by updating paths via SQL query at wp_post table, and using better search replace and velvet blues update URLs plugins.

    None of the images or links of theme options are working properly, they are still pointing the old URL. Everything else is working fine.
    All the missing images are located in their own folder (called assets) at wp-content.

    Is there a proper way to move servers while using pinnacle theme without loosing this content?

Viewing 4 replies - 1 through 4 (of 4 total)
  • WEN Solutions

    (@wen-solutions)

    8 years, 5 months ago

    I think, while you move site from local server to live server, the SQL query is not properly hit. So try the below SQL query of your live server database.

    UPDATE wp_options SET option_value = replace(option_value, 'http://www.example.com';, 'http://www.liveserver.com');

UPDATE wp_posts SET guid = replace(guid, 'http://www.example.com', 'http://www.liveserver.com');

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.example.com/, 'http://www.liveserver.com');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.example.com','http://www.liveserver.com');

    or follow the below link to move site from local servet to live server.
    Link 1
    Link 2

    Try the above process, if not work again feel free to ask.
    Thanks

    Thread Starter nacionarte

    (@nacionarte)

    8 years, 5 months ago

    Thank You Wen,

    There is little pieces of information on your answer that I did not perform yesterday, since I only made a query (wp_tables) directly from phpMyAdmin.

    I would try later again and let you know if the settings from Theme Option are properly migrated to the new server.

    😉

    Theme Author Ben Ritner – Kadence WP

    (@britner)

    8 years, 5 months ago

    Hey,
    The theme options data is saved in the wp_options database, using better string replace should be catching those strings.

    What I personally like to use is this plugin: https://wordpress.org/plugins/duplicator/

    Kadence Themes

    Thread Starter nacionarte

    (@nacionarte)

    8 years, 5 months ago

    Duplicator works like a charm.
    😉

    Thanks for the tip, and Keep up the good work.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Export Theme Options from local to live’ is closed to new replies.