Posts in category mysql

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:

/usr/local/mysql/bin/mysql -p

Enter password: mypassword

mysql> CREATE database blog;
    -> ON blog.*
    -> TO blog@localhost
    -> 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 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!