Akeeba Solo

#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.

Environment Information

PHP version
Akeeba Solo version


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.



Akeeba Staff


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 • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!


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.

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!

Summer vacations: Our support will be closed for replies and new tickets from August 6th to August 21st, 2022 due to summer vacations.