The 42nd Estate

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

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

2. Access MySQL

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.

3. Running the SQL Query

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';

Tweet

Tags: hybrid, mysql, SEO, thesis

This entry was posted on Tuesday, July 20th, 2010 at 9:52 am and is filed under Blogging Tips. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.