In this blog post, I will try to cover a few dump and
data-loading utilities offered by MySQL Shell.
What is MySQL Shell?
It is a robust client and code editor for MySQL. In addition to
having APIs for dealing with MySQL, MySQL Shell offers scripting
capabilities for JavaScript and Python. It provides an AdminAPI
to manage MySQL servers and create InnoDB Cluster and ReplicaSet
deployments. It supports an X DevAPI to work on both SQL and
NoSQL interfaces via the X Protocol. Finally, it provides
utilities to make working with MySQL in Python and Javascript
mode easier.
Now, let’s jump into some practical stuff and see what these
tools offer us.
Dump Utility
In the dump utility, there are three tools: util.dumpInstance(),
util.dumpSchemas(), and util.dumpTables () so let’s discuss them
one by one.
1. “util.dumpInstance()” – This was introduced in MySQL
Shell 8.0.21 and …
[Read more]