Hi Sorry, I was on my temp server which was under a different domain name as I couldn’t set a domain reference, the idea was the client hosted with me but they wanted to stick with their existing co in the end so I added a 1 to the domain thinking I would just map to the reference when it was ready.
OLD htaccess
RewriteEngine Off
SetEnv DEFAULT_PHP_VERSION 53
DirectoryIndex index.cgi index.php
# BEGIN WordPress
RewriteEngine On
RewriteBase /oldsitename1.co.uk/
RewriteRule ^index\.php$ - [L]
# add a trailing slash to /wp-admin
RewriteRule ^([_0-9a-zA-Z-]+/)?wp-admin$ $1wp-admin/ [R=301,L]
RewriteCond %{REQUEST_FILENAME} -f [OR]
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^ - [L]
RewriteRule ^([_0-9a-zA-Z-]+/)?(wp-(content|admin|includes).*) $2 [L]
RewriteRule ^([_0-9a-zA-Z-]+/)?(.*\.php)$ $2 [L]
RewriteRule . index.php [L]
# END WordPress
NEW
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]
# add a trailing slash to /wp-admin
RewriteRule ^([_0-9a-zA-Z-]+/)?wp-admin$ $1wp-admin/ [R=301,L]
RewriteCond %{REQUEST_FILENAME} -f [OR]
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^ - [L]
RewriteRule ^([_0-9a-zA-Z-]+/)?(wp-(content|admin|includes).*) $2 [L]
RewriteRule ^([_0-9a-zA-Z-]+/)?(.*\.php)$ $2 [L]
RewriteRule . index.php [L]
I downloaded a local copy of the old DB.
I changed wp-options site and home from https://111.11.111.11/oldsitename1.co.uk to https://www.newsitename.co.uk
I have no fileupload_url in the table to change – if there is a set option ID I can confirm this.
wp_site old domain 111.11.11.11 path /oldsitename1.co.uk
wp_site new newsitename.co.uk path/
wp_blog #1 old domain 111.11.11.11 path /oldsitename1.co.uk
#3 old domain 111.11.11.11 path /oldsitename1.co.uk/subsitethatworksperfectly.co.uk
wp_blog #1 new domain newsitename.co.uk path/
#3 new domain newsitename.co.uk path /subsitethatworksperfectly.co.uk
#3 wp_options as per normal but this is working normally
I used a find and replace in notepad for the wp_posts changes from https://111.11.111.11/oldsitename1.co.uk to https://www.newsitename.co.uk – I exported the table on it’s own so these are nowhere else in the tables.
Once done, I imported the database to the new sql database.
Apologies, if I missed a step, I have been switching between the old and new DB to find the changes.
