Support

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
n/a
Akeeba Solo version
n/a

Latest post by conectatec on Wednesday, 17 March 2021 05:57 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.

tampe125
Akeeba Staff

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

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.

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

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!