What is MyDB Dump ?

MyDB Dump is a Powerful database utility that can easily perform the following tasks:

  1. Backup your MySQL database:

    MyDB Dump converts your MySQL database structure and/or records into a single PHP file. Nothing in your MySQL database is changed. By running this PHP file once in your website, you can restore your MySQL database easily whenever you need.

  2. Import your Access database to MySQL even if remote connection to the MySQL server is not allowed.

    With regard to websites, some host providers don’t allow remote connection to their MySQL servers.

    MyDb Dump allows you to convert your Access database to a PHP file without changing the contents or structure of your MySQL database. By running this PHP file in your website you can import your Access database to your MySQL server. This avoids the need for a remote connection to your MySQL server.

  3. Backup your Access database

    Mydbdump creates a text file from your Access db containing the SQL script necessary to recreate your Access database whenever you need.

  4. MyDB Dump Main Features
  • 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:

  • 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.