MySQL Forums
Forum List  »  Newbie

mysql not starting
Posted by: Mohammed Yasir Hashmi
Date: October 17, 2016 02:42AM

HI all,
I am using windows.

I took backup of mysql database and dropped it for testing purpose.
I shutdown my sql :
mysqladmin -u root -p shutdown

But when I am starting it back, its throwing error:

mysqld: Can't change dir to 'c:\Program Files\MySQL\MySQL Server 5.7\data\' (Err
code: 2 - No such file or directory)
2016-10-17T08:37:36.413655Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is
deprecated. Please use --explicit_defaults_for_timestamp server option (see doc
umentation for more details).
2016-10-17T08:37:36.413655Z 0 [Warning] Insecure configuration for --secure-file
-priv: Current value does not restrict location of generated files. Consider set
ting it to a valid, non-empty path.
2016-10-17T08:37:36.413655Z 0 [Note] mysqld (mysqld 5.7.15-enterprise-commercial
-advanced) starting as process 10876 ...
2016-10-17T08:37:36.420659Z 0 [Warning] Can't create test file c:\Program Files\
MySQL\MySQL Server 5.7\data\LP-54EE753D8BF9.lower-test
2016-10-17T08:37:36.421659Z 0 [Warning] Can't create test file c:\Program Files\
MySQL\MySQL Server 5.7\data\LP-54EE753D8BF9.lower-test
2016-10-17T08:37:36.421659Z 0 [ERROR] failed to set datadir to c:\Program Files\
MySQL\MySQL Server 5.7\data\
2016-10-17T08:37:36.422663Z 0 [ERROR] Aborting

2016-10-17T08:37:36.422663Z 0 [Note] Binlog end
2016-10-17T08:37:36.422663Z 0 [Note] mysqld: Shutdown complete


Any help would be appreciated.

Regards,
Yasir

Options: ReplyQuote


Subject
Written By
Posted
mysql not starting
October 17, 2016 02:42AM
October 17, 2016 04:16AM
October 17, 2016 09:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.