-----BEGIN PGP SIGNED MESSAGE-----
...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?
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-----