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.
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.