Re: mysqldump of huge innodb database

2007-09-24 Thread Dan Buettner
happen, but now I just run all of my > backups straight to a mirrored server. > > > > Example: mysqldump -h 192.168.x.x -u mysqldump --password= --opt > --verbose --net_buffer_length=1G --max_allowed_packet=1G > --single-transaction dbname > dbname.sql > > > >

Re: mysqldump of huge innodb database

2007-09-24 Thread Benjamin Schmidt
ent: Tuesday, 4 September 2007 7:05 PM To: mysql@lists.mysql.com Subject: mysqldump of huge innodb database 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

RE: mysqldump of huge innodb database

2007-09-04 Thread Hartleigh Burton
min Schmidt [mailto:[EMAIL PROTECTED] Sent: Tuesday, 4 September 2007 7:05 PM To: mysql@lists.mysql.com Subject: mysqldump of huge innodb database 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 se

mysqldump of huge innodb database

2007-09-04 Thread Benjamin Schmidt
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 =