OceanBase Loader and Dumper
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.
Import and Export Data in OceanBase Database
OBLOADER imports schemas and data into OceanBase database based on the specified command-line options. It supports data files in CSV, INSERT SQL, CUT, ORC, and Parquet formats.
For more information, refer to "User guide (OBLOADER)".
OBDUMPER exports schemas and data from OceanBase database based on the specified command-line options. It can export table data to files in CSV, INSERT SQL, CUT, ORC, and Parquet formats.
For more information, refer to "User guide (OBDUMPER)".
Learn more about OBLOADER
Learn more about OBDUMPER