#!bin/bash
if [! -d "dump_data" ]; then
#rm -rf dump_data
mkdir dump_data
fi
cd dump_data
function dump()
{
table_name=$1
if [ -d "$table_name" ]; then
rm -rf $table_name
fi
mkdir $table_name
cd $table_name
a=`mysql -f -h11.22.xx.xx -uUsername -pPassword -P3306 -e "use $table_name;show tables;"`
for t in $a
do
echo $t
file="$t.sql"
datafile="$t.txt"
`/usr/local/mysql/bin/mysqldump -d -f -h11.22.xx.xx -uhuichuan -phu1Chuan -P3306 $table_name --table $t > $file`
`mysql -f -h11.xx.xx.xx -uUsername -pPassword -P3306 --default-character-set=utf8 -e "use $table_name; select * from $t;" > $datafile`
done
}
dump "table_name"
将数据表定义文件反过来创建对应的数据表:mysql -h127.0.0.1 -uUsername -pPassword Dbname < db_define.sql
查看数据表的定义:show create table tableName ;