#!/bin/bash
DIR
=
"/backups/mysql_dump"
mkdir
-
p
$DIR
LOG
=
"/var/log/mysql_dump.log"
touch
$LOG
TIMENAME
=
`date
+
%
d
.
%
m
.
%
Y
-
%
H
.
%
M
`
db
=
`mysql
-
u root
-
h localhost
-
pРУТОВЫЙ
_
ПАРОЛЬ
_
МУСКУЛА
-
Bse
'show databases'
`
for
n in
$db
;
do
TIMEDUMP
=
`date
'+%T %x'
`
echo
"backup has been done at $TIMEDUMP : $TIMENAME on db: $n"
>
>
$LOG
mysqldump
-
u root
-
h localhost
-
pРУТОВЫЙ
_
ПАРОЛЬ
_
МУСКУЛА
$n
|
gzip
-
c
>
"$DIR/mysql-$TIMENAME-$n-db.dump.gz"
done