wait_timeout too high for Windows
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
Subject
Views
Written By
Posted
wait_timeout too high for Windows
871
May 30, 2022 02:53AM
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.