java 实现 mysql 数据库导出与导入(适合linux和windows)
来源:互联网 发布:香港理工大学知乎 编辑:程序博客网 时间:2024/05/22 10:13
</pre>备份<p></p><p></p><pre name="code" class="html">import java.io.BufferedReader;import java.io.FileOutputStream;import java.io.InputStream;import java.io.InputStreamReader;import java.io.OutputStreamWriter;public class DataBackup {public static void main(String[] args) {backup();}public static void backup() {try {Runtime rt = Runtime.getRuntime();Process child = rt.exec("D:/MySQL/MySQL Server 5.6/bin/mysqldump -uroot -p123456 -R -c --set-charset=utf8 senyuan");InputStream in = child.getInputStream();InputStreamReader xx = new InputStreamReader(in, "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();FileOutputStream fout = new FileOutputStream("E:/sql/qq.sql");OutputStreamWriter writer = new OutputStreamWriter(fout, "utf8");writer.write(outStr);writer.flush();in.close();xx.close();br.close();writer.close();fout.close();} catch (Exception e) {e.printStackTrace();}}}
public static void load() {try {String fPath = "备份的文件路径名";Runtime rt = Runtime.getRuntime();Process child = rt.exec("mysql -u用户名 -p密码 数据库名");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);writer.flush();out.close();br.close();writer.close();} catch (Exception e) {e.printStackTrace();}}
0 0
- java 实现 mysql 数据库导出与导入(适合linux和windows)
- 使用Java实现对MySql数据库的导入与导出
- linux mysql 数据库导入导出
- Linux导入导出mysql数据库
- linux,导入导出mysql数据库
- mysql数据库导出与导入
- mysql 数据库导出与导入
- MYSQL 导入与导出数据库
- Java Mysql 数据库导出导入
- MySQL数据库导出和导入
- mysql导入和导出数据库
- mysql导入和导出数据库
- mysql数据库导入和导出
- 【mysql】数据库导出和导入
- 详解Windows和Linux下从数据库导出表结构,以及Linux下如何导入.sql文件到MySQL数据库
- 【Mysql】MySQL导出数据库与导入数据库
- 通过导出和导入修改MySQL数据库编码(linux与win平台转换)
- Linux下txt文件与mysql数据库导入导出
- python脚本退出后 不应该为负值
- mac中配置hadoop常见问题
- ImageLoader 介绍
- 深入浅出JMS(一)--JMS基本概念
- Android UI基础布局
- java 实现 mysql 数据库导出与导入(适合linux和windows)
- Android Gradle实用技巧——多渠道打包
- 媒体查询-手机尺寸参考
- 解决MySQL ERROR 1130 (HY000): Host 'XXXX' is not allowed to connect to this MySQL server
- vagrant 环境配置以及常用命令
- bzoj 2456: mode(找众数)
- 112. Path Sum
- redis的选择和定位
- 数组中的逆序对