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

[Reindl Harald]

Am 13.11.2015 um 17:12 schrieb jim Zhou:

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


this is most likely because the socket file lives by default in 
"/var/lib/mysql" and maybe created too soon for the task


write a bugreport and in the meantime temporary configure mysqld with 
the socket file somewhere else like /tmp, make sure with "ls -lha 
/var/lib/mysql" that the directory is really empty




signature.asc
Description: OpenPGP digital signature

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

[Reindl Harald]

Am 13.11.2015 um 17:37 schrieb jim Zhou:

I change socket=/tmp/mysql.sock in my.cnf file and I am still having the
same error.
ls -lha /var/lib/mysql the directory is not empty. those .pem files are
created by the service even I deleted them.


write a bugreport if they are really created by the service before 
mysql_install_db is called, in the meantime make sure the directory is 
empty and call "mysql_install_db" by hand without trying to start the 
service before


P.S.: don't reply offlist!


[root@deweyods1 pem]# ls -lha /var/lib/mysql
total 48K
drwxr-x--x.  2 mysql mysql 4.0K Nov 13 07:33 .
drwxr-xr-x. 44 root  root  4.0K Nov 12 15:12 ..
-rw---.  1 mysql mysql  255 Nov 13 08:27 .bash_history
-rw---.  1 mysql mysql 1.7K Nov 13 07:33 ca-key.pem
-rw-r--r--.  1 mysql mysql 1.1K Nov 13 07:33 ca.pem
-rw-r--r--.  1 mysql mysql 1.1K Nov 13 07:33 client-cert.pem
-rw---.  1 mysql mysql 1.7K Nov 13 07:33 client-key.pem
-rw---.  1 mysql mysql 1.7K Nov 13 07:33 private_key.pem
-rw-r--r--.  1 mysql mysql  451 Nov 13 07:33 public_key.pem
-rw-r--r--.  1 mysql mysql 1.1K Nov 13 07:33 server-cert.pem
-rw---.  1 mysql mysql 1.7K Nov 13 07:33 server-key.pem
-rw---.  1 mysql mysql  578 Nov 12 15:21 .viminfo




signature.asc
Description: OpenPGP digital signature

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

[jim Zhou]

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

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

[Reindl Harald]

Am 13.11.2015 um 17:46 schrieb Axel Diehl:

what kind of OS do you have?


pretty sure Fedora/CentOS7 because "yum" and the package name, if i 
would be him i would just install mariadb which is the default mysql 
implementation these days on most linux distributions and hence the 
packages are better maintained



-Ursprüngliche Nachricht-
Von: jim Zhou [mailto:jim.jz.z...@gmail.com]
Gesendet: Freitag, 13. November 2015 17:12
An: mysql@lists.mysql.com
Betreff: --initialize specified but the data directory has files in it. 
Aborting.

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?




signature.asc
Description: OpenPGP digital signature

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

[Axel Diehl]

Hi,

what kind of OS do you have?

Regards,
Axel

-Ursprüngliche Nachricht-
Von: jim Zhou [mailto:jim.jz.z...@gmail.com] 
Gesendet: Freitag, 13. November 2015 17:12
An: mysql@lists.mysql.com
Betreff: --initialize specified but the data directory has files in it. 
Aborting.

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

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

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

[jim Zhou]

[root@deweyods1 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.6 (Santiago)

On Fri, Nov 13, 2015 at 8:56 AM, Reindl Harald 
wrote:

>
>
> Am 13.11.2015 um 17:46 schrieb Axel Diehl:
>
>> what kind of OS do you have?
>>
>
> pretty sure Fedora/CentOS7 because "yum" and the package name, if i would
> be him i would just install mariadb which is the default mysql
> implementation these days on most linux distributions and hence the
> packages are better maintained
>
>
> -Ursprüngliche Nachricht-
>> Von: jim Zhou [mailto:jim.jz.z...@gmail.com]
>> Gesendet: Freitag, 13. November 2015 17:12
>> An: mysql@lists.mysql.com
>> Betreff: --initialize specified but the data directory has files in it.
>> Aborting.
>>
>> 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?
>>
>
>

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

[shawn l.green]

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