MySQL Shell Blogs

Back Up MySQL View Definitions

If you want to back up your table and views, stored procedures, or stored function definitions, you can use mysqldump or mysqlpump to export the schema without the data. However, if you just want the views you need to look

Read More »

MySQL Shell 8.0.16: User Defined Reports

Table Of Contents BackgroundExample Custom ReportThe Report FunctionRegistering the ReportTesting the ReportThe shell.reports ObjectIn my blog yesterday, I wrote about the new reporting framework in MySQL Shell. It is part of the 8.0.16 release. I also noted that it includes

Read More »

MySQL Shell 8.0.16: Built-in Reports

Table Of Contents BackgroundExample Custom ReportThe Report FunctionRegistering the ReportTesting the ReportThe shell.reports ObjectBuilt-In FeaturesThe \show CommandThe Query ReportThe \watch CommandConclusionReaders of my blog know that I like how MySQL Shell allows you to customize it and use it's Python

Read More »

MySQL 8: Drop Several Stored Events, Procedures, or Functions

Table Of Contents BackgroundExample Custom ReportThe Report FunctionRegistering the ReportTesting the ReportThe shell.reports ObjectBuilt-In FeaturesThe \show CommandThe Query ReportThe \watch CommandConclusionSetupMySQL ShellEvents – InteractiveEvents – FunctionProcedures and Functions – InteractiveFunctions and Procedures – FunctionMySQL Connector/PythonMaybe the biggest new feature in

Read More »

Auto-Refreshing Reports in MySQL Shell

Table Of Contents BackgroundExample Custom ReportThe Report FunctionRegistering the ReportTesting the ReportThe shell.reports ObjectBuilt-In FeaturesThe \show CommandThe Query ReportThe \watch CommandConclusionSetupMySQL ShellEvents – InteractiveEvents – FunctionProcedures and Functions – InteractiveFunctions and Procedures – FunctionMySQL Connector/PythonBasic ExampleMySQL iotopMySQL Shell makes it

Read More »

Slides and Workbooks From Oracle OpenWorld & CodeOne

Table Of Contents BackgroundExample Custom ReportThe Report FunctionRegistering the ReportTesting the ReportThe shell.reports ObjectBuilt-In FeaturesThe \show CommandThe Query ReportThe \watch CommandConclusionSetupMySQL ShellEvents – InteractiveEvents – FunctionProcedures and Functions – InteractiveFunctions and Procedures – FunctionMySQL Connector/PythonBasic ExampleMySQL iotopFirst of all, thanks

Read More »

MySQL Shell 8.0.13 Prompt: Now with New Line Support

Table Of Contents BackgroundExample Custom ReportThe Report FunctionRegistering the ReportTesting the ReportThe shell.reports ObjectBuilt-In FeaturesThe \show CommandThe Query ReportThe \watch CommandConclusionSetupMySQL ShellEvents – InteractiveEvents – FunctionProcedures and Functions – InteractiveFunctions and Procedures – FunctionMySQL Connector/PythonBasic ExampleMySQL iotopWhy Use a New

Read More »

Awesome MySQL Shell Prompt

Table Of Contents BackgroundExample Custom ReportThe Report FunctionRegistering the ReportTesting the ReportThe shell.reports ObjectBuilt-In FeaturesThe \show CommandThe Query ReportThe \watch CommandConclusionSetupMySQL ShellEvents – InteractiveEvents – FunctionProcedures and Functions – InteractiveFunctions and Procedures – FunctionMySQL Connector/PythonBasic ExampleMySQL iotopWhy Use a New

Read More »

MySQL Shell: Built-In Help

Table Of Contents BackgroundExample Custom ReportThe Report FunctionRegistering the ReportTesting the ReportThe shell.reports ObjectBuilt-In FeaturesThe \show CommandThe Query ReportThe \watch CommandConclusionSetupMySQL ShellEvents – InteractiveEvents – FunctionProcedures and Functions – InteractiveFunctions and Procedures – FunctionMySQL Connector/PythonBasic ExampleMySQL iotopWhy Use a New

Read More »

MySQL Shell: Using External Python Modules

Table Of Contents BackgroundExample Custom ReportThe Report FunctionRegistering the ReportTesting the ReportThe shell.reports ObjectBuilt-In FeaturesThe \show CommandThe Query ReportThe \watch CommandConclusionSetupMySQL ShellEvents – InteractiveEvents – FunctionProcedures and Functions – InteractiveFunctions and Procedures – FunctionMySQL Connector/PythonBasic ExampleMySQL iotopWhy Use a New

Read More »

Configuring the MySQL Shell Prompt

Table Of Contents BackgroundExample Custom ReportThe Report FunctionRegistering the ReportTesting the ReportThe shell.reports ObjectBuilt-In FeaturesThe \show CommandThe Query ReportThe \watch CommandConclusionSetupMySQL ShellEvents – InteractiveEvents – FunctionProcedures and Functions – InteractiveFunctions and Procedures – FunctionMySQL Connector/PythonBasic ExampleMySQL iotopWhy Use a New

Read More »