mysql server has gone away on large file import

Discussion in 'General' started by schwim, May 5, 2019.

  1. schwim

    schwim Member HowtoForge Supporter

    Hi there everyone!
    115mb file.
    I've also tried bigdump but the file is not compatible.

    I googled this error and wanted to try to extend the timeout and max packet size but oh my lord, I've gotten totally lost in all of the cnf files that are pointing to each other.or completely empty.

    Could someone tell me how to get mysql to allow for a large sql file import?

    Thanks for yoru time!
     
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    I have imported large files from command line just like your command, but as operating system root user. And used root user of MySQL.
     

Share This Page