Introduction

What is OBLOADER?

OBLOADER is a client tool that is developed in Java. At present, OBLOADER applies only to OceanBase Database. You can use OBLOADER to import database definitions and table data files from the storage media to OceanBase Database. We recommend that you use OBLOADER in combination with OBDUMPER. OBLOADER is compatible with the CSV files exported by using client tools such as mysqldump or Mydumper. Therefore, you can use OBLOADER in data migration. OBLOADER provides various types of built-in data preprocessing functions to improve its data import performance. The automatic fault tolerance mechanism ensures data import stability. Rich monitoring information is provided for you to observe the import performance and progress in real time.

What is OBDUMPER?

OBDUMPER is a client tool that is developed in Java. At present, OBDUMPER applies only to OceanBase Database. You can use OBDUMPER to export objects and table data from OceanBase Database to the storage media in the specified file format. To use OBDUMPER in logical backup, you can directly integrate OBDUMPER to the database O&M system. OBDUMPER cannot be used in incremental backup. Compared with other client export tools such as mysqldump, OBDUMPER has the following benefits:

• Quick data export: Multiple data query strategies are designed to significantly improve the export performance.

• Versatile data exchange capabilities: Data in tables can be exported to multiple types of storage media in different formats.

• Powerful data processing capabilities: Data is compressed, encrypted, desensitized, and preprocessed before being exported.

Supported OceanBase Database versions

The following table describes OceanBase Database versions and modes that are supported.