What is AutoMysqlBackup
AutoMySQLBackup with a basic configuration will create Daily, Weekly and Monthly backups of one or more of your MySQL databases from one or more of your MySQL servers.
How to install AutoMySQLBackup on Ubuntu
1 2 3 |
sudo apt-get install automysqlbackup |
Tool backup file to Google Drive
We use gdrive tool by prasmussen on github.com
1 2 3 |
https://github.com/prasmussen/gdrive |
How to push AutoMysqlBackup files to Google Drive with cronjob
0. Download gdrive tool for 64bit
1 2 3 4 |
wget https://drive.google.com/uc?id=0B3X9GlR6Embnb095MGxEYmJhY2c -O /usr/local/bin/gdrive chmod 755 /usr/local/bin/gdrive |
1. Get access-key from Google Drive
run gdrive command and open the url to get verification code
1 2 3 4 5 6 7 8 |
gdrive Go to the following link in your browser: https://accounts.google.com/o/oauth2/auth?client_id=367116221053-7n0vf5akeru7on6o2fjinrecpdoe99eg.apps.googleusercontent.com&redirect_uri=urn%3Aietf%3Awg%3Aoauth%3A2.0%3Aoob&response_type=code&scope=https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fdrive&state=state Enter verification code: 4/IW2XFXswSDRSDFSDvSXesSeIjScmsoHVJecpMoqS2GY |
2. Set backup file to Google Drive on cronjob
1 2 3 4 5 |
crontab -e 0 3 * * * /usr/local/bin/gdrive upload --file /var/lib/automysqlbackup >/dev/null 2>&1 |
Reff
+ Google
+ Timothy-quinn