mysqldump导出符合条件的记录

xjc2694

1. for table_witz in witz_impressionsummary_hourly \
   
2. witz_clicksummary_hourly \
   
3. witz_tracksummary_hourly \
   
4. 
   
5. do
   
6. echo "#######$table_witz"
   
7. mysqldump -uroot -p111111 dbname $table_witz --where=" date_time >= date_add(current_date,interval -5 day)" >/opt/dump_db/data/$table_witz.sql
   
8. done
   
9. 
   
10. mysqldump -uroot -p111111 dbname witz_snapshot_report --where=" snaptime >= date_add(current_date,interval -5 day)" >/opt/dump_db/data/witz_snapshot_report.sql
    
11. 
    
12. mysqldump -uroot -p111111 dbname ox_stats_vast --where=" interval_start >= date_add(current_date,interval -5 day)" >/opt/dump_db/data/ox_stats_vast.sql