Depth Analysis: Find the benefits of MySQL

First step-install MySQL

Download this server, MySQL GUI tool, and MySQL ODBC driver to http://dev.mysql.com/downloads/. The servers you can choose from are: 5.0, 5.1 or 6.0. Then install them.

Considerations during the installation:

Your firewall should be set up to allow connection through 3306 ports.

Run MySQL as a service (you can choose the command-line method).

MySQL Install default username/login = root and server = localhost.

MySQL provides a choice of storage engine/table types-primarily Mysam and InnoDB. The latter looks more like access, it has transactions and foreign keys, so we use this approach in this article.

has user and security options. Don't forget to record all the passwords.

Also have to install bullzip access to MySQL and Dreamcoder for later use.

Step Two-Move the table from access to MySQL

Use Bullzip to transfer the background datasheet to MySQL, or open your database and export your data through ODBC.

Things to be aware of:

MySQL does not recognize the functions that access defaults to fields (for example, the now () and date () functions in the Date/time field): They may be deleted or the table will be rejected. It is recommended that you delete them before transfer/export.

Access's AutoNumber field is inconsistent with the MySQL auto_increment field. Bullzip is converted when it is transferred, while ODBC does not.

The Access data type is converted to a similar MySQL data type. However, in MySQL the scope is bigger, you may want to change them later.

Access's "OLE Object" becomes a "blob" in MySQL. Because of an OLE server problem, we change the blobs to Longtext.

Step three--change the MySQL table (field)

Open the Dreamcoder or MySQL manager (a GUI tool). If you are familiar with SQL Server, consider these as enterprise or SQL Server Management Studio Express interfaces.

Connect to this transfer/export database.

Figure 1. Dreamcoder "Database-Connection"