Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
1  
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
add comment

1 Answer

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.

Thanks

share|improve this answer
add comment

Your Answer

 
discard

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.