最近又把服务器迁移到了国外，面对几个G的数据打包迁移确实不是那么好弄的。遂写下这个脚本来备份一下！！
- 2015年10月7日更新，修复Mysql提示Warning: Using a password on the command line interface can be insecure
- 2015年10月23日更新，模块化
使用方法：
|
1 2 |
curl "https://raw.githubusercontent.com/jalena/vps-backup/master/backup.sh" -O backup.sh && chmod +x backup.sh && ./backup.sh init ./backup.sh backup |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 |
#! /bin/bash #=============================================================================================== # System Required: CentOS6.x (32bit/64bit) # Description: Server backup and restore script # Author: Jalena <jalena@bcsytv.com> # Intro: https://jalena.bcsytv.com/archives/1358 #=============================================================================================== [[ $EUID -ne 0 ]] && echo 'Error: This script must be run as root!' && exit 1 # global variables current_date=`date +%Y%m%d` # Initialize the database of account information function initialization(){ if [[ ! -e '/root/.my.cnf' ]]; then echo -e "\e[34mPlease enter the MySQL user (Default : \e[33mroot):\e[0m" read -p "Please enter：" MYSQL_USER [[ -z "$MYSQL_USER" ]] && MYSQL_USER="root" echo -e "\e[34mPlease enter the MySQL password:\e[0m" read -p "Please enter：" MYSQL_PASS cat > /root/.my.cnf<<EOF [client] user=$MYSQL_USER password=$MYSQL_PASS [mysqldump] user=$MYSQL_USER password=$MYSQL_PASS EOF echo -e "------------------------------------------------------" echo -e "MySQL User = $MYSQL_USER" echo -e "MySQL Pass = $MYSQL_PASS" echo -e "------------------------------------------------------" fi if [[ ! -e '/root/.backup.option' ]]; then echo -e "\e[34mPlease enter backup path:(Default : \e[33m/data/backup\e[0m):" read -p "Please enter：" BACKUP_DIR [[ -z "$BACKUP_DIR" ]] && BACKUP_DIR="/data/backup" echo -e "\e[34mPlease enter the path to the site (Default : \e[33m/data/wwwroot\e[0m):" read -p "Please enter：" WEB_PATH [[ -z "$WEB_PATH" ]] && WEB_PATH="/data/wwwroot" echo -e "\e[34mPlease enter nginx configuration path (Default : \e[33m/usr/local/nginx/conf/vhost\e[0m):" read -p "Please enter：" NGINX_PATH [[ -z "$NGINX_PATH" ]] && NGINX_PATH="/usr/local/nginx/conf/vhost" cat > /root/.backup.option<<EOF BACKUP_DIR="$BACKUP_DIR" WEB_PATH="$WEB_PATH" NGINX_PATH="$NGINX_PATH" EOF echo -e "------------------------------------------------------" echo -e "Backup directory = \e[33m$BACKUP_DIR\e[0m" echo -e "web directory = \e[33m$WEB_PATH\e[0m" echo -e "nginx directory = \e[33m$NGINX_PATH\e[0m" echo -e "------------------------------------------------------" fi } function initialization_check(){ if [[ -s '/root/.backup.option' ]]; then source /root/.backup.option elif [[ -s '/root/.my.cnf' ]]; then source /root/.my.cnf else initialization fi if [[ ! -d $BACKUP_DIR ]]; then mkdir -p ${BACKUP_DIR} fi } # Backup all database tables function backup_database(){ for db in $(mysql -B -N -e 'SHOW DATABASES' |sed -e '/_schema/d' -e '/mysql/d' -e '/sys/d') do mysqldump ${db} | gzip -9 > ${BACKUP_DIR}/${db}.sql.gz echo -e "\t\e[1;32m--- Backup data table \e[1;31m${db} \e[1;32msuccess! ---\e[0m" done # Pack all database tables tar zcPf ${BACKUP_DIR}/sql_${current_date}.tar.gz ${BACKUP_DIR}/*.sql.gz --remove-files } # Packing site data function packing_data(){ for web in $(ls -1 ${WEB_PATH} |sed -e '/phpMy/d') do tar zcPf ${BACKUP_DIR}/${web}_${current_date}.tar.gz ${WEB_PATH}/${web} echo -e "\t\e[1;32m--- package \e[1;31m${web} \e[1;32msuccess! ---\e[0m" done } # package the nginx configuration file function configuration(){ tar cPf ${BACKUP_DIR}/nginx_${current_date}.tar.gz $NGINX_PATH echo -e "\t\e[1;32m--- package \e[1;31mnginx_${current_date}.tar.gz \e[1;32msuccess! ---\e[0m" find / -name nginx.conf |grep -v root | xargs tar rPf ${BACKUP_DIR}/nginx_${current_date}.tar.gz echo -e "\t\e[1;32m--- Additional file successfully ---\e[0m" } # Upload data function upload_file(){ for file in $(ls -1 ${BACKUP_DIR}) do #scp ${file} root@23.239.196.3:/root/backup/${file} #sh /root/dropbox_uploader.sh upload ${file} backup/${file} qshell fput backup ${file} ${BACKUP_DIR}/${file} http://up.qiniug.com done } # Restore all data function restore_all(){ level=`tar -ztPf sql*.tar.gz | grep -o '/' | wc -l` num=level-1 tar zxf sql*.tar.gz --strip-components ${num} for db in $(find ${BACKUP_DIR}/*.sql.gz | sed 's/.sql.gz//g') do # mysqladmin create ${db} # gunzip -f < ${BACKUP_DIR}/${db}.sql.gz | mysql ${db} done for web in $(ls -1 ${BACKUP_DIR}/*.tar.gz| grep -v mysql |grep -v nginx) do tar zxPf ${BACKUP_DIR}/${web} done for nginx in $(ls -1 ${BACKUP_DIR}/nginx*) do tar zxPf ${BACKUP_DIR}/${nginx} done } # Initialization settings function initial_setup(){ initialization } function backup_db(){ initialization_check backup_database } # Full backup function backup_all(){ initialization_check backup_database packing_data configuration upload_file } function upload(){ initialization_check upload_file } # Initialization step action=$1 # [ -z $1 ] && action=backup case "$action" in init) initial_setup ;; backup) backup_all ;; db) backup_db ;; up) upload ;; Restore) restore_all ;; *) echo -e "\n\t\e[1;32mUsage: \e[1;33m./backup.sh init|backup|db|Restore\n\e[0m" ;; esac |
对于Mysql 5.6 出现Warning: Using a password on the command line interface can be insecure的解决方法
|
1 2 3 4 5 6 7 8 9 10 11 |
touch /root/.my.cnf vi /root/.my.cnf # 以下为插入的内容 [client] user=数据库用户 password=数据库密码 [mysqldump] user=数据库用户 password=数据库密码 |
然后到新服务器使用tar zxPf 解压就可以了
单独备份一个数据库怎么写呢
mysqldump -u$MYSQL_USER -p$MYSQL_PASS table | gzip -9 – > table.sql.gz
把table换为你的库名称就可以了。其它就可以舍弃了
能不能备份到百度云哦
可以的，直接去研究下BCS的api吧
代码简单，就看你怎么弄了！适当修改就可以了！
谢谢啊！！
我只是拿来做个备份而已，对你有帮助那很好啊