Initializing a MySQL Database

The following topic describes how to configure TrackStudio for use with a MySQL database management system.

For MySQL 4.1 (Win) start MySQL Command Line Client or start mysql.exe the from command line:

shell> mysql -u root

Create the database:

Copy Code

mysql> create database trackstudio character set utf8;
mysql> commit;
mysql> use trackstudio;

Configure the database connection properties:
- TrackStudio SA: Go to the Database -> Database Connectivity tab, enter the JDBC connection properties.
- TrackStudio WAR: Edit the trackstudio.hibernate.properties:

Copy Code

hibernate.dialect org.hibernate.dialect.MySQLInnoDBDialect
hibernate.connection.driver_class com.mysql.jdbc.Driver
hibernate.connection.url jdbc:mysql://localhost/trackstudio?useUnicode=true
                              &characterEncoding=UTF-8&autoReconnect=true
hibernate.connection.username root
hibernate.connection.password

Initialize the database:
- TrackStudio SA: Go to the Database -> Database Management tab and click the Create Database button.
- TrackStudio WAR: Execute following command from command line:

Copy Code

shell>mysql -u root -p trackstudio <"trackstudio-mysql.sql"

Topic path: Installation Guide > Creating and Managing the Database > Initializing a MySQL Database