How To: Migrate Thesis SEO values to Hybrid SEO values

Posted by Adam Pieniazek | Blogging Tips | July 20th, 2010

Having recently moved my personal blog from the Thesis theme to the Hybrid theme, I had to also migrate over a bunch of SEO values from the Thesis data set to the Hybrid set. It all went rather smoothly and only took a few minutes. Here’s how to move your Thesis post meta values over to Hybrid.

Since these steps are similar to moving All in One SEO values to Thesis SEO values, please refer back to that post for detailed instructions on backing up your database and accessing the database.

  1. Backup your database
  2. Before making any huge changes to your database, you should always back it up first.

  3. Access MySQL
  4. There are a multitude of ways to access MySQL, the two most common being phpMyAdmin and the good ol’ command line. Whichever way you choose, you’ll need to get to your database and run a SQL query.

  5. Running the SQL Query
  6. If we’ve lost you up to this point, please do refer back to our super detailed post on changing database values. Once you get to the section titled ‘Copy, Paste, Go!’, come back here and grab the below query code.

    Otherwise, if you’ve been following along simply grab the below code and run it.

    insert wp_postmeta (post_id,meta_key,meta_value)
    select post_id, 'Title', meta_value
    from wp_postmeta where meta_key in ('thesis_title');
    
    insert wp_postmeta (post_id,meta_key,meta_value)
    select post_id, 'Description', meta_value
    from wp_postmeta where meta_key in ('thesis_description');
    
    insert wp_postmeta (post_id,meta_key,meta_value)
    select post_id, 'Keywords', meta_value
    from wp_postmeta where meta_key in ('thesis_keywords');
    
    insert wp_postmeta (post_id,meta_key,meta_value)
    select post_id, 'Thumbnail', meta_value
    from wp_postmeta where meta_key in ('thesis_post_image');
    

    Line by line, this code will insert into each posts meta values a Title, Description, Keywords, and thumbnail URL, using your values from Thesis.

    After each set, you should see a message noting how many records were changed:

    Query OK, 66 rows affected (0.01 sec)
    Records: 66 Duplicates: 0 Warnings: 0

    Addendum: Deleting Thesis database values

    After migrating over your meta values to Hybrid, there’s no need to keep the old Thesis meta values cluttering up your database. After checking to make sure the values transferred over correctly, run this command to wipe the database clean:

    delete from wp_postmeta where meta_key = 'thesis_title';
    delete from wp_postmeta where meta_key = 'thesis_description';
    delete from wp_postmeta where meta_key = 'thesis_keywords';
    delete from wp_postmeta where meta_key = 'thesis_post_image';
    

WordPress 2.9 Timezone and Scheduled Posts Missed Fixes

Posted by Adam Pieniazek | Blogging Tips | December 23rd, 2009

On sites running WordPress 2.9, we’ve noticed a small bug appear on a few installations. After the upgrade it appears the timezone settings get misconfigured AND scheduled posts don’t publish on time. If the timezone was manually set (e.g. using UTC […] Continue Reading…

Where to Find Batch Plugin Update in WordPress 2.9

Posted by Adam Pieniazek | Blogging Tips | December 19th, 2009

WordPress 2.9 was released today and features a ton of additions. Amongst the new features and fixes:

Batch Plugin updates (a-w-e-s-o-m-e)
Built-in Image Editor
oEmbed support
Trash can (awesome – prevent accidents)
Post Thumbnails (awesome)
Sidebar Descriptions
Better Custom Post Type API integration

and a bunch more features.

One feature […] Continue Reading…

Spotlight: The Lost Jacket

Posted by Adam Pieniazek | Spotlight | November 11th, 2009

Stuart Foster from The Lost Jacket approached us to simplify his existing site and transform its look from a blog into an agency site. We were very happy to do so as we’re big fans of the content on The Lost […] Continue Reading…

Comments Off on Emergent Group at Boston Young Entrepreneurs

Emergent Group at Boston Young Entrepreneurs

Posted by Adam Pieniazek | News | October 30th, 2009

We’re big fans of the City of Boston run group Boston Young Entreprenuers, having received excellent advice and met tons of awesome people via BYE. The featured company for November’s meeting has been announced and it’s Emergent Energy Group.

Emergent is all […] Continue Reading…

Recent Posts From The 42nd Estate Network

Recent Posts From The Community