-----BEGIN PGP SIGNED MESSAGE-----
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 :-)
% ... :-)
HTH & HAND
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)
-----END PGP SIGNATURE-----