我要用方维系统做产品的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:\tiaowode.sql,就这样,过了一会儿,导入后,问题就解决了