-----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) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- 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----- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php