Hi, Is it totally possible that when dumping a db to a text file with mysqldump that any encrypted stuff in the tables will be "lost"? when I mean lost I mean that it isnt the same in a text file as it is when it was originally encrypted. I have a problem with creating a table with encrypted passwords with md5, dumping it to a text file with mysqldump and then running that script on a different server. For some strange reason the encrypted passwords lose their encrypted state and are nothing more now than text strings. Is there any way to preserve the state of md5 encrypted fields when doing a mysqldump?
