Access page contents on sql database

  • I need to find a way to access the page content on my sql database backup. My site was hacked, so I suspended it. I now have a new host and a new site, but I need to access the content of my old one, which I backed up a few days before the hacking. Every time I try to upload the backup via cpanel on the old host, I get the hacked homepage again, all I want to do is copy and past the content.

    I figured the simplest way was just to access the content of my backup locally – anyone know how to do that?

    Fingers crossed!

Viewing 1 replies (of 1 total)

  • @woodleysue

    Hi! Thank you for writing.

    I’m sorry that the site was hacked ??

    To answer the question directly. To query the database directly, how about using a SQL query like this:
    SELECT * FROM database1.wp_posts WHERE (post_status = 'publish' AND post_type = 'post')

    May I ask more questions?

    – It almost sounds like the backup is from a time after the site was hacked. Do you have an older backup that you can try?

    – Even though the site was hacked, are you still able to access the WP dashboard? If so then can you export the posts via the WordPress export functionality, and if so then do you think that will lead to a solution?

    Write back to let us know how you go!

Viewing 1 replies (of 1 total)
  • The topic ‘Access page contents on sql database’ is closed to new replies.