OpenForum RSS: �� Bash

�� Bash (merfi)

Thu, 20 Jan 2011 06:26:17 GMT

>> ...., � � ��
> �� , �� ţ �� . :)
> �� 2-��
> 00 4 2-31 * * root mysqldump ....

�� ! ��

#Create mysql backup
#!/bin/bash
#function create_file_name build name file with month archive
function create_month_archive(){
F_D=""
F_T=""
FILE_DATE=""
F_T=$(echo `find /backup/mysql -name 'pet_*' -type f -cmin +1000 -exec ls {} \;`)
F_D=$(echo `date -r $F_T` | awk '{print substr( $0, 5, 3) substr( $0, 25, 4)}')
echo $F_D
FILE_NAME=pet-$F_D.tar.bz2
/etc/init.d/mysqld stop;
sleep 30;
FILE_DATE=$(echo `date +%d-%Y`)
tar -cjf /backup/mysql/pet_${FILE_DATE}.tar.bz2 /var/lib/mysql/test/*;
find /backup/mysql -name 'pet_*' -type f -cmin +1000 -exec ls -la {} \;
echo "DELETE OLD"
find /backup/mysql -name 'pet_*' -type f -cmin +1000 -exec rm -rf {} \;
echo "RENAME

�� Bash (pavlinux)

Wed, 19 Jan 2011 11:05:42 GMT

> ...., � � ��

�� , �� ţ �� . :)

�� 2-��

00 4 2-31 * * root mysqldump ....

�� Bash (merfi)

Wed, 19 Jan 2011 06:27:25 GMT

>> �� tem_31-��-2011.tar.bz2 �� tem_��-2011.tar.bz2
> ��
> # �� 04:00
> 00 4 * * * root mysqldump -uroot -pgod --all-databases | bzip2
> -z9 > /backup/mysql/tem_`date +%d-%b-%Y`.bz2
> # �� 1-�� 03:00 (GMT = 00:00 �� ޣ)
> 00 3 1 * * root mysqldump -uroot -pgod --all-databases | bzip2
> -z9 > /backup/mysql/tem_`date +%b-%Y`.bz2

��
�� 1 �� backup
��
� � ��

�� Bash (merfi)

Wed, 19 Jan 2011 06:26:31 GMT

>> md=`date +%b-%Y`
>> mv `find /backup/mysql -name 'tem_*' -type f -cmin + 1000` /backup/mysql/tem-$md
> find �� , �� ? ��
> ��.
> "-cmin + 1000" - �� (� ��, ��
> ��, � ��-�� ?). �� "-cmin +1000",
> �� : "��, �� 1000 ��
> ��" - ��

��
��
��
md=`date -r ` | awk '{print substr($0, 4, 4)}'
��
� ��
mv `find /backup/mysql -name 'tem_*' -type f -cmin + 1000` /backup/mysql/tem-${md}
��
��

�� Bash (pavlinux)

Tue, 18 Jan 2011 22:39:24 GMT

> �� tem_31-��-2011.tar.bz2 �� tem_��-2011.tar.bz2

��

# �� 04:00
00 4 * * * root mysqldump -uroot -pgod --all-databases | bzip2 -z9 > /backup/mysql/tem_`date +%d-%b-%Y`.bz2

# �� 1-�� 03:00 (GMT = 00:00 �� ޣ)
00 3 1 * * root mysqldump -uroot -pgod --all-databases | bzip2 -z9 > /backup/mysql/tem_`date +%b-%Y`.bz2

�� Bash (XAnder)

Tue, 18 Jan 2011 13:59:05 GMT

> md=`date +%b-%Y`
> mv `find /backup/mysql -name 'tem_*' -type f -cmin + 1000` /backup/mysql/tem-$md

find �� , �� ? �� .

"-cmin + 1000" - �� (� ��, �� , � ��-�� ?). �� "-cmin +1000", �� : "��, �� 1000 �� " - �� .

OpenForum RSS: �������� Bash

�������� Bash (merfi)

�������� Bash (pavlinux)

�������� Bash (merfi)

�������� Bash (merfi)

�������� Bash (pavlinux)

�������� Bash (XAnder)

OpenForum RSS: �� Bash

�� Bash (merfi)

�� Bash (pavlinux)

�� Bash (merfi)

�� Bash (merfi)

�� Bash (pavlinux)

�� Bash (XAnder)