linux mysqldump java

import java.io.IOException;
import java.io.InputStreamReader;
import java.io.LineNumberReader;

/**
 * mysql备份
 * @author gaoyihang
 *
 */
public class MysqlDump {

	/**
	 * linux下执行shell文件~~
	 * @param args
	 * @throws IOException 
	 */
	public static void main(String[] args) throws IOException {
		// TODO Auto-generated method stub
		Process process = null;
		InputStreamReader ir = null; 
		LineNumberReader input = null;
		//需要找到mysql.sh所在的文件路径
		String mysql = Thread.currentThread().getContextClassLoader().getResource("mysql.sh").toString().replaceFirst("file:", "");
		process = Runtime.getRuntime().exec(mysql);
		ir = new InputStreamReader(process.getInputStream());
		input = new LineNumberReader(ir);
		String line = null;
		while ((line = input.readLine ()) != null){
			System.out.println(line);
		}
	}

}


/*


#!/bin/sh
all_db=$(/home/alexgaoyh/soft/mysql-5.5.27-linux2.6-i686/bin/mysql -u root -p880823 -Bse 'show databases')
for db in $all_db
do
echo "$db"
if [ "$db" = "mysql" ] \
	|| [ "$db" = "information_schema" ] \
	|| [ "$db" = "performance_schema" ]; then
    echo "------------->$db not need dump!!" 
else
	/home/alexgaoyh/soft/mysql-5.5.27-linux2.6-i686/bin/mysqldump --default-character-set=utf8 -u root -h localhost -p880823 --skip-lock-tables $db | gzip -9 > /home/alexgaoyh/test/$db.gz
fi
done
exit 0



*/