database SQLCipher key location

  • Hi

    I have a digitalocean droplet, basically a vm running ubuntu 20.04 with wordpress. I entered ssh and downloaded the wordpress database by using mysqldump -u root -p wordpress > db.sql and downloaded it using sftp into my local machine. But then I cannot open the database using db browser for sqlite application as it asks me for SQLCipher encryption key as in picture. What’s interesting is that I can open the database file using notepad editor and the words are not gibberish/encrypted. I don’t know if here is the right place to ask this but I gladly thank you for all your help.

    https://ibb.co/9rKVHnX – the prompt in db browser
    https://ibb.co/94sWZwV – can just open it in editor and looks unencrypted

    Thanks.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator Yui

    (@fierevere)

    永子

    MySQL dumps are completely different format with SQLite database format.

    You can view them as plain text in any text viewer or editor, but to see it as database you will have to import it into a running MySQL database server instance and view them in PHPMyAdmin or other application which can access MySQL

    Thread Starter runcit

    (@runcit)

    Thanks a lot Yui.

    I will proceed with the suggestions given.

    Thread Starter runcit

    (@runcit)

    I managed to view the database and its tables, by following the guide as suggested by Yui.

    I created an empty database in MySQL and from there, I imported the dump file into the database. At first there is an error then I searched around an tried the solution by Rangel at https://stackoverflow.com/questions/29916610/1273-unknown-collation-utf8mb4-unicode-ci-cpanel, and it works right now!

    Thanks Yui and have a nice day!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘database SQLCipher key location’ is closed to new replies.