(1)、备份数据库部分表到本地文件夹
echo off
rm -rf ~/develop/task/tmp/summary.sql
/usr/local/mysql/bin/mysqldump -uroot -proot123456 uni_app --skip-comments --skip-add-locks --no-tablespaces --skip-disable-keys > ~/develop/task/tmp/summary.sql
echo on
命令解释:
先删除summary.sql文件,然后生成summary.sql
上面批处理文件名称为sql.sh
(2)、mac添加定时任务
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
<key>Label</key>
<string>com.mx.sql.plist</string>
<key>ProgramArguments</key>
<array>
<string>/Users/bluestar/develop/task/sql.sh</string>
</array>
<key>KeepAlive</key>
<true/>
<key>RunAtLoad</key>
<true/>
<key>StartInterval</key>
<integer>60</integer>
<key>StandardErrorPath</key>
<string>/Users/bluestar/develop/task/tmp/sql.err</string>
<key>StandardOutPath</key>
<string>/Users/bluestar/develop/task/tmp/sql.out</string>
</dict>
</plist>
命令解释:
上面文件名称为com.mx.sql.plist
路径和权限报错:sudo chown root /Library/LaunchAgents/com.mx.sql.plist
定时备份sql服务开启命令:launchctl load ~/develop/task/com.mx.sql.plist
定时备份sql服务关闭命令:launchctl unload ~/develop/task/com.mx.sql.plist
(3)、备份到网盘:
开通百度云盘会员
百度云盘定时备份工作空间
(4)、执行导入数据sql报错
错误:MySQL server has gone away
// 导入文件1000M大小文件
set global max_allowed_packet=1024*1024*1000;