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

#!/bin/sh


mysqldump -c -t z3000_ext LOG_AGENT_STATE  -w 'generate_time BETWEEN "2008-01-21 00:00:00" and "2008-01-22 23:59:59"'> LOG_AGENT_STATE.sql
mysqldump -c -t z3000_ext LOG_CHANNEL_STATE  -w 'generate_time BETWEEN "2008-01-21 00:00:00" and "2008-01-22 23:59:59"'> LOG_CHANNEL_STATE.sql
mysqldump -c -t z3000_ext LOG_COLINE_INBOUND_CALL_TRAVEL  -w 'generate_time BETWEEN "2008-01-21 00:00:00" and "2008-01-22 23:59:59"'> LOG_COLINE_INBOUND_CALL_TRAVEL.sql
mysqldump -c -t z3000_ext LOG_COLINE_OUTBOUND_CALL_TRAVEL  -w 'generate_time BETWEEN "2008-01-21 00:00:00" and "2008-01-22 23:59:59"'> LOG_COLINE_OUTBOUND_CALL_TRAVEL.sql
mysqldump -c -t z3000_ext LOG_INLINE_INCOMING_CALL  -w 'generate_time BETWEEN "2008-01-21 00:00:00" and "2008-01-22 23:59:59"'> LOG_INLINE_INCOMING_CALL.sql
mysqldump -c -t z3000_ext LOG_INLINE_OUTGOING_CALL  -w 'generate_time BETWEEN "2008-01-21 00:00:00" and "2008-01-22 23:59:59"'> LOG_INLINE_OUTGOING_CALL.sql
mysqldump -c -t z3000_ext LOG_MEETING  -w 'generate_time BETWEEN "2008-01-21 00:00:00" and "2008-01-22 23:59:59"'> LOG_MEETING.sql
mysqldump -c -t z3000_ext LOG_MULTILINE_QUEUE  -w 'generate_time BETWEEN "2008-01-21 00:00:00" and "2008-01-22 23:59:59"'> LOG_MULTILINE_QUEUE.sql
mysqldump -c -t z3000_ext LOG_OUTDIAL_RESULT  -w 'generate_time BETWEEN "2008-01-21 00:00:00" and "2008-01-22 23:59:59"'> LOG_OUTDIAL_RESULT.sql
mysqldump -c -t z3000_ext LOG_SESSION_ID  -w 'generate_time BETWEEN "2008-01-21 00:00:00" and "2008-01-22 23:59:59"'> LOG_SESSION_ID.sql
mysqldump -c -t z3000_ext LOG_SKILLGROUP_WORK  -w 'generate_time BETWEEN "2008-01-21 00:00:00" and "2008-01-22 23:59:59"'> LOG_SKILLGROUP_WORK.sql

#mysqldump -c -t z3000_ext LOG_IVR_PROCESS  -w 'generate_time BETWEEN "2008-01-21 00:00:00" and "2008-01-22 23:59:59"'> LOG_IVR_PROCESS.sql



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

rm -f LOG*.sql