MySQL database import, export, data transfer

Import and export between Navicat databases
1. Double-click the database you want to export, right-click the dump SQL file ..., select the folder you want to save.

　　　　
2. Click Start to start exporting.

　　
Database Import
1. Create a new database, the name of the database must be the same as the imported database file.

　　
2. Right-click on the new database and select Run SQL file ...

　　　　
3. Fill in the file with the file you want to import. You can import it next.

Copy the server database to the local database, navicat the server-side database, the local database,
You can use the method above. Another way to do this: data transfer
1> a database with the same name as the server-side database is built locally
2> Select the database connected to the server in Navicat, select the tool in the menu bar and transfer data
3> in the popup window "source" section is the source database you want to export, "target" is the local database, click on the bottom left corner Select All, then click the Start button

　　
Click OK

　　
The last finished-successfully means the transmission is successful! Click Close

　　

Look at the local database and the data and structure in the server-side database have been imported into the local database.

MySQL database import, export, data transfer