MySQL Forums
Forum List  »  Install & Repo

5.7.11 Install Errors on Windows 10 Using Noinstall Zip Archive
Posted by: Patrik Krepps
Date: April 08, 2016 09:07AM

I'm trying to do a manual install of 5.7.11 on Windows 10 Pro 64-bit. I want everything on my E: Data drive which is a Microsoft Storage Spaces Parity Array 3.62TB (2.82TB Free). I setup the folder structure as follows:

Directory: E:\mysql\mysql5.7.11x64

Mode LastWriteTime Length Name
---- ------------- ------ ----
d----- 4/7/2016 12:34 PM bin
d----- 4/7/2016 2:34 PM data
d----- 4/7/2016 12:34 PM docs
d----- 4/7/2016 12:34 PM include
d----- 4/7/2016 12:34 PM lib
d----- 4/7/2016 12:34 PM share
-a---- 4/7/2016 12:34 PM 17987 COPYING
-a---- 4/7/2016 12:34 PM 1141 my-default.ini.old
-a---- 4/7/2016 12:54 PM 1121 my.ini
-a---- 4/7/2016 12:34 PM 2478 README


In my.ini the only active entries are as follows:

[mysqld]
# set basedir to your installation path
basedir=E:/MySQL/MySQL5.7.11x64
# set datadir to the location of your data directory
datadir=E:/MySQL/MySQL5.7.11x64/data

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

I'm following the directions in the Reference Manual 2.3.5 Installing MySQL on Microsoft Windows Using a noinstall Zip Archive.
When trying to Initialize the Data Directory I open PowerShell as Administrator and run the following commands:

C:\WINDOWS\system32>e:
E:\>cd mysql\mysql5.7.11x64
E:\MySQL\MySQL5.7.11x64>bin\mysqld.exe --defaults- file=E:\mysql\mysql5.7.11x64\my.ini --initialize-insecure --console

I was planning to setup User Account passwords later, and wanted more information displayed in the PowerShell console. The last command displays the following errors:

2016-04-08T12:20:38.039725Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defau
lts_for_timestamp server option (see documentation for more details).
2016-04-08T12:20:38.039725Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes sho
uld be used with strict mode. They will be merged with strict mode in a future release.
2016-04-08T12:20:38.039725Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2016-04-08T12:20:44.207529Z 0 [ERROR] InnoDB: Operating system error number 87 in a file operation.
2016-04-08T12:20:44.207529Z 0 [ERROR] InnoDB: File .\ib_logfile101: 'aio write' returned OS error 187. Cannot continue o
peration
2016-04-08T12:20:44.207529Z 0 [ERROR] InnoDB: Cannot continue operation.

Are there other things I should be adding to my.ini for this type of install?
Are there System Environment Variables I should setup before running this process?
I tried to open the log files created in the data directory in Notepad, but they wouldn't open.
I would appreciate any help you can give me to resolve this issue.

Options: ReplyQuote


Subject
Written By
Posted
5.7.11 Install Errors on Windows 10 Using Noinstall Zip Archive
April 08, 2016 09:07AM


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.