Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
CREATE TABLE `wp_yoast_seo_links` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`post_id` bigint(20) unsigned NOT NULL,
`target_post_id` bigint(20) unsigned NOT NULL,
`type` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `link_direction` (`post_id`,`type`)
) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `wp_yoast_seo_meta` (
`object_id` bigint(20) unsigned NOT NULL,
`internal_link_count` int(10) unsigned NOT NULL DEFAULT '0',
`incoming_link_count` int(10) unsigned DEFAULT NULL,
UNIQUE KEY `object_id` (`object_id`)
) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
Copy link

ghost commented Jul 15, 2018

@yogeshbaghel You should enter these lines to SQL section in your phpMyadmin into the related database

Copy link

ghost commented Jul 15, 2018

Worked fine for me. Thanks

@jovanmili91
Copy link

jovanmili91 commented Feb 22, 2019

Can you help me a little more precisely? Where do I need to add ? Im new

@jovanmili91
Copy link

jovanmili91 commented Feb 22, 2019

Ok, i just follow ghost comment. Thanks ! Its working now

@okeyravi
Copy link

okeyravi commented Mar 1, 2019

Hi, I have mentioned it Yoast SEO table creation step by step on my website. It will help you guys to create Yoast seo tables in database properly. Thanks GitHub for this wonderful article.

@leymannx
Copy link

leymannx commented May 29, 2019

WP-CLI

This can simply be done with WP-CLI:

$ wp db query < create-yoast-seo-5.0-tables.sql

@sae1kodok
Copy link

sae1kodok commented Oct 16, 2020

hi okeyravi
I have tried your code but an error occurs, can you help. Oh, I want to create a wp_yoast_seo_meta table on my site, https://saelekko.com/
i am using yoast seo Version 15.1.1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment