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?
no, you will need to convert it.
Converters and Importers (http://www.simplemachines.org/community/index.php?board=20.0)
also see the conversion docs at http://docs.simplemachines.org
Will I still get to keep my members and posts?
And one last question. The forum isnt hosted by my own web host. So will I be able to still convert it?
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.
Ok, well I can buy a backup of the database from them. So that should then work, right?
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? (http://www.simplemachines.org/community/index.php?topic=21919.0))
Well I am having trouble importing the database to my MySQL Database. Anyone care to help me?
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.
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?
Lainaus käyttäjältä: Motoko-chan - helmikuu 16, 2008, 08:19:34 IP
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.
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
Lainaus käyttäjältä: Ol' Wombat - helmikuu 16, 2008, 09:00:08 IP
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?
there is only one for the *database* ending with .sql (that's the one)
Lainaus käyttäjältä: Ol' Wombat - helmikuu 16, 2008, 09:21:47 IP
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.
ok, then get the latest by date does not matter how its called - database or not but ending with sql
;)
Lainaus käyttäjältä: Ol' Wombat - helmikuu 16, 2008, 09:32:13 IP
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. :)
mate, lunchtime here in OZ - will be back later this afternoon. meanwhile someone else may help you clearing the confusion.
cya latter :)
Can someone by any chance do this for me?
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.
Lainaus käyttäjältä: rsw686 - helmikuu 17, 2008, 05:26:18 IP
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.
Have you figured this issue out?
If not your best bet would be the 'forum.sql' file. Try that and post back. =]