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…

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.

It would have been great if MySQL Workbench would have worked. I saw a bunch of error reports with it when I looked at options, and so I didn’t recommend it. I mentioned the schema dump and CSV export/import method once before, and I’ll only mention it once more with a slight modification to make i…

我的 phpBB 迁移之旅 (postgresql)

支持迁移

gerhard (Gerhard Schlager) 2023 年2 月 27 日 20:55 8

如果你不注意数据库字符集和排序规则，这听起来就像是灾难的根源。

几年前我开始着手做这件事，但它未完成且已过时。不过，也许它会有帮助。

话题		回复	浏览量
Migrate a phpBB3 forum to Discourse Migrating to Discourse how-to	464	100373	2025 年9 月 4 日
Change from phpbb to Discourse Migration phpbb	11	4290	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	12984	2024 年1 月 10 日
Migrate phpBB3 forum new data to existing discourse forum Migration phpbb	5	1072	2023 年6 月 21 日

我的 phpBB 迁移之旅 (postgresql)

相关话题