Navicat for MySQL export data pit

Navicat you choose to dump the structure and data, the resulting SQL file will be larger, because each piece of data will generate an SQL statement, it will cause the use of source restore will be very slow slow very slow,

Files that are exported using mysqldump are bulk-inserted when restored using source.

The difference is that if you have 1w data, the files exported with Navicat will be inserted 1w times, while mysqldump may only be needed once.

Navicat for MySQL export data pit