Lost about 2 months of my Database.

  • Unknown's avatar
    raymondday61 · Member ·

    That link is not the WordPress I use at home on a home server.

    Had WordPress on a 256GB USB stick and had to reboot my server and it could not mount that stick any more. I did a fix to it but then just blank.

    Forgot the Database was not on the 256GB stick and I restored it from a 2 month old backup. Then remember I could of just left the Data base.

    Any way I did a apt install some restore deleted files. My WordPress was still open so I did a find for text in all the files it restored. I did find one that looks like it’s about the last 2 months.

    But it has I guess some format commands in it. I guess for the time and Date and stuff.

    Here is what part of that restore data looks like.

    I got there but they switch back.inheritclosedclosed 43845-revision-v1™œK噜›åE«      https://xxxxxx.xxx/blog/?p=43856revision  ×    Ÿ7¨ÀÏÿQ«             ™œN활ží

    Is there any way I can restore this? Does any one know what the other things are in this text?

    I could just copy and past the text but don’t know what time and date it was.

    -Raymond Day

    The blog I need help with is: (visible only to logged in users)

  • Unknown's avatar
    raymondday61 · Member ·

    Looks like it’s a file in /var/lib/mysql/WordPress/wp_post.MYD

    I did copy all the lost text in to the file after I cp wp_posts.MYD wp_posts.MYD.bk

    Made sure the Owner is mysql and restarted mysql but WordPress looks the same nothing changed. I guess I need to update the database some how. Is there a URL I can go to in WordPress to do that?

  • Unknown's avatar
    justjennifer · Member ·

    Hey there, you’ve posted your question in the support forums for sites hosted by WordPressdotcom, but by the sound of it, your site appears to be using the standalone WP (org) software.

    Standalone WP (org) and WordPressdotcom (where we are) are different entities with different documentation and support forums; more information about the differences can be found here: https://en.support.wordpress.com/com-vs-org/

    You can find all the support information for sites using the WP (org) software at https://codex.wordpress.org/Main_Page and at https://wordpress.org/support/ If you don’t have a username on the ORG forums, you can register one on that page.

    Best wishes for a quick resolution.

  • Unknown's avatar
    raymondday61 · Member ·

    Thank you justjennifer. I just posted about it were you said too.

  • The topic ‘Lost about 2 months of my Database.’ is closed to new replies.