Help hurricane victims by donating to the American Red Cross.

From Ollie's Web Site

MySQL / SQL

This section is for information about MySQL and SQL.

• MySQL's Home Page
• SQL Reference with Examples
• MySQL online reference manual
• ODBC & MySQL

Upgrading from 4.1 to 5.0

I recently upgraded mysql from mysql-4.1.11a-4sa (debian) to mysql-standard-5.0.19-linux-i686-glibc23. Upgrading mysql, especially leaving the somewhat customized debian world for a standard binary, is a bit of a trial. Not that there is anything truly hidden or of a "gotcha" nature, but that it takes a while to fit the standard distribution to where everything is in debian. Read more at MysqlUpgrade.

Backing up MySQL on Webserver

MySQLBackup

Cron routine in root calls /root/mysql/mysql.dump daily which:

• runs mysqldump on all the databases
• rotates the resulting dump files through 7 days.
• stores output in /root/mysql/mysql.dump

ODBC

Got odbc to work after some fuss. MysqlODBC See a message I posted on mysql forums.