[kwlug-disc] secure remote backup of mysql?

[Cory Oldford]

If you setup public key authentication and a .my.cnf with the mysql credentials the following is more than sufficient: 

ssh user at hostname -C "/usr/bin/mysqldump database" > /tmp/dump 


-- 
Cory Oldford 
PeaceWorks Computer Consulting 
#2 - 396 Assiniboine Ave, Winnipeg 
204 480 0314 --or-- 519 725 7875, ext 610. 

----- Original Message ----- 
From: john at netdirect.ca 
To: "KWLUG discussion" <kwlug-disc at kwlug.org> 
Sent: Friday, February 12, 2010 11:24:29 AM GMT -06:00 US/Canada Central 
Subject: Re: [kwlug-disc] secure remote backup of mysql? 

What's wrong with an ssh tunnel? 

John Van Ostrand , CTO, co-CEO 
Net Direct Inc. 
564 Weber St. N. Unit 12 
Waterloo, ON N2L 5C6 
Ph: 519-883-1172 
Fx: 519-883-8533 
http://www.netdirect.ca 


----- Original Message ----- 
From: "Robert P. J. Day" [rpjday at crashcourse.ca] 
Sent: 02/12/2010 12:15 PM EST 
To: KWLUG discussion list <kwlug-disc at kwlug.org> 
Subject: [kwlug-disc] secure remote backup of mysql? 




what's the strategy of choice for backing up an active mysql 
database across the intertoobz securely? i just recently ran across 
this: 

http://www.zmanda.com/backup-mysql.html 

worth it? overkill? thanks. 

rday 
-- 

======================================================================== 
Robert P. J. Day Waterloo, Ontario, CANADA 

Linux Consulting, Training and Kernel Pedantry. 

Web page: http://crashcourse.ca 
Twitter: http://twitter.com/rpjday 
======================================================================== 

_______________________________________________ 
kwlug-disc_kwlug.org mailing list 
kwlug-disc_kwlug.org at kwlug.org 
http://astoria.ccjclearline.com/mailman/listinfo/kwlug-disc_kwlug.org 

_______________________________________________ 
kwlug-disc_kwlug.org mailing list 
kwlug-disc_kwlug.org at kwlug.org 
http://astoria.ccjclearline.com/mailman/listinfo/kwlug-disc_kwlug.org 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://kwlug.org/pipermail/kwlug-disc_kwlug.org/attachments/20100212/856fafec/attachment.htm>