Navicat的主机破解使用参见:https://blog.csdn.net/weixin_37264997/article/details/85045471
MySQL数据库备份
1、借助工具 Navicat Premium Version 12.0.28(64-bit) -Premium
![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLiAzNfRHLGZkRGZkRfJ3bs92YsYTMfVmepNHL90TUkNjVXFWc1cVWxg2MMBjVtJWd0ckW65UbM5WOHJWa5kHT20ESjBjUIF2X0hXZ0xCMx81dvRWYoNHLrdEZwZ1Rh5WNXp1bwNjW1ZUba9VZwlHdssmch1mclRXY39CXldWYtlWPzNXZj9mcw1ycz9WL49zZuBnLxgDO1QTN1MTM4ATMwkTMwIzLc52YucWbp5GZzNmLn9Gbi1yZtl2Lc9CX6MHc0RHaiojIsJye.png)
2、例如备份MySQL数据库 testdb 数据库,用Navicat打开数据库,
testdb — Backups — 选中-右键 - New Backup - start
3、还原备份的数据库
testdb — Backups — 选中-右键 -Restore Backup from,找到备份的文件
C:\Users\lucy\Documents\Navicat\MySQL\Servers\mysqlLocal\testdb\20190108111059.nb3
另外,Navicat的自动备份计划可以参考:
https://blog.csdn.net/xuanjiewu/article/details/86065257