MySQL import on hundreds of megabytes of SQL processing

I am using the mysql5.6 version

One

SET GLOBAL max_allowed_packet = 500*1024*1024; Maximum size of the buffer between client/server communication;
Set global net_buffer_length=100000; TCP/IP and socket communication buffer size, creating a line of length up to Net_buffer_length
SET GLOBAL interactive_timeout=28800 000; Effective for subsequent interactive links;
SET GLOBAL wait_timeout=28800000//is valid for the current interactive link;

Show VARIABLES like '%max_allowed_packet% ';

See if you've adjusted the values later

Second, log on to the MySQL server

mysql-uroot-p xxx

After login

SOURCE Xx.sql

Or

Mysql-u User name-p password database name < database name. sql
#mysql-UROOT-P ABC < Abc.sql

200M of SQL 30-60s execution completed

MySQL import on hundreds of megabytes of SQL processing