Thanks!! Me too!! On 2014-11-04 17:23, Michael Havens wrote: > so glad you worked that out , man! > > :-)~MIKE~(-: > > On Tue, Nov 4, 2014 at 1:17 PM, Keith Smith > wrote: > >> Thank you to those of you who replied.  Interesting experience. >> >> I was uploading a data dump into MySql. My "Konsole" did not show >> any activity for about an hour and a half. Then I get the message >> "Write failed: Broken pipe". >> >> This morning I erased the database I had uploaded last night >> because there was no way to tell if the import was complete. >> >> The import was about 600MB. >> >> Last night I had added "ServerAliveInterval 5" to my sshd config. >> >> This morning when I did the upload it took about 3 minutes. It >> looks like all the data is there.  That means my shell must have >> been hung for well over an hour. >> >> Thanks again for all the ideas and feedback!! >> >> Keith >> >> On 2014-11-04 10:40, der.hans wrote: >> Am 04. Nov, 2014 schwätzte Keith Smith so: >> >> moin moin Keith, >> >> Last night I shelled into a web server I am working on and issue >> the command to upload data into MySql from the command line.  The >> process took about an hour and a half. >> >> Then I received the message "Write failed: Broken pipe".  In >> researching, apparently sshd timed out. >> >> I'm guessing the process completed...  But how would I know? >> >> Check MySQL to see if all of the data loaded. >> >> The ssh connection was killed, so you don't know how the shell did. >> >> If you need to run long commands on remote systems, use screen or >> tmux on >> the remote system. That will keep the shell running even if the >> network >> connection is killed. It also allows you to reconnect to the shell. >> >> screen -S mysession # Start a screen session named mysession >> screen -x mysession # reconnect to the screen session named >> mysession >> >> -a d # disconnect from an active screen session >> >> If you already run screen locally you can either run screen within >> screen >> or you can start a new xterm, then connect out. >> >> I also recommend the ServerAliveInterval, but I set it to 5 >> minutes. I >> used that for all ssh connections. >> >> ServerAliveInterval 300 >> >> ciao, >> >> der.hans >> --------------------------------------------------- >> PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org >> To subscribe, unsubscribe, or to change your mail settings: >> http://lists.phxlinux.org/mailman/listinfo/plug-discuss [1] > > -- > Keith Smith > --------------------------------------------------- > PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org > To subscribe, unsubscribe, or to change your mail settings: > http://lists.phxlinux.org/mailman/listinfo/plug-discuss [1] > > > Links: > ------ > [1] http://lists.phxlinux.org/mailman/listinfo/plug-discuss > > --------------------------------------------------- > PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org > To subscribe, unsubscribe, or to change your mail settings: > http://lists.phxlinux.org/mailman/listinfo/plug-discuss -- Keith Smith --------------------------------------------------- PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org To subscribe, unsubscribe, or to change your mail settings: http://lists.phxlinux.org/mailman/listinfo/plug-discuss