Hello list members
Since a few days I get this error message when making a backup of my
database:
mysqldump: Error 2013: Lost connection to MySQL server during query when
dumping table `dbmail_messageblks` at row: 174955
================================================================================
Script ended at: Tue Sep 4 06:45:37 CEST 2007 (1188881137)
Execution Time:
Hours: 4
Minutes: 282
Seconds: 16956
The ibdata1 file now has a size of 42GB (I use the innodb engine). The
command to backup is following:
ssh root@XXXX \
"mysqldump -u mysqldump --password=XXXX --quick
--single-transaction dbmail | /bin/gzip" > /Backup/mysqldump.tar.gz
And this is my config-file (default values from the debian package):
...
innodb_data_file_path=ibdata1:10M:autoextend:max:183G
key_buffer = 16MB
max_allowed_packet = 64M
thread_stack = 128K
query_cache_limit = 1048576
query_cache_size = 16777216
query_cache_type = 1
set-variable = max_connections=1000
max_allowed_packet = 64M
...
As I wrote above, it worked this way a very long time. And it should
work again ;)
Does anyone know this problem or has an idea?
Many thanks in advance,
Benjamin Schmidt
