MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Walter Harms Date:February 14 2019 1:28pm
Subject:Re: mysql V 8.0.12 and mysqdump
View as plain text  

> Halaasz Saandor <hsv@stripped> 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
Thread
mysql V 8.0.12 and mysqdumpWalter Harms8 Feb 2019
  • Re: mysql V 8.0.12 and mysqdumpHalaasz Saandor9 Feb 2019
    • Re: mysql V 8.0.12 and mysqdumpWalter Harms9 Feb 2019
    • Re: mysql V 8.0.12 and mysqdumpWalter Harms14 Feb 2019