14 Mar
2010
14 Mar
'10
2:28 p.m.
Hello,
On Sun, Mar 14, 2010 at 02:21:41PM +0000, James Gregory wrote:
ssh dbbackup@dbhost 'mysqldump -u dbuser dbname | gzip -c --best --rsyncable'
> /data/backup/dbbackup.sql.gz
Sorry!
Cheers,
Andy
mysqldump -u
dbuser dbname | gzip -c --best --rsyncable | ssh dbbackup(a)example.com '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.