终极精品 › 技术资源 › 教程专区 › Navicat for mysql数据传输转存到另外服务器数据库

查看: 1620|回复: 0

[网络技术] Navicat for mysql数据传输转存到另外服务器数据库

[复制链接]

zhoji

等级:

级别: 管理员

UID: 1

积分: 407416

威望: 3806

贡献: 3745

活跃: 0

发贴: 1401 (4)

终极币: 394653

性别:

阅读权限: 200
在线时长: 1151 小时
注册时间: 2014-7-25
最后登录: 2025-4-29

电梯直达 go

楼主

发表于 2018-11-10 23:10:00 |只看该作者 |倒序浏览

查看完整版请注册登录浏览

您需要登录才可以下载或查看，没有帐号？点击注册

我们做服务网站数据迁移由于数据库G级太大，需要从源服务器数据库迁移到近服务器的数据库，这时时就要用到Navicat for mysql远程数据传输的功能了
首先第一步：打开云服务器ECS，配置安全组放开3306端口，
第二步：宝塔服务器控制面板找到安全防火墙开放放开3306端口，
第三步：宝塔服务器管理面板 ---->对应数据库
找到对应的虚拟主机数据库点击权限选中所有人就可以了记住 选中所有人
第五步：naviact 链接mysql 就可以成功链接
方法：点击“工具”---->"数据传输"

QQ图片20181110225719.png (165.04 KB, 下载次数: 0)

下载附件

2018-11-10 23:02 上传

然后选择从哪个数据库传到哪个数据库，左边栏是从哪个连接的数据库
(要复制数据所在的数据库，源数据库),右边是“目标”数据库。然后点开始即可。

22.png (76.46 KB, 下载次数: 0)

下载附件

2018-11-10 23:08 上传

4.png (58.38 KB, 下载次数: 0)

下载附件

2018-11-10 23:11 上传

QQ图片20181110231358.png (95.97 KB, 下载次数: 0)

下载附件

2018-11-10 23:16 上传

[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

分享到: QQ好友和群 QQ空间 腾讯微博 腾讯朋友

收藏0 支持0 反对0

宣传推广终极精品资源www.chnspy.com提升下载权限1...

使用道具举报

返回列表