Ok, don't yell at me for not knowing anything about telnet....but I tried to restore my .SQL file on my hard drive, and got numerous errors, you can laugh all you want because some of the stuff I'm about to say is newbie.
first....I have Windows 2000....I go into "command.exe".....and execute it, giving me a little black window with a C:\>
I type: ftp
It gives me a: ftp>
then it asks for my username and password when I login to my IP address of the server that has vbulletin installed on it... so I enter it, then I'm in. I have the SQL file sitting on my hard drive, and in a directory on my server @: /forums/forum.sql
I create a new database called "forum_here".....but what I have a problem with is getting my SQL file restored.
what do I type at the "ftp>"?
ftp> mysql -uUSERNAME -pPASSWORD newdbname < /path/to/dump.txt right?
I don't have a "dump.txt"....I just have a file I got when I backed the databse up thru the admin CP.
Really, what I've done to start was I went into the Admin CP and backed everything up, I did a dump and saved it on my hard drive, that's what I'm trying to restore, I'm not transferring it from domain to domain thru telnet, but rather transferring it from server1, to my hard drive, then to server2., I just want to restore it...I have absolutely no clue how to telnet, and everytime I type "mysql" at the "ftp>" prompt, it says "invalid command"
the following commands work though:
Commands may be abbreviated. Commands are:
! delete literal prompt send
? debug ls put status
append dir mdelete pwd trace
ascii disconnect mdir quit type
bell get mget quote user
binary glob mkdir recv verbose
bye hash mls remotehelp
cd help mput rename
close lcd open rmdir
Any help on what to do next would be greatly appreciated....
first....I have Windows 2000....I go into "command.exe".....and execute it, giving me a little black window with a C:\>
I type: ftp
It gives me a: ftp>
then it asks for my username and password when I login to my IP address of the server that has vbulletin installed on it... so I enter it, then I'm in. I have the SQL file sitting on my hard drive, and in a directory on my server @: /forums/forum.sql
I create a new database called "forum_here".....but what I have a problem with is getting my SQL file restored.
what do I type at the "ftp>"?
ftp> mysql -uUSERNAME -pPASSWORD newdbname < /path/to/dump.txt right?
I don't have a "dump.txt"....I just have a file I got when I backed the databse up thru the admin CP.
Really, what I've done to start was I went into the Admin CP and backed everything up, I did a dump and saved it on my hard drive, that's what I'm trying to restore, I'm not transferring it from domain to domain thru telnet, but rather transferring it from server1, to my hard drive, then to server2., I just want to restore it...I have absolutely no clue how to telnet, and everytime I type "mysql" at the "ftp>" prompt, it says "invalid command"
the following commands work though:
Commands may be abbreviated. Commands are:
! delete literal prompt send
? debug ls put status
append dir mdelete pwd trace
ascii disconnect mdir quit type
bell get mget quote user
binary glob mkdir recv verbose
bye hash mls remotehelp
cd help mput rename
close lcd open rmdir
Any help on what to do next would be greatly appreciated....
Comment