Ssh - Irish SEO, Marketing & Webmaster Discussion

sullyman1 · #1 (**permalink**) 03-01-2008, 09:29 PM

Hi Folks,

How do i use SSH to connect to a server to backup a MySQL DB.

I am using a Windows machine and want to connect to a Hosting365 account to backup a database.

From reading up, i have downloaded the program Putty and entered correct Host name etc. but i am getting connection refused.

Is Putty the correct program to use? Am i on the right track.

Thanks,
S

paul · #2 (**permalink**) 03-01-2008, 10:05 PM

read this MySQL AB :: MySQL 5.0 Reference Manual :: 4.5.1 mysql — The MySQL Command-Line Tool

sullyman1 · #3 (**permalink**) 03-01-2008, 10:12 PM

Thanks Paul

I found those commands from searching online earlier but my problem is actually getting into a Shell command environment.

Hosting365 enabled Shell on my account earlier but when i run Putt now with correct login account, the Putty Window just disappears after entering login password

Any idea?

Frodo · #4 (**permalink**) 04-01-2008, 01:24 AM

Sounds like a wrong password/user really. If you are getting prompted for your user and pass then your connection is ok but some severs will force a client close on entering a wrong user pass combo as a security feature. I'd contact h365 and confirm you are using the right user and password, they may not be the same as your account login.

hosting365 · #5 (**permalink**) 04-01-2008, 09:46 AM

Just to confirm, once SSH is active, use your FTP user/pass combo to get in.

Forbairt · #6 (**permalink**) 05-01-2008, 01:16 AM

also change your putty settings to not close the window on exit ... might give you a useful bit of info

sullyman1 · #7 (**permalink**) 05-01-2008, 04:15 PM

Thanks guys.

Managed to login over SSH with putty but still having problems.

I have a few domains in my account. Do i need to CD into a certain directory.

I am trying to use this command

mysqldump -u username -pPassword Databasename > /hsphere/local/home/Webserver/bckdb/test.sql

to backup my MySQL DB but getting the following error:

Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect

Any ideas?

Frodo · #8 (**permalink**) 06-01-2008, 12:50 AM

I run this (extract only) on a cron to do daily back ups, I change to the directory I'm backing up to first thats only difference to yours, oh and no space between -u and username (thought thats probably just a typo here). But this might help you.

Code:

#!/bin/bash
# backup.sh by Ciaran

# file paths
ECHO=/bin/echo
LS=/bin/ls
DATE=/bin/date

# script variables
DATECODE=`date +%Y-%m-%d`
BACKDIR=/media/WD1/backUp/

# do the work
$ECHO `date` ":-- ==== starting backup ==== --"

###############################################
cd "$BACKDIR"
mkdir "$DATECODE"

$ECHO `date` ": Web Files Backup"
cd /srv
zip -r srv * >> /log.log
mv srv.zip $BACKDIR/$DATECODE

$ECHO `date` ": Apache Setup Backup"
cd /etc/apache2
zip -r apache * >> /log.log
mv apache.zip $BACKDIR/$DATECODE


$ECHO `date` ": MySQL backup"
cd $BACKDIR/$DATECODE
mysqldump -uusername -ppassword databasename > databasename.sql

Forbairt · #9 (**permalink**) 06-01-2008, 08:31 AM

Quote:

Originally Posted by sullyman1

mysqldump -u username -pPassword Databasename > /hsphere/local/home/Webserver/bckdb/test.sql

to backup my MySQL DB but getting the following error:

Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect

Any ideas?

I may be wrong but you may have to specify the host as well a lot of webhosts don't let you connect to localhost. -h should be what you're after

Forbairt · #10 (**permalink**) 06-01-2008, 08:34 AM

Quote:

Originally Posted by Frodo

I run this (extract only) on a cron to do daily back ups, I change to the directory I'm backing up to first thats only difference to yours, oh and no space between -u and username (thought thats probably just a typo here). But this might help you.

Code:

#!/bin/bash
# backup.sh by Ciaran

# file paths
ECHO=/bin/echo
LS=/bin/ls
DATE=/bin/date

# script variables
DATECODE=`date +%Y-%m-%d`
BACKDIR=/media/WD1/backUp/

# do the work
$ECHO `date` ":-- ==== starting backup ==== --"

###############################################
cd "$BACKDIR"
mkdir "$DATECODE"

$ECHO `date` ": Web Files Backup"
cd /srv
zip -r srv * >> /log.log
mv srv.zip $BACKDIR/$DATECODE

$ECHO `date` ": Apache Setup Backup"
cd /etc/apache2
zip -r apache * >> /log.log
mv apache.zip $BACKDIR/$DATECODE


$ECHO `date` ": MySQL backup"
cd $BACKDIR/$DATECODE
mysqldump -uusername -ppassword databasename > databasename.sql

Cheers for that I will probably start using that in conjunction with a cron from my local machine to pull down the backups and then store them offline.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
changing permissons via ssh	Cormac	Server / Technical Administration Tips and Queries	5	15-08-2006 11:29 PM