mirror of
				https://github.com/MariaDB/server.git
				synced 2025-11-04 04:46:15 +01:00 
			
		
		
		
	
		
			
				
	
	
		
			23 lines
		
	
	
	
		
			378 B
		
	
	
	
		
			Text
		
	
	
	
	
	
			
		
		
	
	
			23 lines
		
	
	
	
		
			378 B
		
	
	
	
		
			Text
		
	
	
	
	
	
CREATE TABLE t(i INT) ENGINE ROCKSDB;
 | 
						|
INSERT INTO t VALUES(1);
 | 
						|
# xtrabackup backup
 | 
						|
INSERT INTO t VALUES(2);
 | 
						|
# xtrabackup prepare
 | 
						|
# shutdown server
 | 
						|
# remove datadir
 | 
						|
# xtrabackup move back
 | 
						|
# restart
 | 
						|
SELECT * FROM t;
 | 
						|
i
 | 
						|
1
 | 
						|
# xbstream extract
 | 
						|
# xtrabackup prepare
 | 
						|
# shutdown server
 | 
						|
# remove datadir
 | 
						|
# xtrabackup move back
 | 
						|
# restart server
 | 
						|
# restart
 | 
						|
SELECT * FROM t;
 | 
						|
i
 | 
						|
1
 | 
						|
DROP TABLE t;
 |