PhpBB migrate script - Updated for beta 5

robrotheram

The way I got my script to work is start of with a fresh install of flarum. I would suggest when creating the first admin account to use a different email then the one in phpbb since on import mysql will detect a conflict with the email. After flarum in successfully installed. We can proceed with the migration. I Run the script which generates a sql file that will update all the tables. Since I working on command line. I then do :
mysql -uUSER -pPASSWORD flarumDBNAME < sqlfile.sql

I would love to build an extension but sadly do not have a lot of time to invest, the script was a hack together job to get some data quickly into forum it definitely no where a plug and play but it does the job for me and I though I share it to help other people and

lorde

robrotheram can i speak to you about some changes to flarum? Custom.

robrotheram

I have updated the top of the post with instructions and a updated scipt that now does formatting and fixes a few bugs.

ozkans

Oh, you mean prior to install?

robrotheram

ozkans You can run the script at anytime to generate the flaurm.sql file. The most reliable way to import the data into flarum is to have a fresh forum with the admin account you setup with a username and email different to any stored in the phpbb database / flaurm.sql.

I went for a sql file export rather then some direct database changes because some people aka me for example have phpbb running but are testing or have flarum on a different machine but still want to see there phpbb data.

VTX

Thanks for providing this script. Any idea's how to handle attachments? Is there already some kind of plugin/extension for flarum to support attachments?

robrotheram

VTX I have to admit I have not looked at attachments mainly due to the forum I was migrating did not allow attachments to be uploaded only public links to places such as imgur. It would depend on the url phpBB gives for the links. if they are relative such as /uploads/filename.ext then you should be able to copy over the folder and set a static path in apache / nginx config. The other option is change the link URL could be done with some find and replace magic on the resulting sql file. Sadly I don't have the time to investigate further

KarlWard

Sorry to butt in to this discussion, but are there any suggestions how to migrate or redirect existing phpBB urls? I have a forum with 7000 unique topics, using the standard viewtopic.php?f=52&t=8814. As far as I can see, when migrating to flarum, all existing url's would simply become 404.

VIRUXE

I've been editing this script for quite a while now. It's still not finished but it has worked great for me.
P.S.: Don't mind Github's silly indentation.

gist.github.com/viruxe/5a1be93ec1e8e6c9288b

robrotheram

VIRUXE wow excellent work I been meaning to get back to this but life been getting in the way glad someone else has done more work on it ?

VIRUXE

robrotheram well I'm not too happy about the code but as long as it does the job it should be fine.
Although I think this would benefit from a proper repository.

robrotheram

VIRUXE I think you are right so I went ahead and created one https://github.com/robrotheram/phpbb_to_flarum I added my script and then committed your script so we can see the changes you are welcome to do with this as you want

VIRUXE

robrotheram Actually I was thinking about having your script in a repo and then I would commit my parts of code and document all the changes with each commit instead.

robrotheram

Updated the initial post.
Thanks to all the contributions the script has had

TLDR script works for beta 5
now only does DB --> DB migration (no messy sql files to worry about)
script is here: https://github.com/robrotheram/phpbb_to_flarum

VIRUXE

I totally forgot about this. I'll have a look and see if I can help with anything.

robrotheram

VIRUXE
no problem I only really got back to it today, On of my plans now is to work on some rewrite rules for nginx / Apache since now topic/discussion id's are preserved its now possible for old forum links to work ?

isti37

I wonder if we could rewrite the phpbb session handler code to work with flarum so the passwords from phpbb would work with flarum on imported users.

The seo is a little more complicated, I think one should avoid phpbb/nginx rewrites and stick to routing from the database.

robrotheram

isti37 There is the possibility to create a phpbb authentication plugin for flaurm that would allow them to log in with the old username and password without having to do any sort of decryption.

On the seo how would you do it since old links to domain/viewtopic.php?f=12&?t=121 would not work My plan is to have a viewtopic.php the would get the topic id and redirect to the correct post but I am open to suggestions

« Previous Page Next Page »