How to import All-in-One-SEO meta values to Thesis 1.7

I’ve been running Thesis on my blogs for the last year or so. With the upgrade of Thesis 1.7 and its built-in SEO features, it’s due time to get rid of my all time favorite All-in-One-SEO WordPress plugin to reduce clutter and redundancy on my server.

Less clutter is good but at the same time it introduces a new problem. All my SEO-friendly meta tags are stuck in All-in-One-SEO-made fields in my database. To continue to use them I need to port the values to Thesis values.

Gladly, for every problem there’s a solution.

I hope you have access to your webserver’s control panel. From there fire up phpMyAdmin and select your WordPress database. Then hit the SQL tab and run the following SQL query on your database. Please don’t forget to first backup your database. I won’t be responsible for any loss.

PS: this is for All-in-One-SEO version 1.6 and up only.

insert wp_postmeta (post_id,meta_key,meta_value)
select post_id, concat('thesis_', substring(meta_key,10)), meta_value
from wp_postmeta where meta_key in ('_aioseop_title','_aioseop_description','_aioseop_keywords');

When you’re done, you can go to your WordPress Dashboard and disable All-in-One-SEO from your plugin list. You could also delete it if you like.

For those of you who don’t use Thesis, I strongly recommend keeping All-in-One-SEO because it really kicks ass. It’s just done its time in my case and I need to say good-bye.