News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Upgrading from phpBB

Started by WOLKA, May 01, 2005, 02:18:53 PM

Previous topic - Next topic

WOLKA

Hi,

How can I upgrade phpBB2 to SMF
without losing any post ?

thanks,
Serhiy Horobets, [email protected]

Owdy

Make fresh install of smf to same server where your phpbb is, use differend dir of course. Upload converter to smf's root and run it. Thats it! :)

Remember, both forums has to use same database!

http://www.simplemachines.org/download.php?converters
Former Lead Support Specialist

Tarvitsetko apua SMF foorumisi kanssa? Otan työtehtäviä vastaan, lue:http://www.simplemachines.org/community/index.php?topic=375918.0

WOLKA

Serhiy Horobets, [email protected]

Owdy

Former Lead Support Specialist

Tarvitsetko apua SMF foorumisi kanssa? Otan työtehtäviä vastaan, lue:http://www.simplemachines.org/community/index.php?topic=375918.0

Miraenda

Quote from: Owdy on May 01, 2005, 02:22:14 PM
Make fresh install of smf to same server where your phpbb is, use differend dir of course. Upload converter to smf's root and run it. Thats it! :)

Remember, both forums has to use same database!


Are you sure about this?  I just tested this as I thought I'd put my 2 forums into a different database at one point when I was testing phpBB to SMF conversion and I just retested doing just that.  I have 2 different forums:

miraenda_phptosmf (has phpBB forum in it)
miraenda_smftest (has SMF test forum in it)

I then ran the conversion script, and it successfully converted it even though both were in different databases.  I've also tested with both in the same database.  No difference, both work.  Thus, have you tested this doesn't work?

If you test it, this is how it works.  The database user has to have access to both databases.  If you put it in the same database, this isn't an issue.  If you put the 2 scripts in different databases, then you have to ensure the database user (or one of the users) has the same password to access both databases.  These configurations work:

- same database (as password you input will work for both)
- different databases, same database user (as password you input will work for both)

This will not work:

- different databases, different database users with different passwords

Not yet sure if this works:

- different databases, different database users with same password

I'll gladly let you test on my account if you don't believe me that this does work to have them in different databases following the above configurations.

Thanks.

[Unknown]

Yes, you really just have to have one ACCOUNT that has access to both databases (and as many other accounts as you want with access to whichever you wish.)  However, in practice, some control panel tools do not give you the ability to give one user access to more than once database.

-[Unknown]

makingob

Hi, I have been reading this thread and have to ask an insanly stupid question. Gee can you tell I am a complete newbie at this?

I have SMF installed and working. I have the converter script uploaded into the SMF directory. I have a backup of my PHPbb forum.

What do I do now?????

I am kinda lost. :o

Thanks

WOLKA

Now
have a fun using SMF  ;) !

Now You may delete your phpBB...
Serhiy Horobets, [email protected]

Owdy

Quote from: makingob on May 07, 2005, 01:23:46 PM
Hi, I have been reading this thread and have to ask an insanly stupid question. Gee can you tell I am a complete newbie at this?

I have SMF installed and working. I have the converter script uploaded into the SMF directory. I have a backup of my PHPbb forum.

What do I do now?????

I am kinda lost. :o

Thanks
Run converter script from smf root dir.
Former Lead Support Specialist

Tarvitsetko apua SMF foorumisi kanssa? Otan työtehtäviä vastaan, lue:http://www.simplemachines.org/community/index.php?topic=375918.0

makingob

I did that, but am confused as to the path of my backup database file. I am not sure where to find it.

Thanks

[Unknown]

It doesn't need the backup database file, it needs the database to be uploaded and installed into MySQL.

You need to be able to access the data with phpMyAdmin on the server.  What is phpMyAdmin?

After that, the path to the phpBB settings file should be similar to that of the SMF one, except with phpBB instead of smf, or similar.  If you're still confused, just copy config.php and extension.inc into the SMF directory.

-[Unknown]

d6veteran

My phpbb 2.0.17 mySQL server is [email protected].
My smf 1.0.5 mySQL server is [email protected].

Both databases have the same username and password.

When I run the phpbb to smf script I get the error: "Sorry, the database connection information used in the specified installation of SMF cannot access the installation of phpBB2. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it."

I've heard both that the conversion will work with different DBs and that it will not.  Is there any hack to get it to work across two DBs?  Is there anything I am missing?

Thanks.


Oldiesmann

Make sure that the username and password specified in SMF's Settings.php match the username and password specified in phpBB's config.php...
Michael Eshom
Christian Metal Fans

d6veteran

I couldn't get it to work until I exported and restored the phpBB tables into the smf db.  Then I just made a fake phpbb config file pointing to the smf db.  That worked fine.

trina

Can someone please tell me why I keep getting this?

The database password you entered was incorrect. Please make sure you are using the right password (for the SMF user!) and try it again.

I am using the right password.

Oldiesmann

That means that the database password you're entering doesn't match what's in Settings.php. Use the one that's in Settings.php and you won't get that message :)
Michael Eshom
Christian Metal Fans

trina

thanks...now i'm getting this...

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of phpBB2. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

Oldiesmann

Make sure that the MySQL username and password are the same for both SMF and phpBB. If that still doesn't work, move all the phpBB tables onto your SMF database and try it.
Michael Eshom
Christian Metal Fans

sputnikradio

I have a question about this.


I recently switched to sm but i switched servers and deleted my entire site. I recently installed (today) sm . I only downloaded a back up of my previous phpbb database . I do not have the phpbb database or program running on my new server. I only have the database back up.

is there anyway anyway whatsoever I can use this database to make sm have the same tables and post and forums and members and all so that I do not lose a whole years worth of members and their post?


If there is NO WAY then I understand I have to just start over. But if there is anyway could you at least drop me a hint . Anyone with knowledge of this of course.

Thank you


sput

judymcl

I sort of had a similar problem as you sputnikradio, except mine wasn't deleted yet. I got it to work but I had to do a few extra steps 1st.

    1. What I did was I created my new database to house SMF and temporarily phpBB (I was using phpBB before).
    2. Then I created 2 directories (same server), one for SMF and one for phpBB (temporary one)
    3. I uploaded the files for SMF to the SMF directory and uploaded phpBB to the phpBB directory.
    4. I believe I ran the installer for SMF 1st and installed it so it was using my new database.
    5. I then ran the installer for phpBB and installed it to the same new database that SMF is in.
    6. I made sure I used my original phpBB login for both SMF and the new copy of phpBB.
    7. Upon successful install of both, I went into the phpBB admin, and 'restored' the BB forum.
    8. At this point I had my original phpBB restored, however it was now sharing the same database as the new install of SMF.
    9. Next I uploaded and ran the convertion script, which went beautifully. *I did loose the user uploaded avatars, which was no big deal....they just uploaded it again in to SMF after I was done.

Once I checked everything over at my new SMF to make sure everything was all good, I just deleted the phpBB directory and the phpBB tables out of the database.

I can't guarantee it will work for you, but it may be a worth a shot if you like.


Judy

O Velho

Quote from: d6veteran on October 09, 2005, 01:15:44 AM
My phpbb 2.0.17 mySQL server is [email protected].
My smf 1.0.5 mySQL server is [email protected].

Both databases have the same username and password.

When I run the phpbb to smf script I get the error: "Sorry, the database connection information used in the specified installation of SMF cannot access the installation of phpBB2. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it."

I've heard both that the conversion will work with different DBs and that it will not.  Is there any hack to get it to work across two DBs?  Is there anything I am missing?

Thanks.



That´s exactly my problem! Any toughts? Anyone?  :D

Oldiesmann

Quote from: sputnikradio on October 21, 2005, 01:28:05 PM
I have a question about this.


I recently switched to sm but i switched servers and deleted my entire site. I recently installed (today) sm . I only downloaded a back up of my previous phpbb database . I do not have the phpbb database or program running on my new server. I only have the database back up.

is there anyway anyway whatsoever I can use this database to make sm have the same tables and post and forums and members and all so that I do not lose a whole years worth of members and their post?


If there is NO WAY then I understand I have to just start over. But if there is anyway could you at least drop me a hint . Anyone with knowledge of this of course.

Thank you


sput

http://www.simplemachines.org/community/index.php?topic=54639.msg383845#msg383845

Quote from: O Velho on October 26, 2005, 01:56:50 PM
Quote from: d6veteran on October 09, 2005, 01:15:44 AM
My phpbb 2.0.17 mySQL server is [email protected].
My smf 1.0.5 mySQL server is [email protected].

Both databases have the same username and password.

When I run the phpbb to smf script I get the error: "Sorry, the database connection information used in the specified installation of SMF cannot access the installation of phpBB2. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it."

I've heard both that the conversion will work with different DBs and that it will not.  Is there any hack to get it to work across two DBs?  Is there anything I am missing?

Thanks.



That´s exactly my problem! Any toughts? Anyone?  :D

Make sure that both the smf database user and the phpbb database user can access both the smf and the phpbb databases - It will work with different databases, but you need to make sure that forums are using the same MySQL username and password or that both users have access to both databases.
Michael Eshom
Christian Metal Fans

Advertisement: