How to encrypt data while we take mysqldump?
I need to encrypt data while we take mysqldump from database through command prompt. My OS is windows7. Plea开发者_如何转开发se help me.
Can't you just pipe the dump output directly though your encryption tool?
ie:
mysqldump mydb | some-encryption-tool.sh
btw, the only reason I suggested piping directly through an encryption tool is to the (unsafe) plain-text version never exists on disk, which is the only interpretation of the question that makes sense. Otherwise, just save the dump to a file and encrypt it - there is nothing to "answer".
精彩评论