List:General Discussion« Previous MessageNext Message »
From:Tom Brown Date:November 22 2005 12:10pm
Subject:Re: dump to more than 1 file
View as plain text  
> The output of mysqldump is standard output, not a file.  You can pipe
> it into another program, or redirect the output to a file, but
> mysqldump does not make a file.  Therefore, there is no option in
> mysqldump to make more than 1 file.
> 
> How is your database stored on disk?  The documentation Edwin pointed
> to shows you how to dump individual tables, so dumping each table
> separately might work.  Also, you can pipe your output into a
> compression utility (bzip2 compresses text smaller than gzip).

yes thanks to you both - alas the majority of the data is made up of 
blobs in a single table to the select option around dates might work - 
Also i may try exporting into named pipes or some other such to get the 
data into more than 1 file

its times like this i wish mysqldump behaved more like exp

thanks

Thread
dump to more than 1 fileTom Brown21 Nov
  • RE: dump to more than 1 fileISC Edwin Cruz21 Nov
    • Re: dump to more than 1 filesheeri kritzer21 Nov
      • Re: dump to more than 1 fileTom Brown22 Nov
        • Re: dump to more than 1 fileTom Brown22 Nov
  • Re: dump to more than 1 fileSteve Edberg22 Nov
  • Re: dump to more than 1 fileGleb Paharenko22 Nov