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

Author: Donncha

Donncha Ó Caoimh is a software developer at Automattic and WordPress plugin developer. He posts photos at In Photos and can also be found on Google+ and Twitter.

Leave a Reply