I need to dump to a text file a large database, which comprises one laaaarge table. I'm ding it like this:

# mysqldump -p --single-transaction --quick --max-allowed-packet=2147483648 --tab=/mnt/export --fields-terminated-by=, --fields-optionally-enclosed-by=\" --fields-escaped-by=\\ geo

and then I got:

mysqldump: Got error: 2013: Lost connection to MySQL server during query when executing 'SELECT INTO OUTFILE'

In the same time I see in the processlist that the file continues to grow, and the select into outfile query continues to run. I tried to set up various timeouts:

mysql> SET GLOBAL net_write_timeout = 31536000;
mysql>  SET GLOBAL net_read_timeout = 31536000;

but it was futile. What is preventing mysqldump from running ?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.