Encrypted my db?!? I didn't do that..

Hi Aleksander,

Your English is very good!

If you look at the code in UD for where the database encryption is done – the function UpdraftPlus_Backup::encrypt_file() which you can read at http://plugins.svn.wordpress.org/updraftplus/tags/1.8.12/backup.php – then it reads like this:

public function encrypt_file($file) {
global $updraftplus;
$encryption = UpdraftPlus_Options::get_updraft_option(‘updraft_encryptionphrase’);
if (strlen($encryption) > 0) {
// Do encryption stuff and return path of encrypted file, using $encryption as the encryption key
} else {
// Do nothing – just return path of unencrypted file
}
}

So, the only way that encryption can get done is if the option ‘updraft_encryptionphrase’ is set in your WP options database – and that option comes directly from the corresponding field on the UD settings page. That option is then used as the encryption key. If that option is empty, then the encryption code is by-passed.

So, if your database is encrypted, then that field must have been non-empty. Are you sure you don’t have another copy of the database somewhere, whether in a MySQL server, or in an SQL dump? Or in MySQL transaction logs? You only need to locate the value of that one field; then you can use it to decrypt your encrypted file. There’s no “back-door” for the encryption, so you do need to find the key from somewhere.

David

Hi Aleksander,

As SQL is mostly text, just a simple search for ‘updraft_encryptionphrase’ should suffice.

David

Phew!

You’re welcome!

The digital equivalent of a kiss can be given at http://updraftplus.com/shop/ . 😉

Best wishes,
David