mysql导入出现：/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER */

最新推荐文章于 2023-12-10 16:41:37 发布
最新推荐文章于 2023-12-10 16:41:37 发布 · 6.2k 阅读 · 4
文章标签：

#数据库 #操作系统

本文介绍了一种常见的MySQL数据库导入问题及解决方法。当遇到特殊SQL语句导致导入失败时，可通过文本编辑器删除相关行来解决问题。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

导入数据库出现：/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */怎么解决

当时试着网站搬家的时候，在备份数据后然后在新的数据库中导入原来备份好的数据库提示这个：

“/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;”

不知道什么原因，在网上查看各种资料，后来终于找到解决办法如下： 先备份原来的数据，然后后用文本编辑器编辑（我用的Editplus） 找到：

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */;

删除，然后导入就ok了，

提醒的有的底部也有这3行代码，同样需要删除就OK了。

iteye_11539
关注
.mysql 数据库导入错误：40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET
Player_jun的专栏
07-24 1万+
最近在联系用Thinkphp建站，今天试着将项目上传，在Mysql数据库导入时遇到些问题，记录下来供大家共同学习。 首先，在phpMyadmin里，选择你要导出的数据库，点击导出，导出方式选择和格式都是默认即可，然后执行。 这时你会得到一个 ***.sql 文件 然后在你的空间里进入phpMyadmin 首页 点击Import 导入你刚才从本地导出的
mysql dump 40101_.mysql 数据库导入错误：40101 SET @OLD_CHARACTER_SET_CLIENT=@
weixin_36189159的博客
02-07 1422
朋友申请了一个免费的 mysql 数据库空间做测试，今天上午就把数据库导入试试，反正导了几次都出错：40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET朋友申请了一个免费的 mysql 数据库空间做测试，今天上午就把数据库导入试试，反正导了几次都出错。错误提示：代码如下复制代码/*!40101 SET @OLD_CHARACTER_SET_CLIE...
mysql 数据库导入错误：40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET
weixin_34345753的博客
09-28 1230
mysql 数据库导入错误：40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@...
.sql数据库导入错误:/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */
wutrg1502的博客
06-25 3654
通过navicat导入sql文件失败。 我开始以为是通过mysqldump命令导出数据库，所导出的sql中回包含许多的注释信息。导入的时候无法识别，后来去搜了注释的含义发现好像并不是。1)注释的含义/*!后面的数字，其实就是mysql版本号信息，意思是当版本号高于或者等于注释里的版本号时，里面的set命令才会被执行。2）导入数据时禁止/激活索引说明： DISABLE KEYS 是禁止索引 ENABLE KEYS 是激活索引 在插入数据时，都会先禁止索引
mysql 导出40101_mysql导入数据库时出现40101错误解决方法
weixin_29737207的博客
01-19 972
导入错误：40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET入的方法: mysqluse test; mysql source c:/test.sql 导入数据时，如果目标数据库或表是UTF-8字符集的，而导入SQL中有中文，可能在最终结果中出现乱码，此时只需在导入的SQL文件第一行加入如下内容 即可。 /*!40101 SET NAMES ut...
mysql /*!40101 set @old_character_set_client=@' at line 1
05-21
这是 MySQL 版本升级后的语法...这个语句表示设置一个变量 @old_character_set_client 的值为当前连接的字符集。在旧版本的 MySQL 中，没有该语法，所以会被忽略掉。如果你的 MySQL 版本较新，可以不用关注这个语句。
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET NAMES utf8 */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;这是在干嘛该段sql是人为编写的吗
04-27
40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_ALL_TABLES' */; ``` 尽管如此，整体框架仍保持高度一致性和规律性特征，表明其主要来源于标准化流程或专用软件输出产物之上再做适当个性化适应改动而已。 ...
[root@hadoop0 conf]# schematool -dbType mysql -initSchema -verbose SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/opt/apps/hive3.1/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/opt/apps/hadoop-2.7.6/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] Metastore connection URL: jdbc:mysql://hadoop0:3306/metastore?useSSL=false Metastore Connection Driver : com.mysql.cj.jdbc.Driver Metastore connection User: root Starting metastore schema initialization to 3.1.0 Initialization script hive-schema-3.1.0.mysql.sql Connecting to jdbc:mysql://hadoop0:3306/metastore?useSSL=false Connected to: MySQL (version 8.0.42) Driver: MySQL Connector/J (version mysql-connector-java-8.0.23 (Revision: 18bbd5e68195d0da083cbd5bd0d05d76320df7cd)) Transaction isolation: TRANSACTION_READ_COMMITTED 0: jdbc:mysql://hadoop0:3306/metastore> !autocommit on Autocommit status: true 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */ No rows affected (0.033 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */ No rows affected (0.016 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */ No rows affected (0.014 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET NAMES utf8 */ No rows affected (0.015 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */ No rows affected (0.019 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40103 SET TIME_ZONE='+00:00' */ No rows affected (0.016 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */ No rows affected (0.004 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */ No rows affected (0.016 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */ No rows affected (0.008 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */ No rows affected (0.024 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.014 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.02 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> CREATE TABLE IF NOT EXISTS `BUCKETING_COLS` ( `SD_ID` bigint(20) NOT NULL, `BUCKET_COL_NAME` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `INTEGER_IDX` int(11) NOT NULL, PRIMARY KEY (`SD_ID`,`INTEGER_IDX`), KEY `BUCKETING_COLS_N49` (`SD_ID`), CONSTRAINT `BUCKETING_COLS_FK1` FOREIGN KEY (`SD_ID`) REFERENCES `SDS` (`SD_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.024 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.011 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.001 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> CREATE TABLE IF NOT EXISTS `CDS` ( `CD_ID` bigint(20) NOT NULL, PRIMARY KEY (`CD_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.035 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.013 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.008 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> CREATE TABLE IF NOT EXISTS `COLUMNS_V2` ( `CD_ID` bigint(20) NOT NULL, `COMMENT` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `COLUMN_NAME` varchar(767) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `TYPE_NAME` MEDIUMTEXT DEFAULT NULL, `INTEGER_IDX` int(11) NOT NULL, PRIMARY KEY (`CD_ID`,`COLUMN_NAME`), KEY `COLUMNS_V2_N49` (`CD_ID`), CONSTRAINT `COLUMNS_V2_FK1` FOREIGN KEY (`CD_ID`) REFERENCES `CDS` (`CD_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.022 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.022 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.025 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> CREATE TABLE IF NOT EXISTS `DATABASE_PARAMS` ( `DB_ID` bigint(20) NOT NULL, `PARAM_KEY` varchar(180) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `PARAM_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (`DB_ID`,`PARAM_KEY`), KEY `DATABASE_PARAMS_N49` (`DB_ID`), CONSTRAINT `DATABASE_PARAMS_FK1` FOREIGN KEY (`DB_ID`) REFERENCES `DBS` (`DB_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.021 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.004 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> CREATE TABLE `CTLGS` ( `CTLG_ID` BIGINT PRIMARY KEY, `NAME` VARCHAR(256), `DESC` VARCHAR(4000), `LOCATION_URI` VARCHAR(4000) NOT NULL, UNIQUE KEY `UNIQUE_CATALOG` (`NAME`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Error: Table 'CTLGS' already exists (state=42S01,code=1050) Closing: 0: jdbc:mysql://hadoop0:3306/metastore?useSSL=false org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore state would be inconsistent !! Underlying cause: java.io.IOException : Schema script failed, errorcode 2 org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore state would be inconsistent !! at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:594) at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:567) at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:1517) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.RunJar.run(RunJar.java:221) at org.apache.hadoop.util.RunJar.main(RunJar.java:136) Caused by: java.io.IOException: Schema script failed, errorcode 2 at org.apache.hive.beeline.HiveSchemaTool.runBeeLine(HiveSchemaTool.java:1226) at org.apache.hive.beeline.HiveSchemaTool.runBeeLine(HiveSchemaTool.java:1204) at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:590) ... 8 more *** schemaTool failed ***
最新发布
07-10
CREATE DATABASE metastore CHARACTER SET latin1 COLLATE latin1_bin; # 重新授权（如果使用非root用户） GRANT ALL ON metastore.* TO 'hiveuser'@'%'; FLUSH PRIVILEGES; # 退出MySQL后重新初始化 schematool -...
[root@hadoop0 conf]# schematool -dbType mysql -initSchema -verbose SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/opt/apps/hive3.1/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/opt/apps/hadoop-2.7.6/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] Metastore connection URL: jdbc:mysql://hadoop0:3306/metastore?useSSL=false Metastore Connection Driver : com.mysql.cj.jdbc.Driver Metastore connection User: root Starting metastore schema initialization to 3.1.0 Initialization script hive-schema-3.1.0.mysql.sql Connecting to jdbc:mysql://hadoop0:3306/metastore?useSSL=false Connected to: MySQL (version 8.0.42) Driver: MySQL Connector/J (version mysql-connector-java-8.0.23 (Revision: 18bbd5e68195d0da083cbd5bd0d05d76320df7cd)) Transaction isolation: TRANSACTION_READ_COMMITTED 0: jdbc:mysql://hadoop0:3306/metastore> !autocommit on Autocommit status: true 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */ No rows affected (0.012 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */ No rows affected (0.005 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */ No rows affected (0.008 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET NAMES utf8 */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */ No rows affected (0.026 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40103 SET TIME_ZONE='+00:00' */ No rows affected (0.018 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */ No rows affected (0.012 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */ No rows affected (0.016 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */ No rows affected (0.027 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */ No rows affected (0.019 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.015 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.011 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> CREATE TABLE IF NOT EXISTS `BUCKETING_COLS` ( `SD_ID` bigint(20) NOT NULL, `BUCKET_COL_NAME` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `INTEGER_IDX` int(11) NOT NULL, PRIMARY KEY (`SD_ID`,`INTEGER_IDX`), KEY `BUCKETING_COLS_N49` (`SD_ID`), CONSTRAINT `BUCKETING_COLS_FK1` FOREIGN KEY (`SD_ID`) REFERENCES `SDS` (`SD_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.048 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.013 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.007 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.001 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> CREATE TABLE IF NOT EXISTS `CDS` ( `CD_ID` bigint(20) NOT NULL, PRIMARY KEY (`CD_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.018 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.016 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.012 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> CREATE TABLE IF NOT EXISTS `COLUMNS_V2` ( `CD_ID` bigint(20) NOT NULL, `COMMENT` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `COLUMN_NAME` varchar(767) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `TYPE_NAME` MEDIUMTEXT DEFAULT NULL, `INTEGER_IDX` int(11) NOT NULL, PRIMARY KEY (`CD_ID`,`COLUMN_NAME`), KEY `COLUMNS_V2_N49` (`CD_ID`), CONSTRAINT `COLUMNS_V2_FK1` FOREIGN KEY (`CD_ID`) REFERENCES `CDS` (`CD_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.005 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.008 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.004 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> CREATE TABLE IF NOT EXISTS `DATABASE_PARAMS` ( `DB_ID` bigint(20) NOT NULL, `PARAM_KEY` varchar(180) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `PARAM_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (`DB_ID`,`PARAM_KEY`), KEY `DATABASE_PARAMS_N49` (`DB_ID`), CONSTRAINT `DATABASE_PARAMS_FK1` FOREIGN KEY (`DB_ID`) REFERENCES `DBS` (`DB_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.015 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop0:3306/metastore> CREATE TABLE `CTLGS` ( `CTLG_ID` BIGINT PRIMARY KEY, `NAME` VARCHAR(256), `DESC` VARCHAR(4000), `LOCATION_URI` VARCHAR(4000) NOT NULL, UNIQUE KEY `UNIQUE_CATALOG` (`NAME`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Error: Table 'CTLGS' already exists (state=42S01,code=1050) Closing: 0: jdbc:mysql://hadoop0:3306/metastore?useSSL=false org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore state would be inconsistent !! Underlying cause: java.io.IOException : Schema script failed, errorcode 2 org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore state would be inconsistent !! at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:594) at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:567) at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:1517) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.RunJar.run(RunJar.java:221) at org.apache.hadoop.util.RunJar.main(RunJar.java:136) Caused by: java.io.IOException: Schema script failed, errorcode 2 at org.apache.hive.beeline.HiveSchemaTool.runBeeLine(HiveSchemaTool.java:1226) at org.apache.hive.beeline.HiveSchemaTool.runBeeLine(HiveSchemaTool.java:1204) at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:590) ... 8 more *** schemaTool failed ***
07-10
命令是：`schematool -dbType mysql -initSchema -verbose`，输出显示在尝试创建表 `CTLGS` 时出错，因为表已经存在。 错误信息是： ``` Error: Table 'CTLGS' already exists (state=42S01,code=1050) ``` 这导致...
40101对mysql_mysql 备份时出现 /*!40101 */
weixin_33649132的博客
01-25 858
标签：/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;该set语句将当前系统变量character_set_client的值赋值给用户变量@OLD_CHARACTER_SET_CLIENT备份文件的最后几行mysql使用set语句恢复服务器系统变量原来的值，例如：/*!40101 SET CHARACTER_SET_...
character_set_client character_set_connection character_set_results
04-13
NULL 博文链接：https://skywhsq1987.iteye.com/blog/1729773
mysql导入数据库时出现40101错误解决方法
chenrui310的博客
03-12 5729
文章总结了关于mysql导入数据库时出现40101错误,不能成功把数据库入的解决办法,有需要学习的朋友可参考一下. 导入错误:40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET 导入的方法:mysqluse test; mysql source c:/test.sql 导入数据时,如果目标数据库或表是UTF-8字符集的，而导入SQL中有中文，...
40101 mysql_mysql 备份时出现 /*!40101 */
weixin_36341727的博客
01-26 714
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;该set语句将当前系统变量character_set_client的值赋值[emailprotected]_CHARACTER_SET_CLIENT备份文件的最后几行mysql使用set语句恢复服务器系统变量原来的值，例如：/*!40101 SET [emailpr...
mysqldump迁移数据库报错 40101
波风水门
06-30 2696
文章目录前言正文 前言 今天迁移数据库时遇到个奇怪问题，使用mysqldump命令导入数据库的某张表，导出成功，导入失败，但是使用source导入又成功，特来写下具体原因 具体数据库迁移命令，可以参考 MySQL迁移数据库（mysqldump）文章 正文 导出命令如下： mysqldump -u root -p密码 数据库名 数据库表明>/tmp/mysql_data.sql --在使用导出时，执行成功 导入命令 mysqldump -u root -p密码 数据库名 < /tmp/mysq
mysql 40101_mysql 40101
weixin_31100895的博客
01-19 227
最近在练习用Thinkphp建站，今天试着将项目上传，在Mysql数据库导入时遇到些问题，记录下来供大家共同学习。首先，在phpMyadmin里，选择你要导出的数据库，点击导出，导出方式选择和格式都是默认即可，然后执行。 这时你会得到一个 ***.sql 文件然后在你的空间里进入phpMyadmin 首页 点击Import 导入你刚才从本地导出的 ***.sql 文件这是phpMyadmin可能会...
mysql 40101_mysql导入数据库时出现40101错误解决方法
weixin_35998762的博客
02-01 480
文章总结了关于mysql导入数据库时出现40101错误，不能成功把数据库入的解决办法，有需要学习的朋友可参考一下。导入错误：40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET入的方法: mysqluse test; mysql source c:/test.sql 导入数据时，如果目标数据库或表是UTF-8字符集的，而导入SQL中有中文，可能在最...
[mysql] 批量导入提示： Variable ‘character_set_client’ can’t be set to the value of ‘NULL
李培刚的博客
12-15 4864
在批量导入的 sql 文件中找到：/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNE
linux mysql 40101_mysql导入数据库时出现40101错误解决方法
weixin_35968185的博客
01-21 494
文章总结了关于mysql导入数据库时出现40101错误，不能成功把数据库入的解决办法，有需要学习的朋友可参考一下。导入错误：40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET入的方法: mysqluse test; mysql source c:/test.sql 导入数据时，如果目标数据库或表是UTF-8字符集的，而导入SQL中有中文，可能在最...
mysql 导入时遇到 的解决 Variable ‘time_zone‘ can‘t、‘character_set_client‘问题
jugt的博客
12-10 408
在sql文件末尾注释该条sql语句，前面加#号或删除。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值