SQL

Quick and Dirty MySQL Backup

4 August 2006

This is great for a quick backup of all databases before performing maintenance or check/repair. mysqldump –all-databases -p | gzip > db_dump-YYYYMMDD.gz Replace YYYYMMDD with Year, Month and Day.

Read the full article →

MySQL5 JOIN Syntax Changes

23 February 2006

Changes in the SQL parser in MySQL5 have exposed previously unnoticed errors in several open source applications I support recently. These changes are to comply more accurately with the SQL:2003 standard. A good thing. The bad thing is most apps throw a db error when they encounter a JOIN query of this specific form. Until [...]

Read the full article →