Import. sql files with Navicat for MySQL

1. Export 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; "src=" Https://s3.51cto.com/wyfs02/M01/08/38/wKiom1neKQTT3jdaAAFwdspttjY232.png "title=" 5_v} A4_issiff4$nx]m5}~n.png "alt=" Wkiom1nekqtt3jdaaafwdspttjy232.png "/>

Then, a Save box will pop up where you choose to save, select a good location, click OK, OK

2. Import the database:

Open Navicat for MySQL, then right-click to select New database with the same name as the data we want to import.

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M01/A6/EA/wKioL1ndumrgy7USAACo4ddrCXU961.png "title=" 4) 4[( 7f8 (35a9@58ds '%oq9.png "alt=" Wkiol1ndumrgy7usaaco4ddrcxu961.png "/>

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 "..." to select the path of the file

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M00/08/38/wKiom1neKh-jje1oAAD5uO6x6Y4092.png "title=" E{vi ( Qej1g[s2y9ih3xqbg1.png "alt=" Wkiom1nekh-jje1oaad5uo6x6y4092.png "/>

Click Start, the file will be imported successfully!

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M01/08/38/wKiom1neKmPy6s3sAAC7nSMQFAc401.png "title=" tyt4ls4r{ugp_6%) w_zuq$f.png "alt=" Wkiom1nekmpy6s3saac7nsmqfac401.png "/>

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 the "11854647" blog, please be sure to keep this source http://11864647.blog.51cto.com/11854647/1971429

Import. sql files with Navicat for MySQL