首页 > 代码库 > 源码安装mysql5.6x启动报错:[ERROR] Can't find messagefile '/data/mysqldata/3306/english/errmsg.sys'

源码安装mysql5.6x启动报错:[ERROR] Can't find messagefile '/data/mysqldata/3306/english/errmsg.sys'

 

170502 10:43:40 mysqld_safe Starting mysqld daemon with databases from /data/mysqldata/3306/data
2017-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] Cant find messagefile /data/mysqldata/3306/english/errmsg.sys2017-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 pages
2017-05-02 10:43:40 19170 [Note] InnoDB: The InnoDB memory heap is disabled
2017-05-02 10:43:40 19170 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-05-02 10:43:40 19170 [Note] InnoDB: Memory barrier is not used
2017-05-02 10:43:40 19170 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-05-02 10:43:40 19170 [Note] InnoDB: Using CPU crc32 instructions
2017-05-02 10:43:40 19170 [Note] InnoDB: Initializing buffer pool, size = 200.0M
2017-05-02 10:43:40 19170 [Note] InnoDB: Completed initialization of buffer pool
2017-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 start
2017-05-02 10:43:41 19170 [Note] InnoDB: 5.6.33 started; log sequence number 1600638
2017-05-02 10:43:41 19170 [ERROR] Aborting
2017-05-02 10:43:41 19170 [Note] Binlog end
2017-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 1600648
2017-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:3306
COMMAND   PID  USER   FD   TYPE DEVICE SIZE/OFF NODE NAME
mysqld  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.cnf
mysql    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

 

源码安装mysql5.6x启动报错:[ERROR] Can't find messagefile '/data/mysqldata/3306/english/errmsg.sys'