Create a Project in a MySQL Database

To create a project in a repository on MySQL 4 or 5, you work through the following stages:

·

Stage 1: Create an empty database repository and set up the data tables

·

Stage 2: Set up the ODBC Driver

·

Stage 3: Perform a project integrity check on the .project file you are using as a base (optional, but recommended)

·

Stage 4: Transfer the data

·

Stage 5: Connect to the repository and open the project

Prerequisites

·

Install MySQL version 4.0.3 or higher, and MySQL ODBC 5.1 or higher

Create a MySQL Repository

If MySQL is set up to use MyISAM table types (the default), transactional support is disabled. To enable transactions you must set up MySQL to use InnoDB tables and create the database tables as InnoDB type.