How to decrypt a data dump
Answer ID 2825   |   Last Review Date 11/13/2017

What are the instructions for a customer to decrypt a data dump we send them?

Environment:

Decrypt, Data Export

Resolution:

Your Data Export is delivered in a standard MySQL export format.

You can request a Data Export as well as other Oracle Consulting engagements by contacting your Sales Account Manager. They will be available to answer any questions you may have.

If you have had a Data Export performed and are in possession of the Data Export URL and passphrase please see decryption instructions below.

If you do not have the technical ability to parse or understand your Data in the format provided, please contact your Sales Account Manager and they can engage you with our Oracle Consulting group.

GPG Decryption How to:

  1. Download decryption software such as GPG4Win
    a. http://www.gpg4win.org/download.html
    b. Download the latest stable version
  2. Install GPG4Win (May require a system restart)
  3. Open GPG4Win (called Kleopatra)
  4. Click on File > Decrypt/Verify Files, navigate to your .gpg file.  
    1. This will ask for your passphrase. Enter the passphrase provided by Oracle RightNow and choose the directory where you would like your files unzipped.
      Hints:
      1. Be absolutely sure you enter the correct passphrase. If you are not sure of any of the characters in the passphrase cut and paste the character into a text editor and change the font. This may help to make any ambiguous characters clear.
      2. Be sure to unzip the directory to a secure location with enough storage space. Data Exports are very large files.
      3. If the unzipped folder appears empty, be sure to uncheck "Input file is an archive; unpack with: " in GPG4Win (Kleopatra)


A successful Data Export and extraction will result in several files in SQL format. The steps required to migrate data from one database to another will require a Database Administrator. Our Oracle Consulting groups are happy to help if you require assistance. 

An SQL file can be opened with a program such as Notepad++ or Notepad. 

Would you like help collecting this information?

Yes, let's chat!

Viewing our site using a mobile device? Our mobile pages are just a tap away.

View site in: Desktop | Mobile