A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All

BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All

PRODUCTS

OceanBase Cloud

OceanBase Database

Tools Connectors and Middleware

QUICK START

OceanBase Cloud OceanBase Database

BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

OceanBase Loader and Dumper

V4.2.5Community Edition

Document Overview
Introduction
Preparations
- Prepare the environment
- Download OBLOADER & OBDUMPER
Import data
- Quick start
- Command-line options
- Data processing
  - Define control files
  - Preprocessing functions
  - Case expressions
- Performance tuning
- Error handling
- FAQ
Export data
- Quick start
- Command-line options
- Data processing
  - Define control files
  - Preprocessing functions
  - Case expressions
- Performance tuning
- FAQ
Security features
Connection settings
Self-service troubleshooting
Release Note
- Release Note
  - 4.x
    - OBLOADER & OBDUMPER V4.2.5
    - OBLOADER & OBDUMPER V4.2.4
    - OBLOADER & OBDUMPER V4.2.1
    - OBLOADER \& OBDUMPER V4.1.0
    - OBLOADER \& OBDUMPER V4.0.0
  - 3.x
    - OBLOADER \& OBDUMPER V3.1.0
    - OBLOADER \& OBDUMPER V3.0.0
- Version rules

Download PDF

OceanBase Loader and Dumper

OceanBase Loader and Dumper are developed based on Java for importing and exporting data. OceanBase Loader provides extensive command-line options that allow you to import schemas and data to OceanBase Database in many complex scenarios. We recommend that you use OceanBase Loader along with OceanBase Dumper. However, OceanBase Loader can also import SQL and CSV files that are exported by third-party tools, such as Navicat, MyDumper, and SQL Developer. OceanBase Loader fully uses the features of the distributed OceanBase Database system. The tool is particularly optimized for import performance and stability, and is enhanced to provide more operation monitoring information to improve user experience. You can use OceanBase Dumper to export data objects and relevant data in OceanBase Database to files.

Download

Build a Business System

Import and Export Data in OceanBase Database

Import and Export Data Across Platforms

1
Use OceanBase Loader to import data within OceanBase Database
OceanBase Loader can import definitions and data to OceanBase Database based on specified command-line options. You can import data from files in the CSV, SQL, ORC, or Parquet format.
For more information, see "User Guide (OceanBase Loader)".
2
Use OceanBase Dumper to export data within OceanBase Database
OceanBase Dumper can export definitions and data from OceanBase Database based on specified command-line options. You can export data in tables to a file in the CSV, SQL, CUT, ORC, or Parquet format.
For more information, see "User Guide (OceanBase Dumper)".

Dive Deep into OceanBase Loader and Dumper

Use OceanBase Loader
Learn more about OceanBase Loader
Documents
Use OceanBase Dumper
Learn more about OceanBase Dumper
Documents