Web lists-archives.com

Re: --initialize specified but the data directory has files in it. Aborting.




Hello Jim,

On 11/13/2015 11:12 AM, jim Zhou wrote:
Hi,

I did "yum install myswl-community-server" and "service mysqld start"
I got the error

Initializing MySQL database:  2015-11-13T15:54:01.203931Z 0 [Warning]
Changed limits: max_open_files: 1024 (requested 5000)
2015-11-13T15:54:01.204205Z 0 [Warning] Changed limits: table_open_cache:
431 (requested 2000)
2015-11-13T15:54:01.204397Z 0 [Warning] TIMESTAMP with implicit DEFAULT
value is deprecated. Please use --explicit_defaults_for_timestamp server
option (see documentation for more details).
2015-11-13T15:54:01.207712Z 0 [ERROR] --initialize specified but the data
directory has files in it. Aborting.
2015-11-13T15:54:01.207751Z 0 [ERROR] Aborting

can someone help?

thank you,
Jim


You attempted to install a new 5.7 on top of an existing set of data.

Quoting from
http://dev.mysql.com/doc/refman/5.7/en/server-options.html#option_mysqld_initialize
This option is used to initialize a MySQL installation by creating the data directory and populating the tables in the mysql system database.

That is why it told you that the folder it was attempting to use was not empty then stopped (aborted). It wasn't going to overwrite your existing system tables with the ones it needs to use.

You could have used YUM to install an RPM or used a native YUM repo (you did not say). Did you also read this in the manual?
http://dev.mysql.com/doc/refman/5.7/en/updating-yum-repo.html
By default, the MySQL Yum repository updates MySQL to the latest version in the release series you have chosen during installation (see Selecting a Release Series for details), which means, for example, a 5.6.x installation will NOT be updated to a 5.7.x release automatically.

There is a link in that page that points you to this other very important page:
http://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html

Does this help?

--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville, TN

Become certified in MySQL! Visit https://www.mysql.com/certification/ for details.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql