import large sql dump file to Mysql Database from CLI

danang setya pramana August 2, 2024 0 Comments

mysql.exe -u root set global net_buffer_length=1000000; set global max_allowed_packet=1000000000; SET foreign_key_checks = 0; SET UNIQUE_CHECKS = 0; SET AUTOCOMMIT = 0; source /home/user/dbdump150113.sql after restore remember to return default setting…