Template:MySQLdump Windows: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
mNo edit summary |
||
Line 12: | Line 12: | ||
REM TESTED ON WINDOWS 11 Pro with MYSQL SERVER 5.7.36 ON UBUNTU SERVER 18.04 | REM TESTED ON WINDOWS 11 Pro with MYSQL SERVER 5.7.36 ON UBUNTU SERVER 18.04 | ||
SET A/ timestamp = | REM SET FORMATTED TIMESTAMP | ||
SET A/ timestamp=%date:~0,2%_%time:~0,2%_%time:~3,2%_%time:~6,2% | |||
REM EXPORT PATH, ADJUST TO YOUR OWN CONVENIENCE | REM EXPORT PATH, ADJUST TO YOUR OWN CONVENIENCE | ||
SET A/ ="/home/user/Dropbox/MySQL/kodidtbs_v19_"" | SET A/ path="/home/user/Dropbox/MySQL/kodidtbs_v19_""%timestamp%""_" | ||
REM FILENAMES | REM FILENAMES | ||
SET A/ video_export = %path% + "video.sql" | SET A/ video_export=%path% + "video.sql" | ||
SET A/ music_export = %path% + "music.sql" | SET A/ music_export=%path% + "music.sql" | ||
SET A/ user_export | SET A/ user_export =%path% + "user.sql" | ||
REM USER PARAMETERS TO EDIT ACCORDING TO YOUR DATABASE SERVER, CREDENTIALS AND PORT SITUATION | REM USER PARAMETERS TO EDIT ACCORDING TO YOUR DATABASE SERVER, CREDENTIALS AND PORT SITUATION | ||
SET A/ user = " --user=kodi --password=kodi" | SET A/ user=" --user=kodi --password=kodi" | ||
SET A/ srvr = " --host=srvr1 " | SET A/ srvr=" --host=srvr1 " | ||
SET A/ port = " --port=3306 " | SET A/ port=" --port=3306 " | ||
REM FIXED PARAMETERS FOR KODI DATABASES | REM FIXED PARAMETERS FOR KODI DATABASES | ||
SET A/ params = " --add-drop-database --add-drop-table --add-drop-trigger --routines --triggers " | SET A/ params=" --add-drop-database --add-drop-table --add-drop-trigger --routines --triggers " | ||
REM VARIABLE PARAMETERS FOR KODI DATABASES | REM VARIABLE PARAMETERS FOR KODI DATABASES | ||
SET A/ video = " --databases MyVideos119 " | SET A/ video=" --databases MyVideos119 " | ||
SET A/ music = " --databases MyMusic82 " | SET A/ music=" --databases MyMusic82 " | ||
REM --------------------------------------------------------------------------------------- | REM --------------------------------------------------------------------------------------- | ||
Line 39: | Line 40: | ||
for %%x in (%*) do ( | for %%x in (%*) do ( | ||
REM CHECK FOR VIDEO | REM CHECK FOR VIDEO | ||
if (%%x == "v") OR (%%x == "video") echo "Exporting video to : | if (%%x == "v") OR (%%x == "video") echo "Exporting video to : %video_export%"; mysqldump %user% %srvr% %params% %video% > %video_export% | ||
if (%%x == "m") OR (%%x == "music") echo "Exporting music to : | if (%%x == "m") OR (%%x == "music") echo "Exporting music to : %music_export%"; mysqldump %user% %srvr% %params% %music% > %music_export% | ||
if (%%x == "u") OR (%%x == "user") echo "Exporting user to : " | if (%%x == "u") OR (%%x == "user") echo "Exporting user to : "%$user_export%; mysqldump %user% %srvr% %params% --where="User='kodi'" > %user_export% | ||
) | ) | ||
Line 60: | Line 61: | ||
REM EXIT | REM EXIT | ||
</syntaxhighlight > | </syntaxhighlight > |
Revision as of 23:00, 25 January 2022
MySQLdump script for Windows OSes using MySQLdump is possible, and the tool is typically provided along with the mysql/mariadb-server installation. This is a script that can be used either manually or be hung into a time-repetitive scheduler. Log files are created with filenames that have a timestamp built-in, so older backups will not be overwritten. Copy the script below into your favorite text-editor and save it as a .bat (batch) file into the location+filename of your choosing. You can export database contents for the Kodi video library, music library, and the database user for the Kodi application.
cls @echo off echo " " echo "MYSQLDUMP databases Kodi v19+ video & music" echo "-------------------------------------------" REM TESTED ON WINDOWS 11 Pro with MYSQL SERVER 5.7.36 ON UBUNTU SERVER 18.04 REM SET FORMATTED TIMESTAMP SET A/ timestamp=%date:~0,2%_%time:~0,2%_%time:~3,2%_%time:~6,2% REM EXPORT PATH, ADJUST TO YOUR OWN CONVENIENCE SET A/ path="/home/user/Dropbox/MySQL/kodidtbs_v19_""%timestamp%""_" REM FILENAMES SET A/ video_export=%path% + "video.sql" SET A/ music_export=%path% + "music.sql" SET A/ user_export =%path% + "user.sql" REM USER PARAMETERS TO EDIT ACCORDING TO YOUR DATABASE SERVER, CREDENTIALS AND PORT SITUATION SET A/ user=" --user=kodi --password=kodi" SET A/ srvr=" --host=srvr1 " SET A/ port=" --port=3306 " REM FIXED PARAMETERS FOR KODI DATABASES SET A/ params=" --add-drop-database --add-drop-table --add-drop-trigger --routines --triggers " REM VARIABLE PARAMETERS FOR KODI DATABASES SET A/ video=" --databases MyVideos119 " SET A/ music=" --databases MyMusic82 " REM --------------------------------------------------------------------------------------- REM CHECK IF USER-GIVEN ARGUMENTS ARE PRESENT for %%x in (%*) do ( REM CHECK FOR VIDEO if (%%x == "v") OR (%%x == "video") echo "Exporting video to : %video_export%"; mysqldump %user% %srvr% %params% %video% > %video_export% if (%%x == "m") OR (%%x == "music") echo "Exporting music to : %music_export%"; mysqldump %user% %srvr% %params% %music% > %music_export% if (%%x == "u") OR (%%x == "user") echo "Exporting user to : "%$user_export%; mysqldump %user% %srvr% %params% --where="User='kodi'" > %user_export% ) if (%%x ='') echo "EXAMPLE: dtbs-export.bat video "; echo " "; echo "Possible user parameters:"; echo " v or video"; echo " m or music"; echo " u or user"; echo " all"; echo " "; echo "Note: for importing full Kodi database exports, you need SQL database root user access"; echo ""; echo "For a complete guide, type: 'mysqldump --help' or 'man mysqldump' "; echo " "; fi REM EXIT