In the last episode (Jan 24), Andrew Gould said: > I'm running short on harddrive space on my Windows computer. What's > the best way to get the smallest dump file in one step in Windows XP? > > On my FreeBSD computer, the following command produces an 808MB > dumpfile from an 11GB database in one step: > > mysqldump -q -uusername -p dbname | gzip -c > dbname.gz > > I tried the following in Windows; but stopped mysqldump after the > resulting file exceeded 1GB: > > mysqldump -q -C -uusername -p"password" dbname > dbname.dmp
You can get gzip for windows at http://www.gzip.org/#exe . That will let you use the same commandline as you used on the FreeBSD system. -- Dan Nelson [EMAIL PROTECTED] --------------------------------------------------------------------- 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