Mysql数据库快速备份恢复 作者:Admin MySql 时间:2022-11-01 16:51:41 724人已阅读 个人博客 简介Mysql数据库快速备份恢复 ### Mysql数据库快速备份恢复 #### 数据备份: ``` Mysql insert into goods_expand_back select id,goods_id,group_info from goods_expand where goods_id in (SELECT `id` FROM `goods` WHERE `category_id` IN (42) ) ``` #### 数据恢复: ``` Mysql update goods_expand g inner join goods_expand_back gb on g.id = gb.id set g.group_info = gb.group_info ``` 上一篇: ES常见搜索 下一篇: 二进制搭建PHP