Good morning everyone, 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 Thanks, Andrew Gould __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com --------------------------------------------------------------------- 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
