From: Dan Nelson Date: January 24 2003 4:34pm Subject: Re: smallest dumpfiles in Windows in one step? List-Archive: http://lists.mysql.com/mysql/130841 Message-Id: <20030124163430.GA41076@dan.emsphone.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii 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 dnelson@stripped