Issue with theme mod options during domain migration

Question

Issue with theme mod options during domain migration

Louis D.

2019年7月30日 15:42

I want to migrate my development wordpress site to the production domain. In order to success the migration I found and replace all previous url occurences (http://localhost) to the new (https://mywebsite.com). The problem is that old urls cannot be replaced directly in the field option_value of theme_mods_{your theme name} in the table wp_options because data in there are serialized.

How can I replace old urls by the new without breaking theme settings ?

Topic get-theme-mod theme-options migration themes Wordpress

Category Web

Tom J Nowell · Accepted Answer · 2019年7月30日 15:42

Use the official CLI tool:

wp search-replace 'http://localhost' 'https://yoursitecom'

It will automatically deserialize any post meta, options, theme mods, etc and adjust them to match the new URL.

Fundamentally though, it's bad practice to store URLs to images posts and assets in the database. Store the post ID instead, and this problem goes away

Louis D. · Accepted Answer · 2019年7月30日 15:39

It's possible to search and replace old urls to new ones by using maybe_unserialize(get_theme_mods()) and get_theme_mod() WP functions and following these steps:

Create a php file in the root folder of your WP installation (same path as wp-load.php).
Insert the following code :

require_once("wp-load.php");
$r = maybe_unserialize(get_theme_mods());
foreach ($r as $k => $v){
    if(!empty($k)){
        $ListOptions[] = $k;
    }
}
foreach($ListOptions as $option){
    $str = get_theme_mod($option);
    $str = str_replace('http://localhost', 'https://mywebsite.com', $str);
    $str = str_replace('http:\\/\\/localhost', 'https:\\/\\/mediadroit.fr', $str);
    set_theme_mod($option, $str);
    var_dump('|'.$option.': '.get_theme_mod($option).' ===> '.$str);
    echo "\n";
}

Execute the script

Issue with theme mod options during domain migration

About