M
M
MasterCopipaster2021-08-21 07:33:12
MySQL
MasterCopipaster, 2021-08-21 07:33:12

Terminal close -- query aborted when uploading a dump how to win?

Listen - I'm trying to upload a large 5GB dump using this command:

nohup mysql -u root < dump.sql &

But I keep getting an error:
Terminal close -- query aborted

When importing other dumps, the same problem. Everything that I found on the first page of Google does not solve the problem, and the question does not google very well at all. Tell me what to do?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
Saboteur, 2021-08-21
@MasterCopipaster

What about limits in mysqld?
net_read_timeout = ???
net_write_timeout=???
max_allowed_packet=???
bulk_insert_buffer_size=???

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question