mysql数据备份和还原

正式环境常用的数据备份和恢复的sql

#数据备份sql
CREATE TABLE bs_house_cost_item_record_bak as SELECT * FROM bs_house_cost_item_record where community_id = 163;

#删除原数据库中的数据
DELETE FROM bs_house_cost_item_record where community_id = 163;

#查询备份的数据
SELECT * FROM bs_house_cost_item_record_bak;

#将备份的数据还原到数据库 bs_house_cost_item_record 中
INSERT INTO bs_house_cost_item_record SELECT * FROM bs_house_cost_item_record_bak