Discussion:
lost server connection
(too old to reply)
v***@at.BioStrategist.dot.dot.com
2020-02-24 02:32:47 UTC
Permalink
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.}---
J.O. Aho
2020-02-24 05:46:09 UTC
Permalink
Post by v***@at.BioStrategist.dot.dot.com
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
v***@at.BioStrategist.dot.dot.com
2020-02-24 09:13:17 UTC
Permalink
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.}---
v***@at.BioStrategist.dot.dot.com
2020-02-24 09:38:26 UTC
Permalink
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.}---
J.O. Aho
2020-02-24 17:35:31 UTC
Permalink
Post by v***@at.BioStrategist.dot.dot.com
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.
Post by v***@at.BioStrategist.dot.dot.com
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
Axel Schwenke
2020-02-24 09:39:00 UTC
Permalink
Post by v***@at.BioStrategist.dot.dot.com
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.
Post by v***@at.BioStrategist.dot.dot.com
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.
Post by v***@at.BioStrategist.dot.dot.com
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.
v***@at.BioStrategist.dot.dot.com
2020-02-25 00:49:41 UTC
Permalink
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.}---
v***@at.BioStrategist.dot.dot.com
2020-02-25 01:27:17 UTC
Permalink
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.}---
v***@at.BioStrategist.dot.dot.com
2020-02-25 03:20:04 UTC
Permalink
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.}---
Continue reading on narkive:
Loading...