Automating mysql backup and uploading to GDrive

Comments

• andreipoe Member

  August 2017

  You could use rclone to upload to GDrive from your bash script.

  Thanked by 2alilet raindog308
• irm Member

  August 2017 edited August 2017

  https://github.com/prasmussen/gdrive

  works flawlessly. i run backups with it using a cronjob/bash script (maybe not the best but it works).

  https://pastebin.com/ULeezPAf

  Thanked by 4Ramsterdam alilet Dormeo JohnMiller92
• WSS Member

  August 2017 edited August 2017

  Use ~ ~ ~ between stanzas or < p r e >

  For what it's worth, you can easily pipe the dump into gzip if you're not going to bother checking return codes, and moving/sync is kind of, well, OK, sure. Still not checking return codes.

  if [ $? -ne 0 ]; then
    OH FUCK DECIDE WHAT TO DO
  else
    OH SHIT IT WORKED.
  fi
  
• imok Member

  August 2017

  Pastebin is not loading for me, I can't see the @irm code.

  In case it's a different one, I'm using this to backup my Confluence instance:

  #!/bin/bash
  
  # This is a script to take a MySQL dump and upload to Google Drive.
  # Uses gdrive https://github.com/prasmussen/gdrive. See the gdrive readme first.
  
  # The path to the gdrive binary
  GDRIVE_BIN=/usr/sbin/gdrive
  
  # Use "gdrive list" to get the id of the directory where you want to upload the files
  BACKUP_DRIVE_DIR=
  
  # Set your MySQL password. You can also use a config fille https://dev.mysql.com/doc/refman/5.7/en/password-security-user.html
  MYSQL_PASS=
  
  # The directory where your data is stored
  DATA_DIR=/home/confluence
  
  # The directory where the generated backup will be stored
  BACKUP_DEST_DIR=/home/backup/confluence/`date +%Y%m%d-%H%M%S`
  
  # The database you want to backup
  DATABASE_NAME=confluence
  DATABASE_USER=confluence
  
  echo "Backup from dir: $DATA_DIR"
  echo "Backup to dir: $BACKUP_DEST_DIR"
  echo "Google Drive Directory ID: $BACKUP_DRIVE_DIR"
  
  rm -rf $DATA_DIR/temp/*
  mkdir -p $BACKUP_DEST_DIR
  
  mysqldump -u $DATABASE_USER -p"$MYSQL_PASS" $DATABASE_NAME | gzip > $BACKUP_DEST_DIR/db-confluence-`date +%Y%m%d-%H%M%S`.sql.gz
  echo "MySQL backup completed"
  
  tar -cjvf $BACKUP_DEST_DIR/data-confluence-`date +%Y%m%d-%H%M%S`.bzip $DATA_DIR > $BACKUP_DEST_DIR/homedir.status
  echo "Confluence data backup completed"
  
  echo "Sending to Google Drive"
  $GDRIVE_BIN upload -r -p $BACKUP_DRIVE_DIR $BACKUP_DEST_DIR
  
  echo "Done."
  

  Thanked by 3alilet RUGWOO WebProject
• jaden Member

  August 2017 edited August 2017

  You could use automysqlbackup and rclone.
• redalertrox Member

  August 2017

  bash + GDrive/rclone
• codezed Member

  October 2020

  Here's code for free backup service for your database and storage/minio
  https://github.com/negati-ve/docker-rclone-google-drive-cron-backup
• Pilzbaum Member

  October 2020 edited October 2020

  To quote a member of this forum @codezed

  @angstrom said:
  Congrats on your first comment

  Thanked by 1angstrom
• angstrom Moderator

  October 2020 edited October 2020

  @Pilzbaum said:
  To quote a member of this forum @codezed

  @angstrom said:
  Congrats on your first comment

  He's just another necro-poster trying to draw attention to something that he threw onto GitHub some hours before

  Thanked by 2lentro Pilzbaum