Zip file way to big

[TheNextItGirl]

Hey there, I was given access to a database that holds over 15 million pieces of information. I have been going through hell and back trying to get it open today. Of course, It requires using some kind of zip file service but even the ones I've tried end up getting an error, file too large, etc. I was told that the file is probably going to require some special programming or something in order to open. Is there anyone who would know how to get this zip file open? and in English please? lol please pm me as well if you know anything.

 

[Machairodont]

it would be great to have more information:
- Ending of file? (zip?)
- Size of file?

Have you tried 7-zip? normally it handles nearly all compressed formats and I never had problems about too big files...

 

[Salamouna]

You need to have a powerfull pc also

 

[xcodes]

When you don't explain the situation properly how you would expect help ? Is this windows machine or Linux
Mysql or mariaBD , What error your getting with ZIP export ? Or you just want everyone to guess your situation ?

 

[Gogol]

If you have access to a linux machine, copy that file there. Install unzip (sudo apt install unzip if you are using a debian based linux), and try unzipping with that program, from the terminal. That program can unzip anything you can throw at it according to my experience (includes large db dumps).

 

[HoNeYBiRD]

Probably it has something to do with the amount of the files in the archive and/or the length of the filenames and not the actual size of the file. If you're using Windows, it can't handle too long file paths (limit is 260 chars), so when you're trying to unzip into a subdirectory of subdirectories, you can easily exceed this limit.

https://docs.microsoft.com/en-us/windows/win32/fileio/maximum-file-path-limitation?tabs=cmd
One thing you can try is to uncompress the file to the root of a drive.

 

[Ashk881]

What platform are you on (windows, Linux, Mac?). Also are you sure its not a zip bomb? Often decompression tools try to detect this and error out if its like a zip bomb. Did it come from a source you trust?

 

[TheNextItGirl]

When you don't explain the situation properly how you would expect help ? Is this windows machine or Linux
Mysql or mariaBD , What error your getting with ZIP export ? Or you just want everyone to guess your situation ?

Still new to this, i am doing this on my mac, the file was downloaded as a .zip file, thankfully I was able to convert it as an .SQL so I'm pretty sure there are services that can hopefully open a file this big.

 

[TheNextItGirl]

If you have access to a linux machine, copy that file there. Install unzip (sudo apt install unzip if you are using a debian based linux), and try unzipping with that program, from the terminal. That program can unzip anything you can throw at it according to my experience (includes large db dumps).

Thanks this actually was helpful!!

 

[Gogol]

Thanks this actually was helpful!!

I am glad it helped.