You may not be authorized to see this content. Please contact Data Access Europe for more information.

Cancel Data Access Europe

You are not authorized to see this content.

Cancel Data Access Europe

Migrating to MySQL Environment

Introduction (0m 59s)

What is MySQL (1m 37s)

Why migrate to MySQL (1m 00s)

MySQL Environment (1m 47s)

Setting up the MySQL Environment (13m 21s)

DataFlex Environment (0m 58s)

Setting up MySQL to work with DataFlex (11m 14s)

Next lesson:

Setting up the MySQL Environment

Cancel

Online Documentation

Migrating to MySQL Environment

Lesson 3: MySQL Environment

The MySQL Environment consists of a client side and a server side.

The server side:

Is where the data is stored
There are many MySQL editions available. This course will use the free community edition.
MySQL calculator - a tool available from MySQL to help determine the minimum hardware requirements needed for peak performance on the server
MySQL Workbench – graphic interface to help maintain both the server and the databases
It is important to remember to configure the collate and charset to latin1_general_ci

The client side:

The client needs to be installed and configured to access the data stored on the server
The MySQL Connector ODBC driver is needed to connect applications to different servers. To accomplish this the ODBC 32-bit version is needed.
The 32-bit ODBC Data Source Administrator is needed for DSN configuration with the ANSI driver.