<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Times New Roman; font-size: 12pt; color: #000000'>If you setup public key authentication and a .my.cnf with the mysql credentials the following is more than sufficient:<br><br>ssh user@hostname -C "/usr/bin/mysqldump database" > /tmp/dump<br><br><div>-- <br>Cory Oldford<br>PeaceWorks Computer Consulting<br>#2 - 396 Assiniboine Ave, Winnipeg<br>204 480 0314 --or-- 519 725 7875, ext 610. </div><br><br>----- Original Message -----<br>From: john@netdirect.ca<br>To: "KWLUG discussion" <kwlug-disc@kwlug.org><br>Sent: Friday, February 12, 2010 11:24:29 AM GMT -06:00 US/Canada Central<br>Subject: Re: [kwlug-disc] secure remote backup of mysql?<br><br>What's wrong with an ssh tunnel?<br><br>John Van Ostrand , CTO, co-CEO<br>Net Direct Inc.<br>564 Weber St. N. Unit 12<br>Waterloo, ON N2L 5C6<br>Ph: 519-883-1172<br>Fx: 519-883-8533<br>http://www.netdirect.ca<br><br><br>----- Original Message -----<br>From: "Robert P. J. Day" [rpjday@crashcourse.ca]<br>Sent: 02/12/2010 12:15 PM EST<br>To: KWLUG discussion list <kwlug-disc@kwlug.org><br>Subject: [kwlug-disc] secure remote backup of mysql?<br><br><br><br><br> what's the strategy of choice for backing up an active mysql<br>database across the intertoobz securely? i just recently ran across<br>this:<br><br> http://www.zmanda.com/backup-mysql.html<br><br>worth it? overkill? thanks.<br><br>rday<br>--<br><br>========================================================================<br>Robert P. J. Day Waterloo, Ontario, CANADA<br><br> Linux Consulting, Training and Kernel Pedantry.<br><br>Web page: http://crashcourse.ca<br>Twitter: http://twitter.com/rpjday<br>========================================================================<br><br>_______________________________________________<br>kwlug-disc_kwlug.org mailing list<br>kwlug-disc_kwlug.org@kwlug.org<br>http://astoria.ccjclearline.com/mailman/listinfo/kwlug-disc_kwlug.org<br><br>_______________________________________________<br>kwlug-disc_kwlug.org mailing list<br>kwlug-disc_kwlug.org@kwlug.org<br>http://astoria.ccjclearline.com/mailman/listinfo/kwlug-disc_kwlug.org<br></div></body></html>