mysqldump -h db481.1und1.de -P 3306 -udbo263011116 -pxy.cTPv8 db263011116 --compact --tables sms_history -w"f_clientid = '1' AND DATE_FORMAT(senddate,'%m') = DATE_FORMAT(CURRENT_TIMESTAMP() - INTERVAL 1 MONTH ,'%m')" | gzip > _DB/Backup/TESTSEITE_12-2008.gz
"--compact" :Produce less verbose output. This option enables the --skip-add-drop-table, --skip-add-locks, --skip-comments, --skip-disable-keys, and --skip-set-charset options.
没有评论:
发表评论