Web lists-archives.com

Re: Start mysqld 5.7.7 with new disk






Am 23.12.2015 um 14:11 schrieb Jørn Dahl-Stamnes:
I had to replace the datadisk where mysql had its innodb files.

But after I had added a new disk I'm not able to initialize mysql files any more:

# mysqld --initialize --user=mysql
2015-12-23T13:07:08.216472Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2015-12-23T13:07:08.216556Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-12-23T13:07:08.216577Z 0 [ERROR] Failed to initialize plugins.
2015-12-23T13:07:08.216595Z 0 [ERROR] Aborting

I have created the directories stored in my /etc/my.cnf and changed group and ownership to the
directories to mysql:mysql

man mysql_install_db

NAME
       mysql_install_db - initialize MariaDB data directory

SYNOPSIS
       mysql_install_db [options]

DESCRIPTION
mysql_install_db initializes the MariaDB data directory and creates the system tables that it contains, if they do not exist.

       To invoke mysql_install_db, use the following syntax:

           shell> mysql_install_db [options]

Because the MariaDB server, mysqld, needs to access the data directory when it runs later, you should either run mysql_install_db from the same account that will be used for running mysqld or run it as root and use the --user option to indicate the user name that mysqld will run as. It might be necessary to specify other options such as --basedir or --datadir if mysql_install_db does not use the correct locations for the installation directory or data directory. For example:

           shell> bin/mysql_install_db --user=mysql \
                    --basedir=/opt/mysql/mysql \
                    --datadir=/opt/mysql/mysql/data

Attachment: signature.asc
Description: OpenPGP digital signature