Affiliate Marketing blog by James Little

Just wanted to say a massive thanks to everyone who was involved in the Affiliate GTG on Thursday Night; one of the best affiliate events I have attended yet.

It was a fantastic night and there are a few individual thanks to make:

Kevin & Jess:   As the two main organisers who managed to pull it all together both before and on the night!

Josh from Great UK Surveys:  I was tired and ready for going, then you got us THAT cocktail that turned me into a maniac for the rest of the night!

Tom, Kitty (Maximiles) & James (Flightmapping): For attending the pre-networking drinks at the ship!

Hannah, Mike and Mark:  For keeping team Xtreme alive! Hopefully some parts of the gay nightclub will be forgotten sooner than others… the helicopter, arfgh.

Graham: For sharing the Taxi home – hope your coat turns up or at the very least that your wife doesn’t kill you!

Look forward to the next one!

The 2009 series of The Apprentice kicks off tomorrow at 9pm on BBC1 and the line up of this year’s 15 contenders has been announced.

In all honestly last year was the first year that I’d really had a chance to watch the series after reading Kierons blog post about how good it was and for the first few episodes I could not stand it – the arrogance of some of the people on the show was absolutely astounding but as the series developed I got into it and was relieved when Alan didn’t give the job to Claire, one of the most annoying people I’ve ever seen on TV.

In advance of the launch tomorrow I’d like to wish one of the contestants, James McQuillan all the best of luck in the show.

I worked with James about 8 years ago at One.Tel and whilst we were in different teams (I was lead web developer and he was head of buying) we were at pretty much the same level management wise and shared many a beer together.

I’ve not spoken to James since I left One.Tel a number of years ago but am sure that he will do well and am looking forward to the start of the season!

I recently decided to get rid of my dedicated server that I have in Germany as I could not really justify the cost or time spend on administration of it, especially with the Euro getting stronger so the costs going up.  In the end I opted for some low cost hosting with Hostgator who I’ve had a very positive experience with recently.

With that being the case, I needed to work out how to easily migrate a number of Wordpress blogs across to a new server and thought it was worth sharing the experience here for others in the same situation as I seem to have got it just about right after two or three migrations.

So here is my step by step guide – hope it’s helpful for others in the same situation:

1. Get the new version of wordpress setup first – I would suggest using a temporary domain / sub-domain for this (test.domain.com or something like this). If you have Cpanel included in your hosting then Wordpress is a 1 click install which makes life even easier.
2. Login to both the new and old wordpress admin sections – check what plugins you have activated and install them onto the new version of wordpress – this step is important as if you’re using Viper Quicktags for YouTube videos and import your posts BEFORE you add the plugins then they won’t work.
3. Replicate the settings of your plugins (google analytics, seo for wordpress, etc) and your permalinks.
4. Next go to Tools > Export and export all your posts and comments to a file on your old version of wordpress.. if it’s not the latest version it may not be under tools but you should find it easy enough.
5. Next go back into the new version of wordpress, select Tools > Import.  It’s a fairly simple step by step process and make sure you assign the posts to the correct user account / create one as part of this process if required.
6. All your posts and comments should be setup now – the only thing left to sort out should be the theme so let’s do that next.  First, you’ll need to FTP into your old host and go to the wp-content > themes folder and download the theme that you have been using to your local drive.
7. Next FTP into the new site and put the theme back in the same location on the new server (in the wp-content folder).  Go into the new version of the wordpress admin, select Appearance and you should be able to select your theme.
8. If you’ve previously setup Widgets for your theme you’ll need to add these all in again – you can go into your old version of Wordpress and make sure you put them all back into the same order again here.
9. Now the new version of Wordpress is an exact copy – the only thing left to change is under Settings.  As this is on a temporary domain you’ll need to change your Wordpress Address (URL) and Blog Address (URL) to the correct URL’s.  You’ll be logged out and send to the old version of your wordpress when you click on the save button.
10. Last step – change your DNS settings (you’re host or register will either give you a control panel to do this yourself or do it for you) so that you point your domain to the new server… This typically can take up to  12-24 hours to propagate across the internet but is usually a fair bit faster than that for most DNS servers.

That’s the lot – I’ve managed to get it down to a fine art and can do it in around 10 minutes now without any problems and the main things to look out for are getting the plugins activated at the right step and getting all the settings and widgets included… Using this method is a hell of a lot easier than exporting tables from an SQL database as others have suggested in the past!