设为首页 加入收藏 关注我们： 官方微博 官方抖音

打开抖音扫一扫

一起源码网

  • QingYuanMa.com
  • 全球最大的互联网技术和资源下载平台
搜索
源码学习下载
Dz插件 棋牌源码 精品游戏源码 Dz模版 整站资源 经典游戏源码
编程语言
微端制作 浏览器开发 VB 前端框架 后端开发 C++
微信开发
微信后端 Canvas 微信支付开发 支付宝开发 云融合 Xposed框架
分类
IT时讯 知识学习 招聘求职 科技专栏 VR资讯 VR开发
一起源码网 › 门户 › PHPwind专区 › 查看主题

[v9]关于GBK版本备份无法导入的问题解决

发布者: 666123 | 发布时间: 2018-3-26 23:59| 查看数: 5020| 评论数: 1|帖子模式

因为哥们我强烈推荐使用UTF-8的编码格式,而UTF-8没有这样的问题.

所以我就出一个笨一点解决办法,就不动代码了.

先说说问题形成的原因:

用GBK的自己去看看表注释就知道了,在安装入库的时候中文表注释没有准确入库导致乱码.

所以在导出的时候出现了不完整的标签闭合,也是少了一个单引号.

下面附上简单的解决办法就是用phpMyadmin选择库以后把所有的表注释给改为空,也是删除表注释.

一下我给出删除官方表注释的sql,注意表前缀
  1. ALTER TABLE `pw_acloud_apis` COMMENT = '';
  2. ALTER TABLE `pw_acloud_apps` COMMENT = '';
  3. ALTER TABLE `pw_acloud_app_configs` COMMENT = '';
  4. ALTER TABLE `pw_acloud_extras` COMMENT = '';
  5. ALTER TABLE `pw_acloud_keys` COMMENT = '';
  6. ALTER TABLE `pw_acloud_sql_log` COMMENT = '';
  7. ALTER TABLE `pw_acloud_table_settings` COMMENT = '';
  8. ALTER TABLE `pw_admin_auth` COMMENT = '';
  9. ALTER TABLE `pw_admin_config` COMMENT = '';
  10. ALTER TABLE `pw_admin_custom` COMMENT = '';
  11. ALTER TABLE `pw_admin_role` COMMENT = '';
  12. ALTER TABLE `pw_advertisement` COMMENT = '';
  13. ALTER TABLE `pw_announce` COMMENT = '';
  14. ALTER TABLE `pw_application` COMMENT = '';
  15. ALTER TABLE `pw_application_log` COMMENT = '';
  16. ALTER TABLE `pw_app_poll` COMMENT = '';
  17. ALTER TABLE `pw_app_poll_option` COMMENT = '';
  18. ALTER TABLE `pw_app_poll_thread` COMMENT = '';
  19. ALTER TABLE `pw_app_poll_voter` COMMENT = '';
  20. ALTER TABLE `pw_attachs` COMMENT = '';
  21. ALTER TABLE `pw_attachs_thread` COMMENT = '';
  22. ALTER TABLE `pw_attachs_thread_buy` COMMENT = '';
  23. ALTER TABLE `pw_attachs_thread_download` COMMENT = '';
  24. ALTER TABLE `pw_attention` COMMENT = '';
  25. ALTER TABLE `pw_attention_fresh` COMMENT = '';
  26. ALTER TABLE `pw_attention_fresh_index` COMMENT = '';
  27. ALTER TABLE `pw_attention_fresh_relations` COMMENT = '';
  28. ALTER TABLE `pw_attention_recommend_cron` COMMENT = '';
  29. ALTER TABLE `pw_attention_recommend_friends` COMMENT = '';
  30. ALTER TABLE `pw_attention_recommend_record` COMMENT = '';
  31. ALTER TABLE `pw_attention_type` COMMENT = '';
  32. ALTER TABLE `pw_attention_type_relations` COMMENT = '';
  33. ALTER TABLE `pw_bbsinfo` COMMENT = '';
  34. ALTER TABLE `pw_bbs_forum` COMMENT = '';
  35. ALTER TABLE `pw_bbs_forum_extra` COMMENT = '';
  36. ALTER TABLE `pw_bbs_forum_statistics` COMMENT = '';
  37. ALTER TABLE `pw_bbs_forum_user` COMMENT = '';
  38. ALTER TABLE `pw_bbs_posts` COMMENT = '';
  39. ALTER TABLE `pw_bbs_posts_reply` COMMENT = '';
  40. ALTER TABLE `pw_bbs_posts_topped` COMMENT = '';
  41. ALTER TABLE `pw_bbs_specialsort` COMMENT = '';
  42. ALTER TABLE `pw_bbs_threads` COMMENT = '';
  43. ALTER TABLE `pw_bbs_threads_buy` COMMENT = '';
  44. ALTER TABLE `pw_bbs_threads_cate_index` COMMENT = '';
  45. ALTER TABLE `pw_bbs_threads_content` COMMENT = '';
  46. ALTER TABLE `pw_bbs_threads_digest_index` COMMENT = '';
  47. ALTER TABLE `pw_bbs_threads_hits` COMMENT = '';
  48. ALTER TABLE `pw_bbs_threads_index` COMMENT = '';
  49. ALTER TABLE `pw_bbs_threads_overtime` COMMENT = '';
  50. ALTER TABLE `pw_bbs_threads_sort` COMMENT = '';
  51. ALTER TABLE `pw_bbs_topic_type` COMMENT = '';
  52. ALTER TABLE `pw_bbs_topped` COMMENT = '';
  53. ALTER TABLE `pw_cache` COMMENT = '';
  54. ALTER TABLE `pw_common_config` COMMENT = '';
  55. ALTER TABLE `pw_common_cron` COMMENT = '';
  56. ALTER TABLE `pw_common_emotion` COMMENT = '';
  57. ALTER TABLE `pw_common_emotion_category` COMMENT = '';
  58. ALTER TABLE `pw_common_nav` COMMENT = '';
  59. ALTER TABLE `pw_common_process` COMMENT = '';
  60. ALTER TABLE `pw_credit_log` COMMENT = '';
  61. ALTER TABLE `pw_credit_log_operate` COMMENT = '';
  62. ALTER TABLE `pw_design_bak` COMMENT = '';
  63. ALTER TABLE `pw_design_component` COMMENT = '';
  64. ALTER TABLE `pw_design_cron` COMMENT = '';
  65. ALTER TABLE `pw_design_data` COMMENT = '';
  66. ALTER TABLE `pw_design_image` COMMENT = '';
  67. ALTER TABLE `pw_design_module` COMMENT = '';
  68. ALTER TABLE `pw_design_page` COMMENT = '';
  69. ALTER TABLE `pw_design_permissions` COMMENT = '';
  70. ALTER TABLE `pw_design_portal` COMMENT = '';
  71. ALTER TABLE `pw_design_push` COMMENT = '';
  72. ALTER TABLE `pw_design_script` COMMENT = '';
  73. ALTER TABLE `pw_design_segment` COMMENT = '';
  74. ALTER TABLE `pw_design_shield` COMMENT = '';
  75. ALTER TABLE `pw_design_structure` COMMENT = '';
  76. ALTER TABLE `pw_domain` COMMENT = '';
  77. ALTER TABLE `pw_draft` COMMENT = '';
  78. ALTER TABLE `pw_frag_template` COMMENT = '';
  79. ALTER TABLE `pw_hook` COMMENT = '';
  80. ALTER TABLE `pw_hook_inject` COMMENT = '';
  81. ALTER TABLE `pw_invite_code` COMMENT = '';
  82. ALTER TABLE `pw_like_content` COMMENT = '';
  83. ALTER TABLE `pw_like_log` COMMENT = '';
  84. ALTER TABLE `pw_like_source` COMMENT = '';
  85. ALTER TABLE `pw_like_statistics` COMMENT = '';
  86. ALTER TABLE `pw_like_tag` COMMENT = '';
  87. ALTER TABLE `pw_like_tag_relations` COMMENT = '';
  88. ALTER TABLE `pw_link` COMMENT = '';
  89. ALTER TABLE `pw_link_relations` COMMENT = '';
  90. ALTER TABLE `pw_link_type` COMMENT = '';
  91. ALTER TABLE `pw_log` COMMENT = '';
  92. ALTER TABLE `pw_log_login` COMMENT = '';
  93. ALTER TABLE `pw_medal_info` COMMENT = '';
  94. ALTER TABLE `pw_medal_log` COMMENT = '';
  95. ALTER TABLE `pw_medal_user` COMMENT = '';
  96. ALTER TABLE `pw_message_config` COMMENT = '';
  97. ALTER TABLE `pw_message_notices` COMMENT = '';
  98. ALTER TABLE `pw_online_guest` COMMENT = '';
  99. ALTER TABLE `pw_online_statistics` COMMENT = '';
  100. ALTER TABLE `pw_online_user` COMMENT = '';
  101. ALTER TABLE `pw_pay_order` COMMENT = '';
  102. ALTER TABLE `pw_recycle_reply` COMMENT = '';
  103. ALTER TABLE `pw_recycle_topic` COMMENT = '';
  104. ALTER TABLE `pw_remind` COMMENT = '';
  105. ALTER TABLE `pw_report` COMMENT = '';
  106. ALTER TABLE `pw_seo` COMMENT = '';
  107. ALTER TABLE `pw_space` COMMENT = '';
  108. ALTER TABLE `pw_space_domain` COMMENT = '';
  109. ALTER TABLE `pw_style` COMMENT = '';
  110. ALTER TABLE `pw_tag` COMMENT = '';
  111. ALTER TABLE `pw_tag_attention` COMMENT = '';
  112. ALTER TABLE `pw_tag_category` COMMENT = '';
  113. ALTER TABLE `pw_tag_category_relation` COMMENT = '';
  114. ALTER TABLE `pw_tag_record` COMMENT = '';
  115. ALTER TABLE `pw_tag_relation` COMMENT = '';
  116. ALTER TABLE `pw_task` COMMENT = '';
  117. ALTER TABLE `pw_task_cache` COMMENT = '';
  118. ALTER TABLE `pw_task_group` COMMENT = '';
  119. ALTER TABLE `pw_task_user` COMMENT = '';
  120. ALTER TABLE `pw_upgrade_log` COMMENT = '';
  121. ALTER TABLE `pw_user` COMMENT = '';
  122. ALTER TABLE `pw_user_active_code` COMMENT = '';
  123. ALTER TABLE `pw_user_ban` COMMENT = '';
  124. ALTER TABLE `pw_user_behavior` COMMENT = '';
  125. ALTER TABLE `pw_user_belong` COMMENT = '';
  126. ALTER TABLE `pw_user_data` COMMENT = '';
  127. ALTER TABLE `pw_user_education` COMMENT = '';
  128. ALTER TABLE `pw_user_groups` COMMENT = '';
  129. ALTER TABLE `pw_user_info` COMMENT = '';
  130. ALTER TABLE `pw_user_login_ip_recode` COMMENT = '';
  131. ALTER TABLE `pw_user_mobile` COMMENT = '';
  132. ALTER TABLE `pw_user_mobile_verify` COMMENT = '';
  133. ALTER TABLE `pw_user_permission_groups` COMMENT = '';
  134. ALTER TABLE `pw_user_register_check` COMMENT = '';
  135. ALTER TABLE `pw_user_register_ip` COMMENT = '';
  136. ALTER TABLE `pw_user_tag` COMMENT = '';
  137. ALTER TABLE `pw_user_tag_relation` COMMENT = '';
  138. ALTER TABLE `pw_user_work` COMMENT = '';
  139. ALTER TABLE `pw_weibo` COMMENT = '';
  140. ALTER TABLE `pw_weibo_comment` COMMENT = '';
  141. ALTER TABLE `pw_windid_admin_auth` COMMENT = '';
  142. ALTER TABLE `pw_windid_admin_config` COMMENT = '';
  143. ALTER TABLE `pw_windid_admin_custom` COMMENT = '';
  144. ALTER TABLE `pw_windid_admin_role` COMMENT = '';
  145. ALTER TABLE `pw_windid_app` COMMENT = '';
  146. ALTER TABLE `pw_windid_application` COMMENT = '';
  147. ALTER TABLE `pw_windid_application_log` COMMENT = '';
  148. ALTER TABLE `pw_windid_area` COMMENT = '';
  149. ALTER TABLE `pw_windid_config` COMMENT = '';
  150. ALTER TABLE `pw_windid_hook` COMMENT = '';
  151. ALTER TABLE `pw_windid_hook_inject` COMMENT = '';
  152. ALTER TABLE `pw_windid_message` COMMENT = '';
  153. ALTER TABLE `pw_windid_message_dialog` COMMENT = '';
  154. ALTER TABLE `pw_windid_message_relation` COMMENT = '';
  155. ALTER TABLE `pw_windid_notify` COMMENT = '';
  156. ALTER TABLE `pw_windid_notify_log` COMMENT = '';
  157. ALTER TABLE `pw_windid_school` COMMENT = '';
  158. ALTER TABLE `pw_windid_user` COMMENT = '';
  159. ALTER TABLE `pw_windid_user_black` COMMENT = '';
  160. ALTER TABLE `pw_windid_user_data` COMMENT = '';
  161. ALTER TABLE `pw_windid_user_info` COMMENT = '';
  162. ALTER TABLE `pw_word` COMMENT = '';
复制代码
安卓应用备份

最新评论

shennxin1 发表于 2022-6-2 17:40
erp源代码在哪下载

浏览过的版块

轻源码让程序更轻更快

QingYuanMa.com

工作时间 周一至周六 8:00-17:30

侵权处理

客服QQ点击咨询
城事
话题关注
网上民生
新闻拍客
情感家园
生活
房产资讯
汽车生活
谈婚论嫁
妈妈宝贝
游戏设计
动设计
91游戏
VIP游戏
轻松APP
友情链接
爱秒云
真考题
随手APP
goodpay

关注抖音号

定期抽VIP

设为首页 加入收藏手机版小黑屋

Copyright © 2016-2021 https://www.171739.xyz/ 滇ICP备13200218号

快速回复 返回顶部 返回列表