Exporting Source Instance to Object Storage

Use the dumpinstance utility to export the DB system source instance to Object Storage.

Using MySQL Shell

Use MySQL Shell to export the DB system source instance to Object Storage.

This task requires the following:
  • MySQL Shell 8.0.27 or higher version. It is recommended to use the latest version of MySQL Shell. Any earlier versions of MySQL Shell cannot import the exports created by MySQL Shell 8.0.27 or higher version.
  • Access to Object Storage and an existing bucket.
  • A valid configuration file. If you have installed and configured the CLI in the default location, you have a valid configuration file. If you have not installed and configured the CLI, you must either install it or create a configuration file manually. See SDK and CLI Configuration File.
  • At least one database schema in your source instance. MySQL Shell's dumpInstance command fails if there are no database schemas present in the instance.
Do the following to export the source DB system to Object Storage:
  1. Connect to the DB system using MySQL Shell. See Using MySQL Shell and Overview of Exporting and Importing.
  2. In the JS execution mode, run the following command:
    util.dumpInstance("prefix", {osBucketName: "bucket", ocimds: true, threads: n})
    • util.dumpInstance: Export all data in the MySQL instance.
    • prefix: (Optional) Add a prefix to the files uploaded to the bucket. See Overview of Exporting and Importing.
    • ocimds: (Optional) Check your data for compatibility with MySQL HeatWave Service. Specify this option only if you intend to import the dump into another DB system. If you are exporting dump to an external replica, do not specify this option.
    • osBucketName: Specify the case-sensitive name of the Object Storage bucket to export to.
    • threads: Specify the number of processing threads to use for this task. The default value is 4.
Your instance is exported to the Object Storage bucket.