Notes about MySQL
Jump to navigation
Jump to search
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