Comment 1 for bug 1331461

Revision history for this message
Nilnandan Joshi (nilnandan-joshi) wrote :

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$