Using MySQL mysqldump Utility
mysqldump
is a MySQL utility that reproduces table structure and data from a MySQL database.
For more information, see http://dev.mysql.com/doc/refman/5.7/en/mysqldump.html.
Output from mysqldump
can be used to create a NuoDB database.
Because there are some table structure and data definition conflicts between MySQL and NuoDB, it is recommended that the following mysqldump
optional syntax is used to improve compatibility with NuoDB. The cumulative effect of all those options is to remove as many MySQL-isms from the mysqldump
output as possible. However, getting pure, compatible output is still not guaranteed for all possible situations.
Option | Description |
---|---|
--compact |
Produces a more compact output; enables |
--compatible=ansi |
Changes the syntax and behavior to align more closely with the SQL standard |
--skip-add-locks |
Does not dump |
--skip-set-charset |
Suppresses |