|
DBF-to-MySQL
is a program to migrate DBF databases to MySQL server.
Depending on
your privileges on the target MySQL server you can export DBF
data into new database or overwrite the contents of an
existing MySQL database.
DBF-to-MySQL Features:
- All DBF data types and
attributes are supported
- Works with all versions of
Unix and Windows MySQL servers
- Special approach for
VServer users
- Merges DBF data into an
existing MySQL database
- Exports DBF databases into
MySQL dump file
- Command line support
- Easy-to-use wizard-style
interface
- Full install/uninstall
support
DBF-to-MySQL Limitations:
DBF-to-MySQL System Requirements:
- Windows 2000/XP or Windows
NT 4 with Internet Explorer 5 or later or Windows 98/ME or
Windows 95 with Internet Explorer 5 or later
- At least 32 MB of
available memory
VServer
user's option
If you are using Virtual Server hosting you probably have no
sufficient privileges to create new databases on the target
MySQL server. For this case we recommend the following
approach:
- ask your
Virtual Server administrator to create blank database for
you
- run
DBF-to-MySQL and select this database as the conversion
target
- click
"Yes" when you will be asked if you'd like to overwrite
existing MySQL database
When you
complete these steps, the entire contents of the source MS
Access database will be imported into the specified MySQL
database.
MySQL dump file
DBF-to-MySQL allows users to perform deferred conversion and
get more control over the process. Following this way, the
program stores the contents of the source database into a
local dump file instead of moving it to MySQL server directly.
The resulting file contains MySQL statements to create all
tables and to fill them with the data. You will be able to
import this file into existing MySQL database via MySQL client
as follows:
mysql.exe --host=... --user=... --password=... -vvf {MySQL
database name} < {dump file name}
|
