Cleaning up your bblog blog
I am sick of these spammers putting trackback crap. My system doesn't allow trackbacks nor comments, but I have over a thousand filling up my database anyway. When I move fully to my new server, I plan on converting it all to a non-public wiki anyway.
To clean yours out:
Go into SQL, whatever way you normally do.
use blog; <-- yours may be different of course DELETE FROM bB_comments where type = 'comment'; DELETE FROM bB_comments where type = 'trackback';
Now to stop them: Go into the bblog directory:
mv trackback.php trackback_disabled.php
I'll update this later if there's more.
Using bBlog on your own server.
The installation program asks for your MySQL database name and password. I couldn't get the to work by myself, because I run my own so no admin just handed me the info. If you're in the same boat, here's all you need to do:
Enter password: mypassword
mysql> CREATE database blog; mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX -> ON blog.* -> TO [email protected] -> IDENTIFIED BY 'myblogpassword';
Obviously, change the stuff in bold. Then in bBlog's setup use the user and database name of 'blog' with the password set above.
Move MySQL database from one machine to another
I just moved my ENTIRE MySQL database from one machine to another using netcat!
On the original firewall:
./mysqldump -A -a --opt -p | bzip2 | nc -w 3 192.168.1.55 2000
And then on the new virtual one:
nc -l -p 2000 | bunzip2 | /usr/local/mysql/bin/mysql -p
So, on the fly compresion and everything!