List:General Discussion« Previous MessageNext Message »
From:Tom Brown Date:November 22 2005 1:27pm
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).

OK seems like i will be using split for this as i can use

mysqldump -e -u user -ppass dbname | split -b 2000m

to get my db in 2 gig file(s)

I can then cat them together to put them back into the db

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