Search code examples
mysqllinuxbzip2bigdatadatabase

Can I split compressed sql file using split linux command? If not, then any other method to do?


I have a 30 GB compressed sql file (with extension .sql.bz2) and if I unzip it will become 300 GB. However due to disk space issue, I can't do the same.

Could I split the compressed sql file something like using split linux command? I tried but with no success. Any other approach?

Thanks!


Solution

  • You might take a look at this question: split-files-using-tar-gz-zip-or-bzip2 I assume the reason you want to split it is to move it? And that you know you probably wont be able to import a small slice of the file into a database?