gpg: Signature made Sun Mar 14 14:28:07 2010 UTC using DSA key ID BF15490B
gpg: Good signature from "Andy Smith <andy@strugglers.net>"
gpg: aka "Andrew James Smith <andy@strugglers.net>"
gpg: aka "Andy Smith (UKUUG) <andy.smith@ukuug.org>"
gpg: aka "Andy Smith (BitFolk Ltd.) <andy@bitfolk.com>"
gpg: aka "Andy Smith (Linux User Groups UK) <andy@lug.org.uk>"
gpg: aka "Andy Smith (Cernio Technology Cooperative) <andy.smith@cernio.com>"
Hello,
On Sun, Mar 14, 2010 at 02:21:41PM +0000, James Gregory wrote:
> > 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.
ssh dbbackup@dbhost 'mysqldump -u dbuser dbname | gzip -c --best --rsyncable' > /data/backup/dbbackup.sql.gz
Sorry!
Cheers,
Andy
