Import Database

[The 360 Place]

I have a phpbb forum and would like to switch to the simple machines forum. Can I import the database from my phpbb forum into the simple machines one?

[metallica48423]

no, you will need to convert it.

Converters and Importers

also see the conversion docs at http://docs.simplemachines.org

[The 360 Place]

Will I still get to keep my members and posts?

[babjusi]

Will I still get to keep my members and posts?

Yes

[The 360 Place]

And one last question. The forum isnt hosted by my own web host. So will I be able to still convert it?

[metallica48423]

if you have access to download the database or to connect to it, then yes.

Otherwise, unless they're willing to give you it -- no.

[The 360 Place]

Ok, well I can buy a backup of the database from them. So that should then work, right?

[metallica48423]

Yes, if you can do that.

Then you just need to import that database into a mysql database via phpmyadmin or a similar tool, then run the converter script on it

The documentation pointed to and the board above should provide more information

also see (What is phpMyAdmin?)

[The 360 Place]

Well I am having trouble importing the database to my MySQL Database. Anyone care to help me?

[The 360 Place]

Anyone?

[青山 素子]

It helps if:

• You don't bump your topic one hour later. Stuff is handled old to new. That means when you bump, you put yourself at the back of the line.
• You describe the trouble you are having in a bit more detail.

[The 360 Place]

Well lets see. Im trying to import my database from another forum, into my MYSQL Database. Then I was going to run the convertor script on it. But when I tried to import the database it wouldnt let me.

[青山 素子]

What did it say when it wouldn't let you?

[The 360 Place]

What did it say when it wouldn't let you?

Part of the problem is that it says "Character set of the file", im not sure what to select for that. And it says "SQL compatibility mode", im not sure what to select for that either. It also says "Allow interrupt of import in case script detects it is close to time limit. This might be good way to import large files, however it can break transactions", and that is checked.

[Ol' Wombat]

open the file in a text editor and it will tell you (line ~32) what char set it was saved - leave the import options as is

[The 360 Place]

open the file in a text editor and it will tell you (line ~32) what char set it was saved - leave the import options as is

There are lots of files. Is there a specific one I choose?

[Ol' Wombat]

there is only one for the *database* ending with .sql (that's the one)

[The 360 Place]

there is only one for the *database* ending with .sql (that's the one)

All of the files end with .sql. And I didnt see one that said database.

[Ol' Wombat]

ok, then get the latest by date does not matter how its called - database or not but ending with sql

[The 360 Place]

ok, then get the latest by date does not matter how its called - database or not but ending with sql

Sorry but I am still confused. If you havent realized im new to this. I am hoping to get this done ASAP, so I can get my forum back up.

[Ol' Wombat]

mate, lunchtime here in OZ - will be back later this afternoon. meanwhile someone else may help you clearing the confusion.

cya latter

[The 360 Place]

Can someone by any chance do this for me?

[rsw686]

You say you have multiple .sql files. What are the names of them. Maybe they gave you one for each table. If so you'll need to import them all.

[The 360 Place]

You say you have multiple .sql files. What are the names of them. Maybe they gave you one for each table. If so you'll need to import them all.

some say config.sql, prune.sql, forums.sql, auth_access.sql. and there are some more.

[Jalkson]

Have you figured this issue out? 

If not your best bet would be the 'forum.sql' file.  Try that and post back. =]