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
You might also like
If you like this post then please subscribe to my full RSS feed. You can also click here to subscribe by email. There are also my fabulous photos and funny videos to explore too!