Re: Building MySQL 5.7 From Source on Windows

On 18/10/2019 03.29, Lyle H. Gray wrote:

> This is a new installation, not an upgrade.
>
> I should back up a step -- I don't believe that I was able to initialize
> the environement. When I tried, this is what is written to the error
> log:
>
> ---
> 2019-10-18T00:05:59.604872Z 0 [Warning] option 'net_buffer_length':
> unsigned value 209715200 adjusted to 1048576
> 2019-10-18T00:05:59.604976Z 0 [Warning] 'NO_ZERO_DATE',
> 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be
> used with strict mode. They will be merged with strict mode in a future
> release.
> 2019-10-18T00:05:59.987825Z 0 [Warning] InnoDB: New log files created,
> LSN=45790
> 2019-10-18T00:06:00.056571Z 0 [Warning] InnoDB: Creating foreign key
> constraint system tables.
> 2019-10-18T00:06:00.134523Z 0 [Warning] No existing UUID has been found,
> so we assume that this is the first time that this server has been
> started. Generating a new UUID: 10f487b0-f13b-11e9-91b5-1065303827d4.
> 2019-10-18T00:06:00.146312Z 0 [Warning] Gtid table is not ready to be
> used. Table 'mysql.gtid_executed' cannot be opened.
> ---
>
> And nothing else. The initialization hangs at that point.
>

[Quoted] Just some stupid questions, you do have set basedir and datadir and use double backslash?

[mysqld]
basedir=C:\\Program Files\\MySQL\\MySQL Server 5.7 datadir=D:\\MySQLdata

[Quoted] and you use following command when initializing ?

bin\mysqld --defaults-file=C:\my.ini --initialize --console

(of course all paths ain't those you use)

taken from
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html

-- 

  //Aho