📄 backup.result
字号:
set SQL_LOG_BIN=0;drop table if exists t1, t2, t3;create table t4(n int);backup table t4 to '../bogus';Table Op Msg_type Msg_texttest.t4 backup error Failed copying .frm file (errno: X)test.t4 backup status Operation failedWarnings:Error 1 Can't create/write to file 'MYSQLTEST_VARDIR/bogus/t4.frm' (Errcode: X)backup table t4 to '../tmp';Table Op Msg_type Msg_texttest.t4 backup status OKbackup table t4 to '../tmp';Table Op Msg_type Msg_texttest.t4 backup error Failed copying .frm file (errno: X)test.t4 backup status Operation failedWarnings:Error 1 Can't create/write to file 'MYSQLTEST_VARDIR/tmp/t4.frm' (Errcode: X)drop table t4;restore table t4 from '../tmp';Table Op Msg_type Msg_texttest.t4 restore status OKselect count(*) from t4;count(*)0create table t1(n int);insert into t1 values (23),(45),(67);backup table t1 to '../tmp';Table Op Msg_type Msg_texttest.t1 backup status OKdrop table t1;restore table t1 from '../bogus';Table Op Msg_type Msg_textt1 restore error Failed copying .frm fileWarnings:Error 29 File 'MYSQLTEST_VARDIR/bogus/t1.frm' not found (Errcode: X)restore table t1 from '../tmp';Table Op Msg_type Msg_texttest.t1 restore status OKselect n from t1;n234567create 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 t2,t3 to '../tmp';Table Op Msg_type Msg_texttest.t2 backup status OKtest.t3 backup status OKdrop table t1,t2,t3;restore table t1,t2,t3 from '../tmp';Table Op Msg_type Msg_texttest.t1 restore status OKtest.t2 restore status OKtest.t3 restore status OKselect n from t1;n234567select m from t2;m123145167select k from t3;k223245267drop table t1,t2,t3,t4;restore table t1 from '../tmp';Table Op Msg_type Msg_texttest.t1 restore status OKrename table t1 to t5;lock tables t5 write;backup table t5 to '../tmp';unlock tables;Table Op Msg_type Msg_texttest.t5 backup status OKdrop table t5;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -