终极精品

标题: Navicat for mysql数据传输转存到另外服务器数据库 [打印本页]

作者: zhoji    时间: 2018-11-10 23:10
标题: Navicat for mysql数据传输转存到另外服务器数据库
我们做服务网站数据迁移由于数据库G级太大,需要从源服务器数据库迁移到近服务器的数据库,这时时就要用到Navicat for mysql远程数据传输的功能了
首先
第一步:打开云服务器ECS,配置安全组放开3306端口,
第二步:宝塔服务器控制面板 找到 安全防火墙开放放开3306端口
第三步: 宝塔服务器管理面板  ---->对应数据库

找到 对应的虚拟主机数据库 点击 权限 选中 所有人 就可以了 记住 选中所有人
第五步:naviact 链接mysql 就可以 成功链接
方法:点击“工具”---->"数据传输"
[attach]20545[/attach]

然后选择从哪个数据库传到哪个数据库,左边栏是从哪个连接的数据库
(要复制数据所在的数据库,源数据库),右边是“目标”数据库。然后点开始即可。
[attach]20546[/attach]
[attach]20547[/attach]
[attach]20548[/attach]
[DTF] Data Transfer start
[DTF] Getting tables
[DTF] Getting views
[DTF] Getting functions
[DTF] Get table data for `ip_data`
[DTF] Drop table: `ip_data`
[DTF] Create table: `ip_data`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `ip_data`
[DTF] End transaction on target server
[DTF] Drop table: `sgj_accountstat`
[DTF] Create table: `sgj_accountstat`
[DTF] Get table data for `sgj_aquestion`
[DTF] Drop table: `sgj_aquestion`
[DTF] Create table: `sgj_aquestion`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_aquestion`
[DTF] End transaction on target server
[DTF] Get table data for `sgj_artclass`
[DTF] Drop table: `sgj_artclass`
[DTF] Create table: `sgj_artclass`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_artclass`
[DTF] End transaction on target server
[DTF] Get table data for `sgj_black`
[DTF] Drop table: `sgj_black`
[DTF] Create table: `sgj_black`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_black`
[DTF] End transaction on target server
[DTF] Get table data for `sgj_canned`
[DTF] Drop table: `sgj_canned`
[DTF] Create table: `sgj_canned`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_canned`
[DTF] Get table data for `sgj_chatthreadpic`
[DTF] End transaction on target server
[DTF] Drop table: `sgj_chatthreadpic`
[DTF] Create table: `sgj_chatthreadpic`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_chatthreadpic`
[DTF] End transaction on target server
[DTF] Get table data for `sgj_collect`
[DTF] Drop table: `sgj_collect`
[DTF] Create table: `sgj_collect`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_collect`
[DTF] End transaction on target server
[DTF] Get table data for `sgj_config`
[DTF] Drop table: `sgj_config`
[DTF] Create table: `sgj_config`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_config`
[DTF] End transaction on target server
[DTF] Get table data for `sgj_deposit`
[DTF] Drop table: `sgj_deposit`
[DTF] Create table: `sgj_deposit`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_deposit`
[DTF] End transaction on target server
[DTF] Get table data for `sgj_invitation`
[DTF] Drop table: `sgj_invitation`
[DTF] Create table: `sgj_invitation`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_invitation`
[DTF] End transaction on target server
[DTF] Drop table: `sgj_ip`
[DTF] Create table: `sgj_ip`
[DTF] Get table data for `sgj_link`
[DTF] Drop table: `sgj_link`
[DTF] Create table: `sgj_link`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_link`
[DTF] End transaction on target server
[DTF] Get table data for `sgj_message`
[DTF] Drop table: `sgj_message`
[DTF] Create table: `sgj_message`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_message`
[DTF] End transaction on target server
[DTF] Drop table: `sgj_order`
[DTF] Get table data for `sgj_order`
[DTF] Create table: `sgj_order`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_order`
[DTF] End transaction on target server
[DTF] Get table data for `sgj_phone`
[DTF] Drop table: `sgj_phone`
[DTF] Create table: `sgj_phone`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_phone`
[DTF] End transaction on target server
[DTF] Get table data for `sgj_points`
[DTF] Drop table: `sgj_points`
[DTF] Create table: `sgj_points`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_points`
[DTF] Get table data for `sgj_points_set`
[DTF] End transaction on target server
[DTF] Drop table: `sgj_points_set`
[DTF] Create table: `sgj_points_set`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_points_set`
[DTF] End transaction on target server
[DTF] Get table data for `sgj_question`
[DTF] Drop table: `sgj_question`
[DTF] Create table: `sgj_question`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_question`
[DTF] End transaction on target server
[DTF] Get table data for `sgj_question_closely`
[DTF] Drop table: `sgj_question_closely`
[DTF] Create table: `sgj_question_closely`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_question_closely`
[DTF] End transaction on target server
[DTF] Get table data for `sgj_service`
[DTF] Drop table: `sgj_service`
[DTF] Create table: `sgj_service`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_service`
[DTF] End transaction on target server
[DTF] Get table data for `sgj_super`
[DTF] Drop table: `sgj_super`
[DTF] Create table: `sgj_super`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_super`
[DTF] End transaction on target server
[DTF] Get table data for `sgj_teacher`
[DTF] Drop table: `sgj_teacher`
[DTF] Create table: `sgj_teacher`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_teacher`
[DTF] Get table data for `sgj_teacher_214`
[DTF] End transaction on target server
[DTF] Drop table: `sgj_teacher_214`
[DTF] Create table: `sgj_teacher_214`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_teacher_214`
[DTF] Get table data for `sgj_teacher_backup`
[DTF] End transaction on target server
[DTF] Drop table: `sgj_teacher_backup`
[DTF] Create table: `sgj_teacher_backup`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_teacher_backup`
[DTF] End transaction on target server
[DTF] Get table data for `sgj_transaction`
[DTF] Drop table: `sgj_transaction`
[DTF] Create table: `sgj_transaction`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_transaction`
[DTF] End transaction on target server
[DTF] Get table data for `sgj_twenzhang`
[DTF] Drop table: `sgj_twenzhang`
[DTF] Create table: `sgj_twenzhang`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_twenzhang`
[DTF] End transaction on target server
[DTF] Get table data for `sgj_user`
[DTF] Drop table: `sgj_user`
[DTF] Create table: `sgj_user`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_user`
[DTF] End transaction on target server
[DTF] Drop table: `sgj_wenzhang`
[DTF] Get table data for `sgj_wenzhang`
[DTF] Create table: `sgj_wenzhang`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `sgj_wenzhang`
[DTF] End transaction on target server
[DTF] Drop table: `webimchatban`
[DTF] Create table: `webimchatban`
[DTF] Get table data for `webimchatconfig`
[DTF] Drop table: `webimchatconfig`
[DTF] Create table: `webimchatconfig`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `webimchatconfig`
[DTF] End transaction on target server
[DTF] Drop table: `webimchatgroup`
[DTF] Create table: `webimchatgroup`
[DTF] Get table data for `webimchatgroupoperator`
[DTF] Drop table: `webimchatgroupoperator`
[DTF] Create table: `webimchatgroupoperator`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `webimchatgroupoperator`
[DTF] End transaction on target server
[DTF] Get table data for `webimchatmessage`
[DTF] Drop table: `webimchatmessage`
[DTF] Create table: `webimchatmessage`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `webimchatmessage`
[DTF] End transaction on target server
[DTF] Get table data for `webimchatoperator`
[DTF] Get table data for `webimchatresponses`
[DTF] Get table data for `webimchatrevision`
[DTF] Get table data for `webimchatthread`
[DTF] Drop table: `webimchatnotification`
[DTF] Create table: `webimchatnotification`
[DTF] Drop table: `webimchatoperator`
[DTF] Create table: `webimchatoperator`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `webimchatoperator`
[DTF] End transaction on target server
[DTF] Drop table: `webimchatresponses`
[DTF] Create table: `webimchatresponses`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `webimchatresponses`
[DTF] End transaction on target server
[DTF] Drop table: `webimchatrevision`
[DTF] Create table: `webimchatrevision`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `webimchatrevision`
[DTF] End transaction on target server
[DTF] Drop table: `webimchatthread`
[DTF] Create table: `webimchatthread`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `webimchatthread`
[DTF] End transaction on target server
[DTF] Get table data for `wemall_admin`
[DTF] Drop table: `wemall_admin`
[DTF] Create table: `wemall_admin`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `wemall_admin`
[DTF] End transaction on target server
[DTF] Drop table: `wemall_info`
[DTF] Get table data for `wemall_info`
[DTF] Create table: `wemall_info`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `wemall_info`
[DTF] End transaction on target server
[DTF] Get table data for `wemall_market`
[DTF] Drop table: `wemall_market`
[DTF] Create table: `wemall_market`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `wemall_market`
[DTF] End transaction on target server
[DTF] Get table data for `wemall_marketinfo`
[DTF] Drop table: `wemall_marketinfo`
[DTF] Create table: `wemall_marketinfo`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `wemall_marketinfo`
[DTF] End transaction on target server
[DTF] Drop table: `wemall_marketmiandan`
[DTF] Create table: `wemall_marketmiandan`
[DTF] Get table data for `wemall_user`
[DTF] Drop table: `wemall_user`
[DTF] Create table: `wemall_user`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `wemall_user`
[DTF] End transaction on target server
[DTF] Get table data for `wemall_wenzhang`
[DTF] Drop table: `wemall_wenzhang`
[DTF] Create table: `wemall_wenzhang`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `wemall_wenzhang`
[DTF] End transaction on target server
[DTF] Get table data for `wemall_wxconfig`
[DTF] Drop table: `wemall_wxconfig`
[DTF] Create table: `wemall_wxconfig`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `wemall_wxconfig`
[DTF] End transaction on target server
[DTF] Get table data for `wemall_wxmessage`
[DTF] Drop table: `wemall_wxmessage`
[DTF] Create table: `wemall_wxmessage`
[DTF] Begin transaction on target server
[DTF] Start transfer data for table: `wemall_wxmessage`
[DTF] End transaction on target server
[DTF] Drop view: `sgj_teacher_v`
[DTF] Create view: `sgj_teacher_v`
[ERR] 1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
[DTF] Finished unsuccessfully









欢迎光临 终极精品 (http://www.chnspy.com/) Powered by Discuz! X3.2