Title: Problem with the database
Last modified: November 27, 2017

---

# Problem with the database

 *  [noindex](https://wordpress.org/support/users/noindex/)
 * (@noindex)
 * [8 years, 6 months ago](https://wordpress.org/support/topic/problem-with-the-database-2/)
 * 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 EXISTS`wp_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.

 * ![](https://ps.w.org/disqus-comment-system/assets/icon.svg?rev=1636350)
 * [Disqus Comment System](https://wordpress.org/plugins/disqus-comment-system/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/disqus-comment-system/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/disqus-comment-system/)
 * [Active Topics](https://wordpress.org/support/plugin/disqus-comment-system/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/disqus-comment-system/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/disqus-comment-system/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [noindex](https://wordpress.org/support/users/noindex/)
 * Last activity: [8 years, 6 months ago](https://wordpress.org/support/topic/problem-with-the-database-2/)
 * Status: not resolved