wait_timeout too high for Windows

[Sébastien F.]

Hello,

I try to import airportdb (https://dev.mysql.com/doc/airportdb/en/) on MySQL server installed on my Windows laptop.

MySQL  127.0.0.1:33060+ ssl  sample_db  JS > util.loadDump('D:/airport-db')
Loading DDL and Data from 'D:/airport-db' using 4 threads.
Opening dump...
NOTE: Dump format has version 1.0.2 and was created by an older version of MySQL Shell. If you experience problems loading it, please recreate the dump using the current version of MySQL Shell and try again.
Target is MySQL 8.0.29. Dump was produced from MySQL 8.0.26-cloud
ERROR: [Worker001] Error opening connection to MySQL: MySQL Error 1231 (42000): Variable 'wait_timeout' can't be set to the value of '31536000'
ERROR: [Worker000] Error opening connection to MySQL: MySQL Error 1231 (42000): Variable 'wait_timeout' can't be set to the value of '31536000'
ERROR: [Worker003] Error opening connection to MySQL: MySQL Error 1231 (42000): Variable 'wait_timeout' can't be set to the value of '31536000'
ERROR: [Worker002] Error opening connection to MySQL: MySQL Error 1231 (42000): Variable 'wait_timeout' can't be set to the value of '31536000'
Util.loadDump: Variable 'wait_timeout' can't be set to the value of '31536000' (MYSQLSH 1231)
MySQL  127.0.0.1:33060+ ssl  sample_db  JS > _

The error says "Variable 'wait_timeout' can't be set to the value of '31536000'"

The doc about wait_timeout (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_wait_timeout) says :

> Maximum Value (Windows) 2147483
> Maximum Value (Other) 31536000

I don't find params to set MySQL Shell wait_timeout https://dev.mysql.com/doc/mysql-shell/8.0/en/mysqlsh.html

Any ideas ?

Thx