so glad you worked that out , man!
:-)~MIKE~(-:
On Tue, Nov 4, 2014 at 1:17 PM, Keith Smith <
techlists@phpcoderusa.com>
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
>>
>> <ctrl>-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
---------------------------------------------------
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
(text/plain)