Staying on time in Debian

To stay on time, you should really use ntpd. It is a daemon that runs all the time and makes tiny changes to the system clock. All you need to do is install ntp:

aptitude install ntp

after it's installed, I encourage you to go over to http://www.pool …

more ...

Uninstall MySQL 5 from Debian

I completely. completely messed up MySQL. Badly. I wiped out the data directory (/var/lib/mysql in Debian) and the went to remove mysql ... apt-get remove --purge mysql-server That only deleted something like 86K. dissapointing. It looks like "mysql-server" is a shortcut pointing to the latest version of the software …

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 ...