Profile
Profile is a set of parameters that entirely defines the program session. It includes MySQL connection characteristics (host, user name, etc) and all of the necessary information for each MS Access database being converted (MySQL destination name, MS Access database password and "convert table definitions only" flag).
Once you enter all the information for converting databases, you can store it into a profile and reuse in next sessions. If you don't use any profile initially or change some parameters while working with the Database Conversion Wizard, the program will ask you to store the updated information on exit.
Profile looks like a regular MS Windows .ini file:
[MySQL settings]
host=127.0.0.1
user=Administrator
pass=access_to_mysql
port=3306
[UGL settings]
sys_db=C:\Microsoft Office\Office\SYSTEM.MDW
ugl_user=SuperUser
ugl_pass=1234567
[database 1]
src=C:\test1.mdb
dest=test1
mode=2
acc_pwd=test1
skip_idx=yes
tabdef_only=yes
[database 2]
...
The following table describes profile parameters:
| host |
- network name or IP address of the destination MySQL server |
| user |
- user name |
| pass |
- password |
| port |
- TCP/IP port to connect to MySQL server through (default MySQL port is 3306) |
| sys_db |
- path to MS Access system database (*.mdw) |
| ugl_user |
- user name of MS Access user-level account |
| ugl_pass |
- user password of MS Access user-level account |
| src |
- path to the source MS Access database |
| dest |
- name of the destination MySQL database |
| mode |
- how to process existing MySQL tables
(0 - overwrite, 1 - merge, 2 - skip) |
| acc_pwd |
- MS Access database password (leave it blank if none) |
| skip_idx |
- "skip converting indexes" flag ("yes"/"no") |
| tabdef_only |
- "convert table definitions only" flag ("yes"/"no") |
When you run Access-to-MySQL Pro for the first time or without specifying a profile to load conversion settings from, the program automatically saves the selected databases and MySQL server configuration into profile on exit.
| 
