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
