SQL DB .Cyrpt Issue

  • Resolved gbyrne2011

    (@gbyrne2011)


    9 years, 9 months ago

    Hi all, wondering if you could assist with an issue I’m having.

    I backed up my site a while back and lost everything.. I have the backup saved on the dropbox site which is great, only one issue.

    The .crypt for the SQL DB well is encrypted and I for the life of my cannot remember putting in a password. Is there anyway around this, or even a way to get an idea of what it might be?

    Thank you for all your help.

    https://wordpress.org/plugins/updraftplus/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author David Anderson

    (@davidanderson)

    9 years, 9 months ago

    Hi gbynre2011,

    Here’s a relevant FAQ:
    http://updraftplus.com/faqs/i-lost-my-encryption-key-what-can-i-do/

    Best wishes,
    David

    Thread Starter gbyrne2011

    (@gbyrne2011)

    9 years, 9 months ago

    Thank you for your reply David, sadly it seems there’s nothing I can do but to restart the whole design process and content of the site :(. Didn’t even know the software saved it as .crypt.

    Cheers

    Thread Starter gbyrne2011

    (@gbyrne2011)

    9 years, 9 months ago

    Hi David.. I remember the password to the .crypt. Now I’ve an issue with the DB.

    —
    Unpacking backup…
    Decrypting database (can take a while)…
    Database successfully decrypted.
    Restoring the database (on a large site this can take a long time – if it times out (which can happen if your web hosting company has configured your hosting to limit resources) then you should use a different method, such as phpMyAdmin)…
    An error (1) occurred: – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘?׳Ϋ[?/?b??4/?? ?x?t̞n?*?Ԥ?????nP<?y?^Q1i??A????.??E?S?i`ܡ??!|F6?B’ at line 1 – the database query being run was:
    An error (2) occurred: – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘7w? $HԶa??p??\??}??Q?|?? ,??d!?dDy?~Z?̽?h?zJ?b??h?v???nޯ?d?r??H?? ˱”‘ at line 1 – the database query being run was:
    An error (3) occurred: – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘̒|!?\8??W?՜? b ?۳??])2)i+?e??Z@??zZ?T?7?8?:???;??aq? ?ٺ?#?`?0?ˉ??s??’ at line 1 – the database query being run was:
    An error (4) occurred: – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘? ???3??AC???O?Ts?C,C?F?q??OƥxPlNwaiY?e??}? f/b?? S??C@1?b*?ݲ?1??@??m’ at line 1 – the database query being run was:
    Finished: lines processed: 4 in 0.05 seconds
    Cleaning up rubbish…
    —

    I think this might be because the name, ID and pass of the original DB is different to the new one. Maybe??

    Cheers

    Plugin Author David Anderson

    (@davidanderson)

    9 years, 9 months ago

    Hi gbyrne2011,

    The “Database successfully decrypted” message is a red herring – the ensuing results indicate that it wasn’t, and thus the remembered password isn’t the right one.

    David

    Thread Starter gbyrne2011

    (@gbyrne2011)

    9 years, 9 months ago

    Thanks for your reply David.

    Why did it say successfully completed?

    Starting to think I’ll never get this password, lol.

    Cheers

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘SQL DB .Cyrpt Issue’ is closed to new replies.