Re: --initialize specified but the data directory has files in it. Aborting.
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.
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.
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.
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.
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.
[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 Haraldwrote: > > > 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.
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