Linux MySQL data as indicated backup backup

1. Backup by Table name

#!/bin/bash

#user

#数据库用户

Dbuser= "Root"

#数据库密码

Dbpassword= "Chenyong"

#时间

date=$ (Date +%y%m%d)

#数据库名称

Dbname=sungrowv3

#备份数据保存的路劲

url=/home/test/sql/

#指定数据库的所以表

tables=$ (mysql-u$dbuser-p$dbpassword-ss-e "use $dbname; show tables;")

if [!-D $url];then

Mkdir-p $url

Fi

CD $url

For T in $tables

Do

Mysqldump-u$dbuser-p$dbpassword $dbname $t > $t. sql

Done

Mysqldump-u$dbuser-p$dbpassword $dbname > $dbname. sql

Zip-m/home/test/$dbname ' _ ' $date. zip./*

Cd.. /

RM-RF SQL

This article is from the "Carefree seeking defeat" blog, please make sure to keep this source http://6355601.blog.51cto.com/6345601/1659273

Linux MySQL data as indicated backup backup