mysql 批量更新错-虚拟主机/数据库问题

问:UPDATE wa_posts set post_title = REPLACE(post_content,\'[:zh]\’,\’\’),mysql 批量更新错

答:您好,请问您更新的时候出现什么错误呢? 请将报错截图反馈一下 ,另外,若需要我司协助,请授权我司协助您处理 ,非常感谢您长期对我司的支持!

问:,能撤回上一步的操作吗?

问:本地有昨天的备份,但是只是想mysql撤回到上一步执行的那个命令,也就是最后执行的那条sql.

答:您好,1、抱歉,执行后无法撤回。

2、若本地有之前的备份,您可以单独将备份sql中的wa_posts 表 进行恢复导入  , 另外,建议在操作数据库之前,提前备份数据库 ,避免出现类似问题,
西部数码 祝您春节安康 ,阖家幸福  ,非常感谢您长期对我司的支持! 

问:今天不是一号了么,怎么流量还是没更新

答:您好,

已开启,非常感谢您长期对我司的支持!

问:后台生成就出现问题,详见图片

答:您好, 建议少量分批生成, 大量长时间生成可能出现超时等异常报错 ,

非常感谢您长期对我司的支持,谢谢!

问:您好:

网站做了改版,怎么批量进行对应的301?谢谢!已经做好了配对
eg.http://www.jjxnb.com/service/ http://www.jjxnb.com/zaixianliuyan/
http://www.jjxnb.com/photo/class/?2.html http://www.jjxnb.com/products/
http://www.jjxnb.com/news/html/?402.html http://www.jjxnb.com/news/xingyexinwen/99.html
http://www.jjxnb.com/news/html/?382.html http://www.jjxnb.com/news/xingyexinwen/98.html
http://www.jjxnb.com/news/html/?359.html http://www.jjxnb.com/news/xingyexinwen/95.html
http://www.jjxnb.com/news/html/?413.html http://www.jjxnb.com/news/xingyexinwen/94.html
http://www.jjxnb.com/news/html/?390.html http://www.jjxnb.com/news/xingyexinwen/86.html
http://www.jjxnb.com/news/html/?388.html http://www.jjxnb.com/news/xingyexinwen/79.html
http://www.jjxnb.com/news/html/?360.html http://www.jjxnb.com/news/xingyexinwen/74.html
http://www.jjxnb.com/news/html/?364.html http://www.jjxnb.com/news/xingyexinwen/111.html
http://www.jjxnb.com/news/html/?400.html http://www.jjxnb.com/news/xingyexinwen/110.html
http://www.jjxnb.com/news/html/?379.html http://www.jjxnb.com/news/xingyexinwen/104.html
http://www.jjxnb.com/news/class/index.php?myord=cl http://www.jjxnb.com/news/xingyexinwen/
http://www.jjxnb.com/news/html/?392.html http://www.jjxnb.com/news/wd/96.html
http://www.jjxnb.com/news/html/?353.html http://www.jjxnb.com/news/wd/93.html
http://www.jjxnb.com/news/html/?361.html http://www.jjxnb.com/news/wd/92.html
http://www.jjxnb.com/news/html/?407.html http://www.jjxnb.com/news/wd/91.html
http://www.jjxnb.com/news/html/?380.html http://www.jjxnb.com/news/wd/90.html
http://www.jjxnb.com/news/html/?405.html http://www.jjxnb.com/news/wd/89.html
http://www.jjxnb.com/news/html/?389.html http://www.jjxnb.com/news/wd/88.html
http://www.jjxnb.com/news/html/?385.html http://www.jjxnb.com/news/wd/87.html
http://www.jjxnb.com/news/html/?322.html http://www.jjxnb.com/news/wd/85.html
http://www.jjxnb.com/news/html/?362.html http://www.jjxnb.com/news/wd/82.html
http://www.jjxnb.com/news/html/?386.html http://www.jjxnb.com/news/wd/81.html
http://www.jjxnb.com/news/html/?320.html http://www.jjxnb.com/news/wd/80.html
http://www.jjxnb.com/news/html/?408.html http://www.jjxnb.com/news/wd/78.html
http://www.jjxnb.com/news/html/?367.html http://www.jjxnb.com/news/wd/77.html
http://www.jjxnb.com/news/html/?349.html http://www.jjxnb.com/news/wd/124.html
http://www.jjxnb.com/news/html/?409.html http://www.jjxnb.com/news/wd/123.html
http://www.jjxnb.com/news/html/?411.html http://www.jjxnb.com/news/wd/122.html
http://www.jjxnb.com/news/html/?412.html http://www.jjxnb.com/news/wd/121.html
http://www.jjxnb.com/news/html/?417.html http://www.jjxnb.com/news/wd/120.html
http://www.jjxnb.com/news/html/?378.html http://www.jjxnb.com/news/wd/117.html
http://www.jjxnb.com/news/html/?348.html http://www.jjxnb.com/news/wd/112.html
http://www.jjxnb.com/news/html/?384.html http://www.jjxnb.com/news/wd/108.html
http://www.jjxnb.com/news/html/?404.html http://www.jjxnb.com/news/wd/103.html
http://www.jjxnb.com/news/html/?316.html http://www.jjxnb.com/news/wd/102.html
http://www.jjxnb.com/news/html/?321.html http://www.jjxnb.com/news/wd/100.html
http://www.jjxnb.com/page/faq/ http://www.jjxnb.com/news/wd
http://www.jjxnb.com/news/html/?332.html http://www.jjxnb.com/news/gongsixinwen/76.html
http://www.jjxnb.com/news/html/?377.html http://www.jjxnb.com/news/gongsixinwen/73.html
http://www.jjxnb.com/news/html/?337.html http://www.jjxnb.com/news/gongsixinwen/72.html
http://www.jjxnb.com/news/html/?416.html http://www.jjxnb.com/news/gongsixinwen/71.html
http://www.jjxnb.com/page/league/?14.html http://www.jjxnb.com/news/gongsixinwen/68.html
http://www.jjxnb.com/news/html/?352.html http://www.jjxnb.com/news/gongsixinwen/118.html
www.jjxnb.com/photo/html/?26.html http://www.jjxnb.com/cp4/75.html
http://www.jjxnb.com/photo/html/?38.html http://www.jjxnb.com/cp4/115.html
http://www.jjxnb.com/photo/html/?28.html http://www.jjxnb.com/cp4/109.html
http://www.jjxnb.com/photo/html/?31.html http://www.jjxnb.com/cp4/107.html
http://www.jjxnb.com/photo/html/?11.html http://www.jjxnb.com/cp2/83.html
http://www.jjxnb.com/photo/html/?12.html http://www.jjxnb.com/cp1/84.html
http://www.jjxnb.com/photo/html/?46.html http://www.jjxnb.com/cp1/101.html
http://www.jjxnb.com/photo/html/?66.html http://www.jjxnb.com/case/70.html
http://www.jjxnb.com/photo/html/?67.html http://www.jjxnb.com/case/69.html
http://www.jjxnb.com/photo/html/?63.html http://www.jjxnb.com/case/119.html
http://www.jjxnb.com/photo/html/?68.html http://www.jjxnb.com/case/116.html
http://www.jjxnb.com/photo/html/?54.html http://www.jjxnb.com/case/114.html?
http://www.jjxnb.com/photo/html/?54.html http://www.jjxnb.com/case/114.html
http://www.jjxnb.com/photo/html/?7.html http://www.jjxnb.com/case/113.html
http://www.jjxnb.com/photo/html/?55.html http://www.jjxnb.com/case/106.html
http://www.jjxnb.com/photo/html/?62.html http://www.jjxnb.com/case/105.html
http://www.jjxnb.com/photo/class/?1.html http://www.jjxnb.com/case
http://www.jjxnb.com/page/league/?16.html http://www.jjxnb.com/baike/
http://www.jjxnb.com/page/html/ http://www.jjxnb.com/about/
http://www.jjxnb.com/news/class/?73.html http://www.jjxnb.com/news/list_2_2.html

答:您好,您的这个需求属于伪静态规则编写,301重定向是指的将不同域名重定向到指定的一个域名,如果相同域名,则会造成重定向循环(可参考:https://www.west.cn/faq/list.asp?unid=805)。编写伪静态重定向规则需要您联系程序人员处理下,谢谢。

问:您好,咱这边可以付费帮忙解决吗?上面的地址是所有的链接

问:微信:

答:您好,可以尝试帮您操作下,您可提交【虚拟主机数据库问题】 -> 网站类问题 -> 设置伪静态/301跳转/自定义404错误类型工单,收费是100元,如果无法解决会告知您大概方向不产生费用,谢谢。

更多关于云服务器域名注册,虚拟主机的问题,请访问西部数码官网:www.west.cn
赞(0)
声明:本网站发布的内容(图片、视频和文字)以原创、转载和分享网络内容为主,如果涉及侵权请尽快告知,我们将会在第一时间删除。文章观点不代表本网站立场,如需处理请联系客服。电话:028-62778877-8306;邮箱:fanjiao@west.cn。本站原创内容未经允许不得转载,或转载时需注明出处:西部数码知识库 » mysql 批量更新错-虚拟主机/数据库问题

登录

找回密码

注册