购物车中还没有商品,赶紧选购吧!

数据库备份还原指南

发布日期:2016-04-26 阅读:3504

推荐使用mysql管理工具navicat for mysql

备份:


备份完成后会生成一个.sql文件

 

还原:

首先打开备份的.sql文件,删除其中的


重新使用navicat还原


运行完后再执行以下命令创建视图

create view sline_search (channelname,webid,aid,typeid,title,description,litpic,shownum,kindlist,attrid,headimgid,tid,ishidden)

AS

SELECT '线路',webid,aid,1,title,features,litpic,shownum,kindlist,attrid,0,id,ishidden FROM sline_line

union

SELECT '酒店',webid,aid,2,title,content,litpic,shownum,kindlist,attrid,0,id,ishidden FROM sline_hotel

union

SELECT '车辆',webid,aid,3,title,content,litpic,shownum,kindlist,attrid,0,id,ishidden FROM sline_car

union

SELECT '攻略',webid,aid,4,title,content,litpic,shownum,kindlist,attrid,0,id,ishidden FROM sline_article

union

SELECT '景点',webid,aid,5,title,content,litpic,shownum,kindlist,attrid,0,id,ishidden FROM sline_spot

union

SELECT '相册',webid,aid,6,title,content,litpic,shownum,kindlist,attrid,headimgid,id,ishidden FROM sline_photo

union

SELECT '签证',webid,aid,8,title,content,litpic,shownum,'','',0,id,ishidden FROM sline_visa

union

SELECT '团购',webid,aid,13,title,content,litpic,shownum,kindlist,attrid,0,id,ishidden FROM sline_tuan;


以上内容是否对您有帮助? 您的反馈信息提交成功,谢谢您的反馈!

会员评论

在线咨询
返回顶部