Moving source data (phpbb) to new host?

[dpatel304]

I'm trying to import my phpbb data into a fresh new vB install. Want to keep my user and post info from phpbb. I have phpbb currently on my old host, and vb on my new host. So, now I have to take all the info from my old host, and put it on my new host. What exactly do I need to do?

thanks in advance.

[Floris]

http://www.vBulletin.com/docs/html/impex

Download impex from the members are and install it on top of vbulletin. Then edit the impexconfig.php file to point to the old phpbb database and your new vb database. Then run the impex and the phpbb modules.

And you're done.

[dpatel304]

thanks but I get this error:



Altering tables

ImpEx will now Alter the tables in the vB database to include import id numbers. This is needed during the import process for maintaining refrences between the tables during an import. If you have large tables (i.e. lots of posts) this can take some time. They will also be left after the import if you need to link back to the origional vB userid.
moderator - importmoderatorid Completed
usergroup - importusergroupid Completed
ranks - importrankid Completed
poll - importpollid Completed
forum - importforumid Completed
forum - importcategoryid Completed
user - importuserid Completed
style - importstyleid Completed
thread - importthreadid Completed
post - importthreadid Completed
thread - importforumid Completed
smilie - importsmilieid Completed
pmtext - importpmid Completed
avatar - importavatarid Completed
customavatar - importcustomavatarid Completed
customprofilepic - importcustomprofilepicid Completed
post - importpostid Completed
attachment - importattachmentid Completed
pm - importpmid Completed
usernote - importusernoteid Completed
phrase - importphraseid Completed
subscription - importsubscriptionid Completed
subscriptionlog - importsubscriptionlogid Completed

Valid found tables :


Possibly custom tables or incorrect prefix :

phpbb_attachments NOT found.
phpbb_attachments_desc NOT found.
phpbb_auth_access NOT found.
phpbb_banlist NOT found.
phpbb_categories NOT found.
phpbb_config NOT found.
phpbb_confirm NOT found.
phpbb_disallow NOT found.
phpbb_forum_prune NOT found.
phpbb_forums NOT found.
phpbb_groups NOT found.
phpbb_posts NOT found.
phpbb_posts_text NOT found.
phpbb_privmsgs NOT found.
phpbb_privmsgs_text NOT found.
phpbb_ranks NOT found.
phpbb_search_results NOT found.
phpbb_search_wordlist NOT found.
phpbb_search_wordmatch NOT found.
phpbb_sessions NOT found.
phpbb_smilies NOT found.
phpbb_themes NOT found.
phpbb_themes_name NOT found.
phpbb_topics NOT found.
phpbb_topics_watch NOT found.
phpbb_user_group NOT found.
phpbb_users NOT found.
phpbb_vote_desc NOT found.
phpbb_vote_results NOT found.
phpbb_vote_voters NOT found.
phpbb_words NOT found.
Failed Check database permissions and connection, or table prefix to ensure its correct



My phpbb was originally on a different host. So, since I can't access that server externally, I have to move my phpbb boards to my new host, and THEN upload. To do that, all I did was copy and paste all files to my new host, but I have a feeling there is more to it than that.

[Steve Machol]

You need to move the phpBB database to your vB server. Impex gets the data from the database, not the phpBB files.

[dpatel304]

right, but i am not sure how I would go about doing this. What I have done is move all my files from my old database, into a new one, but that didn't work. Any help is appreciated, and thanks for the responses.

[Steve Machol]

The only consistently reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeout errors and an incomplete backup file. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/maintenance_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/maintenance_ssh_restore

If you don't have telnet or SSH access, some people have reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showthread.php?t=134821&highlight=mysqlhotcopy

Bigdump (restore only):
http://www.ozerov.de/bigdump.php

[dpatel304]

wow thanks.

so, if I run that on my current phpbb (which is still running), then install a fresh copy on my new host and restore that info, it should work?

[Steve Machol]

Close your phpBB forums. Make a backup of the database. Copy that backup file to your vB server. Then restore that backup to a new database.

[dpatel304]

ok. sorry for all the question, but thanks a bunch. you've been a great help.

[Steve Machol]

No problem. Good luck. :)