Bug #55494 mysqldump can't dump db size more than 4 GB
Submitted: 23 Jul 2010 2:10 Modified: 23 Aug 2010 4:13
Reporter: patcharee sirichavalit Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: General Severity:S2 (Serious)
Version:5.0.22 OS:Linux
Assigned to: CPU Architecture:Any

[23 Jul 2010 2:10] patcharee sirichavalit 
Description:
i run 
mysqldump -u root -p mydatabase > db.sql

but when my dump reach to 4 GB , it 's hang.
So i change max_packet_size from 16 M to 116 M (restart mysql) .
but it's not help .

Then 
i run
mysqldump  -u root -p mydatabase | gzip > outputfile.sql.gz
but when my zip file reach to 900 MB ,it's hang.

Lastly 
i run
mysqldump  -u root -p --skip-lock-tables  mydatabase | gzip > outputfile.sql.gz
but when my zip file reach to 900 MB ,it's hang again.

Is it a bug ?

 

How to repeat:
-
[23 Jul 2010 4:13] Valeriy Kravchuk 
Please, check if --skip-extended-insert option will help:

mysqldump --skip-extended-insert -u root -p mydatabase > db.sql
[23 Aug 2010 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".