[CentOS] backup incrementals on mysql

Alexei Altuhov alexx187 at gmail.com
Tue Nov 11 19:35:40 UTC 2014


On Nov 10, 2014 9: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
>
>
> 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



More information about the CentOS mailing list