14 Mar
2010
14 Mar
'10
2:21 p.m.
Hi 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.
James