+ Reply to Thread
Results 1 to 10 of 10

Thread: Moving source data (phpbb) to new host?

  1. #1
    New Member dpatel304 has disabled reputation
    Join Date
    Sep 2006
    Posts
    12

    Moving source data (phpbb) to new host so I can Impex it.

    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.
    Last edited by dpatel304; Fri 20th Apr '07 at 8:16pm.

  2. #2
    Senior Member Floris has disabled reputation
    Join Date
    Dec 2001
    Posts
    37,096
    Blog Entries
    13
    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.
    smaller than forward slash three.

  3. #3
    New Member dpatel304 has disabled reputation
    Join Date
    Sep 2006
    Posts
    12
    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.

  4. #4
    Customer Support Manager Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol's Avatar
    Join Date
    Jul 2000
    Location
    Jelsoft InterGalactic HQ
    Posts
    142,692
    You need to move the phpBB database to your vB server. Impex gets the data from the database, not the phpBB files.
    Steve Machol, vBulletin Customer Support Manager
    "Have Copy, Will Paste" (when appropriate)

    Please do not email or PM me for vBulletin support. I will be more than glad to answer your questions on the vB Forums and in the support system.

    Just remember that what happens in localhost, stays in localhost.


  5. #5
    New Member dpatel304 has disabled reputation
    Join Date
    Sep 2006
    Posts
    12
    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.

  6. #6
    Customer Support Manager Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol's Avatar
    Join Date
    Jul 2000
    Location
    Jelsoft InterGalactic HQ
    Posts
    142,692
    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/m...nce_ssh_backup

    Restore:
    http://www.vbulletin.com/docs/html/m...ce_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/showt...t=mysqlhotcopy

    Bigdump (restore only):
    http://www.ozerov.de/bigdump.php
    Steve Machol, vBulletin Customer Support Manager
    "Have Copy, Will Paste" (when appropriate)

    Please do not email or PM me for vBulletin support. I will be more than glad to answer your questions on the vB Forums and in the support system.

    Just remember that what happens in localhost, stays in localhost.


  7. #7
    New Member dpatel304 has disabled reputation
    Join Date
    Sep 2006
    Posts
    12
    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?

  8. #8
    Customer Support Manager Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol's Avatar
    Join Date
    Jul 2000
    Location
    Jelsoft InterGalactic HQ
    Posts
    142,692
    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.
    Steve Machol, vBulletin Customer Support Manager
    "Have Copy, Will Paste" (when appropriate)

    Please do not email or PM me for vBulletin support. I will be more than glad to answer your questions on the vB Forums and in the support system.

    Just remember that what happens in localhost, stays in localhost.


  9. #9
    New Member dpatel304 has disabled reputation
    Join Date
    Sep 2006
    Posts
    12
    ok. sorry for all the question, but thanks a bunch. you've been a great help.

  10. #10
    Customer Support Manager Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol's Avatar
    Join Date
    Jul 2000
    Location
    Jelsoft InterGalactic HQ
    Posts
    142,692
    No problem. Good luck.
    Steve Machol, vBulletin Customer Support Manager
    "Have Copy, Will Paste" (when appropriate)

    Please do not email or PM me for vBulletin support. I will be more than glad to answer your questions on the vB Forums and in the support system.

    Just remember that what happens in localhost, stays in localhost.


+ Reply to Thread

Similar Threads

  1. Can you conver phpbb to vbulletin from host to host?
    By Don Charlie in forum vBulletin Impex Import System
    Replies: 1
    Last Post: Fri 5th Jan '07, 1:18pm
  2. ImpEx moving data to database on diff. server/host
    By Exilera in forum vBulletin Impex Import System
    Replies: 1
    Last Post: Fri 13th Oct '06, 8:06pm
  3. phpbb data?
    By gersnet in forum vBulletin Pre-sales Questions
    Replies: 22
    Last Post: Thu 18th Aug '05, 11:28am
  4. phpbb to vb3 connection to source server failed
    By theoperative in forum vBulletin Impex Import System
    Replies: 0
    Last Post: Tue 12th Apr '05, 6:25pm
  5. phpBB 2.0.8 and spurious data
    By nepolia in forum vBulletin Pre-sales Questions
    Replies: 3
    Last Post: Sat 3rd Apr '04, 6:18am

Bookmarks

Posting Permissions

Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts