MySQL Management and Administration with Navicat -- Table of Contents -- MySQL Management and Administration with Navicat -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers, and more -- Why Subscribe? -- Free Access for Packt account holders -- Instant Updates on New Packt Books -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Errata -- Piracy -- Questions -- 1. Getting Started -- Enter Navicat -- Setting up a connection to the database -- Connecting via Secure Shell (SSH) -- Connecting via an HTTP tunnel -- Setting up Secure Sockets Layer (SSL) -- Advanced settings -- Testing and saving your settings -- Summary -- 2. Working with Databases -- Managing database objects with Navicat -- Creating a database from scratch -- Creating tables -- Defining foreign keys -- Defining triggers -- Entering data in tables -- Creating views -- Working with functions and procedures -- Using Navicat's event designer for MySQL -- Working with queries in Navicat -- Designing the Query -- Building further queries -- Summary -- 3. Data Management with Navicat -- Working with an existing database -- Creating the database schema from a SQL dump file -- Importing and exporting data -- Exporting in detail -- Importing a file into a table -- Direct data transfer between two databases -- Data and structure synchronization -- Backup and restore -- Creating and scheduling batch jobs -- Summary -- 4. Data Modeling with Navicat -- Working with Navicat's model designer -- Creating our first model -- Defining the relationships -- Adding some pizzazz to the model with notes and images -- Working with layers -- Deleting unwanted objects -- Working with multiple diagrams -- Exporting the model diagram to SQL.

Reverse-engineering a database into a model -- Summary -- 5. Database Maintenance and Security Management -- User and privilege management with Navicat -- How MySQL deals with access privileges -- Diving deep into creating and editing a user in Navicat -- Performing maintenance tasks with Navicat -- Analyzing a MySQL table or view with Navicat -- Checking a table or view -- Optimization made easy -- Repairing a table -- Summary -- 6. Designing Reports with Navicat -- First contact with the tool(s) -- Preparing the data with Query Wizard -- Designing the report -- Switching to the Preview tab -- Summary -- A. Additional Tips and Tricks -- Transferring your settings from one computer to another -- Transferring settings on the Mac -- Transferring settings on Windows -- Monitoring the MySQL Server -- The process list -- Variables -- Status -- Revealing a hidden search feature of Navicat -- Summary -- Index.