[bitfolk] mysqldump over SSH (Was: Re: The perils of opening tcp/22 to the Internet)

Hello, On Sun, Mar 14, 2010 at 01:46:40PM +0000, James Gregory wrote: Well, mysqldump typically outputs to stdout so you can just pipe that through SSH without issue. gzip it as well if you like: mysqldump -u dbuser dbname | gzip -c --best --rsyncable | ssh dbbackup(a)example.com 'cat > /data/backup/dbbackup.sql.gz' The usual problem with backing up a database *from* outside the box it's on is that just copying the files on disk won't usually provide a consistent (or in some cases, an at all usable) backup. But mysqldump from the db host itself through SSH doesn't suffer from that problem. (it has some other problems) Cheers, Andy -- http://bitfolk.com/ -- No-nonsense VPS hosting