[root@sqlnode3 script]# cat radacct_daily.sh
#!/bin/bash
#This script will backup the radacct table on daily basis
sys_date=`date +%F -d '-1 day'`
echo $sys_date;
/usr/bin/mysqldump --single-transaction --no-create-db --no-create-info ctradius radacct --where="acctstarttime LIKE '${sys_date}%'" > /backup/freeradius/radacct-`date +%F -d '-1 day' `.sql
#!/bin/bash
#This script will backup the radacct table on daily basis
sys_date=`date +%F -d '-1 day'`
echo $sys_date;
/usr/bin/mysqldump --single-transaction --no-create-db --no-create-info ctradius radacct --where="acctstarttime LIKE '${sys_date}%'" > /backup/freeradius/radacct-`date +%F -d '-1 day' `.sql
No comments:
Post a Comment