WordPress Pages - Where Are They Stored In MySql?
January 30th, 2007 • Related • Filed Under
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.
Bookmark & Share
Related Posts
- I Need Wordpress MySQL Help, And I’m Willing To Pay
- Exporting and Importing a MySQL Database
- Guide To Optimizing WordPress Servers
- WordPress 2.1 And UTW Database Issues
- WordPress Optimisation: Block WordPress Referral Spam
- Good List Of WordPress Optimisation Links
- Get Your Blog Ready For WordPress 2.3 This Weekend





Comment by Sridhar Katakam on 30 January 2007:
WordPress pages are stored in wp_posts table.
All pages’ post_status column values will be static.
Comment by Everton on 30 January 2007:
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
Comment by Ulysses Ronquillo on 2 March 2007:
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.