====== Kodi DB Backup ======

The XBMC Backup addon does not back up the mysql database, so this script should be used:

<code - dbbackup.sh>
#!/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"
</code>

Make script executable:
<code>
chmod 755 /home/kodi/dbbackup.sh
</code>

Either add it to crontab to execute it at a particular time like 1am each day:
<code>
crontab -e
</code>
add add
<code>
0 1 * * * /home/kodi/dbbackup.sh
</code>

or add it to daily crontab as root:
<code>
echo "#!/bin/sh" > /etc/cron.daily/kodi-db-backup
echo "/home/kodi/dbbackup.sh" >> /etc/cron.daily/kodi-db-backup
chmod 755 /etc/cron.daily/kodi-db-backup
</code>