Various trial runs to test the some of the software pieces.

 ------------------------------------------------------------

 ./translator.pl creates the ERD database image from 
 the mysql InnoDB table (which are aware of foreign keys).

 For Class::DBI to do it's thing, however,
 the has_a and has_many relations must be defined;
 it doesn't read them from the InnoDB tables.
 Only the methods for each table's columns are auto-generated.

 Note that columns declared UNIQUE KEY may be extracted 
 from the database by ->retrieve( column => value ) 
 which I believe is faster than ->search(column=>value)

 To see the actual SQL queries, run mysqld with
 logging (or even verbose logging) turned on.
 The details of how to do that are in 
 cs/docs/MySQL/manual_MySQL_Database_Administration.html#Configuring_MySQL

 The commands I use to start/stop mysqld are in /usr/local/mysql on cs,
  off: /usr/local/mysql/bin/mysqladmin --user=root --password=*** shutdown
  on: /usr/local/mysql/bin/mysqld_safe --user=mysql --skip-networking &
 These two users are a bit different - when starting up (already logged
 in as root), the --user=mysql flag sqys to run mysqld as the unix mysql user.
 In the "off" command, --user=root says to talk to mysqld with the 
 permissions of the mysql root user, as defined in the mysqld database.

 To turn on logging, use something like
     /usr/local/mysql/bin/mysqld_safe --user=mysql --skip-networking \\
     --log=/usr/local/mysql/log/july11.index &