mysqldump

1. 表结构

#!/bin/bash

PATH=/usr/local/rvm/bin:/opt/mysql/server-5.6/bin:/usr/java/jdk1.7.0_45/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin

name=$1
pass=$2
host=$3
db=$4

now=`date +%Y-%m-%d`
mysqldump -u$name -p$pass -h$host -d --add-drop-table $db > ./"structure_"$now".sql"

2.数据

mysqldump -u$name -p$pass -h$host $db_name $tb_name --where "create_time < '2014-11-25 00:00:00'" > /data/$now_date".sql"

 

3. mysql -h$host -u$user -p$passwd $dbname < $dir/$sqlfile 

 

4. mysql -s -h$host -u$user -p$passwd $dbname -e "$sql"