Monthly Archives: July 2012

3 Sexy SQL Hacks To Transfer WordPress To A New Domain

WordPress runs off a MySQL Database.  This is where all of your content is stored when you hit the save, publish or anything that needs to be remembered inside your WP dashboard.  It’s this MySQL database that needs to be configures correctly in order to move your site onto a new domain.  Otherwise you get the dreaded error message that many newbie web masters have probably lost a few hairs over.

Transfer WordPress to a new domain

Anyway, once you hook the database up correctly the battle still isn’t won… there’s still a list of things that you’ve got to change.  This is because the old domain that your WordPress site was on previously has riddled the MySQL database with that old domain.  You’ve now got to update it to the new domain in every place that it crops up…

But fear not, there are some sexy SQL hacks we all use to get the job done at lightening speed:

1. Change Siteurl & Homeurl

If you copy over your database and do not change both your Siteurl and Homeurl to the new domain, your site will NOT load.  Use this SQL script to update both to your new domain.

[sql]UPDATE wp_options SET option_value = replace(option_value, ‘http://www.oldurl.com’, ‘http://www.newurl.com’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;[/sql]

2. Changing GUID (Globally Unique Identifier)

Changing the GUID is the big one.  This little code will swap out every line of code containing the old domain and replace it with the new domain.

[sql]UPDATE wp_posts SET guid = REPLACE (guid, ‘http://www.oldurl.com’, ‘http://www.newurl.com’);[/sql]

3. Change The URL In Your Published Content

Any links in your posts from being on the old domain will need to be changed too.  WordPress stores them in the database using an absolute path instead of a relative path so they all need to be updated manually… or with this code.

[sql]UPDATE wp_posts SET post_content = REPLACE (post_content, ‘http://www.oldurl.com’, ‘http://www.newurl.com’);[/sql]

 

Geotargeting For International SEO

The debate about how best to geotarget for international SEO is not by any means a new topic amongst search engine optimisers.  The debate still goes on – what’s the best way to get your geotargeted content ranking for each specific country?

We’ve put this short infographic together to help you to understand the options available to you when geotargeting for international SEO.  This is of course our own opinion and only you can decide based on your circumstances which option is best for you. Enjoy.

Geotargeting for International SEO

SEO Overwhelm Buster – 5 Tips To Cut Through The Noise And Start Getting Results

A lot of the companies that I train on SEO, whether it’s one-to-one consultancy, workshops, or our members in Froggo+, they all suffer from an initial overload of information which more often than not leads to overwhelm.  This comes mainly because of the  many SEO techniques there are that you can add to your optimisation tool belt.

Article Marketing, Blogging, Web 2.0, Forum Posting, Blog Commenting, Directory Listings, .edu and .gov sites, Link swaps, Press Releases, 3-way linking, Social Bookmarking, Pinging, Feed Syndication. Spinning, posting, commenting, submitting… the learning curve is steep and I can see how people can get overwhelmed.

In this post my aim is to cut through all the noise and give you what you need to know to have a successful SEO campaign.  Great if you do your SEO in house and hugely beneficial if you buy it in as a service and want to avoid the SEO sharks.

Before Anything You Need To Understand How Search Works

We could have got our animators to make an amazing video showing “How Search Works” but we figured Matt Cutts does a pretty awesome job of it here:

(plus he’s a far bigger SEO nerd [like])

So you can see that Google is a database, a pretty huge one at that!  Now, one thing to note here is that by doing “SEO” we can never manipulate the results that Google displays – This is what Google penalise against if they catch you.  Instead, we get our results by creating and posting good quality content that positions us/you/me as the authority for our chosen keywords on external sites with a link back to the target URL (www.YourWebsite.com).  This is what’s known as a backlink, and it’s these good quality relevant links that you need to focus on getting with your SEO efforts.

Here Are My 5 Tips To Cut Through The Noise And Easily Start Building Good Quality BackLinks For Your Website

  • 00:49 – Get your customers or partners that you regularly work with to link to you.
  • 01:24 – Recommended personally by the engineers at Google – Create a blog for your company.
  • 02:06 – Create good quality unique content that visitors will want to share.
  • 02:36 – Create PR opportunities.
  • 03:20 – Relevant directories or listings.

I really hope this helps clear a lot of the confusion up and stops the overwhelm for anyone new to SEO.  If you’re still unclear and have any questions please comment below.  Additionally, if you just want to send me some love and appreciation, that’s also welcome.

Please Comment Below - James Downton