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

3 files changed, 71 insertions, 1 deletions

diff --git a/mysql-test/r/backup.result b/mysql-test/r/backup.result
new file mode 100644
index 00000000000..a801e1cd28d
--- /dev/null
+++ b/mysql-test/r/backup.result
@@ -0,0 +1,39 @@
+Table	Op	Msg_type	Msg_text
+t1	backup	error	Failed copying .frm file: errno = 2
+test.t1	backup	status	Operation failed
+Table	Op	Msg_type	Msg_text
+test.t1	backup	status	OK
+Table	Op	Msg_type	Msg_text
+test.t1	restore	status	OK
+count(*)
+0
+Table	Op	Msg_type	Msg_text
+test.t1	backup	status	OK
+Table	Op	Msg_type	Msg_text
+t1	restore	error	Failed copying .frm file
+Table	Op	Msg_type	Msg_text
+test.t1	restore	status	OK
+n
+23
+45
+67
+Table	Op	Msg_type	Msg_text
+test.t1	backup	status	OK
+test.t2	backup	status	OK
+test.t3	backup	status	OK
+Table	Op	Msg_type	Msg_text
+test.t1	restore	status	OK
+test.t2	restore	status	OK
+test.t3	restore	status	OK
+n
+23
+45
+67
+m
+123
+145
+167
+k
+223
+245
+267
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;
diff --git a/mysql-test/t/rpl000004.test b/mysql-test/t/rpl000004.test
index c530b434d8d..5b2c41293a2 100644
--- a/mysql-test/t/rpl000004.test
+++ b/mysql-test/t/rpl000004.test
@@ -8,7 +8,7 @@ load data infile '../../std_data/words.dat' into table t1;
 drop table if exists t2;
 create table t2 (word char(20) not null);
 load data infile '../../std_data/words.dat' into table t2;
-create table t3 (word char(20) not null);
+create table t3 (word char(20) not null primary key);
 connection slave;
 use test;
 drop table if exists t1;