The Referers are Gone but I'm still kicking!

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.

#!/bin/sh

export d=`date +%u`
for i in `echo show tables |mysql -u username -ppassword b2`
do
    echo "check table $i"| mysql -u username -ppassword b2
done
mysqldump --opt -u username -ppassword b2 > backup/b2-$d.sql