Bulletin 20080811

MySQL Policies

Please note that mysql databases for users must have a prefix for the database name, in the format of _.
The username is the account username which can either be in 'old AHTR' format ex. JDoe or 'new AHTR' format ex. JohnDoe. This choice should be made based on what your system username is currently set to. This is not a project name.
This applies to all databases related to users except for AHTR official projects which already start with 'ahtr' as well as mysql internal databases.
Old unused databases will be cleared out soon. (ex. last years' projects, ex. mousetrap; or temporary tests, ex. phpnuke_test)

Please have these databases switched over by tonight (2008-08-11) if possible.
Databases left without a prefix will be backed up into a .sql file and cleared off the running configuration on the server.

The unplanned database downtime this morning was caused by a bug in the mysql package that was just updated - this issue has now been resolved.

Renaming Databases
MySQL 5.1 does not have support to rename databases. To accomplish this, you must copy the database tables into the new database name, and then drop the old database.