nhiggs

HaHa! It worked! was worried it would be really hard, but it was soooo easy I even managed it with a baby sat on my head!

Thank you so much for that!
Will def fully read and recommend that ebook to any / every one.

Cheers

Wow! Quick reply!
Cheers for that, that e-book looks excellent. Will have a good read when I get the baby to finally sleep.

Jigoshop? That is free, but you have to pay for extensions (although the basics may do everything you want) and a certain level of support.

If you use it, make sure you fully test that it does everything you want otherwise it can actually become fairly expensive.

Managed to get it exporting by doing a smaller section at a time.
I can now import everything, but my products (from my Jigoshop shop) have no images linked to them anymore. 8(

I’m guessing there must be some other way to do this.

I think it is timing out (I have a lot of data on my main site). The XML file coming out is 1k in size and upon importing I get:

Sorry, there has been an error.
This does not appear to be a WXR file, missing/invalid WXR version number

Cheers. Will try that later.
Would be nice to completely destroy that user though.

I actually figured out that if I added that user back (by adding a existing user by entering the e-mail) I could then change the e-mail to a junk one. Then removed the user. That leaves me clear to user my actual e-mail with a new user (as long as the new one has a unique user name)

Hmmm… Don’t think I quite get all the required setup yet.
When going to my site nearlynewnearyou.co.uk (after making it so that it will use the local version) I get “Error establishing a database connection”

In my httpd.conf I have:

<VirtualHost 127.0.0.1>
  DocumentRoot "C:/wamp/www/nearlynewnearyou.co.uk"
  ServerName nearlynewnearyou.co.uk
  ServerAlias *.nearlynewnearyou.co.uk
  ErrorLog "C:/wamp/www/nearlynewnearyou.co.uk/errors/errors.log"
</VirtualHost>

In my wp-config I have (some details changed as I guessed it would cause a security issue if it were the real data):

define('DB_NAME', 'mydbname');
define('DB_USER', 'myusername');
define('DB_PASSWORD', 'mypassword');
define('DB_HOST', 'localhost');
define('WP_HOME', 'https://nearlynewnearyou.co.uk');
define('WP_SITEURL', 'https://nearlynewnearyou.co.uk');

and my hosts looks like this:

127.0.0.1       localhost
127.0.0.1       nearlynewnearyou.co.uk
127.0.0.1       warwick.nearlynewnearyou.co.uk
127.0.0.1       halloween.nearlynewnearyou.co.uk

myphpadmin shows that I have a database called ‘mydname’ (matches what is in wp-config) and under privileges of that db a user called ‘myusername’ with a password of ‘mypassword’ (both match what is in wp-config) and set to have all privileges.

I have exported the live site db ‘mydbname’ and then imported that data back into the local ‘mydbname’

I also ftp’d all the live sites public_html into C:\wamp\www\nearlynewnearyou.co.uk\

Any idea what I could have done wrong to get that error?

Of course! Thanks for the link Andrea, I completely missed that you could set the site urls to actually point to my local site!

Ah! Ok, so that only exports / imports the sub-domain and not the whole network?

I really hope I have been that dumb!

Will give it a try, cheers!

What exactly is the problem? Is it that you can’t access the wp-admin area or are changes to posts not occurring?

So many things ‘may’ be happening and without more info it’s unlikely anyone can offer any decent advice.

Excellent!
Many thanks.

I have figured it out! It was actually really simple but seemed more complex as I missed the ‘Custom Fields’ options in the add posts / pages screen due to them being hidden by the collapsed ‘screen options’ at the top.

On the about page (which has details about the site) I add any custom fields (i.e ‘branch_name’ I wanted. Now in the template I use the following code:

<?php echo get_post_meta(get_page_by_title( 'About' )->ID, 'branch_name', true); ?>

This gets the page titled ‘About’ and uses it’s ID to extract the custom ‘branch_name’ from that page. It the goes onto write out that field.

I think I’m going to end up using these custom fields much more. 8)

8) and I’m another! I followed the advise on the site below to convert the URLs:
https://codex.www.ads-software.com/Changing_The_Site_URL

It took a fair while, but I got it done and now have a working multisite network.

Really wish it said you MUST get rid of the www rather than it is recommended.

Anyway, thanks for the help! 8)

Ok, cheers.
Is that likely to be what is causing the issues?

It seems too late to change that now. The boxes are greyed out even though I have no reverted my wp-config file.