Navicat MySQL Export data in bulk INSERT form

This is the advanced settings for MySQL same server type data transfer

When you select a database, right-click Dump SQL file the default export record format is a strip of the "full insert statement" in the following format

INSERT  into' User ' (' ID number ', ' username ', ' age ')VALUES('1','Liang Mingjie',' at');INSERT  into' User ' (' ID number ', ' username ', ' age ')VALUES('2','Herman Ann',' About'); INSERT  into' User ' (' ID number ', ' username ', ' age ')VALUES('0','Xu Qin',' at');

This format guarantees compatibility, but it sacrifices performance. The server uses the source import, simply turtle speed.

This can be a lot quicker if you export the following format:

INSERT  into' User 'VALUES('1','Liang Mingjie',' at'), ('2','Herman Ann',' About'), ('0','Xu Qin',' at');

This format is called the "extended INSERT statement" using the following,

When the database is selected, right-"data transfer"-Select Export as File

Click "Advanced"-tick "insert statement with extensions" (You can also tick "use transaction" if necessary)

Navicat MySQL Export data in bulk INSERT form