查找所有sphinx引擎表并生成创建表的语句

-- 查找所有sphinx引擎
select group_concat(table_name separator ' ') from information_schema.tables where engine='SPHINX' and table_schema ='dsideal_db';


-- 导出成sql文件
mysqldump -uroot -pD******** dsideal_db t_bag_resource_info_sphinxse t_base_allpublish_sphinxse t_base_group_member_sphinxse t_base_organization_sphinxse t_base_publish_kyyj_sphinxse t_base_publish_paper_sphinxse t_base_publish_resource_sphinxse t_base_publish_sphinxse t_base_publish_wk_sphinxse t_cloud_resource_info_sphinxse t_cp_person_sphinxse t_game_info_sphinxse t_news_info_sphinxse t_qyjh_hd_sphinxse t_qyjh_xzt_sphinxse t_resource_info_seach_sphinxse t_resource_info_sphinxse t_resource_my_info_sphinxse t_sj_test_sphinxse t_sjk_paper_info_sphinxse t_sjk_paper_my_info_sphinxse t_social_bbs_post_sphinxse t_social_bbs_topic_sphinxse t_social_blog_article_recommend_sphinxse t_social_blog_article_sphinxse t_social_dynamic_info_sphinxse t_social_notice_sphinxse t_supervise_info_sphinxse t_tk_info_sphinxse t_tk_question_info_sphinxse t_tk_question_my_info_sphinxse t_wkds_info_sphinxse t_wkds_wktostudent_sphinxse t_yp_relation_sphinxse t_yx_person_sphinxse t_zy_info_sphinxse >db.sql;