Announcement

Collapse
No announcement yet.

host transfer: upload db using ftp, possible?

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

  • host transfer: upload db using ftp, possible?

    Hi,
    I read this thread: http://www.vbulletin.com/forum/showthread.php?t=96001
    and these advice: http://www.vbulletin.com/manual/movingservers.htm

    Here is my problem: my three weeks old community cannot be reached. The server on which it was hosted has been down for more than 4 days now. No answers no nothing. I got another account at a new hosting company. I have a backup of my db. I will have to upload al the RC4 files on the new server as well as the db. However I don't know nothing when it comes to telnet and such things. Can I just use ftp to upload my db? It's not too big I think. Where will I have to upload it? How? hum... that's bad. I'm a bit lost.

    Thanks in advance,

    Regards,

    Alex
    Alex

  • #2
    No - I dont think so - Think you have to use Telnet to import - upload a DB

    Ask your host to do it for you ....

    Doug
    http://www.TALONClub.com/forum
    http://www.prowltalk.com
    http://www.nloc.net
    http://www.nhtoc.com

    Comment


    • #3
      Alex,
      You can upload the database via FTP, but you cannot inport it that way.

      If your new host offers phpMyAdmin (or you install it yourself) you can go to the SQL tab an import the database directly from your home computer. Browse for it on your local machine and hit "go"
      Webmaster:
      @forumz

      Comment


      • #4
        Originally posted by Martin
        Alex,
        You can upload the database via FTP, but you cannot inport it that way.

        If your new host offers phpMyAdmin (or you install it yourself) you can go to the SQL tab an import the database directly from your home computer. Browse for it on your local machine and hit "go"
        thanks a lot. I will give it a try asap.

        best regards

        Alex
        Alex

        Comment


        • #5
          Using phpMyAdmin will probally not work if the database is much larger than 2 megs.

          Comment


          • #6
            Or upload your database through ftp, and nicely ask your host to import it for you

            Comment


            • #7
              ok here is the thing: the ftp upload solution doesn't work so i will have to use telnet. Unfortunatly I am not familiar with at all... I have downloaded the Putty freeware (first result on google for the keyword 'telnet') but I don't know how to use it. The db I need to import is on my comp. I have phpdev installed on a winXP OS. If anyone can help me that would just be great.



              thanks in advance for your time

              best regards,

              Alex
              Alex

              Comment


              • #8
                You first need to upload the database to the server, then run telnet to import it

                Comment


                • #9
                  Ok here is a weird thing.......... On my comp the db is 5meg and once uploaded it's only 1 meg...... where are the 4 extra megs gone? I am using leech ftp.
                  Alex

                  Comment


                  • #10
                    ok the problem is now solved... I just had to to use another ftp client. So what's next? the db is uploaded, how can I import it now?

                    thanks in advance

                    best regards,

                    Alex
                    Alex

                    Comment


                    • #11
                      Moving servers step 3 http://www.vbulletin.com/manual/movingservers.html

                      Comment


                      • #12
                        thanks a lot Zachery!
                        Alex

                        Comment


                        • #13
                          I've got to Step three here and have been banging my head for 4 days trying to figure this out.



                          I type:
                          mysql –uUSERNAME –p NEWDBNAME < /PATH/TO/NEW/DUMP.SQL


                          changing as needed:

                          -uUSERNAME to
                          -uforum (forum is the username for the database I created)

                          -p NEWDBNAME to
                          -p bulletin_board.sql (bulletin_board.sql is the database I created. I* also tried it simply as bulletin_board without the .sql)

                          < /PATH/TO/NEW/DUMP.SQL to
                          < /home/webadmin/ vb_backup.sql (the directory where the backed up database was transfered. I can see the database in this directory and it's the same size on both servers so I know it transfered.)

                          SSH appears to do what it is suppossed to do. I then go into my Control Panel to look at the database, I see it's name but when I try to look at it, it says "No Tables Found in databse".

                          I have two hosts who have spent about three hours with me and are getting tired of hearing me call about this.

                          What am I doing wrong? What step did I miss?

                          Thanks for the help.

                          Comment


                          • #14
                            -pPASSWORD NEWDBNAME

                            Your missing the password

                            Comment


                            • #15
                              Ahhh that would make things easier :-) in the Manual, Step 3 page

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

                              there is no reference to a password.

                              Thanks for the quick reply.

                              Comment

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