Exporting a Drupal 8 database with phpMyAdmin will result in a broken database dump.
On import you will get the following mysql error:
CREATE TABLE `test`.`key_value` ( `collection` varchar( 128 ) NOT NULL DEFAULT '' COMMENT 'A named collection of key and value pairs.' `value` longblob NOT NULL COMMENT 'The value.',
PRIMARY KEY ( `collection` , `name` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COMMENT = 'Generic key-value storage table. See the state system for…'
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`value` longblob NOT NULL COMMENT 'The value.',
The problem is in the name column of the key_value table. See #5.
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
Is anyone still experiencing this problem?
There has been no discussion here for 5 years so perhaps there has been a change in phpmyadmin that resolved this. This seems like it is outdated. If there in further discussion this issue will be closed in three months.