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 日午後 7:58 6

これは非推奨になるインポーターですか？「新しい」インポーターの状況はどうなっていますか？どの程度の労力を費やすべきか判断しようとしています。アップストリームでの価値はありますか？

トピック		返信	表示
Migrate a phpBB3 forum to Discourse Migrating to Discourse how-to	464	100324	2025 年 9 月 4 日
Change from phpbb to Discourse Migration phpbb	11	4286	2022 年 7 月 25 日
Migrate an IPB 3.1 forum to Discourse Sysadmins how-to	5	5669	2025 年 1 月 29 日
Migrate a bbPress WordPress plugin forum to Discourse Migrating to Discourse how-to	33	12980	2024 年 1 月 10 日
Migrate phpBB3 forum new data to existing discourse forum Migration phpbb	5	1071	2023 年 6 月 21 日

私のphpBB移行ジャーニー（postgresql）

関連トピック