当try 恢复mysql数据库时,我try 以下操作.此数据库位于容器中
cat ~/Downloads/dbname_bkp_20240423-01.sql | docker exec -i mysql-server-main /usr/bin/mysql -u root --password=password dbname
我收到这条消息:
第25行错误1118将某些列更改为文本或BEP或使用ROW_FORMAT= DYNAIC或ROW_FORMAT= COMPLSMED可能会有所帮助.在当前行格式中,768字节的DBC前置存储为内联.
线25
DROP TABLE IF EXISTS `accounts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `accounts` (
`id` char(36) NOT NULL,
`name` varchar(150) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text,
`deleted` tinyint(1) DEFAULT '0',
`assigned_user_id` char(36) DEFAULT NULL,
`type` varchar(50) DEFAULT NULL,
`industry` varchar(50) DEFAULT NULL,
`annual_revenue` varchar(100) DEFAULT NULL,
`phone_fax` varchar(100) DEFAULT NULL,
`billing_address_street` varchar(150) DEFAULT NULL,
`billing_address_city` varchar(100) DEFAULT NULL,
`billing_address_state` varchar(100) DEFAULT NULL,
`billing_address_postalcode` varchar(20) DEFAULT NULL,
`billing_address_country` varchar(255) DEFAULT NULL,
`rating` varchar(100) DEFAULT NULL,
`phone_office` varchar(100) DEFAULT NULL,
`phone_alternate` varchar(100) DEFAULT NULL,
`website` varchar(255) DEFAULT NULL,
`ownership` varchar(100) DEFAULT NULL,
`employees` varchar(10) DEFAULT NULL,
`ticker_symbol` varchar(10) DEFAULT NULL,
`shipping_address_street` varchar(150) DEFAULT NULL,
`shipping_address_city` varchar(100) DEFAULT NULL,
`shipping_address_state` varchar(100) DEFAULT NULL,
`shipping_address_postalcode` varchar(20) DEFAULT NULL,
`shipping_address_country` varchar(255) DEFAULT NULL,
`parent_id` char(36) DEFAULT NULL,
`code` varchar(10) DEFAULT NULL,
`campaign_id` char(36) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
KEY `idx_accnt_id_del` (`id`,`deleted`) USING BTREE,
KEY `idx_accnt_name_del` (`name`,`deleted`) USING BTREE,
KEY `idx_accnt_assigned_del` (`deleted`,`assigned_user_id`) USING BTREE,
KEY `idx_accnt_parent_id` (`parent_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;
关于如何处理此消息有什么建议吗?
提前问候和感谢