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

Performing maintenance tasks with Navicat

Navicat provides a set of graphical tools for database and table maintenance tasks, which are in fact native MySQL services. Toward this end, Navicat supports four major tasks, which can be performed on MySQL database tables:

  • Analysis
  • Check
  • Optimization
  • Repairs

When this book was being authored, Navicat did not have a special menu (in the menu bar) or a button for triggering these tasks. Basically, you need to have switched to Table or View in Navicat's main window and right-clicked on a table or view on which you want to perform one of these tasks. Then, from the pop-up menu select Maintain, and then select the related task as the sub-menu item. Now, let's take a closer look at what these tasks are and what ...

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