{"id":3803,"date":"2018-02-15T13:57:22","date_gmt":"2018-02-15T12:57:22","guid":{"rendered":"https:\/\/monodes.com\/predaelli\/?p=3803"},"modified":"2018-02-15T13:57:22","modified_gmt":"2018-02-15T12:57:22","slug":"changing-the-domain-name-on-wordpress-multi-site","status":"publish","type":"post","link":"https:\/\/monodes.com\/predaelli\/2018\/02\/15\/changing-the-domain-name-on-wordpress-multi-site\/","title":{"rendered":"Changing the Domain Name on WordPress Multi-site"},"content":{"rendered":"<p>At work I&#8217;ve set up a little WordPress network to record workflow notes. One blog for quality management, one used by person in charge of the concrete plant &#8211; I do mildly dislike the word &#8220;manager&#8221; as it is wildly misused here in Italy &#8211; and another for the <span id=\"result_box\" class=\"short_text\" lang=\"en\" tabindex=\"-1\"><span class=\"\">administrative office<\/span><\/span>. Too bad I just used the hostname &#8220;<code class=\"\" data-line=\"\">laboratorio.local<\/code>&#8220;.<\/p>\n<p>Shame on me. I relied on <code class=\"\" data-line=\"\">nmb<\/code> to resolve names. It was easy. It just worked. Too bad it does not word across VPN. And Android phones also don&#8217;t like them at all.<\/p>\n<p>Now all those blogs are really private and it may be good not to let them be read over the VPN. But when our phones will be hooked to an eventual inner WiFi network I will really need to update this.<\/p>\n<p>Oh, I know there is <a href=\"https:\/\/codex.wordpress.org\/Moving_WordPress#Moving_WordPress_Multisite\"><span id=\"Moving_WordPress_Multisite\" class=\"mw-headline\">Moving WordPress Multisite<\/span><\/a>\u00a0on <a href=\"https:\/\/codex.wordpress.org\/\">WordPress Codex<\/a>, but it just is a little fearsome. <em><a href=\"https:\/\/www.accuweaver.com\/2015\/03\/08\/changing-domain-name-on-wordpress-multi-site\/\">Changing the Domain Name on WordPress Multi-site from AccuWeaver LLC<\/a><\/em> looks a little easier to follow.<\/p>\n<p>As usual knowledge is power. I should study Codex a little more<\/p>\n<p><!--more--><\/p>\n<p>You may find on <a href=\".\/2\">page 2<\/a> a copy of relevant codex doc, on <a href=\".\/3\">page 3<\/a> the text rom accuweaver<\/p>\n<p><!--nextpage--><\/p>\n<blockquote>\n<h2><span id=\"Moving_WordPress_Multisite\" class=\"mw-headline\">Moving WordPress Multisite<\/span><\/h2>\n<p><a title=\"Create A Network\" href=\"https:\/\/codex.wordpress.org\/Create_A_Network\">Multisite<\/a> is somewhat more complicated to move, as the database itself has multiple references to the server name as well as the folder locations. If you&#8217;re simply moving to a new server with the same domain name, you can copy the files and database over, exactly as you would a traditional install.<\/p>\n<p>If, instead, you are changing domains, then the best way to move Multisite is to move the files, edit the <tt>.htaccess<\/tt> and <tt>wp-config.php<\/tt> (change DOMAIN_CURRENT_SITE and, if the folder name containing Multisite changed, PATH_CURRENT_SITE), and then manually edit the database. Search for all instances of your domain name, and change them as needed. This step cannot yet be easily automated. It&#8217;s safe to search\/replace any of the <tt>wp_x_posts<\/tt> tables, however do not attempt blanket search\/replace without the <a class=\"external text\" href=\"https:\/\/github.com\/interconnectit\/Search-Replace-DB\" rel=\"nofollow\">Search and Replace for WordPress Databases script<\/a> (aka the interconnectit script).<\/p>\n<p>If you&#8217;re moving Multisite from one folder to another, you will need to make sure you edit the <tt>wp_blogs <\/tt> entries to change the folder name correctly. You should manually review both <tt>wp_site<\/tt> and <tt>wp_blogs<\/tt> regardless, to ensure all sites were changed correctly.<\/p>\n<p>Also, manually review all the <tt>wp_x_options<\/tt> tables and look for <b>three<\/b> fields and edit them as needed:<\/p>\n<ul>\n<li><tt>home<\/tt><\/li>\n<li><tt>siteurl<\/tt><\/li>\n<li><tt>fileupload_url<\/tt><\/li>\n<\/ul>\n<p>If you are moving from subdomains to subfolders, or vice-versa, remember to adjust the <tt>.htaccess<\/tt> file and the value for <tt>SUBDOMAIN_INSTALL<\/tt> in your <tt>wp-config.php<\/tt> file accordingly.<\/p><\/blockquote>\n<p><!--nextpage--><\/p>\n<blockquote>\n<header class=\"page-header\">\n<h1 class=\"entry-title\">Changing the Domain Name on WordPress Multi-site<\/h1>\n<div class=\"entry-meta\"><span class=\"sep\">Posted on <\/span><a title=\"1:18 pm\" href=\"https:\/\/www.accuweaver.com\/2015\/03\/08\/changing-domain-name-on-wordpress-multi-site\/\" rel=\"bookmark\"><time class=\"entry-date\" datetime=\"2015-03-08T13:18:44+00:00\">March 8, 2015<\/time><\/a><span class=\"by-author\"> <span class=\"sep\"> by <\/span> <span class=\"author vcard\"><a class=\"url fn n\" title=\"View all posts by Rob Weaver\" href=\"https:\/\/www.accuweaver.com\/author\/admin\/\" rel=\"author\">Rob Weaver<\/a><\/span><\/span> <span class=\"sep\"> | <\/span> <span class=\"comments-link\"> <a href=\"https:\/\/www.accuweaver.com\/2015\/03\/08\/changing-domain-name-on-wordpress-multi-site\/#disqus_thread\" data-disqus-identifier=\"368515 http:\/\/www.accuweaver.com\/?p=368515\">0 Comments<\/a> <\/span><\/div>\n<\/header>\n<div class=\"entry-content clearfix\">\n<p>I created a <a class=\"zem_slink\" title=\"WordPress\" href=\"http:\/\/wordpress.org\" target=\"_blank\" rel=\"homepage noopener\">WordPress<\/a> site for a client who needed to support both English and Espa\u00f1ol versions of their content, which involved using a plugin called MultilingualPress that creates relationships between sites for each language.<\/p>\n<p>I developed the site locally on my <a class=\"zem_slink\" title=\"Server (computing)\" href=\"http:\/\/en.wikipedia.org\/wiki\/Server_%28computing%29\" target=\"_blank\" rel=\"wikipedia noopener\">server<\/a>, and then after they created some content, migrated it to their hosting service.<\/p>\n<p><span id=\"more-368515\"><\/span>For some reason, WordPress stores information about the site in various places throughout the <a class=\"zem_slink\" title=\"Database\" href=\"http:\/\/en.wikipedia.org\/wiki\/Database\" target=\"_blank\" rel=\"wikipedia noopener\">database<\/a>, so moving from one site to another is not just a simple matter of moving the content and database to the new server.<\/p>\n<p>First I made a backup of the database and the content (and did an export of the content via the WordPress site for an extra level of backup). Then I imported the database\u00a0to the new site, and content copied to the right place on the new server. I updated the wp_config.php file with the new database credentials, but at this point nothing would work because everything still had my original domain name on it.<\/p>\n<p>So the next thing was to add a setting in the wp_config.php file for Muti-Site\u00a0to use the\u00a0new server name.<\/p>\n<div id=\"crayon-5a857eed5e427258634354\" class=\"crayon-syntax crayon-theme-netbeans crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\n<div class=\"crayon-plain-wrap\"><textarea class=\"crayon-plain print-no\" readonly=\"readonly\" wrap=\"soft\" data-settings=\"dblclick\">\/* Multisite *\/<br \/>\ndefine( &#8216;WP_ALLOW_MULTISITE&#8217;, true );<\/p>\n<p>define(&#8216;MULTISITE&#8217;, true);<br \/>\ndefine(&#8216;SUBDOMAIN_INSTALL&#8217;, false);<br \/>\ndefine(&#8216;DOMAIN_CURRENT_SITE&#8217;, &#8216;www.hostname.org&#8217;);<br \/>\ndefine(&#8216;PATH_CURRENT_SITE&#8217;, &#8216;\/&#8217;);<br \/>\ndefine(&#8216;SITE_ID_CURRENT_SITE&#8217;, 1);<br \/>\ndefine(&#8216;BLOG_ID_CURRENT_SITE&#8217;, 1);<\/p>\n<p>define(&#8216;CUSTOM_USER_TABLE&#8217;, &#8216;wp_users&#8217;);<br \/>\ndefine(&#8216;CUSTOM_USERMETA_TABLE&#8217;, &#8216;wp_usermeta&#8217;);<\/textarea><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table table table-striped table-hover\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e427258634354-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5a857eed5e427258634354-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e427258634354-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5a857eed5e427258634354-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e427258634354-5\">5<\/div>\n<div class=\"crayon-num crayon-marked-num crayon-top crayon-bottom crayon-striped-num\" data-line=\"crayon-5a857eed5e427258634354-6\">6<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e427258634354-7\">7<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5a857eed5e427258634354-8\">8<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e427258634354-9\">9<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5a857eed5e427258634354-10\">10<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e427258634354-11\">11<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5a857eed5e427258634354-12\">12<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-5a857eed5e427258634354-1\" class=\"crayon-line\"><span class=\"crayon-c\">\/* Multisite *\/<\/span><\/div>\n<div id=\"crayon-5a857eed5e427258634354-2\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">define<\/span><span class=\"crayon-sy\">(<\/span> <span class=\"crayon-s\">&#8216;WP_ALLOW_MULTISITE&#8217;<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-t\">true<\/span> <span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5a857eed5e427258634354-3\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-5a857eed5e427258634354-4\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">define<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216;MULTISITE&#8217;<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-t\">true<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5a857eed5e427258634354-5\" class=\"crayon-line\"><span class=\"crayon-e\">define<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216;SUBDOMAIN_INSTALL&#8217;<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-t\">false<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5a857eed5e427258634354-6\" class=\"crayon-line crayon-marked-line crayon-top crayon-bottom crayon-striped-line\"><span class=\"crayon-e\">define<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216;DOMAIN_CURRENT_SITE&#8217;<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-s\">&#8216;www.hostname.org&#8217;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5a857eed5e427258634354-7\" class=\"crayon-line\"><span class=\"crayon-e\">define<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216;PATH_CURRENT_SITE&#8217;<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-s\">&#8216;\/&#8217;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5a857eed5e427258634354-8\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">define<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216;SITE_ID_CURRENT_SITE&#8217;<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-cn\">1<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5a857eed5e427258634354-9\" class=\"crayon-line\"><span class=\"crayon-e\">define<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216;BLOG_ID_CURRENT_SITE&#8217;<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-cn\">1<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5a857eed5e427258634354-10\" class=\"crayon-line crayon-striped-line\"><\/div>\n<div id=\"crayon-5a857eed5e427258634354-11\" class=\"crayon-line\"><span class=\"crayon-e\">define<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216;CUSTOM_USER_TABLE&#8217;<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-s\">&#8216;wp_users&#8217;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5a857eed5e427258634354-12\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">define<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216;CUSTOM_USERMETA_TABLE&#8217;<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-s\">&#8216;wp_usermeta&#8217;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Changing the \u2018DOMAIN_CURRENT_SITE\u2019 to the name of the server, gives the multisite the information it needs.<\/p>\n<p>Next to complete, we have to tweak a few things in the database.<\/p>\n<p>First is the table named \u2018wp_site\u2019, which needs the same information as the wp_config.php file:<\/p>\n<div id=\"crayon-5a857eed5e437438383552\" class=\"crayon-syntax crayon-theme-netbeans crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\n<div class=\"crayon-plain-wrap\"><textarea class=\"crayon-plain print-no\" readonly=\"readonly\" wrap=\"soft\" data-settings=\"dblclick\">&#8212; Site<br \/>\nUPDATE  `newdb`.`wp_site`<br \/>\n   SET  `domain` =  &#8216;www.hostname.org&#8217;<br \/>\n WHERE  `newdb`.`id` =1;<\/textarea><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table table table-striped table-hover\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e437438383552-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5a857eed5e437438383552-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e437438383552-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5a857eed5e437438383552-4\">4<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-5a857eed5e437438383552-1\" class=\"crayon-line\"><span class=\"crayon-c\">&#8212; Site<\/span><\/div>\n<div id=\"crayon-5a857eed5e437438383552-2\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-st\">UPDATE<\/span><span class=\"crayon-h\">\u00a0\u00a0<\/span>`newdb`.`wp_site`<\/div>\n<div id=\"crayon-5a857eed5e437438383552-3\" class=\"crayon-line\"><span class=\"crayon-h\">\u00a0\u00a0 <\/span><span class=\"crayon-st\">SET<\/span><span class=\"crayon-h\">\u00a0\u00a0<\/span>`domain` =<span class=\"crayon-h\">\u00a0\u00a0<\/span><span class=\"crayon-s\">&#8216;www.hostname.org&#8217;<\/span><\/div>\n<div id=\"crayon-5a857eed5e437438383552-4\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-st\">WHERE<\/span><span class=\"crayon-h\">\u00a0\u00a0<\/span>`newdb`.`id` =1;<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Next is the table \u2018wp_blogs\u2019, which are a list of the sites created for the multisite. This table has rows for each site, so in this case there were two that were updated:<\/p>\n<div id=\"crayon-5a857eed5e43d744053328\" class=\"crayon-syntax crayon-theme-netbeans crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\n<div class=\"crayon-plain-wrap\"><textarea class=\"crayon-plain print-no\" readonly=\"readonly\" wrap=\"soft\" data-settings=\"dblclick\">&#8212; Blogs<br \/>\nUPDATE  `newdb`.`wp_blogs`<br \/>\n   SET  `domain` =  &#8216;www.hostname.org&#8217;<br \/>\n WHERE  `newdb`.`blog_id` =1;<br \/>\nUPDATE  `newdb`.`wp_blogs`<br \/>\n   SET  `domain` =  &#8216;www.hostname.org&#8217;<br \/>\n WHERE  `wp_blogs`.`blog_id` =2;<\/textarea><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table table table-striped table-hover\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e43d744053328-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5a857eed5e43d744053328-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e43d744053328-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5a857eed5e43d744053328-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e43d744053328-5\">5<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5a857eed5e43d744053328-6\">6<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e43d744053328-7\">7<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-5a857eed5e43d744053328-1\" class=\"crayon-line\"><span class=\"crayon-c\">&#8212; Blogs<\/span><\/div>\n<div id=\"crayon-5a857eed5e43d744053328-2\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-st\">UPDATE<\/span><span class=\"crayon-h\">\u00a0\u00a0<\/span>`newdb`.`wp_blogs`<\/div>\n<div id=\"crayon-5a857eed5e43d744053328-3\" class=\"crayon-line\"><span class=\"crayon-h\">\u00a0\u00a0 <\/span><span class=\"crayon-st\">SET<\/span><span class=\"crayon-h\">\u00a0\u00a0<\/span>`domain` =<span class=\"crayon-h\">\u00a0\u00a0<\/span><span class=\"crayon-s\">&#8216;www.hostname.org&#8217;<\/span><\/div>\n<div id=\"crayon-5a857eed5e43d744053328-4\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-st\">WHERE<\/span><span class=\"crayon-h\">\u00a0\u00a0<\/span>`newdb`.`blog_id` =1;<\/div>\n<div id=\"crayon-5a857eed5e43d744053328-5\" class=\"crayon-line\"><span class=\"crayon-st\">UPDATE<\/span><span class=\"crayon-h\">\u00a0\u00a0<\/span>`newdb`.`wp_blogs`<\/div>\n<div id=\"crayon-5a857eed5e43d744053328-6\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">\u00a0\u00a0 <\/span><span class=\"crayon-st\">SET<\/span><span class=\"crayon-h\">\u00a0\u00a0<\/span>`domain` =<span class=\"crayon-h\">\u00a0\u00a0<\/span><span class=\"crayon-s\">&#8216;www.hostname.org&#8217;<\/span><\/div>\n<div id=\"crayon-5a857eed5e43d744053328-7\" class=\"crayon-line\"><span class=\"crayon-st\">WHERE<\/span><span class=\"crayon-h\">\u00a0\u00a0<\/span>`wp_blogs`.`blog_id` =2;<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Then each site has its own <a class=\"zem_slink\" title=\"Option (finance)\" href=\"http:\/\/en.wikipedia.org\/wiki\/Option_%28finance%29\" target=\"_blank\" rel=\"wikipedia noopener\">options<\/a> in \u2018wp_options\u2019 \u00a0which were also\u00a0updated with the new hostname (both the siteurl and home options):<\/p>\n<div id=\"crayon-5a857eed5e444570099138\" class=\"crayon-syntax crayon-theme-netbeans crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\n<div class=\"crayon-plain-wrap\"><textarea class=\"crayon-plain print-no\" readonly=\"readonly\" wrap=\"soft\" data-settings=\"dblclick\">&#8212; English<br \/>\nUPDATE  `newdb`.`wp_options`<br \/>\n   SET  `option_value` =  &#8216;http:\/\/www.hostname.org\/&#8217;<br \/>\n WHERE  `wp_options`.`option_name` IN (&#8216;siteurl&#8217;, &#8216;home&#8217;);<\/p>\n<p>&#8212; Espanol<br \/>\nUPDATE  `newdb`.`wp_2_options`<br \/>\n   SET  `option_value` =  &#8216;http:\/\/www.hostname.org\/es\/&#8217;<br \/>\n WHERE  `wp_2_options`.`option_name` IN (&#8216;siteurl&#8217;, &#8216;home&#8217;);<\/textarea><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table table table-striped table-hover\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e444570099138-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5a857eed5e444570099138-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e444570099138-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5a857eed5e444570099138-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e444570099138-5\">5<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5a857eed5e444570099138-6\">6<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e444570099138-7\">7<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5a857eed5e444570099138-8\">8<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e444570099138-9\">9<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-5a857eed5e444570099138-1\" class=\"crayon-line\"><span class=\"crayon-c\">&#8212; English<\/span><\/div>\n<div id=\"crayon-5a857eed5e444570099138-2\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-st\">UPDATE<\/span><span class=\"crayon-h\">\u00a0\u00a0<\/span>`newdb`.`wp_options`<\/div>\n<div id=\"crayon-5a857eed5e444570099138-3\" class=\"crayon-line\"><span class=\"crayon-h\">\u00a0\u00a0 <\/span><span class=\"crayon-st\">SET<\/span><span class=\"crayon-h\">\u00a0\u00a0<\/span>`option_value` =<span class=\"crayon-h\">\u00a0\u00a0<\/span><span class=\"crayon-s\">&#8216;http:\/\/www.hostname.org\/&#8217;<\/span><\/div>\n<div id=\"crayon-5a857eed5e444570099138-4\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-st\">WHERE<\/span><span class=\"crayon-h\">\u00a0\u00a0<\/span>`wp_options`.`option_name` <span class=\"crayon-st\">IN<\/span> (<span class=\"crayon-s\">&#8216;siteurl&#8217;<\/span>, <span class=\"crayon-s\">&#8216;home&#8217;<\/span>);<\/div>\n<div id=\"crayon-5a857eed5e444570099138-5\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-5a857eed5e444570099138-6\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-c\">&#8212; Espanol<\/span><\/div>\n<div id=\"crayon-5a857eed5e444570099138-7\" class=\"crayon-line\"><span class=\"crayon-st\">UPDATE<\/span><span class=\"crayon-h\">\u00a0\u00a0<\/span>`newdb`.`wp_2_options`<\/div>\n<div id=\"crayon-5a857eed5e444570099138-8\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">\u00a0\u00a0 <\/span><span class=\"crayon-st\">SET<\/span><span class=\"crayon-h\">\u00a0\u00a0<\/span>`option_value` =<span class=\"crayon-h\">\u00a0\u00a0<\/span><span class=\"crayon-s\">&#8216;http:\/\/www.hostname.org\/es\/&#8217;<\/span><\/div>\n<div id=\"crayon-5a857eed5e444570099138-9\" class=\"crayon-line\"><span class=\"crayon-st\">WHERE<\/span><span class=\"crayon-h\">\u00a0\u00a0<\/span>`wp_2_options`.`option_name` <span class=\"crayon-st\">IN<\/span> (<span class=\"crayon-s\">&#8216;siteurl&#8217;<\/span>, <span class=\"crayon-s\">&#8216;home&#8217;<\/span>);<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>In some cases, there are options for themes\u00a0to be updated, which gets a bit more tricky. If you find an option that has the old <a class=\"zem_slink\" title=\"Uniform resource locator\" href=\"http:\/\/en.wikipedia.org\/wiki\/Uniform_resource_locator\" target=\"_blank\" rel=\"wikipedia noopener\">URL<\/a> for a theme\/plugin. This value is\u00a0stored\u00a0under a key specific to the theme\/plugin in the options table . For instance the All-in-One Calendar plugin stores the value for it\u2019s theme under an option named \u2018ai1ec_current_theme\u2019.<\/p>\n<p>That value is data format,\u00a0\u00a0stored as type\/length\/value pairs. It resembles a\u00a0<a class=\"zem_slink\" title=\"JSON\" href=\"http:\/\/json.org\/\" target=\"_blank\" rel=\"homepage noopener\">JSON<\/a>\u00a0object, (formatted below to make it easier to read):<\/p>\n<div id=\"crayon-5a857eed5e44d927546882\" class=\"crayon-syntax crayon-theme-netbeans crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\n<div class=\"crayon-plain-wrap\"><textarea class=\"crayon-plain print-no\" readonly=\"readonly\" wrap=\"soft\" data-settings=\"dblclick\">a:5: {<br \/>\n        s:9:&#8221;theme_dir&#8221;;<br \/>\n        s:99:&#8221;\/home\/web_hostr\/public_html\/wp-content\/plugins\/all-in-one-event-calendar\/public\/themes-ai1ec\/vortex&#8221;;<br \/>\n        s:10:&#8221;theme_root&#8221;;<br \/>\n        s:92:&#8221;\/home\/webhostr\/public_html\/wp-content\/plugins\/all-in-one-event-calendar\/public\/themes-ai1ec&#8221;;<br \/>\n        s:9:&#8221;theme_url&#8221;;<br \/>\n        s:96:&#8221;http:\/\/www.old.org\/site1\/wp-content\/plugins\/all-in-one-event-calendar\/public\/themes-ai1ec\/vortex&#8221;;<br \/>\n        s:10:&#8221;stylesheet&#8221;;<br \/>\n        s:6:&#8221;vortex&#8221;;<br \/>\n        s:6:&#8221;legacy&#8221;;<br \/>\n        b:0;<br \/>\n    }<\/textarea><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table table table-striped table-hover\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e44d927546882-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5a857eed5e44d927546882-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e44d927546882-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5a857eed5e44d927546882-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e44d927546882-5\">5<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5a857eed5e44d927546882-6\">6<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e44d927546882-7\">7<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5a857eed5e44d927546882-8\">8<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e44d927546882-9\">9<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5a857eed5e44d927546882-10\">10<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e44d927546882-11\">11<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5a857eed5e44d927546882-12\">12<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-5a857eed5e44d927546882-1\" class=\"crayon-line\"><span class=\"crayon-v\">a<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-cn\">5<\/span><span class=\"crayon-o\">:<\/span> <span class=\"crayon-sy\">{<\/span><\/div>\n<div id=\"crayon-5a857eed5e44d927546882-2\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><span class=\"crayon-v\">s<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-cn\">9<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-s\">&#8220;theme_dir&#8221;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5a857eed5e44d927546882-3\" class=\"crayon-line\"><span class=\"crayon-h\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><span class=\"crayon-v\">s<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-cn\">99<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-s\">&#8220;\/home\/web_hostr\/public_html\/wp-content\/plugins\/all-in-one-event-calendar\/public\/themes-ai1ec\/vortex&#8221;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5a857eed5e44d927546882-4\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><span class=\"crayon-v\">s<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-cn\">10<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-s\">&#8220;theme_root&#8221;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5a857eed5e44d927546882-5\" class=\"crayon-line\"><span class=\"crayon-h\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><span class=\"crayon-v\">s<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-cn\">92<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-s\">&#8220;\/home\/webhostr\/public_html\/wp-content\/plugins\/all-in-one-event-calendar\/public\/themes-ai1ec&#8221;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5a857eed5e44d927546882-6\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><span class=\"crayon-v\">s<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-cn\">9<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-s\">&#8220;theme_url&#8221;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5a857eed5e44d927546882-7\" class=\"crayon-line\"><span class=\"crayon-h\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><span class=\"crayon-v\">s<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-cn\">96<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-s\">&#8220;http:\/\/www.old.org\/site1\/wp-content\/plugins\/all-in-one-event-calendar\/public\/themes-ai1ec\/vortex&#8221;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5a857eed5e44d927546882-8\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><span class=\"crayon-v\">s<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-cn\">10<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-s\">&#8220;stylesheet&#8221;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5a857eed5e44d927546882-9\" class=\"crayon-line\"><span class=\"crayon-h\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><span class=\"crayon-v\">s<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-cn\">6<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-s\">&#8220;vortex&#8221;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5a857eed5e44d927546882-10\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><span class=\"crayon-v\">s<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-cn\">6<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-s\">&#8220;legacy&#8221;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5a857eed5e44d927546882-11\" class=\"crayon-line\"><span class=\"crayon-h\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><span class=\"crayon-v\">b<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5a857eed5e44d927546882-12\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">\u00a0\u00a0\u00a0\u00a0<\/span><span class=\"crayon-sy\">}<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>The only trick to this is \u00a0make sure you change the length to match, so the update in this case would change from \u201cold\u201d to \u201chostname\u201d, adding 5 characters, making the update be (this is per site in the multisite):<\/p>\n<div id=\"crayon-5a857eed5e454987237535\" class=\"crayon-syntax crayon-theme-netbeans crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\n<div class=\"crayon-plain-wrap\"><textarea class=\"crayon-plain print-no\" readonly=\"readonly\" wrap=\"soft\" data-settings=\"dblclick\">&#8212; Note theme options are the trickiest, requiring updating the JSON with the value and making the new length match the value<br \/>\n&#8212; In this case, changing from 96 to 101 for the change to &#8216;hostname&#8217;<br \/>\nUPDATE  `newdb`.`wp_3_options`<br \/>\n   SET  `option_value` = &#8216;a:5:{s:9:&#8221;theme_dir&#8221;;s:99:&#8221;\/home\/webhostr\/public_html\/wp-content\/plugins\/all-in-one-event-calendar\/public\/themes-ai1ec\/vortex&#8221;;s:10:&#8221;theme_root&#8221;;s:92:&#8221;\/home\/webhostr\/public_html\/wp-content\/plugins\/all-in-one-event-calendar\/public\/themes-ai1ec&#8221;;s:9:&#8221;theme_url&#8221;;s:112:&#8221;http:\/\/www.hostname.org\/site1\/wp-content\/plugins\/all-in-one-event-calendar\/public\/themes-ai1ec\/vortex&#8221;;s:10:&#8221;stylesheet&#8221;;s:6:&#8221;vortex&#8221;;s:6:&#8221;legacy&#8221;;b:0;}&#8217;<br \/>\n WHERE  `wp_3_options`.`option_name` = &#8216;ai1ec_current_theme&#8217;;<\/textarea><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table table table-striped table-hover\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e454987237535-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5a857eed5e454987237535-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e454987237535-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5a857eed5e454987237535-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5a857eed5e454987237535-5\">5<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-5a857eed5e454987237535-1\" class=\"crayon-line\"><span class=\"crayon-o\">&#8212;<\/span> <span class=\"crayon-e\">Note <\/span><span class=\"crayon-e\">theme <\/span><span class=\"crayon-e\">options <\/span><span class=\"crayon-e\">are <\/span><span class=\"crayon-e\">the <\/span><span class=\"crayon-v\">trickiest<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-e\">requiring <\/span><span class=\"crayon-e\">updating <\/span><span class=\"crayon-e\">the <\/span><span class=\"crayon-e\">JSON <\/span><span class=\"crayon-e\">with <\/span><span class=\"crayon-e\">the <\/span><span class=\"crayon-e\">value <\/span><span class=\"crayon-st\">and<\/span> <span class=\"crayon-e\">making <\/span><span class=\"crayon-e\">the <\/span><span class=\"crayon-r\">new<\/span> <span class=\"crayon-e\">length <\/span><span class=\"crayon-e\">match <\/span><span class=\"crayon-e\">the <\/span><span class=\"crayon-v\">value<\/span><\/div>\n<div id=\"crayon-5a857eed5e454987237535-2\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-o\">&#8212;<\/span> <span class=\"crayon-st\">In<\/span> <span class=\"crayon-r\">this<\/span> <span class=\"crayon-st\">case<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-e\">changing <\/span><span class=\"crayon-i\">from<\/span> <span class=\"crayon-cn\">96<\/span> <span class=\"crayon-st\">to<\/span> <span class=\"crayon-cn\">101<\/span> <span class=\"crayon-st\">for<\/span> <span class=\"crayon-e\">the <\/span><span class=\"crayon-e\">change <\/span><span class=\"crayon-st\">to<\/span> <span class=\"crayon-s\">&#8216;hostname&#8217;<\/span><\/div>\n<div id=\"crayon-5a857eed5e454987237535-3\" class=\"crayon-line\"><span class=\"crayon-i\">UPDATE<\/span><span class=\"crayon-h\">\u00a0\u00a0<\/span><span class=\"crayon-sy\">`<\/span><span class=\"crayon-v\">newdb<\/span><span class=\"crayon-sy\">`<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-sy\">`<\/span><span class=\"crayon-v\">wp_3_options<\/span><span class=\"crayon-sy\">`<\/span><\/div>\n<div id=\"crayon-5a857eed5e454987237535-4\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">\u00a0\u00a0 <\/span><span class=\"crayon-i\">SET<\/span><span class=\"crayon-h\">\u00a0\u00a0<\/span><span class=\"crayon-sy\">`<\/span><span class=\"crayon-v\">option_value<\/span><span class=\"crayon-sy\">`<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-s\">&#8216;a:5:{s:9:&#8221;theme_dir&#8221;;s:99:&#8221;\/home\/webhostr\/public_html\/wp-content\/plugins\/all-in-one-event-calendar\/public\/themes-ai1ec\/vortex&#8221;;s:10:&#8221;theme_root&#8221;;s:92:&#8221;\/home\/webhostr\/public_html\/wp-content\/plugins\/all-in-one-event-calendar\/public\/themes-ai1ec&#8221;;s:9:&#8221;theme_url&#8221;;s:112:&#8221;http:\/\/www.hostname.org\/site1\/wp-content\/plugins\/all-in-one-event-calendar\/public\/themes-ai1ec\/vortex&#8221;;s:10:&#8221;stylesheet&#8221;;s:6:&#8221;vortex&#8221;;s:6:&#8221;legacy&#8221;;b:0;}&#8217;<\/span><\/div>\n<div id=\"crayon-5a857eed5e454987237535-5\" class=\"crayon-line\"><span class=\"crayon-i\">WHERE<\/span><span class=\"crayon-h\">\u00a0\u00a0<\/span><span class=\"crayon-sy\">`<\/span><span class=\"crayon-v\">wp_3_options<\/span><span class=\"crayon-sy\">`<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-sy\">`<\/span><span class=\"crayon-v\">option_name<\/span><span class=\"crayon-sy\">`<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-s\">&#8216;ai1ec_current_theme&#8217;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>After updating the data\u00a0\u00a0(and committed to the DB), it\u2019s a good idea to run a final query\u00a0to see if the old name exists on any of the options for each site.<\/p>\n<p>It is possible that other\u00a0content will remain that\u00a0is still pointing at the old host, since there are other <a class=\"zem_slink\" title=\"HTML element\" href=\"http:\/\/en.wikipedia.org\/wiki\/HTML_element\" target=\"_blank\" rel=\"wikipedia noopener\">tables<\/a> that reference content in a non-relative way, but this will be\u00a0pretty close to what you need.<\/p>\n<p>&nbsp;<\/p>\n<\/div>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p class=\"excerpt\">At work I&#8217;ve set up a little WordPress network to record workflow notes. One blog for quality management, one used by person in charge of the concrete plant &#8211; I do mildly dislike the word &#8220;manager&#8221; as it is wildly misused here in Italy &#8211; and another for the administrative office. Too bad I just&hellip;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"https:\/\/monodes.com\/predaelli\/2018\/02\/15\/changing-the-domain-name-on-wordpress-multi-site\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"activitypub_content_warning":"","activitypub_content_visibility":"","activitypub_max_image_attachments":4,"activitypub_interaction_policy_quote":"anyone","activitypub_status":"","footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[61],"tags":[],"class_list":["post-3803","post","type-post","status-publish","format-standard","hentry","category-wordpress"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6daft-Zl","jetpack-related-posts":[{"id":5428,"url":"https:\/\/monodes.com\/predaelli\/2019\/03\/29\/bad-news\/","url_meta":{"origin":3803,"position":0},"title":"Bad news","author":"Paolo Redaelli","date":"2019-03-29","format":"link","excerpt":"Russia Orders Major VPN Providers To Block 'Banned' Sites - Slashdot Those are bad news IMHO","rel":"","context":"In &quot;Ethics&quot;","block_context":{"text":"Ethics","link":"https:\/\/monodes.com\/predaelli\/category\/ethics\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1448,"url":"https:\/\/monodes.com\/predaelli\/2016\/05\/02\/todays-lesson\/","url_meta":{"origin":3803,"position":1},"title":"Today&#8217;s lesson","author":"Paolo Redaelli","date":"2016-05-02","format":false,"excerpt":"Never, ever say \"I was never...\" bacause Murphy's law will soon take its toll Lately I've written I was never stopped working by an upgrade. Well, actually I wasn't stopped but have you ever tried working on a box that keeps swapping and thrashing at your slightest action? I have\u2026","rel":"","context":"In &quot;Fun&quot;","block_context":{"text":"Fun","link":"https:\/\/monodes.com\/predaelli\/category\/fun\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/monodes.com\/predaelli\/wp-content\/uploads\/sites\/4\/2016\/04\/wp-1461770800807.jpeg?fit=1024%2C389&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/monodes.com\/predaelli\/wp-content\/uploads\/sites\/4\/2016\/04\/wp-1461770800807.jpeg?fit=1024%2C389&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/monodes.com\/predaelli\/wp-content\/uploads\/sites\/4\/2016\/04\/wp-1461770800807.jpeg?fit=1024%2C389&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/monodes.com\/predaelli\/wp-content\/uploads\/sites\/4\/2016\/04\/wp-1461770800807.jpeg?fit=1024%2C389&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":3865,"url":"https:\/\/monodes.com\/predaelli\/2018\/03\/04\/tunnelbear-secure-vpn-service\/","url_meta":{"origin":3803,"position":2},"title":"TunnelBear: Secure VPN Service","author":"Paolo Redaelli","date":"2018-03-04","format":false,"excerpt":"TunnelBear: Secure VPN Service","rel":"","context":"In &quot;Senza categoria&quot;","block_context":{"text":"Senza categoria","link":"https:\/\/monodes.com\/predaelli\/category\/senza-categoria\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2353,"url":"https:\/\/monodes.com\/predaelli\/2017\/04\/12\/ipsec-vpn-wizard\/","url_meta":{"origin":3803,"position":3},"title":"IpSec VPN &#8220;wizard&#8221;","author":"Paolo Redaelli","date":"2017-04-12","format":"link","excerpt":"https:\/\/github.com\/trailofbits\/algo A reasonable sane, secure IpSec-based VPN that doesn't need additional software on the client.","rel":"","context":"In &quot;Documentations&quot;","block_context":{"text":"Documentations","link":"https:\/\/monodes.com\/predaelli\/category\/documentations\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":12237,"url":"https:\/\/monodes.com\/predaelli\/2025\/01\/10\/12237\/","url_meta":{"origin":3803,"position":4},"title":"Setting up a VPN Hotspot\u2026","author":"Paolo Redaelli","date":"2025-01-10","format":"link","excerpt":"Setting up a VPN Hotspot on the Raspberry PI https:\/\/github.com\/wmahfoudh\/rpi-vpn-hotspot","rel":"","context":"In &quot;Documentations&quot;","block_context":{"text":"Documentations","link":"https:\/\/monodes.com\/predaelli\/category\/documentations\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":14101,"url":"https:\/\/monodes.com\/predaelli\/2025\/10\/08\/njal-la\/","url_meta":{"origin":3803,"position":5},"title":"njal.la","author":"Paolo Redaelli","date":"2025-10-08","format":false,"excerpt":"njal.laConsidered the worlds most notorious \"Privacy as a Service\" provider for domains, VPS' and VPNs.","rel":"","context":"In &quot;Senza categoria&quot;","block_context":{"text":"Senza categoria","link":"https:\/\/monodes.com\/predaelli\/category\/senza-categoria\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/posts\/3803","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/comments?post=3803"}],"version-history":[{"count":0,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/posts\/3803\/revisions"}],"wp:attachment":[{"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/media?parent=3803"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/categories?post=3803"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/tags?post=3803"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}