On small droplet, i have to import 30mb, 100mb, 1gb, 9gb tens of sql files.
mysql -u user -p db < file.sql
Even in small file i got error “max_allowed_packet”. After updating max_allowed_packet to bigger, this time i got “lost connection to mysql server during query” error. And decided to resize a bigger (4gb ram) droplet. In new droplet i could import small to 1gb files. After a break, now again i get same error.
Thanks
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Hello,
It sounds like that the server is running out of RAM.
You could try adding a swap file as described here so that you could have some additional buffer:
https://www.digitalocean.com/community/tutorials/how-to-add-swap-space-on-ubuntu-16-04
Also, you could try tweaking your MySQL configuration for better performance and reliability as described here:
https://www.digitalocean.com/community/questions/how-to-tweak-mysql-mariadb-configuration-for-increased-performance-and-stability
Best,
Bobby