dump.sh

使用shell脚本 导出mysql数据 带条件的例子

mysqldump -c -t z3000_ext LOG_AGENT_STATE  -w 'generate_time BETWEEN "2008-07-28" and "2008-07-30"'> LOG_AGENT_STATE.sql
mysqldump -c -t z3000_ext LOG_CHANNEL_STATE  -w 'generate_time BETWEEN "2008-07-28" and "2008-07-30"'> LOG_CHANNEL_STATE.sql
mysqldump -c -t z3000_ext LOG_COLINE_INBOUND_CALL_TRAVEL  -w 'generate_time BETWEEN "2008-07-28" and "2008-07-30"'> LOG_COLINE_INBOUND_CALL_TRAVEL.sql
mysqldump -c -t z3000_ext LOG_COLINE_OUTBOUND_CALL_TRAVEL  -w 'generate_time BETWEEN "2008-07-28" and "2008-07-30"'> LOG_COLINE_OUTBOUND_CALL_TRAVEL.sql
mysqldump -c -t z3000_ext LOG_INLINE_INCOMING_CALL  -w 'generate_time BETWEEN "2008-07-28" and "2008-07-30"'> LOG_INLINE_INCOMING_CALL.sql
mysqldump -c -t z3000_ext LOG_INLINE_OUTGOING_CALL  -w 'generate_time BETWEEN "2008-07-28" and "2008-07-30"'> LOG_INLINE_OUTGOING_CALL.sql
mysqldump -c -t z3000_ext LOG_MEETING  -w 'generate_time BETWEEN "2008-07-28" and "2008-07-30"'> LOG_MEETING.sql
mysqldump -c -t z3000_ext LOG_MULTILINE_QUEUE  -w 'generate_time BETWEEN "2008-07-28" and "2008-07-30"'> LOG_MULTILINE_QUEUE.sql
mysqldump -c -t z3000_ext LOG_OUTDIAL_RESULT  -w 'generate_time BETWEEN "2008-07-28" and "2008-07-30"'> LOG_OUTDIAL_RESULT.sql
mysqldump -c -t z3000_ext LOG_SESSION_ID  -w 'generate_time BETWEEN "2008-07-28" and "2008-07-30"'> LOG_SESSION_ID.sql


tar -czvf LOG.tar.gz LOG*.sql
rm -f LOG*.sql