diff options
Diffstat (limited to 'mysql-test/r/backup.result')
| -rw-r--r-- | mysql-test/r/backup.result | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/r/backup.result b/mysql-test/r/backup.result index a65808bbdd6..a4d1b18fe61 100644 --- a/mysql-test/r/backup.result +++ b/mysql-test/r/backup.result @@ -101,3 +101,23 @@ test.t5 backup status OK Warnings: Warning 1541 The syntax 'BACKUP TABLE' is deprecated and will be removed in MySQL 5.2. Please use MySQL Administrator (mysqldump, mysql) instead. drop table t5; +DROP TABLE IF EXISTS `t+1`; +CREATE TABLE `t+1` (c1 INT); +INSERT INTO `t+1` VALUES (1), (2), (3); +BACKUP TABLE `t+1` TO '../tmp'; +Table Op Msg_type Msg_text +test.t+1 backup status OK +Warnings: +Warning 1541 The syntax 'BACKUP TABLE' is deprecated and will be removed in MySQL 5.2. Please use MySQL Administrator (mysqldump, mysql) instead. +DROP TABLE `t+1`; +RESTORE TABLE `t+1` FROM '../tmp'; +Table Op Msg_type Msg_text +test.t+1 restore status OK +Warnings: +Warning 1541 The syntax 'RESTORE TABLE' is deprecated and will be removed in MySQL 5.2. Please use MySQL Administrator (mysqldump, mysql) instead. +SELECT * FROM `t+1`; +c1 +1 +2 +3 +DROP TABLE `t+1`; |