-----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-----
