RDS修改引擎，无法物理备份

admin

Discuz默认是MyISAM引擎，但是目前云计算平台都默认RDS为Innodb引擎，而且强制性的，这有点坑爹的意味了。而且还跟你讲Innodb引擎多好，可坏处也很明显，如果你直接copy数据库，会发现无法找到，引擎Innodb引擎的数据是存储在ipdata1文件夹的，对于需要搬家的，数据庞大的用户来说就非常麻烦了，这里需要转换成MyISAM引擎。

	优点	缺点
MyISAM引擎	物理备份直接复制黏贴	容易损坏
Innodb引擎	不容易坏	不能直接数据库物理拷贝 还有ipdata1

语句如下，有的数据表可能你的没有，仅供参考。
数据较大的，可分批输入转换，转完后，关闭mysql，然后再进行物理备份复制。

1. ALTER TABLE pre_amuarrange_list ENGINE=MyISAM;
   
2. ALTER TABLE pre_bg_setting ENGINE=MyISAM;
   
3. ALTER TABLE pre_common_addon ENGINE=MyISAM;
   
4. ALTER TABLE pre_common_admincp_cmenu ENGINE=MyISAM;
   
5. ALTER TABLE pre_common_admincp_group ENGINE=MyISAM;
   
6. ALTER TABLE pre_common_admincp_member ENGINE=MyISAM;
   
7. ALTER TABLE pre_common_admincp_perm ENGINE=MyISAM;
   
8. ALTER TABLE pre_common_admincp_session ENGINE=MyISAM;
   
9. ALTER TABLE pre_common_admingroup ENGINE=MyISAM;
   
10. ALTER TABLE pre_common_adminnote ENGINE=MyISAM;
    
11. ALTER TABLE pre_common_advertisement ENGINE=MyISAM;
    
12. ALTER TABLE pre_common_advertisement_custom ENGINE=MyISAM;
    
13. ALTER TABLE pre_common_banned ENGINE=MyISAM;
    
14. ALTER TABLE pre_common_block ENGINE=MyISAM;
    
15. ALTER TABLE pre_common_block_favorite ENGINE=MyISAM;
    
16. ALTER TABLE pre_common_block_item ENGINE=MyISAM;
    
17. ALTER TABLE pre_common_block_item_data ENGINE=MyISAM;
    
18. ALTER TABLE pre_common_block_permission ENGINE=MyISAM;
    
19. ALTER TABLE pre_common_block_pic ENGINE=MyISAM;
    
20. ALTER TABLE pre_common_block_style ENGINE=MyISAM;
    
21. ALTER TABLE pre_common_block_xml ENGINE=MyISAM;
    
22. ALTER TABLE pre_common_cache ENGINE=MyISAM;
    
23. ALTER TABLE pre_common_card ENGINE=MyISAM;
    
24. ALTER TABLE pre_common_card_log ENGINE=MyISAM;
    
25. ALTER TABLE pre_common_card_type ENGINE=MyISAM;
    
26. ALTER TABLE pre_common_connect_guest ENGINE=MyISAM;
    
27. ALTER TABLE pre_common_credit_log ENGINE=MyISAM;
    
28. ALTER TABLE pre_common_credit_log_field ENGINE=MyISAM;
    
29. ALTER TABLE pre_common_credit_rule ENGINE=MyISAM;
    
30. ALTER TABLE pre_common_credit_rule_log ENGINE=MyISAM;
    
31. ALTER TABLE pre_common_credit_rule_log_field ENGINE=MyISAM;
    
32. ALTER TABLE pre_common_cron ENGINE=MyISAM;
    
33. ALTER TABLE pre_common_devicetoken ENGINE=MyISAM;
    
34. ALTER TABLE pre_common_district ENGINE=MyISAM;
    
35. ALTER TABLE pre_common_diy_data ENGINE=MyISAM;
    
36. ALTER TABLE pre_common_domain ENGINE=MyISAM;
    
37. ALTER TABLE pre_common_failedip ENGINE=MyISAM;
    
38. ALTER TABLE pre_common_failedlogin ENGINE=MyISAM;
    
39. ALTER TABLE pre_common_friendlink ENGINE=MyISAM;
    
40. ALTER TABLE pre_common_grouppm ENGINE=MyISAM;
    
41. ALTER TABLE pre_common_invite ENGINE=MyISAM;
    
42. ALTER TABLE pre_common_magic ENGINE=MyISAM;
    
43. ALTER TABLE pre_common_magiclog ENGINE=MyISAM;
    
44. ALTER TABLE pre_common_mailcron ENGINE=MyISAM;
    
45. ALTER TABLE pre_common_mailqueue ENGINE=MyISAM;
    
46. ALTER TABLE pre_common_member ENGINE=MyISAM;
    
47. ALTER TABLE pre_common_member_action_log ENGINE=MyISAM;
    
48. ALTER TABLE pre_common_member_archive ENGINE=MyISAM;
    
49. ALTER TABLE pre_common_member_connect ENGINE=MyISAM;
    
50. ALTER TABLE pre_common_member_count ENGINE=MyISAM;
    
51. ALTER TABLE pre_common_member_count_archive ENGINE=MyISAM;
    
52. ALTER TABLE pre_common_member_crime ENGINE=MyISAM;
    
53. ALTER TABLE pre_common_member_field_forum ENGINE=MyISAM;
    
54. ALTER TABLE pre_common_member_field_forum_archive ENGINE=MyISAM;
    
55. ALTER TABLE pre_common_member_field_home ENGINE=MyISAM;
    
56. ALTER TABLE pre_common_member_field_home_archive ENGINE=MyISAM;
    
57. ALTER TABLE pre_common_member_forum_buylog ENGINE=MyISAM;
    
58. ALTER TABLE pre_common_member_grouppm ENGINE=MyISAM;
    
59. ALTER TABLE pre_common_member_log ENGINE=MyISAM;
    
60. ALTER TABLE pre_common_member_magic ENGINE=MyISAM;
    
61. ALTER TABLE pre_common_member_medal ENGINE=MyISAM;
    
62. ALTER TABLE pre_common_member_newprompt ENGINE=MyISAM;
    
63. ALTER TABLE pre_common_member_profile ENGINE=MyISAM;
    
64. ALTER TABLE pre_common_member_profile_archive ENGINE=MyISAM;
    
65. ALTER TABLE pre_common_member_profile_setting ENGINE=MyISAM;
    
66. ALTER TABLE pre_common_member_security ENGINE=MyISAM;
    
67. ALTER TABLE pre_common_member_secwhite ENGINE=MyISAM;
    
68. ALTER TABLE pre_common_member_status ENGINE=MyISAM;
    
69. ALTER TABLE pre_common_member_status_archive ENGINE=MyISAM;
    
70. ALTER TABLE pre_common_member_stat_field ENGINE=MyISAM;
    
71. ALTER TABLE pre_common_member_stat_fieldcache ENGINE=MyISAM;
    
72. ALTER TABLE pre_common_member_stat_search ENGINE=MyISAM;
    
73. ALTER TABLE pre_common_member_stat_searchcache ENGINE=MyISAM;
    
74. ALTER TABLE pre_common_member_validate ENGINE=MyISAM;
    
75. ALTER TABLE pre_common_member_verify ENGINE=MyISAM;
    
76. ALTER TABLE pre_common_member_verify_info ENGINE=MyISAM;
    
77. ALTER TABLE pre_common_member_wechat ENGINE=MyISAM;
    
78. ALTER TABLE pre_common_member_wechatmp ENGINE=MyISAM;
    
79. ALTER TABLE pre_common_moderate ENGINE=MyISAM;
    
80. ALTER TABLE pre_common_myapp ENGINE=MyISAM;
    
81. ALTER TABLE pre_common_myinvite ENGINE=MyISAM;
    
82. ALTER TABLE pre_common_mytask ENGINE=MyISAM;
    
83. ALTER TABLE pre_common_nav ENGINE=MyISAM;
    
84. ALTER TABLE pre_common_onlinetime ENGINE=MyISAM;
    
85. ALTER TABLE pre_common_optimizer ENGINE=MyISAM;
    
86. ALTER TABLE pre_common_patch ENGINE=MyISAM;
    
87. ALTER TABLE pre_common_plugin ENGINE=MyISAM;
    
88. ALTER TABLE pre_common_pluginvar ENGINE=MyISAM;
    
89. ALTER TABLE pre_common_plugin_cnzzadm ENGINE=MyISAM;
    
90. ALTER TABLE pre_common_process ENGINE=MyISAM;
    
91. ALTER TABLE pre_common_regip ENGINE=MyISAM;
    
92. ALTER TABLE pre_common_relatedlink ENGINE=MyISAM;
    
93. ALTER TABLE pre_common_remote_port ENGINE=MyISAM;
    
94. ALTER TABLE pre_common_report ENGINE=MyISAM;
    
95. ALTER TABLE pre_common_searchindex ENGINE=MyISAM;
    
96. ALTER TABLE pre_common_seccheck ENGINE=MyISAM;
    
97. ALTER TABLE pre_common_secquestion ENGINE=MyISAM;
    
98. ALTER TABLE pre_common_session ENGINE=MyISAM;
    
99. ALTER TABLE pre_common_setting ENGINE=MyISAM;
    
100. ALTER TABLE pre_common_smiley ENGINE=MyISAM;
     
101. ALTER TABLE pre_common_sphinxcounter ENGINE=MyISAM;
     
102. ALTER TABLE pre_common_stat ENGINE=MyISAM;
     
103. ALTER TABLE pre_common_statuser ENGINE=MyISAM;
     
104. ALTER TABLE pre_common_style ENGINE=MyISAM;
     
105. ALTER TABLE pre_common_stylevar ENGINE=MyISAM;
     
106. ALTER TABLE pre_common_syscache ENGINE=MyISAM;
     
107. ALTER TABLE pre_common_tag ENGINE=MyISAM;
     
108. ALTER TABLE pre_common_tagitem ENGINE=MyISAM;
     
109. ALTER TABLE pre_common_task ENGINE=MyISAM;
     
110. ALTER TABLE pre_common_taskvar ENGINE=MyISAM;
     
111. ALTER TABLE pre_common_template ENGINE=MyISAM;
     
112. ALTER TABLE pre_common_template_block ENGINE=MyISAM;
     
113. ALTER TABLE pre_common_template_permission ENGINE=MyISAM;
     
114. ALTER TABLE pre_common_uin_black ENGINE=MyISAM;
     
115. ALTER TABLE pre_common_usergroup ENGINE=MyISAM;
     
116. ALTER TABLE pre_common_usergroup_field ENGINE=MyISAM;
     
117. ALTER TABLE pre_common_visit ENGINE=MyISAM;
     
118. ALTER TABLE pre_common_word ENGINE=MyISAM;
     
119. ALTER TABLE pre_common_word_type ENGINE=MyISAM;
     
120. ALTER TABLE pre_connect_disktask ENGINE=MyISAM;
     
121. ALTER TABLE pre_connect_feedlog ENGINE=MyISAM;
     
122. ALTER TABLE pre_connect_memberbindlog ENGINE=MyISAM;
     
123. ALTER TABLE pre_connect_postfeedlog ENGINE=MyISAM;
     
124. ALTER TABLE pre_connect_tlog ENGINE=MyISAM;
     
125. ALTER TABLE pre_connect_tthreadlog ENGINE=MyISAM;
     
126. ALTER TABLE pre_dc_wenjuan_lists ENGINE=MyISAM;
     
127. ALTER TABLE pre_dc_wenjuan_result ENGINE=MyISAM;
     
128. ALTER TABLE pre_dc_wenjuan_subjects ENGINE=MyISAM;
     
129. ALTER TABLE pre_dsu_vip ENGINE=MyISAM;
     
130. ALTER TABLE pre_dsu_vip_codes ENGINE=MyISAM;
     
131. ALTER TABLE pre_examore ENGINE=MyISAM;
     
132. ALTER TABLE pre_fb_opinion ENGINE=MyISAM;
     
133. ALTER TABLE pre_fb_opinion_comment ENGINE=MyISAM;
     
134. ALTER TABLE pre_fh_config ENGINE=MyISAM;
     
135. ALTER TABLE pre_fh_fenlei ENGINE=MyISAM;
     
136. ALTER TABLE pre_fh_hao ENGINE=MyISAM;
     
137. ALTER TABLE pre_fh_ka ENGINE=MyISAM;
     
138. ALTER TABLE pre_forum_access ENGINE=MyISAM;
     
139. ALTER TABLE pre_forum_activity ENGINE=MyISAM;
     
140. ALTER TABLE pre_forum_activityapply ENGINE=MyISAM;
     
141. ALTER TABLE pre_forum_announcement ENGINE=MyISAM;
     
142. ALTER TABLE pre_forum_attachment ENGINE=MyISAM;
     
143. ALTER TABLE pre_forum_attachment_0 ENGINE=MyISAM;
     
144. ALTER TABLE pre_forum_attachment_1 ENGINE=MyISAM;
     
145. ALTER TABLE pre_forum_attachment_2 ENGINE=MyISAM;
     
146. ALTER TABLE pre_forum_attachment_3 ENGINE=MyISAM;
     
147. ALTER TABLE pre_forum_attachment_4 ENGINE=MyISAM;
     
148. ALTER TABLE pre_forum_attachment_5 ENGINE=MyISAM;
     
149. ALTER TABLE pre_forum_attachment_6 ENGINE=MyISAM;
     
150. ALTER TABLE pre_forum_attachment_7 ENGINE=MyISAM;
     
151. ALTER TABLE pre_forum_attachment_8 ENGINE=MyISAM;
     
152. ALTER TABLE pre_forum_attachment_9 ENGINE=MyISAM;
     
153. ALTER TABLE pre_forum_attachment_exif ENGINE=MyISAM;
     
154. ALTER TABLE pre_forum_attachment_unused ENGINE=MyISAM;
     
155. ALTER TABLE pre_forum_attachtype ENGINE=MyISAM;
     
156. ALTER TABLE pre_forum_bbcode ENGINE=MyISAM;
     
157. ALTER TABLE pre_forum_collection ENGINE=MyISAM;
     
158. ALTER TABLE pre_forum_collectioncomment ENGINE=MyISAM;
     
159. ALTER TABLE pre_forum_collectionfollow ENGINE=MyISAM;
     
160. ALTER TABLE pre_forum_collectioninvite ENGINE=MyISAM;
     
161. ALTER TABLE pre_forum_collectionrelated ENGINE=MyISAM;
     
162. ALTER TABLE pre_forum_collectionteamworker ENGINE=MyISAM;
     
163. ALTER TABLE pre_forum_collectionthread ENGINE=MyISAM;
     
164. ALTER TABLE pre_forum_creditslog ENGINE=MyISAM;
     
165. ALTER TABLE pre_forum_debate ENGINE=MyISAM;
     
166. ALTER TABLE pre_forum_debatepost ENGINE=MyISAM;
     
167. ALTER TABLE pre_forum_faq ENGINE=MyISAM;
     
168. ALTER TABLE pre_forum_filter_post ENGINE=MyISAM;
     
169. ALTER TABLE pre_forum_forum ENGINE=MyISAM;
     
170. ALTER TABLE pre_forum_forumfield ENGINE=MyISAM;
     
171. ALTER TABLE pre_forum_forumrecommend ENGINE=MyISAM;
     
172. ALTER TABLE pre_forum_forum_threadtable ENGINE=MyISAM;
     
173. ALTER TABLE pre_forum_groupcreditslog ENGINE=MyISAM;
     
174. ALTER TABLE pre_forum_groupfield ENGINE=MyISAM;
     
175. ALTER TABLE pre_forum_groupinvite ENGINE=MyISAM;
     
176. ALTER TABLE pre_forum_grouplevel ENGINE=MyISAM;
     
177. ALTER TABLE pre_forum_groupranking ENGINE=MyISAM;
     
178. ALTER TABLE pre_forum_groupuser ENGINE=MyISAM;
     
179. ALTER TABLE pre_forum_hotreply_member ENGINE=MyISAM;
     
180. ALTER TABLE pre_forum_hotreply_number ENGINE=MyISAM;
     
181. ALTER TABLE pre_forum_imagetype ENGINE=MyISAM;
     
182. ALTER TABLE pre_forum_medal ENGINE=MyISAM;
     
183. ALTER TABLE pre_forum_medallog ENGINE=MyISAM;
     
184. ALTER TABLE pre_forum_memberrecommend ENGINE=MyISAM;
     
185. ALTER TABLE pre_forum_moderator ENGINE=MyISAM;
     
186. ALTER TABLE pre_forum_modwork ENGINE=MyISAM;
     
187. ALTER TABLE pre_forum_newthread ENGINE=MyISAM;
     
188. ALTER TABLE pre_forum_onlinelist ENGINE=MyISAM;
     
189. ALTER TABLE pre_forum_optionvalue10 ENGINE=MyISAM;
     
190. ALTER TABLE pre_forum_optionvalue11 ENGINE=MyISAM;
     
191. ALTER TABLE pre_forum_optionvalue12 ENGINE=MyISAM;
     
192. ALTER TABLE pre_forum_optionvalue13 ENGINE=MyISAM;
     
193. ALTER TABLE pre_forum_optionvalue5 ENGINE=MyISAM;
     
194. ALTER TABLE pre_forum_optionvalue6 ENGINE=MyISAM;
     
195. ALTER TABLE pre_forum_optionvalue7 ENGINE=MyISAM;
     
196. ALTER TABLE pre_forum_optionvalue8 ENGINE=MyISAM;
     
197. ALTER TABLE pre_forum_optionvalue9 ENGINE=MyISAM;
     
198. ALTER TABLE pre_forum_order ENGINE=MyISAM;
     
199. ALTER TABLE pre_forum_poll ENGINE=MyISAM;
     
200. ALTER TABLE pre_forum_polloption ENGINE=MyISAM;
     
201. ALTER TABLE pre_forum_polloption_image ENGINE=MyISAM;
     
202. ALTER TABLE pre_forum_pollvoter ENGINE=MyISAM;
     
203. ALTER TABLE pre_forum_post ENGINE=MyISAM;
     
204. ALTER TABLE pre_forum_postcache ENGINE=MyISAM;
     
205. ALTER TABLE pre_forum_postcomment ENGINE=MyISAM;
     
206. ALTER TABLE pre_forum_postlog ENGINE=MyISAM;
     
207. ALTER TABLE pre_forum_postposition ENGINE=MyISAM;
     
208. ALTER TABLE pre_forum_poststick ENGINE=MyISAM;
     
209. ALTER TABLE pre_forum_post_1 ENGINE=MyISAM;
     
210. ALTER TABLE pre_forum_post_2 ENGINE=MyISAM;
     
211. ALTER TABLE pre_forum_post_3 ENGINE=MyISAM;
     
212. ALTER TABLE pre_forum_post_4 ENGINE=MyISAM;
     
213. ALTER TABLE pre_forum_post_5 ENGINE=MyISAM;
     
214. ALTER TABLE pre_forum_post_6 ENGINE=MyISAM;
     
215. ALTER TABLE pre_forum_post_7 ENGINE=MyISAM;
     
216. ALTER TABLE pre_forum_post_8 ENGINE=MyISAM;
     
217. ALTER TABLE pre_forum_post_9 ENGINE=MyISAM;
     
218. ALTER TABLE pre_forum_post_location ENGINE=MyISAM;
     
219. ALTER TABLE pre_forum_post_moderate ENGINE=MyISAM;
     
220. ALTER TABLE pre_forum_post_tableid ENGINE=MyISAM;
     
221. ALTER TABLE pre_forum_promotion ENGINE=MyISAM;
     
222. ALTER TABLE pre_forum_ratelog ENGINE=MyISAM;
     
223. ALTER TABLE pre_forum_relatedthread ENGINE=MyISAM;
     
224. ALTER TABLE pre_forum_replycredit ENGINE=MyISAM;
     
225. ALTER TABLE pre_forum_rsscache ENGINE=MyISAM;
     
226. ALTER TABLE pre_forum_sofa ENGINE=MyISAM;
     
227. ALTER TABLE pre_forum_spacecache ENGINE=MyISAM;
     
228. ALTER TABLE pre_forum_statlog ENGINE=MyISAM;
     
229. ALTER TABLE pre_forum_thread ENGINE=MyISAM;
     
230. ALTER TABLE pre_forum_threadaddviews ENGINE=MyISAM;
     
231. ALTER TABLE pre_forum_threadcalendar ENGINE=MyISAM;
     
232. ALTER TABLE pre_forum_threadclass ENGINE=MyISAM;
     
233. ALTER TABLE pre_forum_threadclosed ENGINE=MyISAM;
     
234. ALTER TABLE pre_forum_threaddisablepos ENGINE=MyISAM;
     
235. ALTER TABLE pre_forum_threadhidelog ENGINE=MyISAM;
     
236. ALTER TABLE pre_forum_threadhot ENGINE=MyISAM;
     
237. ALTER TABLE pre_forum_threadimage ENGINE=MyISAM;
     
238. ALTER TABLE pre_forum_threadlog ENGINE=MyISAM;
     
239. ALTER TABLE pre_forum_threadmod ENGINE=MyISAM;
     
240. ALTER TABLE pre_forum_threadpartake ENGINE=MyISAM;
     
241. ALTER TABLE pre_forum_threadpreview ENGINE=MyISAM;
     
242. ALTER TABLE pre_forum_threadprofile ENGINE=MyISAM;
     
243. ALTER TABLE pre_forum_threadprofile_group ENGINE=MyISAM;
     
244. ALTER TABLE pre_forum_threadrush ENGINE=MyISAM;
     
245. ALTER TABLE pre_forum_threadtype ENGINE=MyISAM;
     
246. ALTER TABLE pre_forum_thread_1 ENGINE=MyISAM;
     
247. ALTER TABLE pre_forum_thread_moderate ENGINE=MyISAM;
     
248. ALTER TABLE pre_forum_trade ENGINE=MyISAM;
     
249. ALTER TABLE pre_forum_tradecomment ENGINE=MyISAM;
     
250. ALTER TABLE pre_forum_tradelog ENGINE=MyISAM;
     
251. ALTER TABLE pre_forum_typeoption ENGINE=MyISAM;
     
252. ALTER TABLE pre_forum_typeoptionvar ENGINE=MyISAM;
     
253. ALTER TABLE pre_forum_typevar ENGINE=MyISAM;
     
254. ALTER TABLE pre_forum_warning ENGINE=MyISAM;
     
255. ALTER TABLE pre_gbg_setting ENGINE=MyISAM;
     
256. ALTER TABLE pre_gysj_logo ENGINE=MyISAM;
     
257. ALTER TABLE pre_home_album ENGINE=MyISAM;
     
258. ALTER TABLE pre_home_album_category ENGINE=MyISAM;
     
259. ALTER TABLE pre_home_appcreditlog ENGINE=MyISAM;
     
260. ALTER TABLE pre_home_blacklist ENGINE=MyISAM;
     
261. ALTER TABLE pre_home_blog ENGINE=MyISAM;
     
262. ALTER TABLE pre_home_blogfield ENGINE=MyISAM;
     
263. ALTER TABLE pre_home_blog_category ENGINE=MyISAM;
     
264. ALTER TABLE pre_home_blog_moderate ENGINE=MyISAM;
     
265. ALTER TABLE pre_home_class ENGINE=MyISAM;
     
266. ALTER TABLE pre_home_click ENGINE=MyISAM;
     
267. ALTER TABLE pre_home_clickuser ENGINE=MyISAM;
     
268. ALTER TABLE pre_home_comment ENGINE=MyISAM;
     
269. ALTER TABLE pre_home_comment_moderate ENGINE=MyISAM;
     
270. ALTER TABLE pre_home_docomment ENGINE=MyISAM;
     
271. ALTER TABLE pre_home_doing ENGINE=MyISAM;
     
272. ALTER TABLE pre_home_doing_moderate ENGINE=MyISAM;
     
273. ALTER TABLE pre_home_favorite ENGINE=MyISAM;
     
274. ALTER TABLE pre_home_feed ENGINE=MyISAM;
     
275. ALTER TABLE pre_home_feed_app ENGINE=MyISAM;
     
276. ALTER TABLE pre_home_follow ENGINE=MyISAM;
     
277. ALTER TABLE pre_home_follow_feed ENGINE=MyISAM;
     
278. ALTER TABLE pre_home_follow_feed_archiver ENGINE=MyISAM;
     
279. ALTER TABLE pre_home_friend ENGINE=MyISAM;
     
280. ALTER TABLE pre_home_friendlog ENGINE=MyISAM;
     
281. ALTER TABLE pre_home_friend_request ENGINE=MyISAM;
     
282. ALTER TABLE pre_home_notification ENGINE=MyISAM;
     
283. ALTER TABLE pre_home_pic ENGINE=MyISAM;
     
284. ALTER TABLE pre_home_picfield ENGINE=MyISAM;
     
285. ALTER TABLE pre_home_pic_moderate ENGINE=MyISAM;
     
286. ALTER TABLE pre_home_poke ENGINE=MyISAM;
     
287. ALTER TABLE pre_home_pokearchive ENGINE=MyISAM;
     
288. ALTER TABLE pre_home_share ENGINE=MyISAM;
     
289. ALTER TABLE pre_home_share_moderate ENGINE=MyISAM;
     
290. ALTER TABLE pre_home_show ENGINE=MyISAM;
     
291. ALTER TABLE pre_home_specialuser ENGINE=MyISAM;
     
292. ALTER TABLE pre_home_userapp ENGINE=MyISAM;
     
293. ALTER TABLE pre_home_userappfield ENGINE=MyISAM;
     
294. ALTER TABLE pre_home_userapp_plying ENGINE=MyISAM;
     
295. ALTER TABLE pre_home_visitor ENGINE=MyISAM;
     
296. ALTER TABLE pre_hwt_dev ENGINE=MyISAM;
     
297. ALTER TABLE pre_hy_bqbg ENGINE=MyISAM;
     
298. ALTER TABLE pre_hy_rand_bg ENGINE=MyISAM;
     
299. ALTER TABLE pre_iwenwen_answers ENGINE=MyISAM;
     
300. ALTER TABLE pre_iwenwen_backflow ENGINE=MyISAM;
     
301. ALTER TABLE pre_kz_spider ENGINE=MyISAM;
     
302. ALTER TABLE pre_lev_user_setting ENGINE=MyISAM;
     
303. ALTER TABLE pre_lev_user_sm ENGINE=MyISAM;
     
304. ALTER TABLE pre_milu_seotool_included ENGINE=MyISAM;
     
305. ALTER TABLE pre_milu_seotool_keyword ENGINE=MyISAM;
     
306. ALTER TABLE pre_milu_seotool_keyword_rank ENGINE=MyISAM;
     
307. ALTER TABLE pre_milu_seotool_spider ENGINE=MyISAM;
     
308. ALTER TABLE pre_mobileoem_member ENGINE=MyISAM;
     
309. ALTER TABLE pre_mobileoem_pushthreads ENGINE=MyISAM;
     
310. ALTER TABLE pre_mobile_setting ENGINE=MyISAM;
     
311. ALTER TABLE pre_mobile_wechat_authcode ENGINE=MyISAM;
     
312. ALTER TABLE pre_mobile_wechat_masssend ENGINE=MyISAM;
     
313. ALTER TABLE pre_mobile_wechat_resource ENGINE=MyISAM;
     
314. ALTER TABLE pre_mobile_wsq_threadlist ENGINE=MyISAM;
     
315. ALTER TABLE pre_myrepeats ENGINE=MyISAM;
     
316. ALTER TABLE pre_nds_votekick ENGINE=MyISAM;
     
317. ALTER TABLE pre_piaobo_qqgroups ENGINE=MyISAM;
     
318. ALTER TABLE pre_piaobo_qqgroup_type ENGINE=MyISAM;
     
319. ALTER TABLE pre_plugin_vfastpost_myforum ENGINE=MyISAM;
     
320. ALTER TABLE pre_plugin_vfastpost_stat ENGINE=MyISAM;
     
321. ALTER TABLE pre_portal_article_content ENGINE=MyISAM;
     
322. ALTER TABLE pre_portal_article_count ENGINE=MyISAM;
     
323. ALTER TABLE pre_portal_article_moderate ENGINE=MyISAM;
     
324. ALTER TABLE pre_portal_article_related ENGINE=MyISAM;
     
325. ALTER TABLE pre_portal_article_title ENGINE=MyISAM;
     
326. ALTER TABLE pre_portal_article_trash ENGINE=MyISAM;
     
327. ALTER TABLE pre_portal_attachment ENGINE=MyISAM;
     
328. ALTER TABLE pre_portal_category ENGINE=MyISAM;
     
329. ALTER TABLE pre_portal_category_permission ENGINE=MyISAM;
     
330. ALTER TABLE pre_portal_comment ENGINE=MyISAM;
     
331. ALTER TABLE pre_portal_comment_moderate ENGINE=MyISAM;
     
332. ALTER TABLE pre_portal_rsscache ENGINE=MyISAM;
     
333. ALTER TABLE pre_portal_topic ENGINE=MyISAM;
     
334. ALTER TABLE pre_portal_topic_pic ENGINE=MyISAM;
     
335. ALTER TABLE pre_ppc_xiu_favorite ENGINE=MyISAM;
     
336. ALTER TABLE pre_ppc_xiu_focuspic ENGINE=MyISAM;
     
337. ALTER TABLE pre_ppc_xiu_information ENGINE=MyISAM;
     
338. ALTER TABLE pre_ppc_xiu_item ENGINE=MyISAM;
     
339. ALTER TABLE pre_ppc_xiu_item_cate ENGINE=MyISAM;
     
340. ALTER TABLE pre_ppc_xiu_member_bbs ENGINE=MyISAM;
     
341. ALTER TABLE pre_ppc_xiu_tag ENGINE=MyISAM;
     
342. ALTER TABLE pre_ppc_xiu_tag_item ENGINE=MyISAM;
     
343. ALTER TABLE pre_ppc_xiu_user_account ENGINE=MyISAM;
     
344. ALTER TABLE pre_ppc_xiu_user_rebate ENGINE=MyISAM;
     
345. ALTER TABLE pre_qqrobot_notice ENGINE=MyISAM;
     
346. ALTER TABLE pre_qqrobot_qa ENGINE=MyISAM;
     
347. ALTER TABLE pre_qqrobot_qq ENGINE=MyISAM;
     
348. ALTER TABLE pre_qqrobot_qunchat ENGINE=MyISAM;
     
349. ALTER TABLE pre_qqrobot_send ENGINE=MyISAM;
     
350. ALTER TABLE pre_security_evilpost ENGINE=MyISAM;
     
351. ALTER TABLE pre_security_eviluser ENGINE=MyISAM;
     
352. ALTER TABLE pre_security_failedlog ENGINE=MyISAM;
     
353. ALTER TABLE pre_strayer_article_content ENGINE=MyISAM;
     
354. ALTER TABLE pre_strayer_article_title ENGINE=MyISAM;
     
355. ALTER TABLE pre_strayer_attach ENGINE=MyISAM;
     
356. ALTER TABLE pre_strayer_category ENGINE=MyISAM;
     
357. ALTER TABLE pre_strayer_evo ENGINE=MyISAM;
     
358. ALTER TABLE pre_strayer_evo_log ENGINE=MyISAM;
     
359. ALTER TABLE pre_strayer_fastpick ENGINE=MyISAM;
     
360. ALTER TABLE pre_strayer_member ENGINE=MyISAM;
     
361. ALTER TABLE pre_strayer_picker ENGINE=MyISAM;
     
362. ALTER TABLE pre_strayer_rules ENGINE=MyISAM;
     
363. ALTER TABLE pre_strayer_searchindex ENGINE=MyISAM;
     
364. ALTER TABLE pre_strayer_setting ENGINE=MyISAM;
     
365. ALTER TABLE pre_strayer_timing ENGINE=MyISAM;
     
366. ALTER TABLE pre_strayer_typeoptionvar ENGINE=MyISAM;
     
367. ALTER TABLE pre_strayer_url ENGINE=MyISAM;
     
368. ALTER TABLE pre_study_seo_head ENGINE=MyISAM;
     
369. ALTER TABLE pre_tools_censorhome ENGINE=MyISAM;
     
370. ALTER TABLE pre_tools_rule ENGINE=MyISAM;
     
371. ALTER TABLE pre_ucenter_admins ENGINE=MyISAM;
     
372. ALTER TABLE pre_ucenter_applications ENGINE=MyISAM;
     
373. ALTER TABLE pre_ucenter_badwords ENGINE=MyISAM;
     
374. ALTER TABLE pre_ucenter_domains ENGINE=MyISAM;
     
375. ALTER TABLE pre_ucenter_failedlogins ENGINE=MyISAM;
     
376. ALTER TABLE pre_ucenter_feeds ENGINE=MyISAM;
     
377. ALTER TABLE pre_ucenter_friends ENGINE=MyISAM;
     
378. ALTER TABLE pre_ucenter_mailqueue ENGINE=MyISAM;
     
379. ALTER TABLE pre_ucenter_memberfields ENGINE=MyISAM;
     
380. ALTER TABLE pre_ucenter_members ENGINE=MyISAM;
     
381. ALTER TABLE pre_ucenter_mergemembers ENGINE=MyISAM;
     
382. ALTER TABLE pre_ucenter_newpm ENGINE=MyISAM;
     
383. ALTER TABLE pre_ucenter_notelist ENGINE=MyISAM;
     
384. ALTER TABLE pre_ucenter_pm_indexes ENGINE=MyISAM;
     
385. ALTER TABLE pre_ucenter_pm_lists ENGINE=MyISAM;
     
386. ALTER TABLE pre_ucenter_pm_members ENGINE=MyISAM;
     
387. ALTER TABLE pre_ucenter_pm_messages_0 ENGINE=MyISAM;
     
388. ALTER TABLE pre_ucenter_pm_messages_1 ENGINE=MyISAM;
     
389. ALTER TABLE pre_ucenter_pm_messages_2 ENGINE=MyISAM;
     
390. ALTER TABLE pre_ucenter_pm_messages_3 ENGINE=MyISAM;
     
391. ALTER TABLE pre_ucenter_pm_messages_4 ENGINE=MyISAM;
     
392. ALTER TABLE pre_ucenter_pm_messages_5 ENGINE=MyISAM;
     
393. ALTER TABLE pre_ucenter_pm_messages_6 ENGINE=MyISAM;
     
394. ALTER TABLE pre_ucenter_pm_messages_7 ENGINE=MyISAM;
     
395. ALTER TABLE pre_ucenter_pm_messages_8 ENGINE=MyISAM;
     
396. ALTER TABLE pre_ucenter_pm_messages_9 ENGINE=MyISAM;
     
397. ALTER TABLE pre_ucenter_protectedmembers ENGINE=MyISAM;
     
398. ALTER TABLE pre_ucenter_settings ENGINE=MyISAM;
     
399. ALTER TABLE pre_ucenter_sqlcache ENGINE=MyISAM;
     
400. ALTER TABLE pre_ucenter_tags ENGINE=MyISAM;
     
401. ALTER TABLE pre_ucenter_vars ENGINE=MyISAM;
     
402. ALTER TABLE pre_vgallerys ENGINE=MyISAM;
     
403. ALTER TABLE pre_vgallery_evaluate ENGINE=MyISAM;
     
404. ALTER TABLE pre_vgallery_favorites ENGINE=MyISAM;
     
405. ALTER TABLE pre_vgallery_report ENGINE=MyISAM;
     
406. ALTER TABLE pre_vgallery_sort ENGINE=MyISAM;
     
407. ALTER TABLE pre_vgallery_top5 ENGINE=MyISAM;
     
408. ALTER TABLE pre_weibo_bind ENGINE=MyISAM;
     
409. ALTER TABLE pre_weibo_bind_user ENGINE=MyISAM;
     
410. ALTER TABLE pre_weibo_idol ENGINE=MyISAM;
     
411. ALTER TABLE pre_weibo_setting ENGINE=MyISAM;
     
412. ALTER TABLE pre_weibo_stat ENGINE=MyISAM;
     
413. ALTER TABLE pre_weibo_synlist ENGINE=MyISAM;
     
414. ALTER TABLE pre_wq_links ENGINE=MyISAM;
     
415. ALTER TABLE pre_xplus_common_attachment ENGINE=MyISAM;
     
416. ALTER TABLE pre_xplus_common_config ENGINE=MyISAM;
     
417. ALTER TABLE pre_xplus_common_module ENGINE=MyISAM;
     
418. ALTER TABLE pre_xplus_common_template ENGINE=MyISAM;
     
419. ALTER TABLE pre_xplus_form_attachment ENGINE=MyISAM;
     
420. ALTER TABLE pre_xplus_form_field ENGINE=MyISAM;
     
421. ALTER TABLE pre_xplus_form_field_class ENGINE=MyISAM;
     
422. ALTER TABLE pre_xplus_form_item ENGINE=MyISAM;
     
423. ALTER TABLE pre_xplus_form_item_count ENGINE=MyISAM;
     
424. ALTER TABLE pre_xplus_form_item_field ENGINE=MyISAM;
     
425. ALTER TABLE pre_xplus_form_item_var ENGINE=MyISAM;
     
426. ALTER TABLE pre_xplus_form_setting ENGINE=MyISAM;
     
427. ALTER TABLE pre_xplus_poll ENGINE=MyISAM;
     
428. ALTER TABLE pre_xplus_poll_category ENGINE=MyISAM;
     
429. ALTER TABLE pre_xplus_poll_item ENGINE=MyISAM;
     
430. ALTER TABLE pre_xplus_poll_option ENGINE=MyISAM;
     
431. ALTER TABLE pre_xplus_poll_profile ENGINE=MyISAM;
     
432. ALTER TABLE pre_xplus_poll_result ENGINE=MyISAM;
     
433. ALTER TABLE pre_xplus_vote ENGINE=MyISAM;
     
434. ALTER TABLE pre_xplus_vote_choice ENGINE=MyISAM;
     
435. ALTER TABLE pre_xplus_vote_field ENGINE=MyISAM;
     
436. ALTER TABLE pre_xplus_vote_value ENGINE=MyISAM;
     
437. ALTER TABLE pre_yingyong_fav ENGINE=MyISAM;
     
438. ALTER TABLE pre_yunstream_dianbo ENGINE=MyISAM;
     
439. ALTER TABLE pre_ztips_contents ENGINE=MyISAM;
     
440. ALTER TABLE pre_ztips_setting ENGINE=MyISAM;
     

复制代码