On Nov 10, 2014 9:25 PM, "Rodrigo Pichiñual Norin" < rodrigo.pichin...@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 _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
