On Mon, Nov 10, 2014 at 8:25 PM, Rodrigo Pichiñual Norin <rodrigo.pichinual at gmail.com> wrote: > Hi all. > > > I usally make backups of databases mysql. > > I make buckups of all datbase for example: > > mysqldump -u user -ppassword name_db > backups.sql > > > also I make backups just its schema for example > > mysqldump -u user -ppassword name_db --no-data > backups.sql Hola, If size's a concern, just export your DBs gziped : mysqldump -u user database | gzip > backup_database.sql Also if you are concerned about time to compress, you can enable multithreaded parallel gzip compress with pigz (available in EPEL) : mysqldump -u user database | pigz > backup_database.sql TBH, 500 MB databases aren't big enough to seek a more complex approach (unless you have more ambitious RTO/RPO requirements) HTH