[gbasedbt@iZ2ze5s78e4tanwe5q2znxZ ~]$ dbaccess test -
Your evaluation license will expire on 2025-05-26 00:00:00
Database selected.
> select * from test21;
id name
1 a
2 b
3 c
3 row(s) retrieved.
Elapsed time: 0.001 sec
2. 通过dbexport备份数据
--创建文件夹
mkdir backup
--执行命令
dbexport test -ss -o backup/ -l
[gbasedbt@iZ2ze5s78e4tanwe5q2znxZ test.exp]$ cat test.sql|grep -i -A 5 -B 5 'create table "gbasedbt".test21'
commcol = id,name }
--说明表test21对应的数据文件为test200118.unl
{ unload file name = test200118.unl number of rows = 3 }
create table "gbasedbt".test21
(
id integer,
name varchar(10)
) extent size 16 next size 64 lock mode page;
[gbasedbt@iZ2ze5s78e4tanwe5q2znxZ test.exp]$ dbaccess test -
Your evaluation license will expire on 2025-05-26 00:00:00
Database selected.
> truncate table test21;
Table truncated.
Elapsed time: 0.003 sec
> load from /home/gbasedbt/backup/test.exp/test200118.unl insert into test21;
3 row(s) loaded.
Elapsed time: 0.002 sec
> select * from test21;
id name
1 a
2 b
3 c
3 row(s) retrieved.
Elapsed time: 0.001 sec
>
(二) 复制数据库(适合小数据库的场景,否则时间过长)
1. 统计数据库大小
select dbsname,sum(pe_size)*4
from
sysmaster:sysptnext a,
outer sysmaster:systabnames b
where a.pe_partnum=b.partnum group by 1;
2. 复制数据库的步骤
准备备份文件夹
备份数据库
更改信息
粘贴(还原)数据库
3. 信息收集
保存的文件夹:/home/gbasedbt/backup
需要复制的数据库:test
复制粘贴成的数据库:test_cp
4. 备份数据库
[gbasedbt@node01 ~]$ mkdir backup
[gbasedbt@node01 ~]$ dbexport test -ss -o backup/ -l
Your evaluation license will expire on 2025-04-22 00:00:00
{ DATABASE test delimiter | }
grant dba to "gbasedbt";
set environment sqlmode 'oracle';
set environment sqlmode 'gbase';
revoke usage on language SPL from public ;
grant usage on language SPL to public ;
dbexport completed
[gbasedbt@node01 ~]$
[gbasedbt@node01 ~]$ dbimport test_cp -i backup/ -l
Your evaluation license will expire on 2025-04-22 00:00:00
{ DATABASE test_cp delimiter | }
grant dba to "gbasedbt";
revoke usage on language SPL from public ;
grant usage on language SPL to public ;
dbimport completed
set environment sqlmode 'oracle';
set environment sqlmode 'gbase';