Differences

This shows you the differences between two versions of the page.

--- kodi:kodi-dbbackup [2020/08/15 23:55] – config:kodi-dbbackup renamed to kodi:kodi-dbbackup Wuff
+++ kodi:kodi-dbbackup [2023/05/29 11:55] (current) – external edit 127.0.0.1
@@ Line 16: / Line 16: @@
 # Get music database number
-MUSIC_DB=$(mysql -u $KODIUSER -p$KODIPASS -e "Show databases;" | grep "MyMusic")
+MUSIC_DB=$(mysql -u $KODIUSER -p$KODIPASS -e "Show databases;" 2>/dev/null | grep "MyMusic")
-MUSIC_DB=${MUSIC_DB:7}
+for DB in $MUSIC_DB
-echo "Exporting database 'MyMusic"$MUSIC_DB"'."
+do
-mysqldump -u $KODIUSER -a -c -h localhost --password="$KODIPASS" MyMusic$MUSIC_DB --databases | bzip2 -z9 > $BACKUPDIR/Music.$MUSIC_DB.$DATE.sql.bz2
+    #DBSHORT=${DB:7}
-echo "Music database exported.";
+    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;" | grep "MyVideos")
+VIDEO_DB=$(mysql -u $KODIUSER -p$KODIPASS -e "Show databases;" 2>/dev/null | grep "MyVideos")
-VIDEO_DB=${VIDEO_DB:8}
+#VIDEO_DB=${VIDEO_DB:8}
-echo "Exporting database 'MyVideos"$VIDEO_DB"'"
+for DB in $VIDEO_DB
-mysqldump -u $KODIUSER -a -c -h localhost --password="$KODIPASS" --databases MyVideos$VIDEO_DB | bzip2 -z9 > $BACKUPDIR/Videos.$VIDEO_DB.$DATE.sql.bz2
+do
-echo "Video database exported."
+    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."