O'Reilly logo

MySQL Management and Administration with Navicat by Gokhan Ozar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

This appendix provided us with some additional tips and tricks, such as how to backup or transfer our Navicat settings. What's more? We have unraveled some more hidden features of Navicat (such as the Server Monitor), which not only give us detailed information about running processes, such as the client user information and command type run by the connected user, but full control to manually terminate processes as well. We also saw how to get other detailed information, such as server variables and server statuses, using this powerful tool.

Lastly, we have seen a search feature that enables us to retrieve specific records from any table containing the searched string and automatically generates a SQL query, which can be reused to perform ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required