Recover Deleted Notes

  • Resolved emillerphx

    (@emillerphx)


    2 years, 5 months ago

    All,

    Our consultants added a new plugin to the dashboard and when they did that, they deleted all my notes.

    Is there a way to get them back?

    I do have access to the database if that is what is needed.

    Thanks!

    Eric

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Jeroen Sormani

    (@sormano)

    Hi Eric,

    Notes are stored as a custom post type, so you can go into the _posts table and restore them. The post type is ‘note’.

    Cheers,
    Jeroen

    Thread Starter emillerphx

    (@emillerphx)

    Jeroen,

    Thanks! Worked like a charm. All my notes are back. I’m embarrassed that I didn’t figure this out on my own. ?? But thank you for the quick response.

    For others, here is how I recreated them:

    Used WP Data Access
    select post_title, post_content from wp_posts where post_type = “note”
    Copy and pasted the HTML from post_content into an HTML preview tool
    Pasted the text into a new note.

    Thanks!

    Eric

    • This reply was modified 2 years, 5 months ago by emillerphx.
    Plugin Author Jeroen Sormani

    (@sormano)

    Glad to hear that Eric.

    As an addition to your solution; you can also change the ‘post_status’ to ‘publish’ instead of ‘trash’ ??

    Cheers,
    Jeroen

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Recover Deleted Notes’ is closed to new replies.