Import using compressed file

malru · 06-28-2006, 04:27 AM

Hi,

I've an export dump file which is compressed & it's of size 20Gb,
the actual size of the file is 60GB,i don't have that much free space,

so i want to import using this dump file in the form of compressed itself,Is it possible to do like this?

Please if any one knows how to do this,please let me know as soon as possible.

Thanks,
Malru

jschiwal · 06-28-2006, 05:42 AM

What type of compression is used? I think you could do something like piping the output of zcat/bzcat/uncompress into the database, such as "zcat dumpfile | dbaseprog -", if the program understands that "-" means to take the sql commands from the standard input. I glossed over the user/database part of the command of course.