java备份mysql数据库

	public boolean backup() {//备份

		try {
			Runtime rt = Runtime.getRuntime();

			String mysql = "mysqldump -uroot -p123456 db";

			// 调用 mysql 的 cmd:
			Process child = rt
			.exec("cmd /c "+mysql);// 设置导出编码为utf8。这里必须是utf8

			// 把进程执行中的控制台输出信息写入.sql文件，即生成了备份文件。注：如果不对控制台信息进行读出，则会导致进程堵塞无法运行
			InputStream in = child.getInputStream();// 控制台的输出信息作为输入流

			InputStreamReader xx = new InputStreamReader(in, "utf8");// 设置输出流编码为utf8。这里必须是utf8，否则从流中读入的是乱码

			String inStr;
			StringBuffer sb = new StringBuffer("");
			String outStr;
			// 组合控制台输出信息字符串
			BufferedReader br = new BufferedReader(xx);
			while ((inStr = br.readLine()) != null) {
				sb.append(inStr + "\r\n");
			}
			outStr = sb.toString();

			// 要用来做导入用的sql目标文件：
			FileOutputStream fout = new FileOutputStream(
					"c:/db.sql");
			OutputStreamWriter writer = new OutputStreamWriter(fout, "utf8");
			writer.write(outStr);
			// 注：这里如果用缓冲方式写入文件的话，会导致中文乱码，用flush()方法则可以避免
			writer.flush();

			// 别忘记关闭输入输出流
			in.close();
			xx.close();
			br.close();
			writer.close();
			fout.close();

			System.out.println("/* Output OK! */");
						
			String error="备份成功!";
			
			StrError = (new String(error.getBytes("ISO-8859-1"),"UTF-8"));  

		} catch (Exception e) {
			e.printStackTrace();
			StrError=StrError+"failure!<br>";
		}

		return true;
	}

	public boolean load() {//还原

		try {

			String fPath = "c:/db.sql";
			Runtime rt = Runtime.getRuntime();

			// 调用 mysql 的 cmd:
			Process child = rt.exec("mysql -uroot -p123456 db ");
			OutputStream out = child.getOutputStream();//控制台的输入信息作为输出流
			String inStr;
			StringBuffer sb = new StringBuffer("");
			String outStr;
			BufferedReader br = new BufferedReader(new InputStreamReader(
					new FileInputStream(fPath), "utf8"));
			while ((inStr = br.readLine()) != null) {
				sb.append(inStr + "\r\n");
			}
			outStr = sb.toString();

			OutputStreamWriter writer = new OutputStreamWriter(out, "utf8");
			writer.write(outStr);
			// 注：这里如果用缓冲方式写入文件的话，会导致中文乱码，用flush()方法则可以避免
			writer.flush();
			// 别忘记关闭输入输出流
			out.close();
			br.close();
			writer.close();
			

			System.out.println("/* Load OK! */");
			StrError=StrError+"备份成功!<br>".getBytes("gb2312");
		} catch (Exception e) {
			e.printStackTrace();
			StrError=StrError+"failure!<br>";
		}
		return true;
	} 

 

评论

3 楼 zhangjf108 2009-10-27  

文件里没东西~~~

2 楼 xp84012493 2008-08-29  

本地的机器~~

1 楼 liusp_eye 2008-08-20  

你这个数据库是在本地机器还是服务器上