I mentioned in my earlier post “10 SEO Tips For Wordpress Blogs” that I couldn’t get a nice plugin called SEO Title Tag to work. I found out that the problem was because the tables were not created when I activated the plugin. The solution is to create the tables manually using phpMyAdmin.

Assuming that your hosting account has cPanel, login and click on an icon called “MySQL Databases”. Look for a link at the bottom of the following page that says “phpMyAdmin”. Clicking on that link will open up a new page with a list of databases. Select your Wordpress database and click on the tab called “SQL” - you will see a form as illustrated in the image below:

Copy the codes below (excluding the lines “Start Below” and “End Above”) and paste them into the yellow area:

—– Start Below —–
CREATE TABLE wp_seo_title_tag_url (
id bigint(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
url varchar(255) NOT NULL,
title varchar(255) NOT NULL
);

CREATE TABLE wp_seo_title_tag_category (
id bigint(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
category_id varchar(255) NOT NULL,
title varchar(255) NOT NULL
);
—– End Above —–

Click on “Go” and the tables should be created automatically. You will see the results in the following page if the query was successful. The simple steps to creating tables manually for the Wordpress SEO Title Tag plugin are summarized below:

1. Login to your hosting account’s cPanel.
2. Click on “MySQL Databses” icon.
3. Click on “phpMyAdmin” link at the bottom of the page.
4. Select your Wordpress table from the left column.
5. Click on the “SQL” tab.
6. Copy and paste the codes above into the box. Click “Go”.
7. The tables are created automatically. Done.

Hope that helps.