PhpBB migrate script - Updated for beta 5

luceos

If i'm not mistaken you configure the phpbb database settings in this file and it will generate an export dump, which you have to import into a clean flarum installation.

luceos

luceos have to import into a clean flarum installation
Dakoom

I told you, the (phpmyadmin) has to be done into a clean flarum install. The user table does not yet exist.

Dakoom

Importing using phpMyAdmin, right? Anyway, I'm trying and I'll let you know!

Dakoom

It creates the .sql file, but when you try to import it into the Flarum db using phpMyAdmin you get this error:

Query SQL:

INSERT INTO users (id, username, email, password, is_activated) VALUES (1002, 'glauco', 'email@gmail.com', 'c942464cf2683c1e2b9250a7337f9728335534959', 1)[...]

Messaggio di MySQL: Documentazione
#1146 - Table 'flarum2.users' doesn't exist

SolidOrphan

you have to put your informations like username, prefix table, password, etc.

Dakoom

SolidOrphan Where?

moay "I read something about placing this in the installer" where? 😛

moay

Are there already plans to create an extension for imports? I think that's a rather easy one to do, I could make one.

I think, I read something about placing this in the installer - but why not just providing an extension?

moay

Dakoom Dunno, somewhere in the docs or in the repo or in the chat or somewhere else... 😉

Dakoom

moay Ok, don't worry. I will wait until some extension will be released.

Dakoom

luceos Oh, you mean prior to install?

Edit: I get the same error.

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 ?