# mysql backup **URL:** \ **Category:** Other MySQL® Questions\ **Created:** [August 12, 2010, 8:47am UTC](https://forums.percona.com/t/mysql-backup/1475 "2010-08-12T08:47:10Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![yogesh77](https://avatars.discourse-cdn.com/v4/letter/y/f08c70/32.png) [@yogesh77](https://forums.percona.com/u/yogesh77)\ **Post date:** [August 12, 2010, 8:47am UTC](https://forums.percona.com/t/mysql-backup/1475/1 "2010-08-12T08:47:10Z")
what is best option to take mysql backup ( incremental backup ) without any database locking for a database having size more than 500 GB and increasing continuously. also how to keep backup on different geographical location. The method I used: mysqldump : lock the table, not suitable for big databases and for real time application. ibbackup : good tool but i do not find any incremental backup option there. using binary log for incremental backup is time consuming process. Please suggest. ---
**Author:** ![justin.swanhart](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/justin.swanhart/32/16904_2.png) [@justin.swanhart](https://forums.percona.com/u/justin.swanhart)\ **Post date:** [August 12, 2010, 10:17am UTC](https://forums.percona.com/t/mysql-backup/1475/2 "2010-08-12T10:17:09Z")
Hi, If you are using only InnoDB tables, then you should consider xtrabackup. Xtrabackup is similar to ibbackup, but it does support incremental backups: [URL][Percona Open Source Software Documentation](http://www.percona.com/docs/wiki/percona-xtrabackup:start%5B/URL%5D) Unfortunately Xtrabackup can’t stream an incremental backup to a remote machine, so you will have to make a local backup then rsync it to a remote location. –Swany ---
**Author:** ![yogesh77](https://avatars.discourse-cdn.com/v4/letter/y/f08c70/32.png) [@yogesh77](https://forums.percona.com/u/yogesh77)\ **Post date:** [August 12, 2010, 1:53pm UTC](https://forums.percona.com/t/mysql-backup/1475/3 "2010-08-12T13:53:41Z")
there are few myisam tables also, can xtrabackup handles both innodb and myisam? ---
**Author:** ![yogesh77](https://avatars.discourse-cdn.com/v4/letter/y/f08c70/32.png) [@yogesh77](https://forums.percona.com/u/yogesh77)\ **Post date:** [August 12, 2010, 2:16pm UTC](https://forums.percona.com/t/mysql-backup/1475/4 "2010-08-12T14:16:11Z")
this is possible, i read it in documentation. [http://www.percona.com/docs/wiki/percona-xtrabackup:xtraback](http://www.percona.com/docs/wiki/percona-xtrabackup:xtraback) up\_manual#making\_a\_partial\_backup If xtrabackup provides all required backup feature then how xtrabackup is different from ibbackup which is paid version? ---
**Author:** ![xaprb](https://avatars.discourse-cdn.com/v4/letter/x/49beb7/32.png) [@xaprb](https://forums.percona.com/u/xaprb)\ **Post date:** [August 12, 2010, 7:09pm UTC](https://forums.percona.com/t/mysql-backup/1475/5 "2010-08-12T19:09:42Z")
ibbackup is not a paid version of XtraBackup. ibbackup is a closed-source backup utility owned by Oracle. XtraBackup is an open-source backup utility created by Percona about a year and a half ago. They are different products from different companies. They just happen to work in a similar fashion. ---
**Author:** ![revin](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/revin/32/824_2.png) [@revin](https://forums.percona.com/u/revin)\ **Post date:** [August 13, 2010, 4:00pm UTC](https://forums.percona.com/t/mysql-backup/1475/6 "2010-08-13T16:00:08Z")
@yogesh77 I might be looking at your situation the wrong way. But if you install mysql 5.1 from RPM, xtrabackup have RPMs available as well. [URL][Download Percona XtraBackup 8.0](http://www.percona.com/downloads/XtraBackup/%5B/URL%5D) ---
**Author:** ![yogesh77](https://avatars.discourse-cdn.com/v4/letter/y/f08c70/32.png) [@yogesh77](https://forums.percona.com/u/yogesh77)\ **Post date:** [August 14, 2010, 8:03am UTC](https://forums.percona.com/t/mysql-backup/1475/7 "2010-08-14T08:03:40Z")
I am able to install RPM xtrabackup, some more error after running backups. 100814 10:20:21 InnoDB: Operating system error number 9 in a file operation. InnoDB: Error number 9 means ‘Bad file descriptor’. InnoDB: Some operating system error numbers are described at InnoDB: [http://dev.mysql.com/doc/refman/5.1/en/operating-system-erro](http://dev.mysql.com/doc/refman/5.1/en/operating-system-erro) r-codes.html InnoDB: File operation call: ‘close’. InnoDB: Cannot continue operation. ---
**Author:** ![yogesh77](https://avatars.discourse-cdn.com/v4/letter/y/f08c70/32.png) [@yogesh77](https://forums.percona.com/u/yogesh77)\ **Post date:** [August 17, 2010, 3:23am UTC](https://forums.percona.com/t/mysql-backup/1475/8 "2010-08-17T03:23:01Z")
any body facing this issue while taking backup?