How MySQL uses Navicat to export and import databases

MySQL is the data we often use, whether it's for developers to practice, a small server, or personal software. To do some personal assistant software, choose MySQL Database is a wise choice, have a good tool is more than the multiplier, for MySQL IDE I recommend navicat for MySQL, now I will show you how to use Navicat for MySQL export and import data.

To export a database:

Open the Navicat, right-click on the data we want to go around, then click "Dump SQL File" on the shortcut menu that pops up, and select the first "data and Structure" in the submenu item that pops up again. 650) this.width=650; "style=" float:none;margin:0px auto 0px 54px; "src=" http://hiphotos.baidu.com/exp/pic/item/ 6f4703950a7b02087563fe6160d9f2d3562cc84d.jpg "class=" Pic-cursor-pointer "height=" 309 "width=" "alt=" 6f4703950a7b02087563fe6160d9f2d3562cc84d "/>

Then, a Save box will pop up a selection save location, select a good location, click OK, OK 650) this.width=650; "style=" float:none;margin:0px auto 0px 101px; "src="/HTTP/ Hiphotos.baidu.com/exp/pic/item/3790312eb9389b50200f20d28735e5dde6116e7b.jpg "class=" Pic-cursor-pointer "height= "348" width= "406" alt= "3790312eb9389b50200f20d28735e5dde6116e7b"/>

Import Database:

Open Navicat for MySQL, then right-click to select New Database, the name is the same as the name of the data we want to import 650) this.width=650; "style=" float:none;margin:0px auto 0px 76px; " Src= "Http://hiphotos.baidu.com/exp/pic/item/b8405490f603738d4658cea2b11bb051f919ece6.jpg" class= " Pic-cursor-pointer "height=" 398 "width=" 456 "alt=" B8405490f603738d4658cea2b11bb051f919ece6 "/>

After clicking OK, we can see the data that we have just established on the left, then right click to select "Run SQL File" will pop up a box, click "..." Select the path of the file, 650) this.width=650; "Style=" float:none; margin:0px auto 0px 96px; "src=" http://hiphotos.baidu.com/exp/pic/item/ Dc15484e9258d1093e8f6432d358ccbf6d814d87.jpg "class=" Pic-cursor-pointer "height=" 358 "width=" 416 "alt=" Dc15484e9258d1093e8f6432d358ccbf6d814d87 "/>

Click Start, the file will be imported successfully! 650) this.width=650; "style=" float:none;margin:0px auto 0px 54px; "src=" http://hiphotos.baidu.com/exp/pic/item/ 0b14ad19ebc4b745a61b7a96cdfc1e178b821560.jpg "class=" Pic-cursor-pointer "height=" 375 "width=" "alt=" 0b14ad19ebc4b745a61b7a96cdfc1e178b821560 "/>

Strictly speaking, navicat for MySQL does not export the database, but the data and structure of all the tables in the database. So, if you do not set up the corresponding database, instead of looking for a data import, the result is that the database has a few more tables just imported.

This article is from "Ghost" blog, please make sure to keep this source http://caizi.blog.51cto.com/5234706/1562553

How MySQL uses Navicat to export and import databases