mysql和pg数据库表备份及还原

mysql

对itsm_hot_service表进行全表备份

create table itsm_hot_service_bak0707 like itsm_hot_service;
insert into itsm_hot_service_bak0707 select * from itsm_hot_service;

修改itsm_hot_service表

update itsm_hot_service set `ord` = 0 where name = '在途流程调整';

回滚itsm_hot_service

ALTER TABLE itsm_hot_service RENAME itsm_hot_service_bak0707_tmp;
ALTER TABLE itsm_hot_service_bak0707 RENAME itsm_hot_service;

postgresql：

备份 notify_announcement_record 表

create table notify_announcement_record_bak0106 ( like dosm_notify_announcement_record including all);
insert into notify_announcement_record_bak0106 select * from dosm_notify_announcement_record;

修改notify_announcement_record 表

update notify_announcement_record set is_del = 1 where id = '1c569068c6ea4833a902a849abd3595b';

回滚 notify_announcement_record 表

ALTER TABLE notify_announcement_record rename to notify_announcement_record_bak0106_tmp;
ALTER TABLE notify_announcement_record_bak0106 rename to notify_announcement_record;