Table of Contents
- 7.1 Upgrade Checker Utility
- 7.2 JSON Import Utility
- 7.3 Parallel Table Import Utility
- 7.4 Instance Dump Utility and Schema Dump Utility
- 7.5 Dump Loading Utility
MySQL Shell includes utilities for working with MySQL. To access
the utilities from within MySQL Shell, use the
util global object, which provides the following
An upgrade checker utility that enables you to verify whether MySQL server instances are ready for upgrade. See Section 7.1, “Upgrade Checker Utility”.
A JSON import utility that enables you to import JSON documents to a MySQL Server collection or table. See Section 7.2, “JSON Import Utility”.
A parallel table import utility that splits up a single data file and uses multiple threads to load the chunks into a MySQL table. See Section 7.3, “Parallel Table Import Utility”.
An instance dump utility and schema dump utility that can export all schemas or a selected schema from an on-premise MySQL server instance into an Oracle Cloud Infrastructure Object Storage bucket or a set of local files. See Section 7.4, “Instance Dump Utility and Schema Dump Utility”.
A dump loading utility that can import schemas dumped using MySQL Shell's instance dump utility and schema dump utility into a MySQL Database Service DB System. See Section 7.5, “Dump Loading Utility”.