Problem with the database

  • noindex

    (@noindex)


    8 years, 6 months ago

    Hi!

    After installing the plugin, a can’t restore databease from the backup.
    I make backup and restore standart way through the console, the backup is done normally, when I restore I receive an error:

    command: mysql dbName -uuser -ppassword < dump.sql
    answer: ERROR 1071 (42000) at line 53: Specified key was too long; max key length is 1000 bytes

    When analyzing backup, I see that the error occurs when creating a table commentsmeta

    DROP TABLE IF EXISTSwp_commentmeta;
    /*!40101 SET @saved_cs_client = @@character_set_client */;
    /*!40101 SET character_set_client = utf8 */;
    CREATE TABLE wp_commentmeta (
    meta_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    comment_id bigint(20) unsigned NOT NULL DEFAULT ‘0’,
    meta_key varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    meta_value longtext COLLATE utf8mb4_unicode_ci,
    PRIMARY KEY (meta_id),
    KEY comment_id (comment_id),
    KEY meta_key (meta_key(191)),
    KEY disqus_dupecheck (meta_key,meta_value(11))
    ) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

    An error occurs while creating the disqus_dupecheck key.

    KEY disqus_dupecheck (meta_key,meta_value(11))

    After deleting this line, the backup is restoring normally, but I’m not sure that this does not cause other errors
    BTW, in this table only 12 lines…

The topic ‘Problem with the database’ is closed to new replies.