# Incremental MySQL Backup

**URL:** <https://forum.inductiveautomation.com/t/incremental-mysql-backup/7953>\
**Category:** Archived Topics\
**Created:** [February 4, 2014, 8:06pm UTC](https://forum.inductiveautomation.com/t/incremental-mysql-backup/7953 "2014-02-04T20:06:58Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mheaton](https://avatars.discourse-cdn.com/v4/letter/m/5f8ce5/32.png) [@mheaton](https://forum.inductiveautomation.com/u/mheaton)\
**Post date:** [February 4, 2014, 8:06pm UTC](https://forum.inductiveautomation.com/t/incremental-mysql-backup/7953/1 "2014-02-04T20:06:58Z")

</div>

Hello,

I am attempting to generate an incremental backup of a MySQL DB from command line. I have successfully generated a complete DB backup from CMD line using the mysqldump command but, I am having some trouble generating an incremental backup based off of that complete backup. I have read through the documentation from MySQL (Links below), and have yet to figure this out. Please note that the command I am trying to use for the incremental is mysqlbackup.

The snippet that I currently have is as follows:

```auto
"C:\Progra~1\MySQL\MySQL Server 5.6\bin\mysql.exe" -uUser -pPassword mysqlbackup --incremental --incremental-base=dir:"C:\Backup" --incremental-backup-dir="C:\Backup"
```

I am not sure if I have something out of order or don’t need the redundant “–increment” option. The full backup that the incremental backup is based off of is located in C:\Backup. Any help would be appreciated.

[dev.mysql.com/doc/mysql-enterpri … tions.html](http://dev.mysql.com/doc/mysql-enterprise-backup/3.6/en/backup-incremental-options.html)

[dev.mysql.com/doc/mysql-enterpri … ental.html](http://dev.mysql.com/doc/mysql-enterprise-backup/3.7/en/mysqlbackup.incremental.html)

Thanks,

-Mark

---

<div class="post-metadata">

**Author:** ![Kyle\_Chase](https://avatars.discourse-cdn.com/v4/letter/k/9de0a6/32.png) [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\
**Post date:** [February 4, 2014, 11:05pm UTC](https://forum.inductiveautomation.com/t/incremental-mysql-backup/7953/2 "2014-02-04T23:05:02Z")

</div>

If you are just doing backups of InnoDb and MyISAM tables, you can use the following  
[http://www.percona.com/software/percona-xtrabackup](http://www.percona.com/software/percona-xtrabackup)

It can do incremental backups.

---

<div class="post-metadata">

**Author:** ![mheaton](https://avatars.discourse-cdn.com/v4/letter/m/5f8ce5/32.png) [@mheaton](https://forum.inductiveautomation.com/u/mheaton)\
**Post date:** [February 4, 2014, 11:36pm UTC](https://forum.inductiveautomation.com/t/incremental-mysql-backup/7953/3 "2014-02-04T23:36:28Z")

</div>

Kyle,

Thanks for the link. I am running MySQL 5.5 on a Windows 7 Pro box. I believe Percona-xtrabackup only runs on Linux if I am not mistaken.

-Mark

---

<div class="post-metadata">

**Author:** ![Kyle\_Chase](https://avatars.discourse-cdn.com/v4/letter/k/9de0a6/32.png) [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\
**Post date:** [February 5, 2014, 4:58pm UTC](https://forum.inductiveautomation.com/t/incremental-mysql-backup/7953/4 "2014-02-05T16:58:38Z")

</div>

Ahh, I didnt pick up on that… time to switch to Linux?

---

<div class="post-metadata">

**Author:** ![mheaton](https://avatars.discourse-cdn.com/v4/letter/m/5f8ce5/32.png) [@mheaton](https://forum.inductiveautomation.com/u/mheaton)\
**Post date:** [February 6, 2014, 3:46pm UTC](https://forum.inductiveautomation.com/t/incremental-mysql-backup/7953/5 "2014-02-06T15:46:46Z")

</div>

That isn’t really a viable option at this point in time.