host transfer: upload db using ftp, possible?

[jeskel]

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

[Silver_2000]

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

[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"

[jeskel]

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

[Zachery]

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

[Cloud Strife]

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

[jeskel]

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

[Zachery]

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

[jeskel]

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.

[jeskel]

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

[Zachery]

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

[jeskel]

thanks a lot Zachery!

[Sir Yendor]

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.

[Zachery]

-pPASSWORD NEWDBNAME

Your missing the password

[Sir Yendor]

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.