help please!! Problems with Importing vB through SSH 2.

[dinko X2K]

I recently switched from a shared server to dedicated, a:
Compaq, P3 1GHz, 512MB, with Ensim Software

I followed the instructions on the manual, and when it asked to put /path/to/dump.sql i did that...
in SSH it gave me a error saying Permission Denied.

Pleae help me!!!

AIM: dinko2222
email: dinko2222@aol.com

[The Prohacker]

Were you root when you did that?

[dinko X2K]

Originally posted by The Prohacker
Were you root when you did that?
i am on step 3 now and have a problem...

Step Three - Restore to new server

telnet into machine2
create a database on the mysql if necessary (ask your server admin for help with this as it varies from machine to machine)
at the prompt type
mysql -uUSERNAME -p newdbname < /path/to/dump.sql
this takes a couple of minutes depending on your database size, but you can track the progress either by FTP (checking the /mysql/data/newdbname and see the files appearing) or by phpMyAdmin (you should see the files appearing there)
when it is completed, it will bring you back to the prompt


i got in, i typed in
mysql -uroot -p vbforums [enter]
/home/..............forums/admin/forumbackup-05-20-2002.sql; [enter]
and then it gives me an error saying... Error 1064: You have an error in your SQL syntax near '/home/.............forums/admin/forumbackup-05-20-2002.sql' at line1


Any help would be greatly appreciated

I just signed into AIM if you have it...

AIM: dinko2222
email: dinko2222@aol.com

[eva2000]

you're meant to type on 1 line

mysql -u mysqlusername -p databasename < /path/to/backup.sql

[dinko X2K]

Originally posted by eva2000
you're meant to type on 1 line

mysql -u mysqlusername -p databasename < /path/to/backup.sql
i don't understand... could you please explain more eva

[dinko X2K]

eva, i did it :D
i don't know how much i can thank you!

check out the board...
http://64.246.40.133/~admin1/forums/

[eva2000]

Originally posted by dinko X2K
eva, i did it :D
i don't know how much i can thank you!

check out the board...
http://64.246.40.133/~admin1/forums/ no probs :)