> Halaasz Saandor <h...@tbbs.net> hat am 9. Februar 2019 um 10:01 geschrieben:
>
>
> 2019/02/08 10:32 ... Walter Harms:
> > Hello list,
> > i run into an unexpected problem with mysqldump:
> >
> > mysqldump --version
> > mysqldump Ver 8.0.12 for Linux on x86_64 (MySQL Community Server - GPL)
> >
> >
> > when i try it results in:
> > mysqldump: Error: 'Lost connection to MySQL server during query' when trying
> > to
> > dump tablespaces
> > mysqldump: Couldn't execute 'SHOW VARIABLES LIKE 'ndbinfo\_version'': MySQL
> > server has gone away (2006)
>
> I regulary hav this problem with the command-line client (mysql.exe) and
> when I asked R H gave this answer (and with the command-line client it
> is much less imporant):
>
> -------- Forwarded Message --------
I found a solution with this (to set for mysqld in my.cnf):
wait_timeout = 31536000
It sets the time out very high and mysqldump can now complet the query.
personaly i would say this is not a propper solution as it does not solve
the problem of an sql statement taking 15min to complet.
re,
wh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
