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

Chapter 3. Data Management with Navicat

In the past, some of us would work with a database and its contents the hard way, typing commands in a console window or using primitive GUI tools with limited functionality. When it came to migrating a database from one server to another or even a simple restore from a backup, such stunts could become tedious tasks. In this chapter, we will see how easy and less time-consuming it is to perform all these tasks with Navicat.

Also, we will manipulate big chunks of data using Navicat's sophisticated tools, and you will learn how to:

  • Import and export data using a variety of formats, such as XML, Excel files, .csv, and .sql
  • Direct data transfer between different databases
  • Synchronize data and structure
  • Back up a ...

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