[CentOS] backup incrementals on mysql

[Fran Garcia]

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