java备份mysql数据库

最新推荐文章于 2024-07-06 02:18:24 发布

zjx2388

最新推荐文章于 2024-07-06 02:18:24 发布

阅读量109

点赞数

分类专栏： database 文章标签： MySQL Java SQL JDK C

本文链接：https://blog.csdn.net/zjx2388/article/details/83945037

版权

database 专栏收录该内容

81 篇文章 0 订阅

订阅专栏

package com.zjx.dbbackup;

/**
 * JAVA 对MYSQL数据库的备份
 *       mysql 5.0
 *       JDK 1.6
 * @author Zhou Jingxian
 *
 */
public class DB_deal {

	public static void main(String[] args) {
		DB_deal.backup();
//		DB_deal.load();
	}
	
	private static String mysqlcmd = null;
	
	/**
	 * 备份数据库
	 */
	public static void backup(){
		//使用mysqldump来备份数据库,格式:"mysqldump -u username -ppassword --opt database_name > direction/backup_name.sql"
		//Example:mysqldump -u root -prootroot --opt maritime > D:/backup_maritime.sql
		mysqlcmd = "mysqldump -u root -prootroot --opt maritime > D:/backup_maritime_0.sql";
		
		try {
			Runtime runtime = Runtime.getRuntime(); 
			
			//调用 mysql的cmd:			
			runtime.exec("cmd /c" + mysqlcmd);
			
			System.out.println("....success....");
		} catch (Exception e) {
			e.printStackTrace();
			System.out.println("....error..."+e.getMessage());
			
		}
	}
	
	/**
	 * 还原数据库
	 */
	public static void load(){
		//使用mysqldump来备份数据库,格式:"mysql -u username -ppassword  database_name < direction/backup_name.sql"
		mysqlcmd = "mysql -u root -prootroot  maritime < D:/backup_maritime_0.sql";
		
		try {
			Runtime runtime = Runtime.getRuntime(); 
			
			//调用 mysql的cmd:			
			runtime.exec("cmd /c" + mysqlcmd);
			
			System.out.println("....success....");
		} catch (Exception e) {
			e.printStackTrace();
			System.out.println("....error..."+e.getMessage());
			
		}
	}
	
}