List:General Discussion« Previous MessageNext Message »
From:David T-G Date:January 28 2003 2:45am
Subject:Re: smallest dumpfiles in Windows in one step?
View as plain text  
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Stefan --

...and then Stefan Hinz, iConnect (Berlin) said...
% 
...
% backing up my MySQL databases on a Win2K box at home to a Linux box in
...
% hand, I have only 128 MBit upstream from my Win machine, and maybe you
% will have a faster network connection. I use:
% 
% c:\mysql\bin> mysqldump --all-databases --add-drop-table > mysql -h
% myoffice -u username -p
% 
% This will take some time, and it's most probably not the smartest thing
% one could do, but it works nicely.

Ouch!  You're mostly, or perhaps even only, dealing with simple text, so
why not take a moment to compress it before you send it over your tiny
drinking straw of a 'net pipeline...

  mysqldump ... | gzip -9 | ssh myoffice gunzip | mysql -u username -p pass

Surely you have the cygwin toolkit and ssh for Win, right?


% 
% HTH,

Ditto :-)


mysql query,
:-D
- -- 
David T-G                      * There is too much animal courage in 
(play) davidtg@stripped * society and not sufficient moral courage.
(work) davidtgwork@stripped  -- Mary Baker Eddy, "Science and Health"
http://justpickone.org/davidtg/      Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (FreeBSD)

iD8DBQE+Ne7iGb7uCXufRwARAvFYAJwMgjyBzYRyQ8/srrqFMVLU86yqPgCg0nyE
6uSEx9VEXPuHakEL3q3MPLg=
=/QK7
-----END PGP SIGNATURE-----
Thread
smallest dumpfiles in Windows in one step?Andrew Gould24 Jan
  • Re: smallest dumpfiles in Windows in one step?Dan Nelson24 Jan
  • Re: smallest dumpfiles in Windows in one step?iConnect \(Berlin\) Stefan Hinz24 Jan
    • Re: smallest dumpfiles in Windows in one step?David T-G28 Jan
      • Re: smallest dumpfiles in Windows in one step?Benjamin Pflugmann28 Jan
        • Re: smallest dumpfiles in Windows in one step?David T-G28 Jan