wood burning stoves 2.0*
The moose likes JDBC and the fly likes Mysqldump - Insert statement is missed - /*!40000 ALTER TABLE `tb1` DISABLE KEYS */; Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Mysqldump - Insert statement is missed - /*!40000 ALTER TABLE `tb1` DISABLE KEYS */;" Watch "Mysqldump - Insert statement is missed - /*!40000 ALTER TABLE `tb1` DISABLE KEYS */;" New topic
Author

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

zhetha lakshmi
Greenhorn

Joined: Apr 30, 2004
Posts: 3
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

Joined: Sep 01, 2005
Posts: 182
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.
 
 
subject: Mysqldump - Insert statement is missed - /*!40000 ALTER TABLE `tb1` DISABLE KEYS */;
 
Similar Threads
FileIO
connection problem in jdbc
Code owrks in Netbeans but the Jar fails to execute the code outside netbeans
Dumping MySql database
Copying MS Access Database