How do you encrypt data while performing a mysqldump?

My OS is windows 7.

• How can I encrypt data while performing a mysqldump?

• From the command prompt, can I take a mysqldump with encrypted varchar and texts values?

Please help me.

Thanks

You can use ccrypt. Example:

-
Creating the key file:

echo 'mySecretKey123' > ~/.backup.key
chmod 600 ~/.backup.key

-
Encrypting the backup:

mysqldump databasename | ccrypt -k ~/.backup.key | bzip -c > ~/backup-mysql.sql.bz2.cpt

-
To decrypt the backup:

cat ~/backup-mysql.sql.bz2.cpt | ccat -k ~/.backup.key | bunzip2 -c | less

StackExchange Database Administrators Q#5831, answer score: 7