博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
源码安装mysql5.6x启动报错:[ERROR] Can't find messagefile '/data/mysqldata/3306/english/errmsg.sys'...
阅读量:5775 次
发布时间:2019-06-18

本文共 5815 字,大约阅读时间需要 19 分钟。

 

170502 10:43:40 mysqld_safe Starting mysqld daemon with databases from /data/mysqldata/3306/data2017-05-02 10:43:40 0 [Warning] The syntax '--language/-l' is deprecated and will be removed in a future release. Please use '--lc-messages-dir' instead.2017-05-02 10:43:40 0 [Note] /app/mysql-5.6.33/bin/mysqld (mysqld 5.6.33-log) starting as process 19170 ...2017-05-02 10:43:40 19170 [ERROR] Can't find messagefile '/data/mysqldata/3306/english/errmsg.sys'2017-05-02 10:43:40 19170 [Note] Plugin 'FEDERATED' is disabled.2017-05-02 10:43:40 19170 [Note] InnoDB: Using atomics to ref count buffer pool pages2017-05-02 10:43:40 19170 [Note] InnoDB: The InnoDB memory heap is disabled2017-05-02 10:43:40 19170 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2017-05-02 10:43:40 19170 [Note] InnoDB: Memory barrier is not used2017-05-02 10:43:40 19170 [Note] InnoDB: Compressed tables use zlib 1.2.32017-05-02 10:43:40 19170 [Note] InnoDB: Using CPU crc32 instructions2017-05-02 10:43:40 19170 [Note] InnoDB: Initializing buffer pool, size = 200.0M2017-05-02 10:43:40 19170 [Note] InnoDB: Completed initialization of buffer pool2017-05-02 10:43:40 19170 [Note] InnoDB: Highest supported file format is Barracuda.2017-05-02 10:43:41 19170 [Note] InnoDB: 128 rollback segment(s) are active.2017-05-02 10:43:41 19170 [Note] InnoDB: Waiting for purge to start2017-05-02 10:43:41 19170 [Note] InnoDB: 5.6.33 started; log sequence number 16006382017-05-02 10:43:41 19170 [ERROR] Aborting2017-05-02 10:43:41 19170 [Note] Binlog end2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'partition'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'BLACKHOLE'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_SYS_TABLES'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_FT_CONFIG'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_FT_DELETED'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_METRICS'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_CMPMEM'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_CMP_RESET'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_CMP'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_CMP'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_LOCKS'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'INNODB_TRX'2017-05-02 10:43:41 19170 [Note] Shutting down plugin 'InnoDB'2017-05-02 10:43:41 19170 [Note] InnoDB: FTS optimize thread exiting.2017-05-02 10:43:41 19170 [Note] InnoDB: Starting shutdown...2017-05-02 10:43:42 19170 [Note] InnoDB: Shutdown completed; log sequence number 16006482017-05-02 10:43:42 19170 [Note] Shutting down plugin 'ARCHIVE'2017-05-02 10:43:42 19170 [Note] Shutting down plugin 'CSV'2017-05-02 10:43:42 19170 [Note] Shutting down plugin 'MEMORY'2017-05-02 10:43:42 19170 [Note] Shutting down plugin 'MRG_MYISAM'2017-05-02 10:43:42 19170 [Note] Shutting down plugin 'MyISAM'2017-05-02 10:43:42 19170 [Note] Shutting down plugin 'sha256_password'2017-05-02 10:43:42 19170 [Note] Shutting down plugin 'mysql_old_password'2017-05-02 10:43:42 19170 [Note] Shutting down plugin 'mysql_native_password'2017-05-02 10:43:42 19170 [Note] Shutting down plugin 'binlog'2017-05-02 10:43:42 19170 [Note]170502 10:43:42 mysqld_safe mysqld from pid file /data/mysqldata/3306/mysql.pid ended

从源码包中把该文件复制到安装目录中:

[root@DB english]# pwd/data/mysqldata/3306/english[root@DB english]# cp /usr/local/src/mysql-5.6.33/sql/share/english/errmsg.sys ./

ok,再次启动,成功:

[root@DB english]# /app/mysql-5.6.33/bin/mysqld_safe --defaults-file=/data/mysqldata/3306/my.cnf &
[root@DB english]# lsof -i:3306COMMAND   PID  USER   FD   TYPE DEVICE SIZE/OFF NODE NAMEmysqld  19765 mysql   17u  IPv6  64982      0t0  TCP *:mysql (LISTEN)

 

/bin/sh /app/mysql-5.6.33/bin/mysqld_safe --defaults-file=/data/mysqldata/3306/my.cnfmysql    19765  0.0 80.4 1088216 403736 pts/0  Sl   10:48   0:00 /app/mysql-5.6.33/bin/mysqld --defaults-file=/data/mysqldata/3306/my.cnf --basedir=/app/mysql-5.6.31 --datadir=/data/mysqldata/3306/data --plugin-dir=/app/mysql-5.6.33/lib/plugin --user=mysql --log-error=/data/mysqldata/3306/data/../mysql-error.log --open-files-limit=512 --pid-file=/data/mysqldata/3306/mysql.pid --socket=/data/mysqldata/3306/mysql.sock --port=3306

 

转载地址:http://mweux.baihongyu.com/

你可能感兴趣的文章
浅谈linux优化
查看>>
rhel6.2 本地yum源搭建
查看>>
Docker 镜像与库
查看>>
Disruptor技术调研之配置ExceptionHandler
查看>>
硬盘工作原理
查看>>
Go 语言中数据类型的判断
查看>>
RPF(Reverse Path Forwarding 反向路径转发)技术
查看>>
python函数定义和调用
查看>>
地图具体位置标注
查看>>
docker registry 安装步骤
查看>>
树莓派nodejs,mongodb
查看>>
话里话外:流程持续优化的关键点
查看>>
centos下做Lvs负载均衡
查看>>
mongoDB find函数用法
查看>>
详解Linux运维工程师必备技能
查看>>
20111222是不是也该云一下
查看>>
去除XP所有病毒的绝招
查看>>
zabbix server is not running解决办法
查看>>
整理几个liunx命令
查看>>
【NPoco ORM系列】For linq
查看>>