From MySQL Shell 8.0.24, it’s possible to log all the SQL statements issued in MySQL Shell. Everything is well documented in the dedicated manual section: System Logging for SQL Statements. Let’s see it in action. We will first start MySQL…
Recently I posted an article on how to deal with arrays when trying to use MySQL Shell Dump Utility in command line. Of course, this proposed solution was a workaround for MySQL Shell <= 8.0.23. The new version of MySQL…
MySQL 8.0.24 has been released today \o/ As usual, it’s highly advised to read the release notes to get informed about the changes and bug fixed. MySQL is Open Source and each release contains contributions from our great Community. Let…
Another common question I receive about MySQL Shell Dump & Load Utility is how to dump a schema and load it with another name. Make a copy in fact. Dumping the Schema To do so, we need to use the…
As you know, the best way to perform logical dump for MySQL is to use MySQL Shell Dump & Load utilities. This is the most powerful option as it can dump and load in parallel (it also include many options…
As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.
You can find articles I wrote on Oracle’s blog.