Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ SQL Reference/ SQL Syntax/ E/ EXPDP DATABASE
Updated on 2025-08-19 GMT+08:00
View PDF

EXPDP DATABASE

Description

EXPDP DATABASE exports all physical files in a database.

Syntax

EXPDP DATABASE db_name LOCATION = 'directory';

Parameters

  • db_name

    Name of the database to be exported.

  • directory

    Directory for storing exported files.

Examples

-- The EXPDP DATABASE syntax is used for fine-grained backup and restoration and is called by the backup and restoration tool. If you call it directly, the error message "ERROR: Only auxdb is allowed to execute expdp cmd." is displayed.
gaussdb=# EXPDP DATABASE test LOCATION = '/data1/expdp/database';
Parent topic: E