PacktLib: MySQL Management and Administration with Navicat

MySQL Management and Administration with Navicat

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

Getting Started

Enter Navicat

Setting up a connection to the database

Setting up Secure Sockets Layer (SSL)

Summary

Working with Databases

Managing database objects with Navicat

Creating a database from scratch

Entering data in tables

Creating views

Working with functions and procedures

Using Navicat’s event designer for MySQL

Working with queries in Navicat

Summary

Data Management with Navicat

Working with an existing database

Importing and exporting data

Direct data transfer between two databases

Data and structure synchronization

Backup and restore

Creating and scheduling batch jobs

Summary

Data Modeling with Navicat

Working with Navicat's model designer

Exporting the model diagram to SQL

Reverse-engineering a database into a model

Summary

Database Maintenance and Security Management

User and privilege management with Navicat

Performing maintenance tasks with Navicat

Summary

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

Additional Tips and Tricks

Additional Tips and Tricks

Additional Tips and Tricks

Additional Tips and Tricks

Additional Tips and Tricks