MySQL backup script uploads mysqldump files to Google Drive .
- Python 2.6 or greater.
pippython package management tool.- A Google account with Google Drive enabled.
git clone [email protected]:KasunDon/google-drive-mysql-backup.git /opt/google-drive-mysql-backup
cd /opt/google-drive-mysql-backup
pip install -r requirements.txt
Also we need creating OAuth keys to access Google Drive API. Please use following steps,
- Sign into Google Developers Console and create or select a project in the Google Developers Console.
- Enable Google Drive API under API Section.
- Go to credentials.
- Go to OAuth consent screen tab. Select an Email address, enter a Product name and other information.
- Go to Credentials tab, click the Create credentials button and select OAuth client ID.
- Select the application type Other and set application name.
- Download credential as a JSON file
- Place downloaded credential file as
config/client_secret.json.
MySQL connection details should also added to config/mysql-config.json
When running backup service for first time it should be authorised with Google API's. There are two ways to authorise backup service.
-
Brower based authorisation, following command will launch up browser window for authorisation
python backup_initiator.py -
Server-side authorisation, following command will show up a URL for manual authorisation. Copy the URL from the console and manually open it in your browser.Once authorised verfication code should be added.
python backup_initiator.py --noauth_local_webserver
Use following command to list help options.
python backup_initiator.py -h
If you need specific file name prefix for backup files use following command.
python backup_initiator.py --backup-file-name "myblog_mysql-backup"