MySQL Forums
Forum List  »  MySQL Shell

wait_timeout too high for Windows
Posted by: Sébastien F.
Date: May 30, 2022 02:53AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
wait_timeout too high for Windows
918
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.