List:General Discussion« Previous MessageNext Message »
From:David T-G Date:January 28 2003 12:22pm
Subject:Re: smallest dumpfiles in Windows in one step?
View as plain text  
Hash: SHA1

Benjamin, et al --

...and then Benjamin Pflugmann said...
% On Mon 2003-01-27 at 21:45:54 -0500, davidtg-mysql@stripped wrote:
% > 
% > ...and then Stefan Hinz, iConnect (Berlin) said...
% > % 
% > % c:\mysql\bin> mysqldump --all-databases --add-drop-table > mysql -h
% > % myoffice -u username -p
% ">" is wrong, of course, because it will try to direct the output into
% a file named "mysql". "|" is what is used to pipe between programs.

Agreed.  I wasn't going to mess with that side detail, though; I figured
that if he were actually doing this he couldn't have that character there,
and if it were just theoretical then it wasn't important anyway :-)

% > 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
% That wouldn't work, would it? I am quite sure the pipes are all
% interpreted by your local shell, so that would effectively mean to

Oh, you're quite right.  Slap some quotes around it like

  ... "gunzip ... pass"

and we're in much better shape.

% send the data via ssh to the remote machine for unzipping and then
% processing the output that got sent back via a local mysql. ;)

But it's *good* to run the data through that remote gunzip filter.
Besides, think of the MRTG output ;-)

% > Surely you have the cygwin toolkit and ssh for Win, right?
% And you could use build-in compression of ssh. So presuming a working
% ssh on the Microsoft Windows machine, something like this hopefully works:
% mysqldump ... | ssh -C myoffice mysql -u username -p pass

I haven't played with ssh compression to know how well it works (and I
should probably have used bzip2 in my example to squeeze out any extra
little bit), and I *have* seen problems with ssh installs that do not
compress, but I agree that that looks right (and more elegant :-) to me.

% > % HTH,
% > 
% > Ditto :-)
% ... :-)


%     Benjamin.
% -- 
% benjamin-mysql@stripped


mysql query,
- -- 
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"      Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

Version: GnuPG v1.0.7 (FreeBSD)

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