hi all,
i have a table that contains aes_encrypted data.
is there a STANDARD way to backup restore it or should i write some
php (or perl or whatelse) for doing this ?
I've tried export/import (via phpmyadmin) and sqldump, but the
restored data is corrupted.
Thank you !
:-)

cb wrote:

Firstly direct backup of the files themselves.

Secondly writing a script that duplicates the table, but sends the AES
data as hex encoded.

Finally, getting the raw data from encrypted or binary BLOB fields,
putting it in a temporary file, and using LOAD_FILE on it.

There may be others.

The Natural Philosopher <tnp (AT) invalid (DOT) invalid> wrote:
mysqldump --help
....
--hex-blob Dump binary strings (BINARY, VARBINARY, BLOB) in
hexadecimal format.

Not sure if phpmyadmin has such an option, but it's unsuitable for
reliable backups anyway.


XL

El 02/11/2010 12:37, cb escribió/wrote:
I don't think there's a special column type for encrypted data. I
presume you have a BLOB or BINARY column and your backup software does
not handle binary data properly. The mysqldump command line tool should
do it fine:

http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html


--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--

On Nov 2, 1:20*pm, "Álvaro G. Vicario"
<alvaro.NOSPAMTH... (AT) demogracia (DOT) com.invalid> wrote:
that's the point : my aes_encrypted field is "text"
thank you !

El 03/11/2010 8:28, cb escribió/wrote:
Well, as you already guessed, the function returns a binary string:

http://dev.mysql.com/doc/refman/5.1/...on_aes-encrypt



--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--