用 DUMP/LOAD TABLE 经 Stage 恢复表

先在 MatrixOne 服务端新建空的 /tmp/mo-cookbook-dump 目录,确认服务进程可写。DUMP TABLE 不会覆盖已有的 full/manifest.json;重复练习时请换用新的空目录。此操作适合复制实验表;对生产恢复策略,应使用正式备份方案。

CREATE DATABASE cookbook_dump;
CREATE STAGE cookbook_dump_stage URL='file:///tmp/mo-cookbook-dump/';
CREATE TABLE cookbook_dump.src(id INT PRIMARY KEY, amount INT);
INSERT INTO cookbook_dump.src VALUES (1,10),(2,20);
SELECT mo_ctl('dn','flush','cookbook_dump.src');
CREATE TABLE cookbook_dump.dst(id INT PRIMARY KEY, amount INT);
DUMP TABLE cookbook_dump.src TO 'stage://cookbook_dump_stage/full';
LOAD TABLE cookbook_dump.dst FROM 'stage://cookbook_dump_stage/full';
SELECT COUNT(*) AS rows_restored, SUM(amount) AS amount_sum FROM cookbook_dump.dst;
DROP DATABASE cookbook_dump;
DROP STAGE cookbook_dump_stage;

应得到 rows_restored=2、amount_sum=30。Stage 删除后,底层文件仍可能保留;确认实验目录后再清理。语义和元数据模式见源码 表导出恢复测试。