Restoring a Database

[Super Shadow]

Hey,

I have a .sql database backup of my boards, since they crashed a little while ago. I was wondering if anyone could direct me as to how to restore the database using this backup file... Someone's told me I might encounter a few problems, seeing as the .sql file is 95.3 MB... :surprised:

Thanks in advance :nervous:

- Alexandre

[Infopro]

mysql -u myname_myname -p myname_databasename < /home/I/Backedup/The/DB_Import/Here/bkMay_09_04.sql

95.3 MB is not a big deal at all.
HTH

[Fluous]

ermm...i was wondering the same thing just incase. but what you just said sorta clucked my mind infopro. sorta care on explaining more? lol

[Velocd]

Download putty:
http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

Enter your host, and make sure SSH for protocol is selected.

It will prompt you for your server username and password.

Once logged in, run the command given by Infopro above.

Another thread for reference:
https://vborg.vbsupport.ru/showthread.php?t=39558

[Super Shadow]

Thanks a lot, Velocd, but I downloaded putty, set in the login, but it won't let me write in my password... I'd be typing on my keyboard, but nothing actually shows up on screen. What's with that?.

EDIT: Looked at the thread you posted, and I decided to try out Secure CRT 4.1 Only thing is that, it gives me an error whenever I try to connect. It says I don't have Shell Access enabled... Is that at the server?

[ctsolutions]

Thanks a lot, Velocd, but I downloaded putty, set in the login, but it won't let me write in my password... I'd be typing on my keyboard, but nothing actually shows up on screen. What's with that?.


EDIT: Looked at the thread you posted, and I decided to try out Secure CRT 4.1 Only thing is that, it gives me an error whenever I try to connect. It says I don't have Shell Access enabled... Is that at the server?


first off all,did your host enable ssh for you ?


CtSolutions