checking mysq logs

cat /var/log/mysqld.log | grep -i error | less

dialer query

 /usr/bin/mysql -Ddialer -uroot -p1233 -se "update list  set call_status='pending' where call_dispo='FAILED'"

mysql> select count(*),call_dispo from list group by call_dispo;

+----------+------------+

| count(*) | call_dispo |

+----------+------------+

|     1309 | NULL       |

|     8142 | ANSWERED   |

|      517 | BUSY       |

|     1036 | FAILED     |

|     5367 | NO ANSWER  |

+----------+------------+

 

cronjob 3 AM

0 3 * * *  /usr/bin/mysql -Ddialer -uroot -p1933 -se "update campaing set cp_status=1 where cp_id=26"