From: Date: June 30 2008 3:22am
Subject: [patch 02/10] Basic backup and restore test
List-Archive: http://lists.mysql.com/internals/35761
Message-Id: <20080630012610.995430990@flamingspork.com>

This can be used to easily find the (now fixed) bug of restore not working over 32kb.
---
 mysql-test/r/backup_really_simple.result |   19 +++++++++++++++++++
 mysql-test/t/backup_really_simple.test   |   15 +++++++++++++++
 2 files changed, 34 insertions(+)

Index: stew-encrypted-backup/mysql-test/t/backup_really_simple.test
===================================================================
--- /dev/null	1970-01-01 00:00:00.000000000 +0000
+++ stew-encrypted-backup/mysql-test/t/backup_really_simple.test	2008-06-26 02:33:42.327625254 +1000
@@ -0,0 +1,15 @@
+create table t1 (a int);
+insert into t1 values (1),(2),(42),(3),(4),(1);
+insert into t1 select * from t1;
+insert into t1 select * from t1;
+insert into t1 select * from t1;
+insert into t1 select * from t1;
+insert into t1 select * from t1;
+insert into t1 select * from t1;
+insert into t1 select * from t1;
+insert into t1 select * from t1;
+insert into t1 select * from t1;
+insert into t1 select * from t1;
+BACKUP DATABASE test TO 'test.ba';
+use test;
+RESTORE FROM 'test.ba';
Index: stew-encrypted-backup/mysql-test/r/backup_really_simple.result
===================================================================
--- /dev/null	1970-01-01 00:00:00.000000000 +0000
+++ stew-encrypted-backup/mysql-test/r/backup_really_simple.result	2008-06-26 02:48:35.410620062 +1000
@@ -0,0 +1,19 @@
+create table t1 (a int);
+insert into t1 values (1),(2),(42),(3),(4),(1);
+insert into t1 select * from t1;
+insert into t1 select * from t1;
+insert into t1 select * from t1;
+insert into t1 select * from t1;
+insert into t1 select * from t1;
+insert into t1 select * from t1;
+insert into t1 select * from t1;
+insert into t1 select * from t1;
+insert into t1 select * from t1;
+insert into t1 select * from t1;
+BACKUP DATABASE test TO 'test.ba';
+backup_id
+1
+use test;
+RESTORE FROM 'test.ba';
+backup_id
+2

-- 
Stewart Smith