1. Method 1: Select the list of tables you want to export

Step 1: Right click on ‘database ‘–> select’ Data Transfer ‘, as shown below:

Step 2: Fill in the corresponding information and start (note: export is: table structure and data)

supplement: If you just want to export the table structure, uncheck the ‘advanced’ insert record check box

  1. The demo. SQL file is imported in the Mysql black window in Linux
mysql>source /tmp/demo.sql;
Copy the code
  1. Another way to export: select the table to export > dump the SQL file >01. Structure and Data / 02. Structure only

Summary: 1. If there are 500 tables in the database, only 485 tables with specific selection are exported. 2. Export only a few tables.

If you feel good, order a zan