The method for accelerating MySQL import and export the SQL statement exported by MySQL may be very slow during import. It may take several hours to import millions of data records. Using a few parameters properly during export can greatly speed up the import. -E use the multi-row INSERT syntax, provide a more compact and faster insert statement -- max_allowed_packet = maximum size of the cache for communications between the XXX client/server -- net_buffer_length = XXX TCP/IP and socket communication buffer size max_allowed_packet and net_buffer_length cannot be compared the Set Value of the target database is large, otherwise, an error may occur. First, determine the parameter value of the target database: SQL code mysql> show variables like 'max _ allowed_packet '; mysql> show variables like 'net _ buffer_length'; write the mysqldump Command Based on the parameter value: SQL code mysqldump-uroot-proot eric-e -- max_allowed_packet = 1048576 -- net_buffer_length = 16384> eric. SQL