Java操作mysql备份.docVIP

Java操作mysql备份 通过网上代码改的 2009-10-21 15:27:37 mysql备份?it 运行时首先 设mysql环境变量 MySQL_HOME c:/mysql 在classpath里面添加 c:/mysql/bin 然后重起才可以的不然报错 error 2哈哈，我可能深受其害 db.properties文件内容直接入在SRC直接目录下 username rootpassword 1address localhost#full backup namedatabaseName sepm#myIncrepath backup namemyIncreName db_full_back.sql#full backup pathmysqlpath E:/mysql/#incremental backup pathmyIncrepath E:/dbbackup/#tabletb_backupdata tb_backupdata 类 package com.sinrow.epm.basic.backupdatabase.operation; import java.io.File;import java.io.IOException;import java.io.InputStream;import java.util.Properties; public class BackmysqlUtil 爌ublic static void backup String sqlname, String readlyPath 牋爐hrows IOException 牋Properties pros getPprVue db.properties ; 牋String username pros.getProperty username ; 牋String password pros.getProperty password ; 牋// 得到MYSQL的用户名密码后调用 mysql 的 cmd: ??String databaseName pros.getProperty databaseName ;??String address pros.getProperty address ; ??File backupath new File readlyPath ;??if !backupath.exists backupath.mkdir ; StringBuffer sb new StringBuffer ; 牋sb.append mysqldump ;牋sb.append --opt ;牋sb.append -h ;牋sb.append address ;牋sb.append ;牋sb.append --user ;牋sb.append username ;牋sb.append ;牋sb.append --password ;牋sb.append password ;牋sb.append ;牋sb.append --lock-all-tables true ;牋sb.append --result-file ;牋sb.append readlyPath ;牋sb.append sqlname ;牋sb.append ;牋sb.append --default-character-set utf8 ;牋sb.append databaseName ;牋Runtime cmd Runtime.getRuntime ; 牋System.out.println sb.toString ; ??Process p cmd.exec sb.toString ; ??pros.setProperty ss, ss ; public static void load String filename, String readlyPath throws IOException Properties pros getPprVue db.properties ; ??// 这里是读取的属性文件，也可以直接使用 ??String root pros.getProperty username ; ??String pass pros.getProperty password ; String databaseName pros.getProperty databaseName ; String address pros