Notes about MySQL

backup solutions

• see A Quick Look at MySQL 6.0’s New Backup (BACKUP command vs mysqldump)
• see [http://www.zmanda.com/quick-mysql-backup.html zmanda open source backup tutorial for MySQL

Differences to PostgreSQL

• we need to use InnoDB tables in order to have foreign key constraints
• there are no default values for CURRENT_DATE, because it is a function; see also MySQL Documentation and MySQL Forum Discussion
• there seem to be no SEQUENCES in MySQL; see for a proposed workaround: LAST_INSERT_ID

current implementation

• PetraTools GenerateSQL.exe already creates the CREATE TABLE sql file
• still todo:
  • load data from db/basedata CSV files (nant resetDatabase)
  • Ict.Common.DB needs an implementation of TMysql for IDataBaseRDBMS