Andrew,
> Good morning everyone
Thanks for your optimism. It's 5 o'clock in the afternoon, here in
Berlin ;)
> I tried the following in Windows; but stopped
> mysqldump after the resulting file exceeded 1GB:
> mysqldump -q -C -uusername -p"password" dbname >
> dbname.dmp
Well, Unix seems to be so much better in many ways as you can do
modularized things like
> mysqldump -q -uusername -p dbname | gzip -c >
> dbname.gz
But this won't help you too much. Here's how I solved the problem of
backing up my MySQL databases on a Win2K box at home to a Linux box in
my office. A mysqldump of all my databases will only produce about 50 MB
of SQL, so maybe this solution isn't suitable for you. On the other
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.
HTH,
--
Stefan Hinz <hinz@stripped>
Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
----- Original Message -----
From: "Andrew Gould" <andrewgould@stripped>
To: <mysql@stripped>
Sent: Friday, January 24, 2003 1:47 PM
Subject: smallest dumpfiles in Windows in one step?
> 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 <mysql-thread130819@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-list_hinz=iconnect.de@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
