DBF to MySQL Tutorial
|[DBF to MySQL Converter] [FAQ] [Download] [Buy]|
On this page user can find step-by-step instructions on how to use DBF to MySQL conversion tool.
|1. Select the conversion scenario
On this screen user has to select the conversion scenario. DBF to MySQL database migration tool provides two options to convert .dbf files into MySQL data source:
|2a. Connect to MySQL Server
If user selected "Move to MySQL server directly" option on the first page, they will see this screen where you should enter the necessary settings to establish connection with MySQL server. DBF to MySQL database conversion tool is able to connect to the target server using either local or remote mode. Local mode is being used to connect MySQL server launched on the same machine where DBF to MySQL converter is running. Remote mode allows to connect to the server launched on another computer.
By default, the program uses local connection mode. It is indicated by radio button "Local" selected. To establish remote connection user should select "Remote" radio button. For remote MySQL servers user should also enter host and TCP/IP port to connect through. Host could be either network name or IP address. TCP/IP port value is necessary only if it differs from the default MySQL port number 3306. Otherwise user may leave this field as is.
Finally, user should enter username and password. These fields can be empty for anonymous connection.
|User must have the sufficient privileges to create
new database on MySQL server. Otherwise they will be able only to import FoxPro data
into an existing MySQL database. See Virtual Server
User Notes for related information.
NOTE: MySQL 4.1.0 uses the authentication protocol based on a password hashing algorithm that is incompatible with that used by DBF to MySQL conversion tool. See DBF to MySQL FAQ page to learn how to resolve this problem.
|2b. MySQL dump file settings
On this wizard screen user has to specify how the resulting dump file is generated. There are following settings available:
MySQL version - this parameter determines the syntax of MySQL statements being used in output dump file. 'Old' versions of MySQL (before 3.23.6) put more restrictions on database objects names. Note that 'new' syntax is not accepted by 'old' versions of MySQL. Use 'old' syntax whenever you are not sure about the version of MySQL server.
|4. Select Databases
On this wizard screen user should enter path to the folder with FoxPro (.dbf) files to convert, MySQL database name or path to a dump file (depending on which conversion scenario has been chosen). Also, user can customize the following conversion settings:
By default FoxPro files contain information about encoding. Select particular encoding from "Use Encoding" combo box to override that default value.
|5. Select Tables
On this wizard screen user can manage the list of FoxPro files to convert. In the left part of the window there is "Available tables" list box. It contains all available .dbf files from the specified folder except those are selected already. On the right there is "Selected tables" list box.
To add new .dbf files for converting into MySQL format user should select it in "Available tables" list box and click "Add" button (or double-click the selected item). Also, user can use "Add all" button to insert all available tables.
To remove an item from "Selected tables" list user should select it and click "Remove" button. User can use "Remove all" button to remove all items from "Selected tables" list box.