Dear Jeremy, Gregor
Thanks and sorry for not being more specific.
First of all we use an ISP who runs a Unix server. They won't give us ssh
without a dedicate server - too expensive for us.
Then we use Windows clients (95, 98) not on a network.
We transfer the data down a phone line from the server -> client and from
client - > server.
Thanks for suggesting cron - can you tell me what it is?
Regards
Elizabeth
-----Original Message-----
From: Jeremy Falcon <[EMAIL PROTECTED]>
To: Elizabeth Alderton <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
<[EMAIL PROTECTED]>
Date: 22 August 2001 20:26
Subject: Re: Encryption of Data
>What do you mean by "bring data down?" Would this be over a network? If
>so, what OS would the other machine be running? I'll assume it's Unix
>because that's my favorite. Seeing that mysql prints to STDOUT you could
>write a script to interface with MySQL, get the output, encrypt it, and
then
>send it across the line.
>
>Your application could send encrypted data to the server. For security
>reasons I wouldn't suggest trying to pull off some Telnet/SSH schema to run
>a script from your program. I'd use something like cron to run the script
>at intervals to import what you uploaded. The script could then decrypt
the
>data and run mysql to send it whatever.
>
>If you are looking for a more specific solution, then be more detailed in
>your question.
>
>Cheers,
>
>Jeremy
>
>----- Original Message -----
>From: "Elizabeth Alderton" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Wednesday, August 22, 2001 10:00 AM
>Subject: Encryption of Data
>
>
>If I do a SELECT query to bring data down to a PC (this is being done
>through Delphi) how can I encrypt the data so that it comes safely?
>
>Equally when doing UPDATE and INSERT in the other direction I would want to
>encrypt the data.
>
>Can anyone help please?
>
>Regards
>
>Elizabeth
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
