All databases to one file:
| The code is as follows |
Copy Code |
#!/bin/bash
date=$ (date + '%y%m%d ')
to_dir= "/home/wyl/document/Daily/230_database"
Date_dir=${to_dir} "/" ${date}
Hostname= ' 192.168.1.230 '
Username= ' Root '
Password= ' Tianji '
if [!-d "$DATE _dir"]; Then
mkdir $DATE _dir
Fi
Mysqldump--no-data-h$hostname-u$username-p$password--all-databases > $DATE _dir/all_database.sql |
A single database to a single file:
| code is as follows |
copy code |
| #!/bin/bash
date=$ (DATE + '%y%m%d ')
to_dir="/home/ wyl/Document/Daily/230_database "
Date_dir=${to_dir}"/"${date}
hostname= ' 192.168.1.230 '
Username= ' root '
password= ' Tianji '
If [!-d "$DATE _dir"]; then
    &NB sp; mkdir $DATE _dir
Fi
mysql-h$hostname-u$username-p$password-e "show databases like '%9e% '" |sed ' 1d ' |while read line
do
mysqldump--no-data-h$hostname-u$username- P$password $LINE > $DATE _dir/$LINE. SQL
Done |
