Start

Settings

Process

Sessions

Choose Source

Choose Destination

Customization

Options

Errors and Warnings

Execution

MySQL Storage Engines and Table Types

A2MScheduler

Database Types

FAQ

Order

Registration Process

License

MS Access

Microsoft Access is a popular data management application that allows you to store information in tables that it manages directly from the local disk. It has many built in features to assist you in constructing and viewing your information. You can find more information at http://www.microsoft.com/office/access.

MySQL

MySQL runs on several platform types. MySQL easily interacts with Web servers like Apache supporting a large number of languages such as Perl, PHP, Python, Java, and Ruby. This allows you to perform your database Web interface displayed in any language you choose. Further information at  http://www.mysql.com.

MySQL Dump

MySQL Dump is a text file containing all necessary SQL queries that must be sent to database server, in order to create datasets or database. When imported to a non-filled MySQL database SQL statements build \ rebuild the structure, then populate that structure with the data. Such functionality is used not only when you would like to create a database wholly and fill it with data. Saving into MySQL Dump can be also very useful when you want to add data to an existing MySQL database.

You can import MySQL Dump into existing MySQL database as follows:

• For Windows:

mysql.exe --host=... --user=... --password=... -vvf {MySQL database name} < {dump file name}

For Unix

mysql -h myhost.com -p -u myusername < dumpfile

Ability to store data into a dump file is the best way to present deferred conversion and gain more control over the conversion process. The program fixes the contents of the source database into a local dump file instead of sending it to MySQL server directly. The destination file will consist of MySQL statements to create all tables and to fill them with the data. Using this dump file MySQL server administrator will add data to your MySQL base.
MySQL Php (Php script)

PHP script allows you to upload all necessary data to MySQL server.

In case you have got no access to a MySQL database there is an opportunity for you to save your data into PHP Script file. This will allow you to add data to your MySQL database with no direct access to it. Having put your data in MS Access you can find out that it is not possible to update the data in MySQL base as you have no access to it. To gain access to a MySQL base you usually need to obtain the permission for connection from the particular IP address. It's not always possible to get an access even possessing log-in name and password. Database administrator can deny your access being concerned in protecting the information and avoiding insecure connections.
In case you face such a problem just save data of a MS Access database in PHP script. This file will be copied to the server where work with particular MySQL database is executed. IP address of the server is already defined. The file can be launched from any place connected to Internet and the contained data will be added to the database. The speed of data export is much faster as if MS Access databases would be copied to MySQL database directly because of the fact that the copying to MySQL database is executed with utilization of the server where the particular script is launched.