how to import very large sql file into mysql?

Question

I have a 220GB SQL file. I have to import this into the 355GB Ubuntu MySQL server. There is not enough capacity to import directly from the MySQL server. So I tried to do a remote import from the window with the SQL file. However, it failed several times. I then try to import the 220GB file by a split, but the file size is too big for me. How can I solve this problem? Is division really the answer?

DataVader · Accepted Answer · 2018-08-20 08:24:20Z

1

Did you try opening the command line and doing the following?

mysql -u root -p
set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;
SET foreign_key_checks = 0;
source file.sql
SET foreign_key_checks = 1

answered Aug 20, 2018 at 8:24

DataVader

7801 gold badge6 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Ghun Kim Over a year ago

The SQL file is on the remote server. Can I import the command directly from the remote server? ..with ssh

DataVader Over a year ago

Yeah but you need to edit the command in the first line: mysql -u{user} -h{hostname} -P{PORT} -p{password} And yes, the command really is like this. So a command like 'mysql -uroot -hlocalhost...' would be correct

Ghun Kim Over a year ago

Thank you very much. I solved the problem because of you. After I try, in fact, the problem was very simple. so I bless you

Collectives™ on Stack Overflow

how to import very large sql file into mysql?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related