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