I import large files through mysql but it doesn't work

webstuff

Well-Known Member
Jul 19, 2011
76
2
58
I have a 3 gig sql file. that I uploaded to a cpanel account.. When i run - mysql -u #username# -p #database# < #dump_file# it works fine.. then half way through it just stops...


maybe? -

Then I come back hours later and my putty program says network error... Is there some sort of ssh timeout? I noticed if I walk away or leave it run for so long after not touching it closes... And I am wondering if this is the cause the why my sql doesn't upload completely because everytime I get the network popup it stops moving the files into the sql...

If it helps any... I know the dump files are good too...
 
Last edited:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,908
2,218
463
Hello :)

If you are receiving a network error message and are disconnected from your SSH session, you should try running the command in "screen":

Screen

This utility will allow you to run the command in a screen session and not have to remain logged into the server.

Thank you.