summaryrefslogtreecommitdiff
path: root/mysql-test/t/backup.test
diff options
context:
space:
mode:
authorunknown <sasha@mysql.sashanet.com>2001-01-18 17:36:20 -0700
committerunknown <sasha@mysql.sashanet.com>2001-01-18 17:36:20 -0700
commit1ad779d47c5e7b1e4e044053f9fa8bca71ac9e2b (patch)
tree6be6f043d9869e97211581cece15de29cc37352f /mysql-test/t/backup.test
parentc862fa36467651ef3e3cb3acad61e42fc0b3e07c (diff)
downloadmariadb-git-1ad779d47c5e7b1e4e044053f9fa8bca71ac9e2b.tar.gz
fixed buffer overrun in resolve_stack_dump
fixes for restore table test case for backup/restore extra/resolve_stack_dump.c: fixed buffer overrun mysql-test/t/rpl000004.test: updated load table from master test case sql/ha_myisam.cc: verbose error messages during backup table, very silent repair on restore sql/sql_table.cc: fixed bugs in restore table
Diffstat (limited to 'mysql-test/t/backup.test')
-rw-r--r--mysql-test/t/backup.test31
1 files changed, 31 insertions, 0 deletions
diff --git a/mysql-test/t/backup.test b/mysql-test/t/backup.test
new file mode 100644
index 00000000000..396576badb7
--- /dev/null
+++ b/mysql-test/t/backup.test
@@ -0,0 +1,31 @@
+connect (con1,localhost,root,,test,0,mysql-master.sock);
+connect (con2,localhost,root,,test,0,mysql-master.sock);
+connection con1;
+set SQL_LOG_BIN=0;
+drop table if exists t1;
+create table t1(n int);
+backup table t1 to '../bogus';
+backup table t1 to '../tmp';
+drop table t1;
+restore table t1 from '../tmp';
+select count(*) from t1;
+insert into t1 values (23),(45),(67);
+backup table t1 to '../tmp';
+drop table t1;
+restore table t1 from '../bogus';
+restore table t1 from '../tmp';
+select n from t1;
+create table t2(m int not null primary key);
+create table t3(k int not null primary key);
+insert into t2 values (123),(145),(167);
+insert into t3 values (223),(245),(267);
+backup table t1,t2,t3 to '../tmp';
+drop table t1,t2,t3;
+restore table t1,t2,t3 from '../tmp';
+select n from t1;
+select m from t2;
+select k from t3;
+drop table t1,t2,t3;
+#restore table t1 from '../tmp';
+#connection con2;
+#lock tables t1 write;