@echo off
echo.
echo MySQL数据库备份
echo *****************************
echo.
echo 今天是 %date%
echo 时间是 %time%
echo.
echo *****************************
set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"
md "D:\JDBC\%Ymd%"
"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqldump" --opt -Q -h127.0.0.1 -
u用户名 -p密码 --default-character-set=latin1 要备份的数据库> "D:\JDBC\%Ymd%
\test_bak.sql"
echo.
echo MySQL数据库备份完成，请进行检查。。。
echo.
echo.
pause
---------------------------------------将下面写到一个方法中，然后定时执行这个方法-----------------------------------------------------------
Process p = Runtime.getRuntime().exec("cmd /c D:\\JDBC\\12.bat");
InputStream fis = p.getInputStream();
final BufferedReader br2 = new BufferedReader(new InputStreamReader(p.getErrorStream()));
InputStreamReader isr = new InputStreamReader(fis);
final BufferedReader br = new BufferedReader(isr);
Thread t1 = new Thread(){
public void run(){
String line = null;
try {
while ((line = br2.readLine()) != null) {
System.out.println(line);
}
} catch (IOException e) {
e.printStackTrace();
}
}
};
Thread t2 = new Thread(){
public void run(){
String line = null;
try {
while ((line = br.readLine()) != null) {
System.out.println(line);
}
} catch (IOException e) {
e.printStackTrace();
}
}
};
t1.start();
t2.start();
}
最新评论