MySQL Management and Administration with Navicat

图书信息

作者	G?khan Ozar
出版社	Packt Publishing
ISBN	9781849687478
出版时间	2012-09-13
字数	40.5万
分类	进口书,外文原版书,电脑,网络

读书简介

Standard Mini. This book is written for MySQL Users, Developers, and admins who want to discover just how easy Navicat makes even normally arduous tasks.

目录

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