{"id":4379,"date":"2019-05-12T12:59:43","date_gmt":"2019-05-12T12:59:43","guid":{"rendered":"http:\/\/wiki.davelevy.info\/?p=4379"},"modified":"2025-11-30T23:46:16","modified_gmt":"2025-11-30T23:46:16","slug":"moving-this-wordpress-url-and-domain","status":"publish","type":"post","link":"https:\/\/davelevy.info\/wiki\/moving-this-wordpress-url-and-domain\/","title":{"rendered":"Moving this wordpress url and domain"},"content":{"rendered":"\n<p>I am looking to move this wiki to a location within davelevy.info. This was written in 2019, and in 2025, I let the deptford.red domain go, and needed to move that instance to another leaf in davelevy.info. Here are my [amended] notes&#8230;<\/p>\n\n\n\n<!--more-->\n\n\n\n<h3 class=\"wp-block-heading\">2025<\/h3>\n\n\n\n<p>I didn&#8217;t take a wordpress xml dump, but they all used the same database so I had the old instance tables. What I did!<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>I made a new instance, download the wordpress installation files, make a new folder, and unzip the wordpress installation files. Using the old wp-config.php as a data source, run the installation with a new table prefix.<\/li>\n\n\n\n<li>I then copied the uploads from the old folder to the new folder location. <\/li>\n\n\n\n<li>Since the theme I want to use is no longer available, I copied the required theme directory from the old folder structure to the new. <\/li>\n\n\n\n<li>In order to move <strong>only content<\/strong> (posts, pages, comments, categories, and tags) from one WordPress instance to another by copying database tables, you will need to copy the following tables (using the default <code>wp_<\/code> prefix as an example):\u00a0I used the following code, INSERT INTO ${NEW_PREFIX}_posts SELECT * from ${OLD_PREFIX}_posts:\n<ul class=\"wp-block-list\">\n<li><strong><code>wp_posts<\/code><\/strong>: This is the primary content table, storing all post types including posts, pages, attachments (media library items), and custom post types.<\/li>\n\n\n\n<li><strong><code>wp_postmeta<\/code><\/strong>: This table holds all the extra, detailed information (metadata) related to entries in <code>wp_posts<\/code>, such as custom fields, product details, and attachment data.<\/li>\n\n\n\n<li><strong><code>wp_comments<\/code><\/strong>: This table stores all comments made on your content.<\/li>\n\n\n\n<li><strong><code>wp_commentmeta<\/code><\/strong>: This table stores metadata for the comments in <code>wp_comments<\/code>.<\/li>\n\n\n\n<li><strong><code>wp_terms<\/code><\/strong>: This table stores the actual categories and tags (terms).<\/li>\n\n\n\n<li><strong><code>wp_term_taxonomy<\/code><\/strong>: This table defines the taxonomy for each term (e.g., whether it&#8217;s a category, a tag, or a custom taxonomy).<\/li>\n\n\n\n<li><strong><code>wp_term_relationships<\/code><\/strong>: This table manages the relationships between posts (from <code>wp_posts<\/code>) and their associated terms (from <code>wp_terms<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>I then found and installed the plugins [and unused themes] using the wp-admin panel. <\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">2019<\/h3>\n\n\n\n<p>I think I need to<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Prove the proposed location is findable and not blocked by the master wordpress instance.<\/li>\n\n\n\n<li>Reset the URL parameters on the Settings &#8211; General Page<\/li>\n\n\n\n<li>cpio the installation directory to the new location<\/li>\n\n\n\n<li>test it works and there is no conflict with tags or date queries<\/li>\n\n\n\n<li>delete the old installation directory<\/li>\n\n\n\n<li>make a .htaccess file<\/li>\n\n\n\n<li>5 &amp; 6 could also be implemented by making a new directory with the .htaccess file and pointing the dns record to the new directory<\/li>\n<\/ol>\n\n\n\n<p>I found this to help me,<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><a href=\"https:\/\/codex.wordpress.org\/Installing_Multiple_Blogs\">https:\/\/codex.wordpress.org\/Installing_Multiple_Blogs<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/help.one.com\/hc\/en-us\/articles\/115005585969-Move-your-WordPress-site-to-another-domain\">https:\/\/help.one.com\/hc\/en-us\/articles\/115005585969-Move-your-WordPress-site-to-another-domain<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.stepforth.com\/resources\/web-marketing-knowledgebase\/how-to-redirect-an-old-domain-to-a-new-domain\/\">https:\/\/www.stepforth.com\/resources\/web-marketing-knowledgebase\/how-to-redirect-an-old-domain-to-a-new-domain\/<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>I am looking to move this wiki to a location within davelevy.info. This was written in 2019, and in 2025, I let the deptford.red domain go, and needed to move that instance to another leaf in davelevy.info. Here are my [amended] notes&#8230;<\/p>\n","protected":false},"author":1,"featured_media":2436,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_share_on_mastodon":"0"},"categories":[3,584],"tags":[911,28],"class_list":["post-4379","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","category-wordpress-technology","tag-technology","tag-wordpress"],"share_on_mastodon":{"url":"","error":""},"jetpack_featured_media_url":"https:\/\/davelevy.info\/wiki\/wp-content\/uploads\/2015\/02\/Optimize-WordPress.jpg","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts\/4379","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/comments?post=4379"}],"version-history":[{"count":3,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts\/4379\/revisions"}],"predecessor-version":[{"id":13509,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts\/4379\/revisions\/13509"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/media\/2436"}],"wp:attachment":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/media?parent=4379"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/categories?post=4379"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/tags?post=4379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}