将内容从旧博客平台迁移到 WordPress
我正在为客户开发一个大型网站，但他们当前的网站（数千页深）是建立在专门为他们在 aspx 中构建的遗留博客平台上的。我的工作是获取所有充满数据（评论、类别、帖子、标题、日期等）的 SQL 表，并将它们转换为 WordPress 就绪格式。我希望能够将我拥有的表格重新格式化为 WordPress 可以理解和处理的格式。
这些表甚至与给定的 WordPress 格式不匹配。我正在考虑进行重大数据迁移，并正在寻找可能有帮助的工具、资源或人员。我是一名网页设计师，对 mySQL 或数据库缺乏经验。有人能在这里给我指出一个好的方向吗？
I am working on a massive site for a client, but their current website (thousands of pages deep) is built on a legacy blogging platform that was built specifically for them in aspx. My job is to take all of the SQL tables filled with data(comments, categories, posts, titles, dates, etc) and convert them to a wordpress ready format. I want to be able to reformat the tables that I have into a format that wordpress can understand and process.
The tables are not even close to a match of the given wordpress format. I am looking at a major data migration and am looking for tools, resources, or people that may be of help. I am a web designer with little experience with mySQL or databases. Can anyone point me in a good direction here?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
如果有某种工具可以帮助您迁移，我会感到非常惊讶。这很可能归结为良好的老式 SQL。
听起来您正在尝试执行基本的 提取/转换/加载操作 (ETL)< /a>.我首先要阅读相关内容。你们这里有多少张桌子？
我还建议打印出新旧数据库结构的实体关系模型（数据库图），并确保您了解哪些数据将去往何处。
I'd be very surprised if there is some sort of tool that will help you migrate. This will most likely boil down to good old fashioned SQL.
It sounds like you are trying to do a basic Extract/Transform/Load operation (ETL). I'd start by reading up on that. How many tables are you dealing with here?
I would also recommend printing out the Entity relationship model (database diagram) for both the new and old database structures and make sure you understand what data is going to go where.
不确定 wordpress 读取什么，但希望使用 mysqldump 函数。这将保存 SQL 文件并将其导出。然后只需运行简单的更改表命令，即可准备就绪。
Not sure what wordpress reads, but looking to using the
mysqldumpfunction. this will save the SQL file and export it. Then just running simply change table commands, you can get it ready.