-
Supports
all common MySQL data types and attributes
except "Set" type and "Enum" type.
-
Supports
MS Access Versions 97, 2000, XP.
-
Supports
PHP versions 3 or 4
-
Converts
tables with or without records
-
Converts
indexes with all necessary attributes
-
Easy-to-use
wizard-style interface
-
Converts
password protected MS Access databases
-
Support auto
increment data.
-
Support default
values and not null constraints
-
Support of
tables relationship when dumping access databases
to sql file compatible
with Access (Access SQL)
Dump options
(simply you are in control of every thing):
-
Creates either
(*.sql) file , (*.txt) file or (*.PHP) file
from either MS Access or MySQL.
-
Structure
only of selected/All Tables.
-
Records only
of selected/All Tables
-
Structure
+ records of selected/All Tables
-
Use auto
increment or not
-
Use create/drop/use
database statement or not
-
Complete
insert statement or not
Limitations:
Does not include system (hidden) tables .
click
here to download an example of
dumping the Biblio.mdb Access Database.
Frequently
asked questions about MyDbDump program
Q:
I want to convert my database from Access to mysql
to use it in my website but the problem is my
hosting provider doesn't support direct access
to their mysql servers , how can MyDbDump helps
me?
A:
All you have to do is to dump your Access
database into PHP file using Mydbdump then
Upload the php file and run it once on your web
server it will import your Access file to your
hosting provider SQL server even if they don’t
support direct access to it..
Q: I get
a "file in use by other program" error after selecting
the Access DB I want to convert / dump however
No other application is using the file
A: sometimes
this message appears when the Access database
is read only so all you have to do is to check
your file properties
Q:Are there any constraints on number of fields
or number of records in the dumping process? I
have some fairly large tables in my database?
A: there is no limitation in fields count or
in the number of record
|