大数据库不能复制转移的解决方案,方维系统的数据库

我要用方维系统做产品的V2版本,要复制出来一份,结果,弄了一天了,试了各种方法都没能把数据库复制出来;

我使用的方法如下:

①PHPMYADMIN复制数据库;

②mysql/data文件夹复制的方法;

③方维系统本身的数据库管理工具;

④利用帝国备份王web软件备份方法;

以上方法都未能成功,在无奈之下,我只能去一个个的对表,原始的方维系统的表是这样的:

fanwe_activity 
fanwe_activity_apply 
fanwe_activity_cate 
fanwe_activity_match 
fanwe_activity_post 
fanwe_admin 
fanwe_admin_log 
fanwe_adv 
fanwe_adv_layout 
fanwe_adv_position 
fanwe_album 
fanwe_album_best 
fanwe_album_category 
fanwe_album_match 
fanwe_album_rec 
fanwe_album_share 
fanwe_album_share_index 
fanwe_album_tags 
fanwe_album_tags_related 
fanwe_anchor 
fanwe_api_log 
fanwe_apns_devices 
fanwe_apns_device_history 
fanwe_apns_messages 
fanwe_ask_post 
fanwe_ask_thread 
fanwe_atme 
fanwe_comment_me 
fanwe_cron 
fanwe_daren_cate 
fanwe_delist_share 
fanwe_event 
fanwe_event_share 
fanwe_exchange_goods 
fanwe_exchange_post 
fanwe_expression 
fanwe_fav_me 
fanwe_forum 
fanwe_forum_apply 
fanwe_forum_category 
fanwe_forum_match 
fanwe_forum_post 
fanwe_forum_tags 
fanwe_forum_thread 
fanwe_forum_thread_best 
fanwe_forum_thread_match 
fanwe_forum_update 
fanwe_forum_users 
fanwe_forum_users_apply 
fanwe_friend_link 
fanwe_goods 
fanwe_goods_category 
fanwe_goods_category_tags 
fanwe_goods_cates 
fanwe_goods_cates_gl 
fanwe_goods_cate_collect 
fanwe_goods_cate_disable 
fanwe_goods_check 
fanwe_goods_color 
fanwe_goods_comment 
fanwe_goods_dictionary 
fanwe_goods_disable 
fanwe_goods_match 
fanwe_goods_order 
fanwe_goods_order_index 
fanwe_goods_tags 
fanwe_images_0 
fanwe_images_1 
fanwe_images_2 
fanwe_images_3 
fanwe_images_4 
fanwe_images_5 
fanwe_images_6 
fanwe_images_7 
fanwe_images_8 
fanwe_images_9 
fanwe_images_index 
fanwe_image_servers 
fanwe_index_cate_group 
fanwe_index_cate_share 
fanwe_infinity_collect 
fanwe_ip_banned 
fanwe_login_module 
fanwe_mail_rss_category 
fanwe_mail_rss_content 
fanwe_mail_rss_send_log 
fanwe_mail_rss_user 
fanwe_mail_template 
fanwe_manage_log 
fanwe_medal 
fanwe_medal_apply 
fanwe_m_adv 
fanwe_m_config 
fanwe_m_config_list 
fanwe_m_index 
fanwe_m_searchcate 
fanwe_nav 
fanwe_nav_category 
fanwe_order 
fanwe_pub_schedule 
fanwe_referrals 
fanwe_region 
fanwe_role 
fanwe_role_access 
fanwe_role_nav 
fanwe_role_node 
fanwe_second 
fanwe_second_goods 
fanwe_seo 
fanwe_seo_meimei 
fanwe_sessions 
fanwe_share 
fanwe_sharegoods_module 
fanwe_share_cancel 
fanwe_share_category 
fanwe_share_check 
fanwe_share_collect1 
fanwe_share_collect7 
fanwe_share_collect_temp 
fanwe_share_color 
fanwe_share_comment 
fanwe_share_dapei_best 
fanwe_share_dapei_goods 
fanwe_share_dapei_index 
fanwe_share_goods 
fanwe_share_goods_index 
fanwe_share_goods_match 
fanwe_share_images_index 
fanwe_share_image_sizes 
fanwe_share_look_best 
fanwe_share_look_goods 
fanwe_share_look_index 
fanwe_share_match 
fanwe_share_photo 
fanwe_share_photo_index 
fanwe_share_photo_match 
fanwe_share_tags 
fanwe_share_text_index 
fanwe_share_text_match 
fanwe_share_user_dapei 
fanwe_share_user_goods 
fanwe_share_user_images 
fanwe_share_user_look 
fanwe_share_user_photo 
fanwe_shop 
fanwe_shop_category 
fanwe_shop_cates 
fanwe_shop_cates_related 
fanwe_shop_check 
fanwe_shop_disable 
fanwe_shop_match 
fanwe_shop_share 
fanwe_smtp 
fanwe_style_category 
fanwe_style_category_tags 
fanwe_sys_conf 
fanwe_sys_msg 
fanwe_sys_msg_member 
fanwe_sys_msg_user_group 
fanwe_sys_msg_user_no 
fanwe_sys_msg_user_yes 
fanwe_sys_notice 
fanwe_taobaoke_report 
fanwe_taobaoke_report_temp 
fanwe_taobao_collect 
fanwe_taobao_goods_pic 
fanwe_taobao_share 
fanwe_taobao_shop 
fanwe_taobao_shop_temp 
fanwe_user 
fanwe_user_auction_log 
fanwe_user_authority 
fanwe_user_bind 
fanwe_user_category 
fanwe_user_category_tags 
fanwe_user_collect 
fanwe_user_collect_cate 
fanwe_user_collect_shop 
fanwe_user_consignee 
fanwe_user_count 
fanwe_user_daren 
fanwe_user_daren_cate 
fanwe_user_follow 
fanwe_user_group 
fanwe_user_group_authority 
fanwe_user_match 
fanwe_user_medal 
fanwe_user_me_tags 
fanwe_user_money_log 
fanwe_user_msg 
fanwe_user_msg_0 
fanwe_user_msg_1 
fanwe_user_msg_2 
fanwe_user_msg_3 
fanwe_user_msg_4 
fanwe_user_msg_5 
fanwe_user_msg_6 
fanwe_user_msg_7 
fanwe_user_msg_8 
fanwe_user_msg_9 
fanwe_user_msg_index 
fanwe_user_msg_list 
fanwe_user_msg_member 
fanwe_user_msg_rel 
fanwe_user_notice 
fanwe_user_profile 
fanwe_user_score_log 
fanwe_user_statistics 
fanwe_user_status 
fanwe_user_tags 
fanwe_vote 
fanwe_vote_match 
fanwe_vote_option 
fanwe_vote_post 
fanwe_vote_user 
fanwe_word 
fanwe_word_type 
fanwe_yiqifa_report 
fanwe_yiqifa_shop 

现在缺的表有

fanwe_goods_disable
fanwe_goods_order 
fanwe_goods_order_index 
fanwe_images_0 
fanwe_images_1 
fanwe_images_2 
fanwe_images_3 
fanwe_images_4 
fanwe_images_5 
fanwe_images_6 
fanwe_images_7 
fanwe_images_8 
fanwe_images_9 
fanwe_images_index 
fanwe_mail_rss_send_log 
fanwe_manage_log 
fanwe_pub_schedule 
fanwe_share 
fanwe_share_category 
fanwe_share_check 
fanwe_share_collect1 
fanwe_share_collect7 
fanwe_share_color 
fanwe_share_comment 
fanwe_share_dapei_best 
fanwe_share_dapei_goods 
fanwe_share_dapei_index 
fanwe_share_goods 
fanwe_share_goods_index 
fanwe_share_images_index 
fanwe_share_look_best 
fanwe_share_look_goods 
fanwe_share_look_index 
fanwe_share_photo 
fanwe_share_photo_index 
fanwe_share_tags 
fanwe_share_text_index 
fanwe_share_user_dapei 
fanwe_share_user_goods 
fanwe_share_user_images 
fanwe_share_user_look 
fanwe_share_user_photo 
fanwe_shop 
fanwe_shop_category 
fanwe_shop_check 
fanwe_shop_share 
fanwe_sys_notice 
fanwe_taobaoke_report 
fanwe_taobao_goods_pic 
fanwe_user_auction_log 
fanwe_user_collect 
fanwe_user_collect_cate 
fanwe_user_collect_shop 
fanwe_user_count 
fanwe_user_follow 
fanwe_user_money_log 
fanwe_user_notice 
fanwe_user_score_log 
fanwe_user_statistics 
fanwe_user_status 
fanwe_vote 
fanwe_vote_option 
fanwe_vote_post 
fanwe_vote_user 
fanwe_yiqifa_report 
fanwe_yiqifa_shop 

 我现在要把有问题的表单独备份,解决方维系统数据库不能复制的问题;

到这里,还是不行啊啊  啊,气死我啦;

继续换方法吧。。。

最后,我用phpmyadmin导出了sql文件,500M的文本文件,百万条数据;

然后在服务器上面有cmd命令source d: iaowode.sql,就这样,过了一会儿,导入后,问题就解决了

原文地址:https://www.cnblogs.com/wangtongphp/p/3183726.html