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)