List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:January 30 2008 3:44pm
Subject:RE: transfer huge mysql db
View as plain text  
> >> mysqldump -A > file.dump
> >> tar -jcf file.dump
> >> rsync
> >
> > [JS] You could also just pipe the output of mysqldump through gzip.
> > tar buys
> > you nothing, since it is a single file.
>
> -j is the bzip2 compression option. :)
[JS] Yes, but tar is just extra baggage.


Regards,

Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com





Thread
transfer huge mysql dbIvan Levchenko24 Jan
  • Re: transfer huge mysql dbSaravanan24 Jan
    • Re: transfer huge mysql dbSimon Elliston Ball24 Jan
  • Re: transfer huge mysql dbMatthias Witte24 Jan
    • Re: transfer huge mysql dbIvan Levchenko24 Jan
    • Re: transfer huge mysql dbDavid Schneider-Joseph30 Jan
  • Re: transfer huge mysql dbChris29 Jan
    • transfer huge mysql db between partitionsHelen M Hudson29 Jan
    • RE: transfer huge mysql dbJerry Schwartz29 Jan
      • What about binary files? [was: Re: transfer huge mysql db]Erik Giberti29 Jan
      • Re: transfer huge mysql dbDavid Schneider-Joseph30 Jan
        • RE: transfer huge mysql dbJerry Schwartz30 Jan
          • Re: transfer huge mysql dbDavid Schneider-Joseph30 Jan
            • Re: transfer huge mysql dbMoon's Father2 Jun
              • Re: transfer huge mysql dbIvan Levchenko2 Jun
Re: transfer huge mysql dbIvan Levchenko24 Jan