#!/bin/bash
KODIUSER="kodi"
KODIPASS="kodi"
BACKUPDIR="/home/kodi/.kodi/userdata/Database/dbbackup"
BACKUPKEEPDAYS=7
DATE=`/bin/date +%Y%m%d-%H%M`

echo "Beginning Kodi database backup."
echo "Creating backup directory."
mkdir -p $BACKUPDIR

# Get music database number
MUSIC_DB=$(mysql -u $KODIUSER -p$KODIPASS -e "Show databases;" 2>/dev/null | grep "MyMusic")
for DB in $MUSIC_DB
do
    #DBSHORT=${DB:7}
    echo "Exporting database '"$DB"'."
    mysqldump -u $KODIUSER -a -c -h localhost --password="$KODIPASS" $DB --databases 2>/dev/null | bzip2 -z9 > "$BACKUPDIR/Music."$DB"."$DATE".sql.bz2"
    echo "Music database exported.";
done

# Get video database number
VIDEO_DB=$(mysql -u $KODIUSER -p$KODIPASS -e "Show databases;" 2>/dev/null | grep "MyVideos")
#VIDEO_DB=${VIDEO_DB:8}
for DB in $VIDEO_DB
do
    echo "Exporting database '"$DB"'"
    mysqldump -u $KODIUSER -a -c -h localhost --password="$KODIPASS" --databases $DB 2>/dev/null | bzip2 -z9 > "$BACKUPDIR/Videos."$DB"."$DATE".sql.bz2"
    echo "Video database exported."
done

echo "Kodi backup finished."

# Cleanup
echo "Deleting backups older than $BACKUPKEEPDAYS days"
find $BACKUPDIR/* -mtime +$BACKUPKEEPDAYS -exec rm {} \;
echo "Done"