Skip to main content
Server Fault

Return to Question

formatted block of text
Source Link
edit approved Mar 7, 2012 at 7:18
gideon
edit approved Mar 7, 2012 at 7:18
gideon
  • 1.1k
  • 2
  • 15
  • 28

I'm using mysqldumpmysqldump to move the database to another server. 

Everything works fine, except that mysqldumpmysqldump doesn't export all records from one table. The table contains about 500 records, and mysqldump exports only about 100 records. 

I've noticed this problem after I exported an entire database, and then I tried to dump only this table, the same result. I've tried to increase the value of max_allowed_packetsmax_allowed_packets setting to 256M256M. I've also tried to disable extended inserts. This table contains TEXT fields if that helps (however, other tables with TEXT fields are exported successfully). 

Also, mysqldump doesn't produce any errors, just skips some rows silently. Thanks.

I'm using mysqldump to move the database to another server. Everything works fine, except that mysqldump doesn't export all records from one table. The table contains about 500 records, and mysqldump exports only about 100 records. I've noticed this problem after I exported an entire database, and then I tried to dump only this table, the same result. I've tried to increase the value of max_allowed_packets setting to 256M. I've also tried to disable extended inserts. This table contains TEXT fields if that helps (however, other tables with TEXT fields are exported successfully). Also, mysqldump doesn't produce any errors, just skips some rows silently. Thanks.

I'm using mysqldump to move the database to another server. 

Everything works fine, except that mysqldump doesn't export all records from one table. The table contains about 500 records, and mysqldump exports only about 100 records. 

I've noticed this problem after I exported an entire database, and then I tried to dump only this table, the same result. I've tried to increase the value of max_allowed_packets setting to 256M. I've also tried to disable extended inserts. This table contains TEXT fields if that helps (however, other tables with TEXT fields are exported successfully). 

Also, mysqldump doesn't produce any errors, just skips some rows silently.

Provided details about errors produced by mysqldump
Source Link
Vladimir Kadalashvili
Vladimir Kadalashvili
  • 171
  • 1
  • 6

I'm using mysqldump to move the database to another server. Everything works fine, except that mysqldump doesn't export all records from one table. The table contains about 500 records, and mysqldump exports only about 100 records. I've noticed this problem after I exported an entire database, and then I tried to dump only this table, the same result. I've tried to increase the value of max_allowed_packets setting to 256M. I've also tried to disable extended inserts. This table contains TEXT fields if that helps (however, other tables with TEXT fields are exported successfully). Also, mysqldump doesn't produce any errors, just skips some rows silently. Thanks.

I'm using mysqldump to move the database to another server. Everything works fine, except that mysqldump doesn't export all records from one table. The table contains about 500 records, and mysqldump exports only about 100 records. I've noticed this problem after I exported an entire database, and then I tried to dump only this table, the same result. I've tried to increase the value of max_allowed_packets setting to 256M. I've also tried to disable extended inserts. This table contains TEXT fields if that helps (however, other tables with TEXT fields are exported successfully). Thanks.

I'm using mysqldump to move the database to another server. Everything works fine, except that mysqldump doesn't export all records from one table. The table contains about 500 records, and mysqldump exports only about 100 records. I've noticed this problem after I exported an entire database, and then I tried to dump only this table, the same result. I've tried to increase the value of max_allowed_packets setting to 256M. I've also tried to disable extended inserts. This table contains TEXT fields if that helps (however, other tables with TEXT fields are exported successfully). Also, mysqldump doesn't produce any errors, just skips some rows silently. Thanks.

Source Link
Vladimir Kadalashvili
Vladimir Kadalashvili
  • 171
  • 1
  • 6

mysqldump doesn't export all records from table

I'm using mysqldump to move the database to another server. Everything works fine, except that mysqldump doesn't export all records from one table. The table contains about 500 records, and mysqldump exports only about 100 records. I've noticed this problem after I exported an entire database, and then I tried to dump only this table, the same result. I've tried to increase the value of max_allowed_packets setting to 256M. I've also tried to disable extended inserts. This table contains TEXT fields if that helps (however, other tables with TEXT fields are exported successfully). Thanks.