SGreenunimin.com
Date: Mon Oct 03 2005 - 15:38:41 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Jeff Pflueger <jeffinfouse.com> wrote on 10/03/2005 03:46:09 PM:

> Hi,
> I need to encrypt data as I insert it into a mySQL database.
> The data will then be sent as a text file to another institution to be
> decrypted.
>
> I am using mySQL version 11.18 Distrib 3.23.58 for RedHat Linux.
>
> I cannot find a single encryption function in the documentation that
> seems to not create a syntax error for the version of mySQL I am using.
>
> I am also concerned because whatever encryption I am using needs to be
> decrypted outside of mySQL.
>
> Any suggestions?
>
> Thanks!
>

I don't expect a de-encryptor to be able to disentagle encrypted data from
the other file and record markers from outside of MySQL if you only send
them the data file. If you do send them the datafile (as-is), then they
will need a MySQL server to read the data. They will need to decrypt the
data on the client-side.

Did you mean to say that an EXTRACT of the data will be written to a text
file and encrypted before being sent to your other location? That may be a
better solution for transport security.

As another point of design.... why are you attempting to use the old,
decrepit 3.23 branch? At least upgrade to the 4.1 branch. You gain
encryption options and stability and lots of other improvements with the
move to the newer version.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]