On Nov 10, 2014 9:25 PM, "Rodrigo Pichiñual Norin" <
rodrigo.pichinual@xxxxxxxxx> 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
>
>
> but now I need a backups incrementals, because the size of DB is very big
> (500 mb)
>
>
> How to make this?
>
Rodrigo,
If your storage engine is InnoDB I would advise to use Percona
Innobackupex tool.
Take a look here:
[1]
http://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/incremental_backups_innobackupex.html
[2] http://www.slideshare.net/mobile/kastauyra/bitmap-33283809
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos
