Announcement

Collapse
No announcement yet.

Moving to a host that has no telnet

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Moving to a host that has no telnet

    Ok, as you can see in the title, that is what I want to do... My existing host has telnet, but the new one does not...

    Now, my database size is about 30 megs, and if I was to transfer this in phpmyadmin it would time out... And if I did it table by table, ths would take forever...

    Now what I want to know is if I can transfer JUST the members with their post counts to the new host... I dont mind about their statuses because I can change that when we get to the new board...

    Can it be done??? And how easy is it to do??

    Thanks alot

    Cloud

  • #2
    You can dump only one of the tables to a .sql file and then use PMA on the new host to import it.

    Why would you move to a host that doesn't have shell access?
    --filburt1, vBulletin.org/vBulletinTemplates.com moderator
    Web Design Forums.net: vB Board of the Month
    vBulletin Mail System (vBMS): webmail for your forum users

    Comment


    • #3
      my advice is request new host to import your sql backup... that's the safe way to reimport
      :: Always Back Up Forum Database + Attachments BEFORE upgrading !
      :: Nginx SPDY SSL - World Flags Demo [video results]
      :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

      Comment


      • #4
        thanks for your help, but is there anyway to put on JUST the members and not the posts???

        Thankyou

        Comment


        • #5
          1. Dump the user table from PMA to a file
          2. Import the dumped file into the new host's PMA

          You'll overwrite any existing users, though, but as I hear JamesUS is working on a vB to vB importer that should fix that.
          --filburt1, vBulletin.org/vBulletinTemplates.com moderator
          Web Design Forums.net: vB Board of the Month
          vBulletin Mail System (vBMS): webmail for your forum users

          Comment


          • #6
            Thanks filburt...
            I dont mind about the other bit though...
            There are no registered users :-)
            When I do this will they still have their mod statuses etc and also will their passwords still work???

            Cloud

            Comment


            • #7
              Yes and yes...might want to import the other userx tables, though.
              --filburt1, vBulletin.org/vBulletinTemplates.com moderator
              Web Design Forums.net: vB Board of the Month
              vBulletin Mail System (vBMS): webmail for your forum users

              Comment


              • #8
                Thanks, but what do each of these do??

                useractivation
                userfield
                usergroup
                usertitle

                Comment


                • #9
                  bump

                  Comment


                  • #10
                    You need the user and userfield tables at a minimum.
                    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                    Change CKEditor Colors to Match Style (for 4.1.4 and above)

                    Steve Machol Photography


                    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                    Comment


                    • #11
                      Thankyou steve..

                      Comment

                      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                      Working...
                      X