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 d…

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 · G…

[이미지] 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’…

[이미지] 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…

[이미지] 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 acc…

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 2월 27, 2023, 7:58오후 6

is that importer the one that will be deprecated? what’s the status of the ‘new’ one? i’m trying to decide how much effort i put into this—will there be upstream value?

글		댓글	조회수
Migrate a phpBB3 forum to Discourse Migrating to Discourse how-to	464	104730	9월 4, 2025
Change from phpbb to Discourse Migration phpbb	11	4492	7월 25, 2022
Migrate an IPB 3.1 forum to Discourse Sysadmins how-to	5	5775	1월 29, 2025
Migrate a bbPress WordPress plugin forum to Discourse Migrating to Discourse how-to	33	13306	1월 10, 2024
Migrate phpBB3 forum new data to existing discourse forum Migration phpbb	5	1112	6월 21, 2023

제 phpBB 마이그레이션 여정 (postgresql)

Related topics