Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

WordPress

Brandon Brigham
Brandon Brigham
3,716 Points
Posted by Brandon Brigham
Brandon Brigham
3,716 Points

How do I grab blog posts via phpMyAdmin?

Hello

So a blog of my clients' has been hacked and we can't get to the WordPress dashboard to export the posts.

Is there a way to grab the posts via phpMyAdmin?

I've noticed there are to fields that seem like this could work but want to make sure it will actually work

wp_posts wp_postmeta

Thanks!

2 Answers

Jonny Noble
Jonny Noble
11,165 Points
Jonny Noble
Jonny Noble
11,165 Points

I'm pretty sure that you would have to export the database through phpmyadmin. Once you have a new WordPress install and db set up you can then import the old database into the new install.

Brandon Brigham
Brandon Brigham
3,716 Points
Brandon Brigham
Brandon Brigham
3,716 Points

But I don't want to export the entire database, only the posts, is that possible to do?

Jonny Noble
Jonny Noble
11,165 Points
Jonny Noble
Jonny Noble
11,165 Points

You would require knowledge of how databases work etc.

Check this link out https://www.elegantthemes.com/blog/tips-tricks/import-export-wordpress-website