"Create tables for backup"
Warnings:
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
Warning	1681	Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.

"Starting backup as nowait"
Starting backup
Backup started
"Update tables during backup"

"Wait for backup to complete"
Waiting for backup to complete
Backup completed
"Drop tables after backup completes"
Restore metadata using backup-part 1
Restore data by restoring all backup parts serially
Restore data of PART-12-OF-12 on node 6
Restore data of PART-11-OF-12 on node 6
Restore data of PART-10-OF-12 on node 6
Restore data of PART-9-OF-12 on node 6
Restore data of PART-8-OF-12 on node 6
Restore data of PART-7-OF-12 on node 6
Restore data of PART-6-OF-12 on node 6
Restore data of PART-5-OF-12 on node 6
Restore data of PART-4-OF-12 on node 6
Restore data of PART-3-OF-12 on node 6
Restore data of PART-2-OF-12 on node 6
Restore data of PART-1-OF-12 on node 6
Restore data of PART-10-OF-10 on node 5
Restore data of PART-9-OF-10 on node 5
Restore data of PART-8-OF-10 on node 5
Restore data of PART-7-OF-10 on node 5
Restore data of PART-6-OF-10 on node 5
Restore data of PART-5-OF-10 on node 5
Restore data of PART-4-OF-10 on node 5
Restore data of PART-3-OF-10 on node 5
Restore data of PART-2-OF-10 on node 5
Restore data of PART-1-OF-10 on node 5
Restore data of PART-8-OF-8 on node 4
Restore data of PART-7-OF-8 on node 4
Restore data of PART-6-OF-8 on node 4
Restore data of PART-5-OF-8 on node 4
Restore data of PART-4-OF-8 on node 4
Restore data of PART-3-OF-8 on node 4
Restore data of PART-2-OF-8 on node 4
Restore data of PART-1-OF-8 on node 4
Restore data of PART-6-OF-6 on node 3
Restore data of PART-5-OF-6 on node 3
Restore data of PART-4-OF-6 on node 3
Restore data of PART-3-OF-6 on node 3
Restore data of PART-2-OF-6 on node 3
Restore data of PART-1-OF-6 on node 3
Restore data of PART-4-OF-4 on node 2
Restore data of PART-3-OF-4 on node 2
Restore data of PART-2-OF-4 on node 2
Restore data of PART-1-OF-4 on node 2
Restore data of PART-2-OF-2 on node 1
Restore data of PART-1-OF-2 on node 1
"Print restored rows"
use test;
select * from t0 order by id;
id	val
1	1
2	2
3	3
4	4
5	5
6	6
7	7
8	8
9	9
10	12345
select * from t1 order by val;
val
NULL
2
3
4
5
6
7
8
9
11
select * from t2 order by id;
id
1
3
4
5
6
7
8
9
10
22
select * from t3 order by id;
id	val
1	9
2	8
3	33
4	6
5	5
6	4
7	3
8	2
9	1
10	NULL
select * from t4 order by id;
id	val
1	11001
2	11001
3	11001
4	44
5	11001
6	11001
7	11001
8	11001
9	11001
10	11001
select id, sha1(val) from t5 order by id;
id	sha1(val)
1	0b35a3e0949353117c55151be416c64481dc9778
2	0f5f3d3783159438eff81e6b3c8911480daf7eac
3	7b48e60fd747fc37363da73d3140ba0a41ae862a
4	ea7dffff542a062f6e41c69afac9576d7e97634c
5	266d8973914802f093f698a58224566ca2a664bc
6	4a8284d4be6c4c063a910760610c8754ca1234a3
7	c1bd312a4dd67884e66d15671d38c854e99c8021
8	d8ff0788ec90b18f9d51ecad46274e75aaf4b99f
9	139101d8480a9a68e4e1256ed300aad365725fbc
10	NULL
select * from t6 order by id;
id	val
1	1
2	2
3	3
4	4
5	5
6	66
7	7
8	8
9	9
10	NULL
select * from t7 order by id;
id	val1	val2
1	9	9
2	8	8
3	7	7
4	6	6
5	5	5
6	4	4
7	77	3
8	2	2
9	1	1
10	10	NULL
select id, sha1(val) from t8 order by id;
id	sha1(val)
1	fd7d9e6b83b0d8c82065d03cb3aa7fd9004b1be3
2	bc6d3732391be0cf937c126aedd201348b77eb73
3	558ea7eaf6bc169cf132d8b79fa3cb24d256b43d
4	b940efa7f439709e3a9f6f7ae7a139a0ffc4615c
5	28f701601814c80158537b932009ee46e2f7ceda
6	7aaa4f2845f274d843997517f64e0f613cbb8439
7	d13462051501e81028a3aafcf1359af394493cba
8	b37f6ddcefad7e8657837d3177f9ef2462f98acf
9	26dd2ef1ebb5fa7958eccce47d8f71257642a207
10	NULL
select * from t9 order by auto;
auto	string	vstring	tiny	short	medium	long_int	longlong	real_float	real_double	real_decimal	utiny	ushort	umedium	ulong	ulonglong	bits	options	flags	date_field	year_field	time_field	date_time
1	bbbb	bbbb	-22	-22	-22	-22	-22	22.2	22.2200	22.2200	22	00022	22	22	22		two	two	1922-02-22	1922	22:22:22	1922-02-22 22:22:22
2	8888	8888	-8	-8	-8	-8	-8	8.8	8.8000	8.8000	8	00008	8	8	8	
	one	one	1988-08-08	1988	08:08:08	1988-08-08 08:08:08
3	7777	7777	-7	-7	-7	-7	-7	7.7	7.7000	7.7000	7	00007	7	7	7	
	one	one	1977-07-07	1977	07:07:07	1977-07-07 07:07:07
4	6666	6666	-6	-6	-6	-6	-6	6.6	6.6000	6.6000	6	00006	6	6	6	
	one	one	1966-06-06	1966	06:06:06	1966-06-06 06:06:06
5	5555	5555	-5	-5	-5	-5	-5	5.5	5.5000	5.5000	5	00005	5	5	5	
	one	one	1955-05-05	1955	05:05:05	1955-05-05 05:05:05
6	4444	4444	-4	-4	-4	-4	-4	4.4	4.4000	4.4000	4	00004	4	4	4	
	one	one	1944-04-04	1944	04:04:04	1944-04-04 04:04:04
7	3333	3333	-3	-3	-3	-3	-3	3.3	3.3000	3.3000	3	00003	3	3	3	
	one	one	1933-03-03	1933	03:03:03	1933-03-03 03:03:03
8	2222	2222	-2	-2	-2	-2	-2	2.2	2.2000	2.2000	2	00002	2	2	2	
	one	one	1922-02-02	1922	02:02:02	1922-02-02 02:02:02
9	1111	1111	-1	-1	-1	-1	-1	1.1	1.1000	1.1000	1	00001	1	1	1	
	one	one	1911-01-01	1911	01:01:01	1911-01-01 01:01:01
10	NULL	NULL	10	10	10	10	10	10.1	NULL	NULL	10	00010	10	10	10	NULL	two	two	NULL	NULL	NULL	NULL
Drop all tables
Restore metadata using mt-restore
Restore data using mt-restore of all backup parts
"Print restored rows"
use test;
select * from t0 order by id;
id	val
1	1
2	2
3	3
4	4
5	5
6	6
7	7
8	8
9	9
10	12345
select * from t1 order by val;
val
NULL
2
3
4
5
6
7
8
9
11
select * from t2 order by id;
id
1
3
4
5
6
7
8
9
10
22
select * from t3 order by id;
id	val
1	9
2	8
3	33
4	6
5	5
6	4
7	3
8	2
9	1
10	NULL
select * from t4 order by id;
id	val
1	11001
2	11001
3	11001
4	44
5	11001
6	11001
7	11001
8	11001
9	11001
10	11001
select id, sha1(val) from t5 order by id;
id	sha1(val)
1	0b35a3e0949353117c55151be416c64481dc9778
2	0f5f3d3783159438eff81e6b3c8911480daf7eac
3	7b48e60fd747fc37363da73d3140ba0a41ae862a
4	ea7dffff542a062f6e41c69afac9576d7e97634c
5	266d8973914802f093f698a58224566ca2a664bc
6	4a8284d4be6c4c063a910760610c8754ca1234a3
7	c1bd312a4dd67884e66d15671d38c854e99c8021
8	d8ff0788ec90b18f9d51ecad46274e75aaf4b99f
9	139101d8480a9a68e4e1256ed300aad365725fbc
10	NULL
select * from t6 order by id;
id	val
1	1
2	2
3	3
4	4
5	5
6	66
7	7
8	8
9	9
10	NULL
select * from t7 order by id;
id	val1	val2
1	9	9
2	8	8
3	7	7
4	6	6
5	5	5
6	4	4
7	77	3
8	2	2
9	1	1
10	10	NULL
select id, sha1(val) from t8 order by id;
id	sha1(val)
1	fd7d9e6b83b0d8c82065d03cb3aa7fd9004b1be3
2	bc6d3732391be0cf937c126aedd201348b77eb73
3	558ea7eaf6bc169cf132d8b79fa3cb24d256b43d
4	b940efa7f439709e3a9f6f7ae7a139a0ffc4615c
5	28f701601814c80158537b932009ee46e2f7ceda
6	7aaa4f2845f274d843997517f64e0f613cbb8439
7	d13462051501e81028a3aafcf1359af394493cba
8	b37f6ddcefad7e8657837d3177f9ef2462f98acf
9	26dd2ef1ebb5fa7958eccce47d8f71257642a207
10	NULL
select * from t9 order by auto;
auto	string	vstring	tiny	short	medium	long_int	longlong	real_float	real_double	real_decimal	utiny	ushort	umedium	ulong	ulonglong	bits	options	flags	date_field	year_field	time_field	date_time
1	bbbb	bbbb	-22	-22	-22	-22	-22	22.2	22.2200	22.2200	22	00022	22	22	22		two	two	1922-02-22	1922	22:22:22	1922-02-22 22:22:22
2	8888	8888	-8	-8	-8	-8	-8	8.8	8.8000	8.8000	8	00008	8	8	8	
	one	one	1988-08-08	1988	08:08:08	1988-08-08 08:08:08
3	7777	7777	-7	-7	-7	-7	-7	7.7	7.7000	7.7000	7	00007	7	7	7	
	one	one	1977-07-07	1977	07:07:07	1977-07-07 07:07:07
4	6666	6666	-6	-6	-6	-6	-6	6.6	6.6000	6.6000	6	00006	6	6	6	
	one	one	1966-06-06	1966	06:06:06	1966-06-06 06:06:06
5	5555	5555	-5	-5	-5	-5	-5	5.5	5.5000	5.5000	5	00005	5	5	5	
	one	one	1955-05-05	1955	05:05:05	1955-05-05 05:05:05
6	4444	4444	-4	-4	-4	-4	-4	4.4	4.4000	4.4000	4	00004	4	4	4	
	one	one	1944-04-04	1944	04:04:04	1944-04-04 04:04:04
7	3333	3333	-3	-3	-3	-3	-3	3.3	3.3000	3.3000	3	00003	3	3	3	
	one	one	1933-03-03	1933	03:03:03	1933-03-03 03:03:03
8	2222	2222	-2	-2	-2	-2	-2	2.2	2.2000	2.2000	2	00002	2	2	2	
	one	one	1922-02-02	1922	02:02:02	1922-02-02 02:02:02
9	1111	1111	-1	-1	-1	-1	-1	1.1	1.1000	1.1000	1	00001	1	1	1	
	one	one	1911-01-01	1911	01:01:01	1911-01-01 01:01:01
10	NULL	NULL	10	10	10	10	10	10.1	NULL	NULL	10	00010	10	10	10	NULL	two	two	NULL	NULL	NULL	NULL