Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Not a Bug
-
10.2.14
-
All
Description
Mariabackup doesn't support backup of individual partition of table. Its not having something to be like "--include='^test.members#P#p4'" to have a backup of test.members#P#p4 partition table.
Its taking backup of entire table itself (test case is mentioned below).
While other hand its working fine with innobackupex:-
innobackupex --user='root' --password='root' --include='^test.members#P#p4' /tmp/
(skipping all other databases and its relevant tables including other partition of that table which need to be skipped)
https://www.percona.com/doc/percona-xtrabackup/LATEST/howtos/recipes_ibkx_partition.html
Example:-
|
mariabackup --backup --user='root' --password='root' --databases='test' --tables='^test.members#P#p4' --target-dir /tmp
|
|
180904 20:20:37 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set
|
Using server version 10.2.14-MariaDB-log
|
mariabackup based on MariaDB server 10.2.14-MariaDB Linux (x86_64)
|
mariabackup: uses posix_fadvise().
|
mariabackup: cd to /var/lib/mysql/
|
mariabackup: open files limit requested 0, set to 1024
|
mariabackup: using the following InnoDB configuration:
|
mariabackup: innodb_data_home_dir = .
|
mariabackup: innodb_data_file_path = ibdata1:12M:autoextend
|
mariabackup: innodb_log_group_home_dir = ./
|
2018-09-04 20:20:37 140236241541088 [Note] InnoDB: Number of pools: 1
|
mariabackup: Generating a list of tablespaces
|
Skipping db: ./performance_schema
|
2018-09-04 20:20:37 140236241541088 [Warning] InnoDB: Allocated tablespace ID 28 for test/members#P#p4, old maximum was 0
|
Skipping db: ./sakila
|
Skipping db: ./mysql
|
180904 20:20:37 >> log scanned up to (9047515)
|
180904 20:20:37 [01] Copying ./ibdata1 to /tmp/ibdata1
|
180904 20:20:37 [01] ...done
|
180904 20:20:37 [01] Copying ./test/members#P#p4.ibd to /tmp/test/members#P#p4.ibd
|
180904 20:20:37 [01] ...done
|
180904 20:20:37 [01] Copying ./test/members#P#p0.ibd to /tmp/test/members#P#p0.ibd
|
180904 20:20:37 [01] ...done
|
180904 20:20:37 [01] Copying ./test/members#P#p1.ibd to /tmp/test/members#P#p1.ibd
|
180904 20:20:37 [01] ...done
|
180904 20:20:37 [01] Copying ./test/members#P#p3.ibd to /tmp/test/members#P#p3.ibd
|
180904 20:20:37 [01] ...done
|
180904 20:20:37 [01] Copying ./test/members#P#p2.ibd to /tmp/test/members#P#p2.ibd
|
180904 20:20:37 [01] ...done
|
180904 20:20:38 >> log scanned up to (9047515)
|
180904 20:20:38 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...
|
180904 20:20:38 Executing FLUSH TABLES WITH READ LOCK...
|
180904 20:20:38 Starting to backup non-InnoDB tables and files
|
Skipping db: ./performance_schema
|
180904 20:20:38 [01] Copying ./test/db.opt to /tmp/test/db.opt
|
180904 20:20:38 [01] ...done
|
180904 20:20:38 [01] Copying ./test/members.frm to /tmp/test/members.frm
|
180904 20:20:38 [01] ...done
|
180904 20:20:38 [01] Copying ./test/members.par to /tmp/test/members.par
|
180904 20:20:38 [01] ...done
|
Skipping db: ./sakila
|
Skipping db: ./mysql
|
180904 20:20:38 Finished backing up non-InnoDB tables and files
|
180904 20:20:38 [01] Copying aria_log_control to /tmp/aria_log_control
|
180904 20:20:38 [01] ...done
|
180904 20:20:38 [01] Copying aria_log.00000001 to /tmp/aria_log.00000001
|
180904 20:20:38 [01] ...done
|
180904 20:20:38 [00] Writing xtrabackup_binlog_info
|
180904 20:20:38 [00] ...done
|
180904 20:20:38 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
|
mariabackup: The latest check point (for incremental): '9047506'
|
mariabackup: Stopping log copying thread.
|
|
180904 20:20:38 >> log scanned up to (9047515)
|
180904 20:20:38 Executing UNLOCK TABLES
|
180904 20:20:38 All tables unlocked
|
180904 20:20:38 [00] Copying ib_buffer_pool to /tmp/ib_buffer_pool
|
180904 20:20:38 [00] ...done
|
180904 20:20:38 Backup created in directory '/tmp/'
|
MySQL binlog position: filename 'master-bin.000020', position '3506814', GTID of the last change '1-100-99'
|
180904 20:20:38 [00] Writing backup-my.cnf
|
180904 20:20:38 [00] ...done
|
180904 20:20:38 [00] Writing xtrabackup_info
|
180904 20:20:38 [00] ...done
|
mariabackup: Redo log (from LSN 9047506 to 9047515) was copied.
|
180904 20:20:38 completed OK!
|
|
|
[root@master-node tmp]# cd test/
|
[root@master-node test]# ls -ltrh
|
total 492K
|
-rw-r----- 1 root root 96K Sep 4 20:39 members#P#p4.ibd
|
-rw-r----- 1 root root 96K Sep 4 20:39 members#P#p0.ibd
|
-rw-r----- 1 root root 96K Sep 4 20:39 members#P#p1.ibd
|
-rw-r----- 1 root root 96K Sep 4 20:39 members#P#p3.ibd
|
-rw-r----- 1 root root 96K Sep 4 20:39 members#P#p2.ibd
|
-rw-r----- 1 root root 60 Sep 4 20:39 members.par
|
-rw-r----- 1 root root 977 Sep 4 20:39 members.frm
|
-rw-r----- 1 root root 65 Sep 4 20:39 db.opt
|
|
Other option tried but fail to go..
|
|
[root@master-node tmp]# mariabackup --backup --user='root' --password='root' --databases='test' --tables-file='/var/lib/mysql/test/members#P#p4.ibd' --target-dir /tmp
|
180904 20:43:45 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set
|
Using server version 10.2.14-MariaDB-log
|
mariabackup based on MariaDB server 10.2.14-MariaDB Linux (x86_64)
|
mariabackup: uses posix_fadvise().
|
mariabackup: cd to /var/lib/mysql/
|
mariabackup: open files limit requested 0, set to 1024
|
mariabackup: using the following InnoDB configuration:
|
mariabackup: innodb_data_home_dir = .
|
mariabackup: innodb_data_file_path = ibdata1:12M:autoextend
|
mariabackup: innodb_log_group_home_dir = ./
|
2018-09-04 20:43:45 140461935507424 [Note] InnoDB: Number of pools: 1
|
mariabackup: `▒▒D...` name is too long
|
|
|
|
[root@master-node tmp]# mariabackup --backup --user='root' --password='root' --tables-file='/var/lib/mysql/test/members#P#p4.ibd' --target-dir /tmp
|
180904 20:44:01 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set
|
Using server version 10.2.14-MariaDB-log
|
mariabackup based on MariaDB server 10.2.14-MariaDB Linux (x86_64)
|
mariabackup: uses posix_fadvise().
|
mariabackup: cd to /var/lib/mysql/
|
mariabackup: open files limit requested 0, set to 1024
|
mariabackup: using the following InnoDB configuration:
|
mariabackup: innodb_data_home_dir = .
|
mariabackup: innodb_data_file_path = ibdata1:12M:autoextend
|
mariabackup: innodb_log_group_home_dir = ./
|
2018-09-04 20:44:01 140566690641888 [Note] InnoDB: Number of pools: 1
|
mariabackup: `▒▒D...` name is too long
|
|
|
Attachments
Issue Links
- relates to
-
MDEV-10568 Implement support for ALTER TABLE ... {DISCARD|IMPORT} PARTITION
- Open
-
MDEV-17689 Document how to do partial backups and restores with Mariabackup
- Closed
-
MDEV-28590 Creating backup of a specific partition using mariabackup
- Open