大网数据广告活动
网站运营与故障问答

How do I recover WordPress page content from MySQL database?

· 52CE 我爱测

I have a WordPress site and the database has become corrupted (long story), and it's not backed up. My plan is to create a new WordPress site from scratch and copy all the theme files, images, etc...over from the old site. What I…

问题原文

原帖链接 · SamTheMan · CC BY-SA 3.0

I have a WordPress site and the database has become corrupted (long story), and it's not backed up. My plan is to create a new WordPress site from scratch and copy all the theme files, images, etc...over from the old site.

What I need to know is how to access the content from my posts and pages. I'm a novice when it comes to databases. I just want to see the post/page content as plain text so I can copy & paste it to the new site.

已采纳解答

原帖链接 · Josh Mountain · CC BY-SA 3.0

If your database is truely 'corrupted' as you stated, you are unlikely to be able to retrieve your post/page content. In either case, it is located inside your MySQL database inside the wp_posts table and more specifically the post_content column.

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Webmasters Stack Exchange
适用范围
以原帖系统、软件版本与发布日期为准(2015-01-22)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 3.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。