kingbaseESV8逻辑备份还原

数据库逻辑备份还原

sys_dump -h127.0.0.1 -Usystem -f/home/kingbase/db01.dmp db01

ksql -h127.0.0.1 test system -c 'drop database db01'

ksql -h127.0.0.1 test system -c 'create database db01'

ksql -h127.0.0.1 -Usystem -ddb01 -f/home/kingbase/db01.dmp

-----------------------------------------------------------------------------------------------

2并行度备份数据库db01

mkdir /home/kingbase/Fd

sys_dump -h127.0.0.1 -Usystem -ddb01 -f/home/kingbase/Fd -Fd --inserts -j 2

2并行度恢复数据库db01

ksql test system -c 'drop database db01';

ksql test system -c 'create database db01';

sys_restore -ddb01 /home/kingbase/Fd -j 2