The SQL statement exported by MySQL may be very slow during import. Using several parameters properly during export can greatly speed up the import.
-E uses the multiline INSERT syntax that includes several VALUES lists;
-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, create a line with the length up to net_buffer_length.
Note: max_allowed_packet and net_buffer_length cannot be greater than the set value of the target database. Otherwise, an error may occur.
First, determine the parameter value of the target database.
Mysql> show variables like 'max _ allowed_packet ';
Mysql> show variables like 'net _ buffer_length ';
Write the mysqldump Command Based on the parameter value, for example:
# Mysqldump-uroot-p dbname-e -- max_allowed_packet = 16777216 -- net_buffer_length = 16384> db_name. SQL
OK, now the speed is very fast. Note that the max_allowed_packet and net_buffer_length parameter values of the Import and Export end are set to a greater value.