11 Nov
2014
11 Nov
'14
8:35 p.m.
On Nov 10, 2014 9:25 PM, "Rodrigo Pichiñual Norin" < rodrigo.pichinual@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_b... [2] http://www.slideshare.net/mobile/kastauyra/bitmap-33283809