Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
What is the exact command to export the DB? – patricks Mar 7 '12 at 10:33
I use mysqldump -u username -p dbname – Vladimir Kadalashvili Mar 7 '12 at 14:12

I've found the solution to this problem myself. The problem was that the table that I wanted to export was corrupted. I've repaired it, and now everything works fine.


share|improve this answer
Can you explain please, how you have repaired the table? – Rahat Ali Mar 12 '15 at 9:50

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.