• 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),
    KEY type_status_date (post_type,post_status,post_date,ID),
    KEY post_parent (post_parent),
    KEY post_author (post_author),
    KEY post_name (post_name(191)),
    FULLTEXT KEY yarpp_title (post_title),
    FULLTEXT KEY yarpp_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]

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Modify table to MyISAM, Try create full indexes and fail’ is closed to new replies.