Verified with MariaDB 10, mysql> show create table nil_test \G *************************** 1. row *************************** Table: nil_test Create Table: CREATE TABLE `nil_test` ( `id` int(11) DEFAULT NULL, `name` varchar(10) DEFAULT NULL ) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 1 row in set (0.00 sec) nilnandan.joshi@Perconallc-Support:~/sandboxes/msb_10_0_13/data$ ls -al total 241692 drwx------ 6 nilnandan.joshi admin 4096 Aug 27 11:10 . drwxr-xr-x 4 nilnandan.joshi admin 4096 Aug 27 11:09 .. -rw-rw---- 1 nilnandan.joshi admin 68362240 Aug 27 11:13 aria_log.00000001 -rw-rw---- 1 nilnandan.joshi admin 52 Aug 27 11:13 aria_log_control -rw-rw---- 1 nilnandan.joshi admin 12582912 Aug 27 11:09 ibdata1 -rw-rw---- 1 nilnandan.joshi admin 50331648 Aug 27 11:09 ib_logfile0 -rw-rw---- 1 nilnandan.joshi admin 50331648 Aug 27 11:09 ib_logfile1 -rw-r----- 1 nilnandan.joshi admin 1643 Aug 27 11:09 msandbox.err -rw-rw---- 1 nilnandan.joshi admin 0 Aug 27 11:09 multi-master.info drwx------ 2 nilnandan.joshi admin 4096 Aug 27 11:09 mysql -rw-rw---- 1 nilnandan.joshi admin 6 Aug 27 11:09 mysql_sandbox10013.pid drwx------ 2 nilnandan.joshi admin 96 Aug 27 11:11 nil drwx------ 2 nilnandan.joshi admin 4096 Aug 27 11:09 performance_schema drwx------ 2 nilnandan.joshi admin 10 Aug 27 11:09 test nilnandan.joshi@Perconallc-Support:~/sandboxes/msb_10_0_13/data$ nilnandan.joshi@Perconallc-Support:~/sandboxes/msb_10_0_13$ sudo innobackupex --defaults-file=/home/nilnandan.joshi/sandboxes/msb_10_0_13/my.sandbox.cnf --user=root --password=msandbox --socket=/tmp/mysql_sandbox10013.sock /home/nilnandan.joshi/backup InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved. This software is published under the GNU GENERAL PUBLIC LICENSE Version 2, June 1991. Get the latest version of Percona XtraBackup, documentation, and help resources: http://www.percona.com/xb/p 140827 11:49:49 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/home/nilnandan.joshi/sandboxes/msb_10_0_13/my.sandbox.cnf;mysql_read_default_group=xtrabackup;mysql_socket=/tmp/mysql_sandbox10013.sock' as 'root' (using password: YES). 140827 11:49:49 innobackupex: Connected to MySQL server 140827 11:49:49 innobackupex: Executing a version check against the server... 140827 11:49:49 innobackupex: Done. IMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex prints "completed OK!". innobackupex: Using mysql server version 10.0.13-MariaDB innobackupex: Created backup directory /home/nilnandan.joshi/backup/2014-08-27_11-49-49 140827 11:49:49 innobackupex: Starting ibbackup with command: xtrabackup --defaults-file="/home/nilnandan.joshi/sandboxes/msb_10_0_13/my.sandbox.cnf" --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/home/nilnandan.joshi/backup/2014-08-27_11-49-49 --tmpdir=/home/nilnandan.joshi/sandboxes/msb_10_0_13/tmp --extra-lsndir='/home/nilnandan.joshi/sandboxes/msb_10_0_13/tmp' innobackupex: Waiting for ibbackup (pid=13538) to suspend innobackupex: Suspend file '/home/nilnandan.joshi/backup/2014-08-27_11-49-49/xtrabackup_suspended_2' xtrabackup version 2.2.3 based on MySQL server 5.6.17 Linux (x86_64) (revision id: ) xtrabackup: uses posix_fadvise(). xtrabackup: cd to /home/nilnandan.joshi/sandboxes/msb_10_0_13/data xtrabackup: open files limit requested 0, set to 1024 xtrabackup: using the following InnoDB configuration: xtrabackup: innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 50331648 >> log scanned up to (1616918) [01] Copying ./ibdata1 to /home/nilnandan.joshi/backup/2014-08-27_11-49-49/ibdata1 [01] ...done [01] Copying ./mysql/innodb_table_stats.ibd to /home/nilnandan.joshi/backup/2014-08-27_11-49-49/mysql/innodb_table_stats.ibd [01] ...done [01] Copying ./mysql/innodb_index_stats.ibd to /home/nilnandan.joshi/backup/2014-08-27_11-49-49/mysql/innodb_index_stats.ibd [01] ...done [01] Copying ./mysql/gtid_slave_pos.ibd to /home/nilnandan.joshi/backup/2014-08-27_11-49-49/mysql/gtid_slave_pos.ibd [01] ...done >> log scanned up to (1616918) xtrabackup: Creating suspend file '/home/nilnandan.joshi/backup/2014-08-27_11-49-49/xtrabackup_suspended_2' with pid '13539' 140827 11:49:51 innobackupex: Continuing after ibbackup has suspended 140827 11:49:51 innobackupex: Executing FLUSH TABLES WITH READ LOCK... >> log scanned up to (1616918) 140827 11:49:51 innobackupex: All tables locked and flushed to disk 140827 11:49:51 innobackupex: Starting to backup non-InnoDB tables and files innobackupex: in subdirectories of '/home/nilnandan.joshi/sandboxes/msb_10_0_13/data' innobackupex: Backing up files '/home/nilnandan.joshi/sandboxes/msb_10_0_13/data/mysql/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (84 files) innobackupex: Backing up files '/home/nilnandan.joshi/sandboxes/msb_10_0_13/data/performance_schema/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (53 files) innobackupex: Backing up file '/home/nilnandan.joshi/sandboxes/msb_10_0_13/data/nil/db.opt' innobackupex: Backing up file '/home/nilnandan.joshi/sandboxes/msb_10_0_13/data/nil/nil_test.frm' innobackupex: Backing up file '/home/nilnandan.joshi/sandboxes/msb_10_0_13/data/nil/nil_test.MAI' innobackupex: Backing up file '/home/nilnandan.joshi/sandboxes/msb_10_0_13/data/nil/nil_test.MAD' 140827 11:49:51 innobackupex: Finished backing up non-InnoDB tables and files 140827 11:49:51 innobackupex: Executing FLUSH ENGINE LOGS... 140827 11:49:51 innobackupex: Waiting for log copying to finish xtrabackup: The latest check point (for incremental): '1616918' xtrabackup: Stopping log copying thread. .>> log scanned up to (1616918) xtrabackup: Creating suspend file '/home/nilnandan.joshi/backup/2014-08-27_11-49-49/xtrabackup_log_copied' with pid '13539' xtrabackup: Transaction log of lsn (1616918) to (1616918) was copied. 140827 11:49:52 innobackupex: All tables unlocked innobackupex: Backup created in directory '/home/nilnandan.joshi/backup/2014-08-27_11-49-49' 140827 11:49:52 innobackupex: Connection to database server closed 140827 11:49:52 innobackupex: completed OK! nilnandan.joshi@Perconallc-Support:~/sandboxes/msb_10_0_13$ nilnandan.joshi@Perconallc-Support:~$ cd backup/ nilnandan.joshi@Perconallc-Support:~/backup/2014-08-27_11-49-49$ ls -al total 12316 drwxr-xr-x 6 root root 4096 Aug 27 11:49 . drwxr-xr-x 5 nilnandan.joshi admin 100 Aug 27 11:49 .. -rw-r--r-- 1 root root 357 Aug 27 11:49 backup-my.cnf -rw-r----- 1 root root 12582912 Aug 27 11:49 ibdata1 drwx------ 2 root root 4096 Aug 27 11:49 mysql drwxr-xr-x 2 root root 96 Aug 27 11:49 nil drwxr-xr-x 2 root root 4096 Aug 27 11:49 performance_schema drwxr-xr-x 2 root root 10 Aug 27 11:49 test -rw-r----- 1 root root 89 Aug 27 11:49 xtrabackup_checkpoints -rw-r--r-- 1 root root 648 Aug 27 11:49 xtrabackup_info -rw-r----- 1 root root 2560 Aug 27 11:49 xtrabackup_logfile nilnandan.joshi@Perconallc-Support:~/backup/2014-08-27_11-49-49$