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

«« WordPress 2.1 And UTW Database Issues
Vista Ultimate Installed In 25 Minutes! »»

About the Author

author photo

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, and currently runs the Portal and online operations for one of the largest ISPs in the UK. He also writes for Windows 7 News.

See All Posts by This Author

There Are 3 Responses So Far. »

  1. #1

    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.

  2. #2

    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

  3. #3

    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.

Subscribe without commenting

Post a Response


Comment Policy: Any comments are permitted only because the site owner is letting you post, and any comments could be removed for any reason at the absolute discretion of the site owner.