i’m sharing my findings as i make my way through a migration from phpBB3 to discourse. solutions include: postgres source db emoji tweaks to the importer (fixing quote bug, improved bbcode support (including youtube), attachment comments) soft deleted posts being imported as normal posts i’m supe…

The bulk import script should work for you… discourse/script/bulk_import/phpbb_postgresql.rb at 52d4de7b45eb1b7c7997da2ba8bff83a3c22a3a5 · discourse/discourse · GitHub

thanks, @gerhard is my understanding correct? script/import_scripts/phpbb3 and script/bulk_import are completely separate importers the bulk importer is less sophisticated (though faster), and, for example, it won’t import attachments? if so, it sounds like there are downsides to using the bulk…

Yes, there are drawbacks. If you are comfortable working with Ruby, I’d suggest modifying the files in discourse/script/import_scripts/phpbb3/database at main · discourse/discourse · GitHub so that they work with pg gem instead of mysql2. [图片] shyguy: would it be advisable to explore doing a db…

bummer. well, i’ll take a crack at it. i’ll follow up if i come up with something.

[图片] Migrate a phpBB3 forum to Discourse The current import scripts will be deprecated sometime this year… [图片] Gerhard Schlager: If you are comfortable working with Ruby, I’d suggest modifying the files in discourse/script/import_scripts/phpbb3/database at main · discourse/discourse · Git…

[图片] shyguy: i’m trying to decide how much effort i put into this—will there be upstream value? I have not dealt with the postgresql to mysql issue myself, but purely from a perspective of migrating from phpBB to Discourse, my opinion is: do whatever it takes to accomplish the migration. I’v…

[图片] Migrate a phpBB3 forum to Discourse doing a table-by-table CSV export and import. That sounds like a recipe for disaster if you aren’t careful with database charsets and collations. [图片] shyguy: well, i’ll take a crack at it. A couple of years ago I started working on it, but it’s…

[图片] Gerhard Schlager: That sounds like a recipe for disaster if you aren’t careful with database charsets and collations. I didn’t mean to imply that it would be easy, just that it’s worth the effort, even possible to do manually, and there do seem to be plenty of resources out there to acco…

given that i hate ruby, and the existing importer is going to be deprecated in favor of bulk importer (which is not good enough yet for my purposes), i am going ahead with the postgres → mysql migration strategy. i’m getting somewhere with mysql workbench’s migration wizard. i’ll write up a little …

so far, i’m stuck on this issue: https://bugs.mysql.com/bug.php?id=89048 basically, mysql workbench fails on importing unicode. will try with mariadb tomorrow and see if i can set default db encoding or something before importing.

我的 phpBB 迁移之旅 (postgresql)

支持迁移

shyguy 2023 年2 月 27 日 19:58 6

那个导入器是会被弃用的吗？“新”导入器的状态如何？我正在考虑投入多少精力——这是否会有上游价值？

话题		回复	浏览量
Migrate a phpBB3 forum to Discourse Migrating to Discourse how-to	467	99326	2025 年9 月 4 日
Migrate an IPB 3.1 forum to Discourse Sysadmins how-to	5	5636	2025 年1 月 29 日
Migrate a bbPress WordPress plugin forum to Discourse Migrating to Discourse how-to	33	12909	2024 年1 月 10 日
Change from phpbb to Discourse Migration phpbb	12	4209	2022 年8 月 24 日
phpBB 3 Importer (old) Feature	90	17303	2014 年10 月 8 日

我的 phpBB 迁移之旅 (postgresql)

相关话题