List:General Discussion« Previous MessageNext Message »
From:iConnect \(Berlin\) Stefan Hinz Date:January 24 2003 9:34pm
Subject:Re: smallest dumpfiles in Windows in one step?
View as plain text  
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
>

Thread
smallest dumpfiles in Windows in one step?Andrew Gould24 Jan
  • Re: smallest dumpfiles in Windows in one step?Dan Nelson24 Jan
  • Re: smallest dumpfiles in Windows in one step?iConnect \(Berlin\) Stefan Hinz24 Jan
    • Re: smallest dumpfiles in Windows in one step?David T-G28 Jan
      • Re: smallest dumpfiles in Windows in one step?Benjamin Pflugmann28 Jan
        • Re: smallest dumpfiles in Windows in one step?David T-G28 Jan