Subscribe via RSS FeedRandom Post

WordPress Pages – Where Are They Stored In MySql?

View Comments January 30, 2007 | Everton

After my recent database crash I managed to restore my backup, but my WordPress Pages were missed off for some reason.  Does anyone know which mysql table WordPress Pages are stored in, so that I can do a manual restore?

Thanks in advance.

Tip: Click here to run a free scan for common PC errors

GD Star Rating
loading...

Tags: ,

Category: Tools & Tips

Next Post: »»

Prev Post: »»

About Everton: Everton is based in London and has worked in the internet and mobile space for over ten years now, and before that worked in corporate strategy and consulting. He has a degree in Economics from Cambridge University.He also writes for Windows 7 News, Windows 8 News and One Tip A Day. View posts.

  • Yes, the WordPress Pages are stored in wp_posts table, but they are in the "post_type" column with the value of "page" instead of the example above.

    Hope that helps.
  • For some reason they weren't in my backed up tables. I had a better idea to restore though - I used Google cache to get the old content and I just recreated the pages. Luckily I did it before the cache updated as Google tend to crawl my site everyday
  • WordPress pages are stored in wp_posts table.

    All pages' post_status column values will be static.
blog comments powered by Disqus