Re: [bitfolk] mysqldump over SSH (Was: Re: The perils of ope…

Top Page

Reply to this message
Author: James Gregory
Date:  
To: users
Subject: Re: [bitfolk] mysqldump over SSH (Was: Re: The perils of opening tcp/22 to the Internet)
Hi Andy,

> mysqldump -u dbuser dbname | gzip -c --best --rsyncable | ssh dbbackup@??? 'cat > /data/backup/dbbackup.sql.gz'


Perhaps mysqldump wasn't the best example to use! Anyway, in your
example, you've show mysqldump on the local machine going to a remote
machine - not a problem. I thought the case being explained (when you
might have issue not being SU) was related to a remote machine SSHing
then doing the backup - that is where doing a local 'to disk' backup
then remote copy would be best I think.

James