Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Mysqldump - Insert statement is missed - /*!40000 ALTER TABLE `tb1` DISABLE KEYS */;

 
zhetha lakshmi
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I used the below code for mysqldump through java.




It taken the backup for specfied zzzzz.sql perfectly, when the database have lessthan 10 kb size.
i taken the 2453kb size , it dump the .sql file, one table have more than 150000 row. but it shown only 1 insert statement with below statement


LOCK TABLES `tb1` WRITE;
/*!40000 ALTER TABLE `tb1` DISABLE KEYS */;

How can i import or extract in future.
Kindly do the needful.

Thanks & Regards,
Seetha.


 
Fatih Keles
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Why do you interfere mysqldump file with java? -r option will direct the output to file. Remove readers and writers and just execute the process, I suppose you will see the correct content in the "/Backup/zzzzz.sql" file. msyqldump will handle it. For more options see MySQL 5.1 Reference : mysqldump

Regards,
Fatih.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic