[wp-trac] [WordPress Trac] #54834: Mysql gone away when importing DB on create wp_posts indexes

WordPress Trac noreply at wordpress.org
Sun Jan 16 13:10:48 UTC 2022


#54834: Mysql gone away when importing DB on create wp_posts indexes
--------------------------+-----------------------------
 Reporter:  jasmines      |      Owner:  (none)
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  General       |    Version:
 Severity:  blocker       |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 Already imported the table and its data.
 When I execute the following:

 ALTER TABLE `wp_posts`
   ADD PRIMARY KEY (`ID`),
   ADD KEY `post_name` (`post_name`(191)),
   ADD KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
   ADD KEY `post_parent` (`post_parent`),
   ADD KEY `post_author` (`post_author`);

 I have 2013 error (in console) or 2006 (in phpmyadmin) immediately.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/54834>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform


More information about the wp-trac mailing list