How to update my sparc FreeBSD install

So the spanking new freebsd-update doesn't work for sparc systems... boo. Have to do everything manually. Here's what I remember. Let me know if I forgot something, or its wrong.(very likely)

Install cvsup:

# cd /usr/ports/net/cvsup-without-gui/
# make install

install fastest cvsup:

# cd /usr/ports/sysutils/fastest_cvsup …
more ...

webalizer installation on freebsd 7

cd /usr/ports/www/webalizer
make
make install
make clean
rehash
mkdir /usr/local/www/stats
webalizer -o /usr/local/www/stats /var/log/httpd-access_log

After that, just added it to the root crontab

crontab -e

like this:

0 * * * * /usr/local/bin/webalizer -o /usr/local/www/stats …
more ...

savecore? reboot after panic?

scary. I updated freebsd, and i can only think that i messed it up when i tried to "shutdown -h" to get it shutdown so i could reboot. anyways, when i rebooted, i saw this message. apparently there was a kernel dump on my swap drive. But problem is that …

more ...

FreeBSD MYSQL configuration

FreeBSD does not automatically include a default my.cnf for MySQL. Instead, a set of sample configuration files can be found under /usr/local/share/mysql. These configuration files include my-small.cnf, my-medium.cnf, my-large.cnf, my-innodb-heavy-4G, and my-huge.cnf. The appropriate file can be copied and used as a …

more ...

what not to do in MySQL... and how to pick up the pieces

note to self... do NOT kill mysql processes from phpmyadmin's control panel and force mysql to quit. Bad things happen. In this case, mysql wouldnt start again. InnoDB's indexes, binary logs, etc. were all out of sync. The 20 page log explaining all the ways the DB couldn't start is …

more ...