Проект «SnakeProject» Михаила Козлова

⇒ FreeBSD and Nix ⇐

CISCO

Voice(Asterisk\Cisco)

Microsoft

Powershell

Python

SQL\T-SQL

1С

Общая

WEB Разработка

ORACLE SQL \ JAVA

Мото

Настройка fsbackup на FreeBSD

Настройка fsbackup на FreeBSD

cd /usr/ports/sysutils/fsbackup
make install clean

cd /usr/local/fsbackup

cp cfg_example backup.conf

cat create_backup.sh | grep config_files
config_files="backup.conf"

cat create_backup.sh | grep mysql
# ./scripts/mysql_backup.sh
backup_mysql=1

cat backup.conf

# Имя бэкапа $cfg_backup_name = `hostname | cut -d '.' -f 1 | tr -d '\n' | tr - _`; # Директория хэшей для бэкапа $cfg_cache_dir = "/data/backup/cache"; $prog_md5sum = "md5sum -b"; $prog_tar = "/usr/bin/tar"; $prog_ssh = "/usr/bin/ssh"; $prog_rm = "/bin/rm"; $prog_gzip = "/usr/bin/gzip"; $prog_pgp = "gpg"; $cfg_checksum = "timesize"; # Backup style: # backup - incremental backup (copy only new and changed files). # full_backup - full backup (copy all files). # sync - file tree synchronization. # hash - hash creation without storing archive (spying for new or changed files). $cfg_backup_style = "backup"; # Количество копий бэкапа $cfg_increment_level = 7; $cfg_save_old_backup = 0; $cfg_root_path = "/"; # Удаленный ftp сервер для бэкапов $cfg_type = "remote_ftp"; $cfg_remote_host = "10.0.2.100"; $cfg_remote_login = "user_backup"; $cfg_remote_path = $cfg_backup_name; $cfg_remote_ftp_mode = 0; $cfg_remote_password = 'pass_backup'; $cfg_local_path = "/data/backup"; $cfg_time_limit = 0; $cfg_size_limit = 0; $cfg_maximum_archive_size = 0; $cfg_verbose = 1; $cfg_stopdir_prune=0; 1; # Каталоги для архивации __DATA__ /data !/data/backup f!sess_* f!\.core$ f!^core$ f!\.o$ f!\.log$ /home /root !*/cache/* !*/logs/* # System configuration /etc /var/db/pkg /var/cron/tabs /usr/local/etc /usr/etc # Installed packages /usr/local/bin /usr/local/include /usr/local/lib /usr/local/libdata /usr/local/libexec /usr/local/sbin /usr/local/share # Programs from source /usr/local/search

Пример бэкапов MySQL (остальные скрипты в каталоге scripts)
cat scripts/mysql_backup.sh

#!/bin/sh # Имя бэкапа backup_name="Mysql-backup" # full - backup full DB's structure and data. # db - backup full DB's structure and data only for 'backup_db_list' databases. # notdb- backup full DB's structure and data for all DB's, except # data of 'backup_db_list' databases. # Тип бэкапа, notdb - исключающий то, что есть в списке backup_db_list backup_method="notdb" backup_db_list="information_schema performance_schema mysql:event mysql:slow_log mysql:help_category mysql:general_log" backup_mysqluser="" backup_mysqlpassword="" backup_path="/data/backup/mysql_backup" backup_progdump_path="/usr/local/bin" extra_mysqldump_flag="--complete-insert" if [ -n "$backup_progdump_path" ]; then backup_progdump_path="$backup_progdump_path/" fi if [ "_$backup_method" = "_full" ]; then echo "Creating full backup of all MySQL databases." ${backup_progdump_path}mysqldump --add-drop-table --all-databases --force --no-data $extra_mysqldump_flag --password=$backup_mysqlpassword --user=$backup_mysqluser > $backup_path/$backup_name-struct-mysql ${backup_progdump_path}mysqldump --all-databases --add-drop-table --force $extra_mysqldump_flag --password=$backup_mysqlpassword --user=$backup_mysqluser |gzip > $backup_path/$backup_name-mysql.gz exit fi #------------------------------------------------------------------------- if [ "_$backup_method" = "_db" ]; then echo "Creating full backup of $backup_db_list MySQL databases." ${backup_progdump_path}mysqldump --add-drop-table --all-databases --force --no-data $extra_mysqldump_flag --password=$backup_mysqlpassword --user=$backup_mysqluser > $backup_path/$backup_name-struct-mysql cat /dev/null > $backup_path/$backup_name-mysql for cur_db in $backup_db_list; do echo "Dumping $cur_db..." cur_db=`echo "$cur_db" | awk -F':' '{if (\$2 != ""){print \$1, \$2}else{print \$1}}'` ${backup_progdump_path}mysqldump --add-drop-table --force $extra_mysqldump_flag --password=$backup_mysqlpassword --user=$backup_mysqluser $cur_db >> $backup_path/$backup_name-mysql done gzip -f $backup_path/$backup_name-mysql exit fi if [ "_$backup_method" = "_notdb" ]; then echo "Creating full backup of all MySQL databases except databases $backup_db_list." ${backup_progdump_path}mysqldump --add-drop-table --all-databases --force --no-data $extra_mysqldump_flag --password=$backup_mysqlpassword --user=$backup_mysqluser > $backup_path/$backup_name-struct-mysql cat /dev/null > $backup_path/$backup_name-mysql for cur_db in `${backup_progdump_path}mysqlshow --password=$backup_mysqlpassword --user=$backup_mysqluser| tr -d ' |'|grep -v -E '^Databases$|^\+\-\-\-'`; do grep_flag=`echo " $backup_db_list"| grep " $cur_db:"` if [ -n "$grep_flag" ]; then for cur_db_table in `${backup_progdump_path}mysqlshow --password=$backup_mysqlpassword --user=$backup_mysqluser $cur_db| tr -d ' |'|grep -v -E '^Tables$|^Database\:|^\+\-\-\-'`; do flag=1 for cur_ignore in $backup_db_list; do if [ "_$cur_ignore" = "_$cur_db:$cur_db_table" ]; then flag=0 fi done if [ $flag -gt 0 ]; then echo "Dumping $cur_db:$cur_db_table..." ${backup_progdump_path}mysqldump --add-drop-table --force $extra_mysqldump_flag --password=$backup_mysqlpassword --user=$backup_mysqluser $cur_db $cur_db_table >> $backup_path/$backup_name-mysql else echo "Skiping $cur_db:$cur_db_table..." fi done else flag=1 for cur_ignore in $backup_db_list; do if [ "_$cur_ignore" = "_$cur_db" ]; then flag=0 fi done if [ $flag -gt 0 ]; then echo "Dumping $cur_db..." ${backup_progdump_path}mysqldump --add-drop-table --force $extra_mysqldump_flag --password=$backup_mysqlpassword --user=$backup_mysqluser $cur_db >> $backup_path/$backup_name-mysql else echo "Skiping $cur_db..." fi fi done gzip -f $backup_path/$backup_name-mysql exit fi echo "Configuration error. Not valid parameters in backup_method or backup_sqltype."

Запуск в ручную
./create_backup.sh

В планировщике
cat /etc/crontab | grep fsba

Комментарии пользователей