java mysql mysqldump_Java对备份还原数据库（MysqlDump实现）

首先介绍MysqlDump命令

--多库备份命令

mysqldump -uroot -proot -h127.0.0.1 --default-character-set=utf8 --databases test1 test -r C:\xxx.sql

--多库还原命令

mysql -e "source c:\XXX.sql" -u root -proot -h127.0.0.1 -P3306 -f --default-character-set=utf-8

一.Java使用MysqlDump备份

public synchronized boolean exportSql(DBConfigInDTO dbConfigInDTO) {

Process process = null;

InputStream inStream = null;

OutputStreamWriter writer = null;

try {

Runtime runtime = Runtime.getRuntime();

//TODO 第一步,获取相关参数

DBConfigInDTO dbConfigIn = getCommand(dbConfigInDTO);

dbConfigIn.setDbPath(dbConfigIn.getDbPath() + sdtFileType);

StringBuffer sbuff = new StringBuffer();

sbuff.append(mysqlDumpInPath + "mysqldump");

sbuff.append(" -u").append(dbConfigIn.getUsername());

sbuff.append(" -p").append(dbConfigIn.getPassword()); //密码是用的小p

sbuff.append(" -h").append(dbConfigIn.getHost());

sbuff.append(" -P").append(dbConfigIn.getPort()); //而端口是用的大P

sbuff.append(" --default-character-set=").append(dbConfigInDTO.getCharacterSet());

sbuff.append(" --databases");