How to Migrate All In One SEO Values to Thesis

How to Migrate All In One SEO Values to Thesis

If you are new to the Thesis theme and was earlier running on any other wordpress theme with the help of the AIOSEOP (all in one seo pack plugin) to optimize, please be aware that Thesis theme has this feature inbuilt. So you can delete the AIOSEP plugin and save the blog memory usage.

But before deleting the plugin, ensure that you migrate the AIOSEOP data and values to the thesis database. Below is one simple query you can run from your PhpMyadmin (blog database) to instantly migrate all the information into your thesis DB.

For All in One SEO versions below 1.6
Run the following SQL against the WordPress database:

insert wp_postmeta (post_id,meta_key,meta_value)
select post_id, concat(‘thesis_’,meta_key),meta_value
from wp_postmeta where meta_key in (‘title’,’description’,’keywords’);

 For All in One SEO version 1.6 or higher
Run the following SQL against the WordPress database:

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’);

 IMPORTANT: Always remember to make a backup of your database before executing SQL commands, in the event that something goes wrong!