mysqldump的log-error参数注意事项

备份脚本

1. [root@iZ25kgnqio7Z mysqlback]# more mysqlbackup.sh
   
2. #!/bin/bash
4. databases=(‘oms3’ ‘keyword’)
6. basepath=‘/alidata/mysqlback/’
7. user=‘mysql’
8. passwd=‘xxxxx’
10. if [ ! -d “$basepath“ ]; then
11.   mkdir -p “$basepath“
12. fi
14. for db in ${databases[*]}
15.   do
16.     /bin/nice -n 19 /usr/local/mysql/bin/mysqldump -u$user -p$passwd —log–error=$basepath$db-$(date +%Y%m%d).log —database $db > $basepath$db-$(date +%Y%m%d).sql
17.     
18.     /bin/nice -n 19 tar zPcf $basepath$db-$(date +%Y%m%d).sql.tar.gz $basepath$db-$(date +%Y%m%d).sql
19.     
20.     find $basepath -mtime +7 -name “*.sql.tar.gz“ -exec rm -rf {} \;
21.   done

备份后的结果是：

1. –rw–r––r–– 1 msyql msyql 0 Apr 9 00:15 oms3–20170409.log
   
2. –rw–r––r–– 1 msyql msyql 3380316532 Apr 9 00:34 oms3–20170409.sql.tar.gz
3. –rw–r––r–– 1 msyql msyql 0 Apr 9 00:34 keyword–20170409.log
4. –rw–r––r–– 1 msyql msyql 251514712 Apr 9 00:39 keyword–20170409.sql.tar.gz
5. –rw–r––r–– 1 msyql msyql 0 Apr 10 00:15 oms3–20170410.log
6. –rw–r––r–– 1 msyql msyql 3387944108 Apr 10 00:35 oms3–20170410.sql.tar.gz
7. –rw–r––r–– 1 msyql msyql 0 Apr 10 00:35 keyword–20170410.log
8. –rw–r––r–– 1 msyql msyql 251643052 Apr 10 00:40 keyword–20170410.sql.tar.gz
9. –rw–r––r–– 1 msyql msyql 0 Apr 11 00:15 oms3–20170411.log
10. –rw–r––r–– 1 msyql msyql 3396607153 Apr 11 00:34 oms3–20170411.sql.tar.gz
11. –rw–r––r–– 1 msyql msyql 0 Apr 11 00:34 keyword–20170411.log
12. –rw–r––r–– 1 msyql msyql 251744735 Apr 11 00:39 keyword–20170411.sql.tar.gz

可以看到log日志的大小都是0，MySQL的规则是假如有问题才会写这个文件，否则就创建一个空的，这个和ORACLE还是有很大不同的。