Hints on import big sql 50GB above to MariaDB or MySQL

Access to MySQL

You have to be root to set those settings

# mysql -u root -p

Maximize all Buffer and Packet

Set network buffer length to a large byte number and set maximum allowed packet size to a large byte number

set global net_buffer_length=1048576;
set global max_allowed_packet=1073741824;
SET foreign_key_checks = 0;
SET UNIQUE_CHECKS = 0;
SET AUTOCOMMIT = 0;

Import your SQL file

Import your sql dump file, you can import more than one file

source file-to-import.sql;

Set back to default

Remember to enable foreign key checks when procedure is complete!

SET foreign_key_checks = 1;
SET UNIQUE_CHECKS = 1;
SET AUTOCOMMIT = 1;

Tags:

Leave a Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.