i have exported sql file using mysql dump from a database and i am trying to import this big 5gb file into anohter mysql database. I am using mysql -u username -p -h hostname <file.sql command however getting error after some time.
error : ERROR 2013 (HY000) at line 6950: Lost connection to MySQL server during query
i have added max_allowed_packet =1g and connect_timeout however still not able to import the big file.
If any one can share something that would be great :)