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.