28 reputation
4
bio website maybetomorrow.co.uk
location
age
visits member for 2 years, 2 months
seen Feb 25 at 17:45

Feb
10
comment Backup / Export data from MySQL 5.5 attachments table keeps failing!
Sadly, still the exact same error - again down to the exact same row :(
Feb
6
comment Backup / Export data from MySQL 5.5 attachments table keeps failing!
Ah, brilliant, thanks I will give this a go!
Aug
12
comment Backup / Export data from MySQL 5.5 attachments table keeps failing!
Unfortunately this gives the same error :( Right down to the same row number: mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table attachments` at row: 251249`. Is there anyway to just skip that row? I have tried to output using a mysql query limiting the rows, but that fails with "lost connection to mysql server" too!
Aug
9
comment Backup / Export data from MySQL 5.5 attachments table keeps failing!
Aaron - I have updated the question as advised.
Aug
9
revised Backup / Export data from MySQL 5.5 attachments table keeps failing!
added 856 characters in body
Aug
9
comment Backup / Export data from MySQL 5.5 attachments table keeps failing!
Thanks, I will give this a try!
Aug
9
awarded  Commentator
Aug
9
comment Backup / Export data from MySQL 5.5 attachments table keeps failing!
My apologies - a correction here - the server is 8Gb Ram, not 16. I've had the buffer_pool_size up at 6gb and exactly the same problem. The command I used, and the error is on a comment on the original question. Thanks.
Aug
9
comment Backup / Export data from MySQL 5.5 attachments table keeps failing!
mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table attachments at row: 251249
Aug
9
comment Backup / Export data from MySQL 5.5 attachments table keeps failing!
The server has 16gb RAM, Some of the relevant settings copied below. It is an INNODB database/table. `innodb_buffer_pool_size=3000M, innodb_log_file_size=1113M, max_allowed_packet=2024M, query_cache_size=52M, tmp_table_size=500M, myisam_sort_buffer_size=50M
Aug
9
comment Backup / Export data from MySQL 5.5 attachments table keeps failing!
The size of the table - difficult to say, but the sql dump gets to 27gb when the mysqldump dies. It could be approximately 4 times that in total.
Aug
9
comment Backup / Export data from MySQL 5.5 attachments table keeps failing!
mysqldump --single-transaction --quick mydatabase attachments --password=abc123 -u root > d:\attachments.sql To be honest, I am not sure of the error as I have been running in a batch file most recently, but all errors no matter how I try to get the data out seem to be "lost connection to mysql server" or "out of memory". It seems to hit the same point and stop every time - as though it is a bad/huge record? I will run the above again from the command line and get the precise error.
Aug
9
awarded  Editor
Aug
9
revised Backup / Export data from MySQL 5.5 attachments table keeps failing!
added 109 characters in body
Aug
9
asked Backup / Export data from MySQL 5.5 attachments table keeps failing!
Oct
29
comment Mix of Cyclic and Chained MySQL replication - What do you do with “log-slave-updates”..?
Thanks, I would never have clients writing to two different masters. The second "master" is really a slave and would not have any direct client access - unless I need to take the primary master down for maintenance. I think actually, I would set the the secondary master up with log-slave-updates and make the slave slave from that, as then I would not need to wait for the slave to catch up again when I bring the primary master back on line - if you see what I mean? Thanks for the tips!
Oct
29
asked Mix of Cyclic and Chained MySQL replication - What do you do with “log-slave-updates”..?
Oct
29
awarded  Scholar
Oct
29
comment Setting up MySQL circular replication in existing replication topology?
Worked a charm thanks!
Oct
29
accepted Setting up MySQL circular replication in existing replication topology?