Importing from Object Storage to Replica
Use the loadDump
utility to import the source data and
users from an Object Storage bucket to a replica.
Using MySQL Shell
Use MySQL Shell to import the source data and users.
This task requires the following:
- You have read and implemented the prerequisites. See Replica Configuration.
- 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 that contains the exported files.
- 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.
- Your replica has enough storage space for the import.
- A replica running with
local-infile=ON
. You require the parameter for importing the source dump. You can disable the parameter after the import. If you disable the parameter, restart the replica.See local_infile.Note
If you are importing to a DB system replica, this parameter is enabled by default. To disable it, create a copy of your configuration, setlocal-infile=OFF
, and replace your existing configuration.
Do the following to import the source data and users to the replica:
The source data is imported to the replica.