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

    Tags: , , ,

One Response to “How To: Migrate Thesis SEO values to Hybrid SEO values”

  1. Hi,

    Out of curiosity, is there a reason why you migrated from Thesis to Hybrid? I have been thinking of migrating to Thesis, and never heard of Hybrid….

Recent Posts From The 42nd Estate Network

Recent Posts From The Community