Status
Not open for further replies.
8 comments
Code:
http://www.guvnr.com/web/web-dev/command-line-interface-cli-using-putty/
Go through this course related to VPS It helped me alot :D
 
Yes definitely read into SSH, I was pretty worried and scared about using SSH a few months back, but its only 2 commands you have to learn and your set ;)
 
follow these steps, and you will see how easy ssh is.

1. Upload the .sql file thru ftp first.

2. Then log into ur ssh client, and move to the directory the backup is located. You can do this by typing...
Code:
cd path/to/backupsql

3. type (replace the underlined ones)
Code:
mysql -u [U]dbusername[/U] -p [U]databasename[/U] < [U]backupsqlname[/U].sql

4. hit enter and the client will ask for your db password.

5. and your database will be restored.



* alternatively, after login if you wanna skip step 2, just type
mysql -u dbusername -p databasename < /path/to/backupname.sql
 
Status
Not open for further replies.
Back
Top