Navicat for MySQL Import Export data table database

1. Export Data Sheet

Unicom

, right-click the table you want to export, select Dump SQL File

The following option is to export only the data table structure, no data

The above options contain data, along with the table structure, with the data exported together

2. Importing Data Sheets

Select the database, right click Enter, select Excute SQL file, automatically pop up the file selection list, find the desired file, import it

3. Export the database

The operation is similar to the exported data table, but this part becomes the right-click Database to operate.

4. Import the database

Strictly speaking, the exported database file is just a bunch of table structure relationships, the import database file is essentially the introduction of these tables, operating in the same way as the Import data table.

First, create a new database with the name consistent with the database name you want

This is followed by repeated import of the data table.

In this case, select the database file you want to import, which is actually the parameters and data of the table in the database.

Navicat for MySQL Import Export data table database