[aklug] Re: Remote backup of MySQL database

From: Jeremy Austin <jhaustin@gmail.com>
Date: Wed Feb 23 2011 - 21:15:23 AKST

On Wed, Feb 23, 2011 at 9:03 PM, Christopher Howard
<christopher.howard@frigidcode.com> wrote:
 IIRC, mysqldump would do the trick, but it seems on my
> distribution that you have to install the whole bloody MySQL server just
> to get that program. Googling brought up some scripts where you do the
> dump on the remote server, and then copy the file over to your machine,
> but that is a bit less elegant than I would prefer.

Less elegant perhaps, but probably with much greater bandwidth
economy; I bet piping the .sql file through bzip or gzip would help a
great deal. There's always socat, a great tool Shane put me on to.

jermudgeon
---------
To unsubscribe, send email to <aklug-request@aklug.org>
with 'unsubscribe' in the message body.
Received on Wed Feb 23 21:16:41 2011

This archive was generated by hypermail 2.1.8 : Wed Feb 23 2011 - 21:16:41 AKST