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
