mysqldump 使用／跨主机备份

从服务器备份指定数据库到本地脚本

#!/bin/bash#服务器SERVER_HOST="111.111.111.111"SERVER_PORT="3306"SERVER_USER="root"SERVER_PASSWORD="123456"SERVER_DB="user_db"#本地LOCAL_HOST="localhost"LOCAL_PORT="3306"LOCAL_USER="root"LOCAL_PASSWORD="654321"#在本地创建对应数据库create_db_sql="create database IF NOT EXISTS ${SERVER_DB}"mysql -h${LOCAL_HOST}  -P${LOCAL_PORT}  -u${LOCAL_USER} -p${LOCAL_PASSWORD} -e "${create_db_sql}"#从远程数据库备份到本地数据库mysqldump --host=${SERVER_HOST} -u${SERVER_USER} -p${SERVER_PASSWORD} --opt ${SERVER_DB} | mysql --host=${LOCAL_HOST} -u${LOCAL_USER} -p${LOCAL_PASSWORD} -C ${SERVER_DB}