# groonga - An open-source fulltext search engine and column store.

- 日本語

# 7.3.22. `dump`

## 7.3.22.1. Summary

dump - データベースのスキーマとデータを出力する

Groonga組込コマンドの一つであるdumpについて説明します。組込コマンドは、groonga実行ファイルの引数、標準入力、 またはソケット経由でgroongaサーバにリクエストを送信することによって実行します。

dumpはデータベースのスキーマとデータを後から読み込めるフォーマットで出力します。dumpの結果は大きくなるため、 主にコマンドラインから使うことを想定しています。データベースのバックアップが主な利用方法です。

dumpが出力するフォーマットは直接Groongaが解釈できるフォーマットです。そのため、以下のようにしてデータベースをコピーすることができます。:

    % groonga original/db dump > dump.grn
    % mkdir backup
    % groonga -n backup/db < dump.grn

## 7.3.22.2. Syntax

    dump [tables]
         [dump_plugins]
         [dump_schema]
         [dump_records]
         [dump_indexes]
         [dump_configs]
         [sort_hash_table]

## 7.3.22.3. Usage

Here is the sample schema and data to check dump behaviour:

    plugin_register token_filters/stop_word
    table_create Bookmarks TABLE_HASH_KEY ShortText
    column_create Bookmarks title COLUMN_SCALAR ShortText
    table_create Lexicon TABLE_PAT_KEY ShortText
    table_create Sites TABLE_NO_KEY
    column_create Sites url COLUMN_SCALAR ShortText
    column_create Lexicon bookmark_title COLUMN_INDEX Bookmarks title
    load --table Bookmarks
    [
    {"_key":"Groonga", "title":"Introduction to Groonga"},
    {"_key":"PGroonga", "title":"Introduction to PGroonga"},
    {"_key":"Mroonga", "title":"Introduction to Mroonga"}
    ]
    load --table Sites
    [
    {"_id": 1, "url":"http://groonga.org"},
    {"_id": 2, "url":"http://mroonga.org"}
    ]

Dump all data in database:

    > dump
    plugin_register token_filters/stop_word

    table_create Sites TABLE_NO_KEY
    column_create Sites url COLUMN_SCALAR ShortText

    table_create Bookmarks TABLE_HASH_KEY ShortText
    column_create Bookmarks title COLUMN_SCALAR ShortText

    table_create Lexicon TABLE_PAT_KEY ShortText

    load --table Sites
    [
    ["_id","url"],
    [1,"http://groonga.org"],
    [2,"http://mroonga.org"]
    ]

    load --table Bookmarks
    [
    ["_key","title"],
    ["Groonga","Introduction to Groonga"],
    ["PGroonga","Introduction to PGroonga"],
    ["Mroonga","Introduction to Mroonga"]
    ]

    create Lexicon bookmark_title COLUMN_INDEX Bookmarks title

Dump schema and specific table data:

    > dump Bookmarks
    plugin_register token_filters/stop_word

    table_create Sites TABLE_NO_KEY
    column_create Sites url COLUMN_SCALAR ShortText

    table_create Bookmarks TABLE_HASH_KEY ShortText
    column_create Bookmarks title COLUMN_SCALAR ShortText

    table_create Lexicon TABLE_PAT_KEY ShortText

    load --table Bookmarks
    [
    ["_key","title"],
    ["Groonga","Introduction to Groonga"],
    ["PGroonga","Introduction to PGroonga"],
    ["Mroonga","Introduction to Mroonga"]
    ]

    column_create Lexicon bookmark_title COLUMN_INDEX Bookmarks title

Dump plugin only:

    > dump --dump_schema no --dump_records no --dump_indexes no
    plugin_register token_filters/stop_word

Dump records only:

    > dump --dump_schema no --dump_plugins no --dump_indexes no
    load --table Sites
    [
    ["_id","url"],
    [1,"http://groonga.org"],
    [2,"http://mroonga.org"]
    ]

    load --table Bookmarks
    [
    ["_key","title"],
    ["Groonga","Introduction to Groonga"],
    ["PGroonga","Introduction to PGroonga"],
    ["Mroonga","Introduction to Mroonga"]
    ]

Dump schema only:

    > dump --dump_records no --dump_plugins no --dump_indexes no
    table_create Sites TABLE_NO_KEY
    column_create Sites url COLUMN_SCALAR ShortText

    table_create Bookmarks TABLE_HASH_KEY ShortText
    column_create Bookmarks title COLUMN_SCALAR ShortText

    table_create Lexicon TABLE_PAT_KEY ShortText

Dump sorted hash table data:

    > dump Bookmarks --sort_hash_table yes
    plugin_register token_filters/stop_word

    table_create Sites TABLE_NO_KEY
    column_create Sites url COLUMN_SCALAR ShortText

    table_create Bookmarks TABLE_HASH_KEY ShortText
    column_create Bookmarks title COLUMN_SCALAR ShortText

    table_create Lexicon TABLE_PAT_KEY ShortText

    load --table Bookmarks
    [
    ["_key","title"],
    ["Groonga","Introduction to Groonga"],
    ["Mroonga","Introduction to Mroonga"],
    ["PGroonga","Introduction to PGroonga"]
    ]

    column_create Lexicon bookmark_title COLUMN_INDEX Bookmarks title

## 7.3.22.4. Parameters

There are optional parameters.

### 7.3.22.4.1. Optional parameters

#### 7.3.22.4.1.1. `tables`

出力対象のテーブルを「,」（カンマ）区切りで指定します。存在しないテーブルを指定した場合は無視されます。

#### 7.3.22.4.1.2. `dump_plugins`

New in version 5.0.3.

You can customize the output whether it contains registered plugins or not. To exclude registered plugins from the output, specify `no`.

The default value is `yes`.

#### 7.3.22.4.1.3. `dump_schema`

New in version 5.0.3.

You can customize the output whether it contains database schema or not. To exclude database schema from the output, specify `no`.

The default value is `yes`.

#### 7.3.22.4.1.4. `dump_records`

New in version 5.0.3.

You can customize the output whether it contains records or not. To exclude records from the output, specify `no`.

The default value is `yes`.

#### 7.3.22.4.1.5. `dump_indexes`

New in version 5.0.3.

You can customize the output whether it contains indexes or not. To exclude indexes from the output, specify `no`.

The default value is `yes`.

#### 7.3.22.4.1.6. `sort_hash_table`

New in version 7.0.5.

You can ascending sort by `_key` the output of hash table when it contains hash table. To don't sort the output of hash table, specify `no`.

The default value is `no`.

## 7.3.22.5. Return value

データベースのスキーマとデータをGroongaの組み込みコマンド呼び出し形式で出力します。output_type指定は無視されます。