推薦使(shi)用mysql管理工具navicat for mysql

備份：

備(bei)份完成(cheng)后會生成(cheng)一個.sql文件

還原：

首先打開備份的.sql文件，刪除其中的

重(zhong)新使用(yong)navicat還(huan)原

?

運行完后再執行以下命(ming)令(ling)創建視圖

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

AS

SELECT '線(xian)路(lu)',webid,aid,1,title,features,litpic,shownum,kindlist,attrid,0,id,ishidden FROM sline_line

union

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

union

SELECT '車輛(liang)',webid,aid,3,title,content,litpic,shownum,kindlist,attrid,0,id,ishidden FROM sline_car

union

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

union

SELECT '景點(dian)',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 '簽證(zheng)',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;