You are here: Reference Information > Command Line Tools > NuoDB Migrator > Example of Migrating From MySQL

Example of Migrating From MySQL

MySQL JDBC Driver Information

To access MySQL download and install the appropriate driver.

Supported Driver MySQL Connector/J JDBC Driver
Class Name com.mysql.jdbc.Driver
JDBC URL jdbc:mysql://host:port/dbname

Note: MySQL Connector/J is an official JDBC Type 4 driver and is a pure Java implementation of the MySQL protocol which does not rely on the MySQL client libraries. For additional information, see MySQL JDBC Driver.

Migration Commands

schema

The following sample command generates a NuoDB schema from a MySQL db1 catalog and saves the schema to /tmp/schema.sql:

$ nuodb-migrator schema       \
        --source.driver=com.mysql.jdbc.Driver           \
        --source.url=jdbc:mysql://localhost:3306/db1    \
        --source.username=root                          \
        --source.password=12345                         \
        --output.path=/tmp/schema.sql

Run schema.sql in nuosql to load schema into the NuoDB db2 database.

$ nuosql db2@localhost --user cloud --password user --file /tmp/schema.sql

dump

To dump tables from the MySQL db1 catalog in CSV format to the /tmp/dump directory execute:

$ nuodb-migrator dump         \
        --source.driver=com.mysql.jdbc.Driver           \
        --source.url=jdbc:mysql://localhost:3306/db1    \
        --source.username=root                          \
        --source.password=12345                         \
        --output.type=csv                               \
        --output.path=/tmp/dump

load

Restoring a dump to a NuoDB database into --target.schema is performed using the load command:

$ nuodb-migrator load         \
        --target.url=jdbc:com.nuodb://localhost/db2     \
        --target.schema=test2                           \
        --target.username=cloud                         \
        --target.password=user                          \
        --input.path=/tmp/dump