[H-GEN] remote backup of server

[Michael Anthon]

[ Humbug *General* list - semi-serious discussions about Humbug and     ]
[ Unix-related topics. Posts from non-subscribed addresses will vanish. ]

> > Either the mysqldump tool to dump the grants/structure/data to an SQL
> > file and scp that,
or this...
ssh backup_user at host mysqldump --opt --all-databases | gzip > backup.gz

Particularly useful when there is not enough space on the database host
to store the full backup.

Cheers
Michael

--
* This is list (humbug) general handled by majordomo at lists.humbug.org.au .
* Postings to this list are only accepted from subscribed addresses of
* lists 'general' or 'general-post'.  See http://www.humbug.org.au/