Главная   Изменения   Спек   Патчи   Исходники   Загрузить   Gear   Bugs and FR  Repocop 

#!/bin/sh

#-------------------
# Name of backup, single word.
# п≤п╪я▐ п╠я█п╨п╟п©п╟.
#-------------------

backup_name="test_host"


#-------------------
# Backup method:
# 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.
#
# п°п╣я┌п╬п╢ п╠я█п╨п╟п©п╟:
# full	- п©п╬п╩п╫я▀п╧ п╠я█п╨п╟п© п╡я│п╣я┘ п╠п╟п╥ (я─п╣п╨п╬п╪п╣п╫п╢я┐п╣я┌я│я▐), 
#	 п╟п╫п╟п╩п╬пЁ п╥п╟п©я┐я│п╨п╟ pg_dumpall п╦п╩п╦ mysqldump --all-databases --all
#
# db    - п╠я█п╨п╟п© я┌п╬п╩я▄п╨п╬ я┐п╨п╟п╥п╟п╫п╫я▀я┘ п╡ backup_db_list п╠п╟п╥ п╢п╟п╫п╫я▀я┘, п╥п╟п©п╦я│п╦ п©п╬ 
#	  я─п╣п╨п╬п╫я│я┌я─я┐п╨я├п╦п╦ п╠п╟п╥ п╦ я┌п╟п╠п╩п╦я├ п╥п╟п©п╦я│я▀п╡п╟я▌я┌я│я▐ п╢п╩я▐ п╡я│п╣я┘ п╠п╟п╥ п╫п╟ SQL я│п╣я─п╡п╣я─п╣.
# notdb  - п╠я█п╨п╟п© п╡я│п╣я┘ п╠п╟п╥, п╨я─п╬п╪п╣ я┐п╨п╟п╥п╟п╫п╫я▀я┘ п╡ backup_db_list, п╥п╟п©п╦я│п╦ п©п╬ 
#	   я─п╣п╨п╬п╫я│я┌я─я┐п╨я├п╦п╦ п╠п╟п╥ п╦ я┌п╟п╠п╩п╦я├ п╥п╟п©п╦я│я▀п╡п╟я▌я┌я│я▐ п╢п╩я▐ п╡я│п╣я┘ п╠п╟п╥ п╫п╟ SQL я│п╣я─п╡п╣я─п╣.
#          п▓п╬п╥п╪п╬п╤п╫п╬ п╦я│п╨п╩я▌я┤п╣п╫п╦п╣ п╦п╥ п╠я█п╨п╟п©п╟  п╡я▀п╠п╬я─п╬я┤п╫я▀я┘ я┌п╟п╠п╩п╦я├, я┌п╬пЁп╢п╟ я└п╬я─п╪п╟я┌ 
#	   я│п©п╦я│п╨п╟ п╦я│п╨п╩я▌я┤п╟п╣п╪я▀я┘ я┌п╟п╠п╩п╦я├ п╥п╟п╢п╟п╣я┌я│я▐ п╡ п╡п╦п╢п╣: 
#	   "trash_db1 trash_db2:table1 trash_db2:table2"
#          - п©я─п╬п╦п╥п╡п╬п╢п╦п╪ п╠я█п╨п╟п© п╡я│п╣я┘ п╠п╟п╥, п╨п╬п╪п╣ п╠п╟п╥я▀ trash_db1 п╦ я┌п╟п╠п╩п╦я├ table1 п╦ 
#	   table2 п╠п╟п╥я▀ trash_db2.
#
#-------------------

backup_method="notdb"


#-------------------
# List of databases (delimited by spaces)
# п║п©п╦я│п╬п╨ п╡п╨п╩я▌я┤п╟п╣п╪я▀я┘ п╦п╩п╦ п╦я│п╨п╩я▌я┤п╟п╣п╪я▀я┘ п╦п╥ п╠я█п╨п╟п©п╟ п╠п╟п╥, я┤п╣я─п╣п╥ п©я─п╬п╠п╣п╩.
# п╒п╟п╠п╩п╦я├я▀ я┐п╨п╟п╥я▀п╡п╟я▌я┌я│я▐ п╡ п╡п╦п╢п╣: п╦п╪я▐_п╠п╟п╥я▀:п╦п╪я▐_я┌п╟п╠п╩п╦я├я▀
#-------------------

backup_db_list="aspseek trash:cache_table1 trash:cache_table2 mnogosearch"


#-------------------
# Auth information for MySQL.
# п≤п╪я▐ п©п╬п╩я▄п╥п╬п╡п╟я┌п╣п╩я▐ п╦ п©п╟я─п╬п╩я▄ п╢п╩я▐ я│п╬п╣п╢п╦п╫п╣п╫п╦я▐ я│ Mysql, п╢п╩я▐ PostgreSQL я│п╨я─п╦п©я┌ 
# п╢п╬п╩п╤п╣п╫ п╥п╟п©я┐я│п╨п╟я┌я▄я│я▐ п╦п╥-п©п╬п╢ п©п╬п╩я▄п╥п╬п╡п╟я┌п╣п╩я▐ я│ п©я─п╟п╡п╟п╪п╦ п©п╬п╩п╫п╬пЁп╬ п╢п╬я│я┌я┐п©п╟ п╨ п╠п╟п╥п╟п╪ PostgreSQL.
#-------------------

backup_mysqluser=""
backup_mysqlpassword=""


#-------------------
# Directory to store SQL backup. You must have enought free disk space to store 
# all data from you SQL server.
# п■п╦я─п╣п╨я┌п╬я─п╦я▐ п╨я┐п╢п╟ п╠я┐п╢п╣я┌ п©п╬п╪п╣я┴п╣п╫ п╠я█п╨п╟п© п╢п╟п╫п╫я▀я┘ я│ SQL я│п╣я─п╡п╣я─п╟. 
# п▓п╫п╦п╪п╟п╫п╦п╣ !!! п■п╬п╩п╤п╫п╬ п╠я▀я┌я▄ п╢п╬я│я┌п╟я┌п╬я┤п╫п╬ я│п╡п╬п╠п╬п╢п╫п╬пЁп╬ п╪п╣я│я┌п╟ п╢п╩я▐ п╠я█п╨п╟п©п╟ п╡я│п╣я┘ 
# п╡я▀п╠я─п╟п╫п╫я▀я┘ п▒п■.
#-------------------

backup_path="/var/lib/fsbackup/sys_backup"


#-------------------
# Full path of mysql programs.
# п÷я┐я┌я▄ п╨ п©я─п╬пЁя─п╟п╪п╪п╟п╪ mysql
#-------------------

backup_progdump_path="/usr/bin"

#-------------------
# Extra flags for mysqldump program. 
# -c (--complete-insert) - Use complete insert statements.
# п■п╬п©п╬п╩п╫п╦я┌п╣п╩я▄п╫я▀п╣ п©п╟я─п╟п╪п╣я┌я─я▀ п╢п╩я▐ pg_dump
# -c - я└п╬я─п╪п╦я─п╬п╡п╟я┌я▄ п╠я█п╨п╟п© п╢п╟п╫п╫я▀я┘ п╡ п╡п╦п╢п╣ INSERT п╨п╬п╪п╪п╟п╫п╢, я│ я┐п╨п╟п╥п╟п╫п╦п╣п╪ п╫п╟п╥п╡п╟п╫п╦п╧
#      я│я┌п╬п╩п╠я├п╬п╡. п∙я│п╩п╦ я│п╨п╬я─п╬я│я┌я▄ п╡п╬я│я│я┌п╟п╫п╬п╡п╩п╣п╫п╦я▐ п╦п╥ п╠я█п╨п╟п©п╟ п╦ я─п╟п╥п╪п╣я─ п╠я█п╨п╟п©п╟
#      п╠п╬п╩п╣п╣ п╡п╟п╤п╫я▀, п╦ я│п╬п╡п╪п╣я│я┌п╦п╪п╬я│я┌я▄я▌ я│ п╢я─я┐пЁп╦п╪п╦ п║пёп▒п■ п╪п╬п╤п╫п╬ п©я─п╣п╫п╣п╠я─п╣я┤я▄, 
#      п╦я│п©п╬п╩я▄п╥я┐п╧я┌п╣: extra_mysqldump_flag=""
#-------------------

extra_mysqldump_flag="--complete-insert"