• 源码安装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] 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 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
  • 相关阅读:
    【Jquery系列】详解Jquery对象和Dom对象
    将博客搬至CSDN
    【工具篇】.NET开发常用工具
    【ASP.NET MVC系列】浅谈jqGrid 在ASP.NET MVC中增删改查
    【SqlServer】【问题收集】必须声明标量变量
    【SqlServer】【问题收集】删除同一张表中完全相同的记录
    【SqlServer】【问题收集】阻止保存要求重新创建表的更改
    Java多线程编程中Future模式的详解<转>
    Java后端,应该日常翻看的中文技术网站<转>
    PostgreSql 函数
  • 原文地址:https://www.cnblogs.com/bass6/p/6795090.html
Copyright © 2020-2023  润新知