• lost server connection

    From vjp2.at@at.BioStrategist.dot.dot.co@21:1/5 to All on Mon Feb 24 02:32:47 2020
    I am using an external USB disk

    Is this why I lost the server?

    Previous times I loaded earlier versions of same data
    I never had a problem



    - = -
    Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus
    blog: panix.com/~vjp2/ruminatn.htm - = - web: panix.com/~vjp2/vasos.htm
    facebook.com/vasjpan2 - linkedin.com/in/vasjpan02 - biostrategist.com
    ---{Nothing herein constitutes advice. Everything fully disclaimed.}---

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From J.O. Aho@21:1/5 to vjp2.at@at.BioStrategist.dot.dot.co on Mon Feb 24 06:46:09 2020
    On 24/02/2020 03.32, vjp2.at@at.BioStrategist.dot.dot.com wrote:
    I am using an external USB disk

    Is this why I lost the server?

    Previous times I loaded earlier versions of same data
    I never had a problem

    If you have the mysql database on the external storage and it's not
    mounted when you start the mysql database, it wouldn't work.

    As we ain't mind readers, so we don't know how your setup looks like, so
    we can't really answer your question with anything else than wild guesses.

    --

    //Aho

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From vjp2.at@at.BioStrategist.dot.dot.co@21:1/5 to All on Mon Feb 24 09:13:17 2020
    It loaded three of sixteen files and then lost the server.

    (I cut the file into sixteen pieces because it is too big.)

    Either it was the USB drive or the PC went to sleep.

    I KVM'd to another PC to keep from disturbing it but it did start the screen saver a few times.

    Maybe it wudda been better to stay on the MySQl machine and play video games
    to keep it awake?

    The only thing different from the other times I did this was putting the
    input file on the USB disk (not flash, USB hard dirve).
    It did seem to be slower. But I do this like annually so I can't be sure.


    - = -
    Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus
    blog: panix.com/~vjp2/ruminatn.htm - = - web: panix.com/~vjp2/vasos.htm
    facebook.com/vasjpan2 - linkedin.com/in/vasjpan02 - biostrategist.com
    ---{Nothing herein constitutes advice. Everything fully disclaimed.}---

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Axel Schwenke@21:1/5 to vjp2.at@at.BioStrategist.dot.dot.co on Mon Feb 24 10:39:00 2020
    On 24.02.2020 10:13, vjp2.at@at.BioStrategist.dot.dot.com wrote:
    It loaded three of sixteen files and then lost the server.
    (I cut the file into sixteen pieces because it is too big.)
    Either it was the USB drive or the PC went to sleep.

    This makes not much sense. None of it.

    I KVM'd to another PC to keep from disturbing it but it did start the screen saver a few times.

    Maybe it wudda been better to stay on the MySQl machine and play video games to keep it awake?

    If you put a MySQL server onto a machine, then you must not allow this
    machine to go to sleep on it's own account. The whole point of a database *server* is, that it is always available. And of course you would lose the connection to the MySQL server, once the machine it runs on goes down.

    The only thing different from the other times I did this was putting the input file on the USB disk (not flash, USB hard dirve).
    It did seem to be slower. But I do this like annually so I can't be sure.

    The MySQL server does not mind where the client gets it data from. Also if
    the USB drive would disconnect unexpectedly, you wouldn't get a "connection lost" error.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From vjp2.at@at.BioStrategist.dot.dot.co@21:1/5 to All on Mon Feb 24 09:38:26 2020
    Since I used slice.exe to cut the file up, the file can't be bigger than a
    year ago

    Is it possible that putting it on another drive made it ignore my.cnf settings.


    - = -
    Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus
    blog: panix.com/~vjp2/ruminatn.htm - = - web: panix.com/~vjp2/vasos.htm
    facebook.com/vasjpan2 - linkedin.com/in/vasjpan02 - biostrategist.com
    ---{Nothing herein constitutes advice. Everything fully disclaimed.}---

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From J.O. Aho@21:1/5 to vjp2.at@at.BioStrategist.dot.dot.co on Mon Feb 24 18:35:31 2020
    On 24/02/2020 10.38, vjp2.at@at.BioStrategist.dot.dot.com wrote:
    Since I used slice.exe to cut the file up, the file can't be bigger than a year ago

    If you are talking about the mysql data files, then it's no wonder it
    don't work.


    Is it possible that putting it on another drive made it ignore my.cnf settings.

    If's much possible that it don't find your configuration and that your configuration don't have the new location of the files.

    --

    //Aho

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From vjp2.at@at.BioStrategist.dot.dot.co@21:1/5 to All on Tue Feb 25 00:49:41 2020
    I just upped the SQL Editor prferences timeout from 600 sec to 777
    The ones that worked were under 600 sec


    Error Code: 2013. Lost connection to MySQL server during query




    - = -
    Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus
    blog: panix.com/~vjp2/ruminatn.htm - = - web: panix.com/~vjp2/vasos.htm
    facebook.com/vasjpan2 - linkedin.com/in/vasjpan02 - biostrategist.com
    ---{Nothing herein constitutes advice. Everything fully disclaimed.}---

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From vjp2.at@at.BioStrategist.dot.dot.co@21:1/5 to All on Tue Feb 25 01:27:17 2020
    I upped the query timeout but it still stops at the old limit
    but it still remmebered the new limit


    - = -
    Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus
    blog: panix.com/~vjp2/ruminatn.htm - = - web: panix.com/~vjp2/vasos.htm
    facebook.com/vasjpan2 - linkedin.com/in/vasjpan02 - biostrategist.com
    ---{Nothing herein constitutes advice. Everything fully disclaimed.}---

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From vjp2.at@at.BioStrategist.dot.dot.co@21:1/5 to All on Tue Feb 25 03:20:04 2020
    Got it

    Playing video games (Free Cell) kept the screen saver from coming on.

    So none of the file loads took over 600 sec.

    That and watching Star Trek reruns

    Phew!


    - = -
    Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus
    blog: panix.com/~vjp2/ruminatn.htm - = - web: panix.com/~vjp2/vasos.htm
    facebook.com/vasjpan2 - linkedin.com/in/vasjpan02 - biostrategist.com
    ---{Nothing herein constitutes advice. Everything fully disclaimed.}---

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)