Jeff Pflueger <[EMAIL PROTECTED]> 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
