++ dumpFile=mysql_20110104_170930.sql
+++ date +%Y%m%d_%H%M%S
++ GZDumpFile=192_168_250_2_mysql_20110104_170930.sql.tar.gz
++ /usr/local/mysql/bin/mysqldump -uroot -pmysql --skip-opt --default-character-set=utf8 --extended-insert=false --triggers -R --hex-blob --all-databases --flush-logs --delete-master-logs --delete-master-logs --lock-tables=false
mysqldump: Got error: 2013: Lost connection to MySQL server during query when retrieving data from server
++ [[ 2 == 0 ]]
++ echo 'DataBase Backup Fail!'
/backup/script/mysqlFullBackup.sh: line 42: $emailFile: ambiguous redirect
++ echo --------------------------------------------------------
++ cat /backup/mysql/full/email.txt
++ cat /backup/mysql/full/email.txt
++ mail -s 'MySQL Backup' [email protected]
在google中, 试过了set net_write_timeout=1800;,但是不起作用。
+++ date +%Y%m%d_%H%M%S
++ GZDumpFile=192_168_250_2_mysql_20110104_170930.sql.tar.gz
++ /usr/local/mysql/bin/mysqldump -uroot -pmysql --skip-opt --default-character-set=utf8 --extended-insert=false --triggers -R --hex-blob --all-databases --flush-logs --delete-master-logs --delete-master-logs --lock-tables=false
mysqldump: Got error: 2013: Lost connection to MySQL server during query when retrieving data from server
++ [[ 2 == 0 ]]
++ echo 'DataBase Backup Fail!'
/backup/script/mysqlFullBackup.sh: line 42: $emailFile: ambiguous redirect
++ echo --------------------------------------------------------
++ cat /backup/mysql/full/email.txt
++ cat /backup/mysql/full/email.txt
++ mail -s 'MySQL Backup' [email protected]
在google中, 试过了set net_write_timeout=1800;,但是不起作用。
改成
--opt
《高性能MYSQL》第388页第9行有详细说明。