Modify table to MyISAM, Try create full indexes and fail
-
Centos 7, MariaDB 10.2.11
Steps:
- mysql > use mydatabase;
- mariadb [mysqdatase]>ALTER TABLE
dme3_posts
ENGINE = MyISAM;
Query OK, 22265 rows affected (40.65 sec)
Registros: 22265 Duplicados: 0 Peligros: 0 - Click on button Create full indexes
Fail:
Fulltext Index creation did not work!
Check table on SequelPro (Result below. You see new fulltext key for title and content)
CREATE TABLE
dme3_posts
(
ID
bigint(20) unsigned NOT NULL AUTO_INCREMENT,
post_author
bigint(20) unsigned NOT NULL DEFAULT 0,
post_date
datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
post_date_gmt
datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
post_content
longtext COLLATE utf8mb4_unicode_ci NOT NULL,
post_title
text COLLATE utf8mb4_unicode_ci NOT NULL,
post_excerpt
text COLLATE utf8mb4_unicode_ci NOT NULL,
post_status
varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ‘publish’,
comment_status
varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ‘open’,
ping_status
varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ‘open’,
post_password
varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ”,
post_name
varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ”,
to_ping
text COLLATE utf8mb4_unicode_ci NOT NULL,
pinged
text COLLATE utf8mb4_unicode_ci NOT NULL,
post_modified
datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
post_modified_gmt
datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
post_content_filtered
longtext COLLATE utf8mb4_unicode_ci NOT NULL,
post_parent
bigint(20) unsigned NOT NULL DEFAULT 0,
guid
varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ”,
menu_order
int(11) NOT NULL DEFAULT 0,
post_type
varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ‘post’,
post_mime_type
varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ”,
comment_count
bigint(20) NOT NULL DEFAULT 0,
PRIMARY KEY (ID
),
KEYtype_status_date
(post_type
,post_status
,post_date
,ID
),
KEYpost_parent
(post_parent
),
KEYpost_author
(post_author
),
KEYpost_name
(post_name
(191)),
FULLTEXT KEYyarpp_title
(post_title
),
FULLTEXT KEYyarpp_content
(post_content
)
) ENGINE=MyISAM AUTO_INCREMENT=35298 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;Whta’ is wrong?
The page I need help with: [log in to see the link]
- The topic ‘Modify table to MyISAM, Try create full indexes and fail’ is closed to new replies.