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.


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



Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.