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

[изображение] 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 migrat…

[изображение] 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 worki…

[изображение] 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 ther…

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 27.Февраль.2023 19:58:07 6

Этот импортер — тот самый, который будет устаревшим? Каков статус «нового» импортера? Я пытаюсь решить, сколько усилий стоит вложить в это — будет ли это полезно для основного проекта?

Тема		Ответов	Просм.
Migrate a phpBB3 forum to Discourse Migrating to Discourse how-to	467	100000	04.09.2025
Migrate an IPB 3.1 forum to Discourse Sysadmins how-to	5	5655	29.01.2025
Migrate a bbPress WordPress plugin forum to Discourse Migrating to Discourse how-to	33	12949	10.01.2024
Change from phpbb to Discourse Migration phpbb	12	4253	24.08.2022
phpBB 3 Importer (old) Feature	90	17397	08.10.2014

Мой путь миграции на phpBB (postgresql)

Связанные темы