/* начало скрипта sql-backup.sh */ #!/bin/sh FN=`/bin/date +%Y-%m-%d` BK_DIR='/home/user_name/backup_dir/' PARAM='--quote-names --add-drop-table -udb_login -pdb_pass' cd ${BK_DIR} /opt/mysql/bin/mysqldump ${PARAM} vadim_db1 > vadim_db1.sql /opt/mysql/bin/mysqldump ${PARAM} vadim_db2 > vadim_db2.sql tar -cvf ${BK_DIR}/sql-${FN}.tar *.sql gzip ${BK_DIR}/sql-${FN}.tar chmod 600 ${BK_DIR}sql-${FN}.tar.gz rm *.sql /* конец скрипта */отсюда
Comments are closed.