The referer db table just got hosed but I’ve rebuilt it. Unfortunately your referer listing is going to be a little short for a few days until it fills again!
Anyway, I have the following running each night. Should have done this before.
export d=`date +%u`
for i in `echo show tables |mysql -u username -ppassword b2`
echo "check table $i"| mysql -u username -ppassword b2
mysqldump --opt -u username -ppassword b2 > backup/b2-$d.sql
You might also like