Dump Database

Dump Database – Dumping a database to MDB2 XML

Dump Database

You can use dumpDatabase() to copy your database to a schema file. dumpDatabase() accepts a database definition array, for instance:

require_once 'MDB2/Schema.php';

$options = array(
'log_line_break' => '<br>',
'idxname_format' => '%s',
'debug' => true,
'quote_identifier' => true,
'force_defaults' => false,
'portability' => false
$dsn 'mysql://root:@localhost/MDB2Example';

$schema =& MDB2_Schema::factory($dsn$options);

if (
PEAR::isError($schema)) {
$error $schema->getMessage();
} else {
$dump_options = array(
'output_mode' => 'file',
'output' => 'schema.xml',
'end_of_line' => "\n"

$definition $schema->getDefinitionFromDatabase();
    if (
PEAR::isError($definition)) {
$error $definition->getMessage();
    } else {
$op $schema->dumpDatabase($definition$dump_optionsMDB2_SCHEMA_DUMP_ALL);

      if (
PEAR::isError($op)) {
$error $op->getMessage();

if (isset(
$error)) {


The first parameter is just the database definition array. The second parameter is the options where we choose to output to a file. The third option tells dumpDatabase() what to be dumped - either the structure, the data in the tables, or both. This is defined using the constants MDB2_SCHEMA_DUMP_STRUCTURE, MDB2_SCHEMA_DUMP_CONTENT and MDB2_SCHEMA_DUMP_ALL.

Some databases don't accept a text field with a default value. Given that, notice that $options['force_defaults'] has to be set to false when you want to create a field with the type text, as it is true by default.

Generating the definition array of a physical database or MDB2 XML (Previous) Restoring a database from MDB2 XML (Next)
Last updated: Sat, 16 Feb 2019 — Download Documentation
Do you think that something on this page is wrong? Please file a bug report.
View this page in:
  • English

User Notes:

There are no user contributed notes for this page.