Skip to content
WJunction - Webmaster Forum

Bigdump fails...

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.

About the author

S
Active Member · Joined
I do abit of this and that, i do have Skype ask me for it if you really need it :/
2,577
Messages
538
Reactions
113
Points

Advertise on WJunction

Reach 1000's of webmasters, hosts & affiliates. Banner & sponsored-thread slots available.

Contact us
Back
Top Bottom