systemadmin.es > DBA > MySQL 5.6: [ERROR] Can’t find messagefile /usr/share/mysql/errmsg.sys

MySQL 5.6: [ERROR] Can’t find messagefile /usr/share/mysql/errmsg.sys

Instalando una base de datos con MySQL 5.6 nos podemos encontrar con el siguiente error al intentar inicializar el datadir:

# /usr/local/mysql/scripts/mysql_install_db --user=mysql --datadir=/var/mysql --basedir=/usr/local/mysql
Installing MySQL system tables...2014-07-15 10:13:45 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2014-07-15 10:13:45 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-07-15 10:13:45 6962 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'

En realidad lo que esta ocurriendo es que no esta encontrando las variables necesarias para hacer la instalación, por lo que simplemente deberemos indicar mediante la opción –defaults-file dónde tenemos el fichero my.cnf:

# /usr/local/mysql/scripts/mysql_install_db --defaults-file=/etc/my.cnf
Installing MySQL system tables...2014-07-15 10:14:18 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-07-15 10:14:18 7016 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-07-15 10:14:18 7016 [Note] InnoDB: The InnoDB memory heap is disabled
2014-07-15 10:14:18 7016 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-07-15 10:14:18 7016 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-07-15 10:14:18 7016 [Note] InnoDB: Using CPU crc32 instructions
2014-07-15 10:14:18 7016 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-07-15 10:14:18 7016 [Note] InnoDB: Completed initialization of buffer pool
2014-07-15 10:14:18 7016 [Note] InnoDB: Highest supported file format is Barracuda.
2014-07-15 10:14:18 7016 [Note] InnoDB: 128 rollback segment(s) are active.
2014-07-15 10:14:18 7016 [Note] InnoDB: Waiting for purge to start
2014-07-15 10:14:18 7016 [Note] InnoDB: 5.6.19 started; log sequence number 1600687
2014-07-15 10:14:18 7016 [Note] Binlog end
2014-07-15 10:14:18 7016 [Note] InnoDB: FTS optimize thread exiting.
2014-07-15 10:14:18 7016 [Note] InnoDB: Starting shutdown...
2014-07-15 10:14:19 7016 [Note] InnoDB: Shutdown completed; log sequence number 1626067
OK
(...)

Deja un comentario:

XHTML - Tags permitidos:<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>