Moving this wordpress url and domain

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…

2025

I didn’t take a wordpress xml dump, but they all used the same database so I had the old instance tables. What I did!

1. 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.
2. I then copied the uploads from the old folder to the new folder location.
3. 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.
4. In order to move only content (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 wp_ prefix as an example): I used the following code, INSERT INTO ${NEW_PREFIX}_posts SELECT * from ${OLD_PREFIX}_posts:
   • wp_posts: This is the primary content table, storing all post types including posts, pages, attachments (media library items), and custom post types.
   • wp_postmeta: This table holds all the extra, detailed information (metadata) related to entries in wp_posts, such as custom fields, product details, and attachment data.
   • wp_comments: This table stores all comments made on your content.
   • wp_commentmeta: This table stores metadata for the comments in wp_comments.
   • wp_terms: This table stores the actual categories and tags (terms).
   • wp_term_taxonomy: This table defines the taxonomy for each term (e.g., whether it’s a category, a tag, or a custom taxonomy).
   • wp_term_relationships: This table manages the relationships between posts (from wp_posts) and their associated terms (from wp_terms
5. I then found and installed the plugins [and unused themes] using the wp-admin panel.

2019

I think I need to

1. Prove the proposed location is findable and not blocked by the master wordpress instance.
2. Reset the URL parameters on the Settings – General Page
3. cpio the installation directory to the new location
4. test it works and there is no conflict with tags or date queries
5. delete the old installation directory
6. make a .htaccess file
7. 5 & 6 could also be implemented by making a new directory with the .htaccess file and pointing the dns record to the new directory

I found this to help me,

1. https://codex.wordpress.org/Installing_Multiple_Blogs
2. https://help.one.com/hc/en-us/articles/115005585969-Move-your-WordPress-site-to-another-domain
3. https://www.stepforth.com/resources/web-marketing-knowledgebase/how-to-redirect-an-old-domain-to-a-new-domain/