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

[zhetha lakshmi]

Hi,

I used the below code for mysqldump through java.

	String path = "/Backup/zzzzz.sql";		
	String dumpCommand = "mysqldump -uxxx -pyyyy zzzzz -r "+ path;
        File tst = new File(path);
		FileWriter fw = null;
		try {
			fw = new FileWriter(tst);
			fw.close();
		} catch (IOException ex) {
			ex.printStackTrace();
		}
		Runtime rt = Runtime.getRuntime();
		try {
			Process proc = rt.exec(dumpCommand);
			InputStream in = proc.getInputStream();
			InputStreamReader read = new InputStreamReader(in, "latin1");
			BufferedReader br = new BufferedReader(read);
			BufferedWriter bw = new BufferedWriter(new FileWriter(tst, true));
			String line = null;
			StringBuffer buffer = new StringBuffer();
			while ((line = br.readLine()) != null) {
				buffer.append(line + "\n");
			}
			String toWrite = buffer.toString();
			bw.write(toWrite);
			bw.close();
			br.close();
			status = path;

		} catch (IOException e) {
			logger.error(e);
		}

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]

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.