更新时间：2021-08-05 19:03:14
coverpage
MySQL Management and Administration with Navicat
Credits
About the Author
About the Reviewers
www.PacktPub.com
Support files eBooks discount offers and more
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 1. Getting Started
Enter Navicat
Setting up a connection to the database
Setting up Secure Sockets Layer (SSL)
Summary
Chapter 2. 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
Chapter 3. 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
Chapter 4. Data Modeling with Navicat
Working with Navicat's model designer
Exporting the model diagram to SQL
Reverse-engineering a database into a model
Chapter 5. Database Maintenance and Security Management
User and privilege management with Navicat
Performing maintenance tasks with Navicat
Chapter 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
Appendix A. Additional Tips and Tricks
Transferring your settings from one computer to another
Monitoring the MySQL Server
Revealing a hidden search feature of Navicat
Index
