#34874 – Export only COMPRESSED SQL file

Posted in ‘Akeeba Solo (standalone)’
This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Tuesday, 16 March 2021 12:15 CDT
conectatec

I'm trying to export only the database.

I want:

  • only one SQL file
  • compressed

 

My exported database .sql size is 215 MB

 

If I set "Size for split SQL dump files" to 0MB and try these configs, I get:

  • Main site database only (SQL File) + JPA format:
    • result: one sql file 215MB
  • Main site database only (SQL FIle) + ZIP format:
    • result: one UNCOMPRESSED 215MB zip file with one sql file
  • All configured databases (arquive file) + JPA format:
    • result: one UNCOMPRESSED 215MB JPA file with one sql file

 

The only way I found to export a COMPRESSED file is:

  • setting "Size for split SQL dump files" to 0.5MB + All configured databases (arquive file) + JPA format
    • result: one COMPRESSED JPA 20MB file with hundreds of sql## files...

 

Is'nt there an option to export a compressed sql file?

zip, gzip, jpa, I dont mind... just a single SQL file inside a compressed archive.

 

Thanks.

Custom Fields

PHP version (in x.y.z format) 8.0.3
Akeeba Solo version (x.y.x) 7.5.5.1
Wednesday, 17 March 2021 05:03 CDT
tampe125

Hello,

I'm sorry but that's not possible. In order to do so we would have to read the whole SQL file in memory and the compress it, so it's doable only for very small databases.

What you tried to have a compressed file is the correct method: Akeeba Backup will produce small files and then it's able to compress them one by one.

The resulting archive will include the installer, so you can easily upload and restore it using your browser.



Davide Tampellini

Developer and Support Staff



Italian: native

English: good



Please keep in mind my timezone and cultural differences when reading my replies. Thank you!



Wednesday, 17 March 2021 05:57 CDT
conectatec

Thanks for your reply. I'll close the ticket.

I don't know if this is posible but it would be awesome if you could add in the future an option to compress the file on Post-precessing.

It could be as "easy" as doing something like system(gzip $file) before sending it to Amazon, Google, FTP... to avoid loading it in PHP's memory but I don't know if this is a good practice.

This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.

Support Information

Working hours: Typically we work Monday to Friday, 9am to 7pm Cyprus timezone (EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets, but we cannot respond to them, outside of our working hours.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!