Hello,
On Sun, Mar 14, 2010 at 01:46:40PM +0000, James Gregory wrote:
You can't easily do MySQL dump backups over SSH
for example!
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