Documentation Home
MySQL Shell 8.0
Related Documentation Download this Manual
PDF (US Ltr) - 0.6Mb
PDF (A4) - 0.6Mb
HTML Download (TGZ) - 126.1Kb
HTML Download (Zip) - 137.2Kb


MySQL Shell 8.0  /  MySQL Shell Utilities

Chapter 7 MySQL Shell Utilities

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 functions:

checkForServerUpgrade()

An upgrade checker utility that enables you to verify whether MySQL server instances are ready for upgrade. See Section 7.1, “Upgrade Checker Utility”.

importJSON()

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”.

importTable()

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”.

dumpInstance(), dumpSchemas()

An instance dump utility and schema dump utility that can export all schemas or a selected schema from a MySQL 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”.

loadDump()

A dump loading utility that can import schemas dumped using MySQL Shell's instance dump utility and schema dump utility into a MySQL instance. See Section 7.5, “Dump Loading Utility”.