Skip to content

Backup and Restore

Source

Load and execute SQL file into current database

SOURCE '[path/]sqlfile'

Dump Database

Dump current database to console

DUMP DATABASE

Dump specified database with options

DUMP DATABASE db_name [dump_option] ...

dump_option:
    NODROP      : Don't add DROP statement
  | NOCREATE    : Don't add CREATE statement
  | NODATA      : Don't dump ROW data
  | INTO '[path/]outfile' : Dump into file instead of console

Comments