Can't restore my years of postings, please help :(

  • Resolved Kai2810

    (@kai2810)


    12 years, 8 months ago

    Hi all,

    my site was recently hacked/attacked and i can’t access my wordpress blog. I can’t even get to the admin login page.

    From my webhost technical support suggestion, I deleted my entire wordpress directory and used Softaculous to install a new one.

    Prior to deletion, I downloaded my wp_content and extracted the database using myPhpAdmin, as per the Codex. My export was about 1mb in size.

    Is that size normal for 6 years worth of postings?

    PLEASE ADVISE ??

Viewing 8 replies - 1 through 8 (of 8 total)

  • Is that size normal for 6 years worth of postings?

    The size of the database depends on the number of posts and the size of the posts, and several other factors, Not the number of years.

    Thread Starter Kai2810

    (@kai2810)

    Okay, so now what are my options?

    I have copied out my wp_content directory and did a database backup using phpMyAdmin…

    Thread Starter Kai2810

    (@kai2810)

    Is there any file in the wp_content folder that i can try to use to restore my posts?

    Your images/ photos load from wp_content.

    Thread Starter Kai2810

    (@kai2810)

    how about the posts themselves? the wordings?

    They are in your database.

    If you have taken a backup of your database. You can do the following.

    1. Browse the database and retrieve the table called wp_posts.
    2. Get the SQL for that table.
    3. Browse to phpMyAdmin of your current site and login.
    4. Take the backup of entire database and save it somewhere.
    5. Now, deleted the wp_posts table from current website.
    6. Run the query SQL Query you copied from the raw SQL file of the database you’ve taken the backup.
    7. If it doesn’t seems working try inserting few queries at the beginning of the query like creating table etc.
    8. Now, do same thing for wp_postmeta (if it is needed.)

    Thread Starter Kai2810

    (@kai2810)

    Thanks Tirumal,

    That worked! I got to change the database prefix settings in the wp_config.

    I think it didn’t work previously due to the wp_config database prefix not set correctly.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Can't restore my years of postings, please help :(’ is closed to new replies.