Navicat for mysql数据传输转存到另外服务器数据库
我们做服务网站数据迁移由于数据库G级太大，需要从源服务器数据库迁移到近服务器的数据库，这时时就要用到Navicat for mysql远程数据传输的功能了首先第一步：打开云服务器ECS，配置安全组放开3306端口，
第二步：宝塔服务器控制面板 找到 安全防火墙开放放开3306端口，
第三步： 宝塔服务器管理面板---->对应数据库
找到 对应的虚拟主机数据库 点击 权限 选中 所有人 就可以了 记住 选中所有人
第五步：naviact 链接mysql 就可以 成功链接
方法：点击“工具”---->"数据传输"
然后选择从哪个数据库传到哪个数据库，左边栏是从哪个连接的数据库
(要复制数据所在的数据库，源数据库),右边是“目标”数据库。然后点开始即可。
Data Transfer start
Getting tables
Getting views
Getting functions
Get table data for `ip_data`
Drop table: `ip_data`
Create table: `ip_data`
Begin transaction on target server
Start transfer data for table: `ip_data`
End transaction on target server
Drop table: `sgj_accountstat`
Create table: `sgj_accountstat`
Get table data for `sgj_aquestion`
Drop table: `sgj_aquestion`
Create table: `sgj_aquestion`
Begin transaction on target server
Start transfer data for table: `sgj_aquestion`
End transaction on target server
Get table data for `sgj_artclass`
Drop table: `sgj_artclass`
Create table: `sgj_artclass`
Begin transaction on target server
Start transfer data for table: `sgj_artclass`
End transaction on target server
Get table data for `sgj_black`
Drop table: `sgj_black`
Create table: `sgj_black`
Begin transaction on target server
Start transfer data for table: `sgj_black`
End transaction on target server
Get table data for `sgj_canned`
Drop table: `sgj_canned`
Create table: `sgj_canned`
Begin transaction on target server
Start transfer data for table: `sgj_canned`
Get table data for `sgj_chatthreadpic`
End transaction on target server
Drop table: `sgj_chatthreadpic`
Create table: `sgj_chatthreadpic`
Begin transaction on target server
Start transfer data for table: `sgj_chatthreadpic`
End transaction on target server
Get table data for `sgj_collect`
Drop table: `sgj_collect`
Create table: `sgj_collect`
Begin transaction on target server
Start transfer data for table: `sgj_collect`
End transaction on target server
Get table data for `sgj_config`
Drop table: `sgj_config`
Create table: `sgj_config`
Begin transaction on target server
Start transfer data for table: `sgj_config`
End transaction on target server
Get table data for `sgj_deposit`
Drop table: `sgj_deposit`
Create table: `sgj_deposit`
Begin transaction on target server
Start transfer data for table: `sgj_deposit`
End transaction on target server
Get table data for `sgj_invitation`
Drop table: `sgj_invitation`
Create table: `sgj_invitation`
Begin transaction on target server
Start transfer data for table: `sgj_invitation`
End transaction on target server
Drop table: `sgj_ip`
Create table: `sgj_ip`
Get table data for `sgj_link`
Drop table: `sgj_link`
Create table: `sgj_link`
Begin transaction on target server
Start transfer data for table: `sgj_link`
End transaction on target server
Get table data for `sgj_message`
Drop table: `sgj_message`
Create table: `sgj_message`
Begin transaction on target server
Start transfer data for table: `sgj_message`
End transaction on target server
Drop table: `sgj_order`
Get table data for `sgj_order`
Create table: `sgj_order`
Begin transaction on target server
Start transfer data for table: `sgj_order`
End transaction on target server
Get table data for `sgj_phone`
Drop table: `sgj_phone`
Create table: `sgj_phone`
Begin transaction on target server
Start transfer data for table: `sgj_phone`
End transaction on target server
Get table data for `sgj_points`
Drop table: `sgj_points`
Create table: `sgj_points`
Begin transaction on target server
Start transfer data for table: `sgj_points`
Get table data for `sgj_points_set`
End transaction on target server
Drop table: `sgj_points_set`
Create table: `sgj_points_set`
Begin transaction on target server
Start transfer data for table: `sgj_points_set`
End transaction on target server
Get table data for `sgj_question`
Drop table: `sgj_question`
Create table: `sgj_question`
Begin transaction on target server
Start transfer data for table: `sgj_question`
End transaction on target server
Get table data for `sgj_question_closely`
Drop table: `sgj_question_closely`
Create table: `sgj_question_closely`
Begin transaction on target server
Start transfer data for table: `sgj_question_closely`
End transaction on target server
Get table data for `sgj_service`
Drop table: `sgj_service`
Create table: `sgj_service`
Begin transaction on target server
Start transfer data for table: `sgj_service`
End transaction on target server
Get table data for `sgj_super`
Drop table: `sgj_super`
Create table: `sgj_super`
Begin transaction on target server
Start transfer data for table: `sgj_super`
End transaction on target server
Get table data for `sgj_teacher`
Drop table: `sgj_teacher`
Create table: `sgj_teacher`
Begin transaction on target server
Start transfer data for table: `sgj_teacher`
Get table data for `sgj_teacher_214`
End transaction on target server
Drop table: `sgj_teacher_214`
Create table: `sgj_teacher_214`
Begin transaction on target server
Start transfer data for table: `sgj_teacher_214`
Get table data for `sgj_teacher_backup`
End transaction on target server
Drop table: `sgj_teacher_backup`
Create table: `sgj_teacher_backup`
Begin transaction on target server
Start transfer data for table: `sgj_teacher_backup`
End transaction on target server
Get table data for `sgj_transaction`
Drop table: `sgj_transaction`
Create table: `sgj_transaction`
Begin transaction on target server
Start transfer data for table: `sgj_transaction`
End transaction on target server
Get table data for `sgj_twenzhang`
Drop table: `sgj_twenzhang`
Create table: `sgj_twenzhang`
Begin transaction on target server
Start transfer data for table: `sgj_twenzhang`
End transaction on target server
Get table data for `sgj_user`
Drop table: `sgj_user`
Create table: `sgj_user`
Begin transaction on target server
Start transfer data for table: `sgj_user`
End transaction on target server
Drop table: `sgj_wenzhang`
Get table data for `sgj_wenzhang`
Create table: `sgj_wenzhang`
Begin transaction on target server
Start transfer data for table: `sgj_wenzhang`
End transaction on target server
Drop table: `webimchatban`
Create table: `webimchatban`
Get table data for `webimchatconfig`
Drop table: `webimchatconfig`
Create table: `webimchatconfig`
Begin transaction on target server
Start transfer data for table: `webimchatconfig`
End transaction on target server
Drop table: `webimchatgroup`
Create table: `webimchatgroup`
Get table data for `webimchatgroupoperator`
Drop table: `webimchatgroupoperator`
Create table: `webimchatgroupoperator`
Begin transaction on target server
Start transfer data for table: `webimchatgroupoperator`
End transaction on target server
Get table data for `webimchatmessage`
Drop table: `webimchatmessage`
Create table: `webimchatmessage`
Begin transaction on target server
Start transfer data for table: `webimchatmessage`
End transaction on target server
Get table data for `webimchatoperator`
Get table data for `webimchatresponses`
Get table data for `webimchatrevision`
Get table data for `webimchatthread`
Drop table: `webimchatnotification`
Create table: `webimchatnotification`
Drop table: `webimchatoperator`
Create table: `webimchatoperator`
Begin transaction on target server
Start transfer data for table: `webimchatoperator`
End transaction on target server
Drop table: `webimchatresponses`
Create table: `webimchatresponses`
Begin transaction on target server
Start transfer data for table: `webimchatresponses`
End transaction on target server
Drop table: `webimchatrevision`
Create table: `webimchatrevision`
Begin transaction on target server
Start transfer data for table: `webimchatrevision`
End transaction on target server
Drop table: `webimchatthread`
Create table: `webimchatthread`
Begin transaction on target server
Start transfer data for table: `webimchatthread`
End transaction on target server
Get table data for `wemall_admin`
Drop table: `wemall_admin`
Create table: `wemall_admin`
Begin transaction on target server
Start transfer data for table: `wemall_admin`
End transaction on target server
Drop table: `wemall_info`
Get table data for `wemall_info`
Create table: `wemall_info`
Begin transaction on target server
Start transfer data for table: `wemall_info`
End transaction on target server
Get table data for `wemall_market`
Drop table: `wemall_market`
Create table: `wemall_market`
Begin transaction on target server
Start transfer data for table: `wemall_market`
End transaction on target server
Get table data for `wemall_marketinfo`
Drop table: `wemall_marketinfo`
Create table: `wemall_marketinfo`
Begin transaction on target server
Start transfer data for table: `wemall_marketinfo`
End transaction on target server
Drop table: `wemall_marketmiandan`
Create table: `wemall_marketmiandan`
Get table data for `wemall_user`
Drop table: `wemall_user`
Create table: `wemall_user`
Begin transaction on target server
Start transfer data for table: `wemall_user`
End transaction on target server
Get table data for `wemall_wenzhang`
Drop table: `wemall_wenzhang`
Create table: `wemall_wenzhang`
Begin transaction on target server
Start transfer data for table: `wemall_wenzhang`
End transaction on target server
Get table data for `wemall_wxconfig`
Drop table: `wemall_wxconfig`
Create table: `wemall_wxconfig`
Begin transaction on target server
Start transfer data for table: `wemall_wxconfig`
End transaction on target server
Get table data for `wemall_wxmessage`
Drop table: `wemall_wxmessage`
Create table: `wemall_wxmessage`
Begin transaction on target server
Start transfer data for table: `wemall_wxmessage`
End transaction on target server
Drop view: `sgj_teacher_v`
Create view: `sgj_teacher_v`
1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
Finished unsuccessfully
页:
[1]