6.4 Importing Data with MySQL Shell

This task describes how to import a MySQL Shell dump to a MySQL DB System.

This task requires the following:

• MySQL Shell 8.0.27, or higher. Exports created by MySQL Shell 8.0.27, or higher, cannot be imported by earlier versions of MySQL Shell.

• Data exported from a source MySQL Server following the instructions described in Section 6.3, “Exporting Data with MySQL Shell”.

• Enough storage space on your DB System for the data you intend to import. To check DB System storage space, see Section 3.4, “Viewing DB System Details”.

• You have run the loadDump() command in dryrun mode to check that there will be no issues when the dump files are loaded from a local directory into the connected MySQL DB System; for example:

  MySQL>JS> util.loadDump("/home/user1/tpchdump", {dryRun: true})

The following task uses loadDump() utility to load the schema that was exported in Section 6.3, “Exporting Data with MySQL Shell”.

To import a schema:

1. Start a MySQL Shell session and connect to the DB System; for example:

   $> mysqlsh Username@HostNameOfMySQLDBSystem

   For information about connecting to a DB System using MySQL Shell, see Section 5.2.1, “Connecting with MySQL Shell”.

2. Run the following command to import the tpch schema using the loadDump() utility.

   MySQL>JS> util.loadDump("/home/user1/tpchdump", {threads: 8})

   where:

   • /home/user1/tpchdump is the location of the MySQL shell dump files.

   • threads specifies the number of processing threads to use for this task. The default is 4. For best performance, it is recommended to set this parameter to twice the number of CPUs used by the target MySQL DB System.