Template:MySQLdump Linux - Revision history

Klojum at 08:24, 28 November 2022

2022-11-28T08:24:07Z

← Older revision		Revision as of 08:24, 28 November 2022
Line 11:		Line 11:

	# TESTED ON UBUNTU DESKTOP 21.10 with MYSQL SERVER 5.7.36 ON UBUNTU SERVER 18.04		# TESTED ON UBUNTU DESKTOP 21.10 with MYSQL SERVER 5.7.36 ON UBUNTU SERVER 18.04
			# TESTED ON UBUNTU SERVER 22.04 with MYSQL SERVER 8.0.31 LOCALLY

	timestamp=$(date +"%Y%m%d_%H%M");		timestamp=$(date +"%Y%m%d_%H%M");

Klojum at 09:49, 26 January 2022

2022-01-26T09:49:32Z

← Older revision		Revision as of 09:49, 26 January 2022
Line 78:		Line 78:
	# EXIT		# EXIT
	</syntaxhighlight>		</syntaxhighlight>


	~~'''IMPORTING DATABASE EXPORT FILES'''~~

	~~<syntaxhighlight lang="bash" inline> mysqldump -u-p < exportfile.sql </syntaxhighlight>~~

Klojum at 22:42, 25 January 2022

2022-01-25T22:42:32Z

← Older revision		Revision as of 22:42, 25 January 2022
Line 1:		Line 1:
	Using MySQLdump in Linux is also possible, and is typically provided along with the mysql/mariadb-server installation. This is a script that can be used either manually or be hung into time-repetitive cron jobs. Log files are created with filenames that have a timestamp built-in, so older backups will not be overwritten.		Using MySQLdump in Linux is also possible, and is typically provided along with the mysql/mariadb-server installation. This is a script that can be used either manually or be hung into time-repetitive cron jobs. 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 .sh (bash) file into the location+filename of your chosing, and make the file executable with <syntaxhighlight lang="bash" inline>chmod +x yourfilename.sh</syntaxhighlight>		Copy the script below into your favorite text-editor and save it as a .sh (bash) file into the location+filename of your chosing, and make the file executable with <syntaxhighlight lang="bash" inline>chmod +x yourfilename.sh</syntaxhighlight>. You can export database contents for the Kodi video library, music library, and the database user for the Kodi application. You can do so separately or combined with all three parameters at the same time.

	You can export database contents for the Kodi video library, music library, and the database user for the Kodi application. You can do so separately or combined with all three parameters at the same time.

	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">

Klojum at 22:41, 25 January 2022

2022-01-25T22:41:50Z

← Older revision		Revision as of 22:41, 25 January 2022
Line 1:		Line 1:
	Using MySQLdump in Linux is also possible, and is typically provided along with the mysql/mariadb-server installation.		Using MySQLdump in Linux is also possible, and is typically provided along with the mysql/mariadb-server installation. This is a script that can be used either manually or be hung into time-repetitive cron jobs. 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 .sh (bash) file into the location+filename of your chosing, and make the file executable with <syntaxhighlight lang="bash" inline>chmod +x yourfilename.sh</syntaxhighlight>
	This is a script that can be used either manually or be hung into time-repetitive cron jobs. 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 .sh (bash) file into the location+filename of your chosing, and make the file executable with:
	<syntaxhighlight lang="bash" inline>chmod +x yourfilename.sh</syntaxhighlight>

	You can export database contents for the Kodi video library, music library, and the database user for the Kodi application. You can do so separately or combined with all three parameters at the same time.		You can export database contents for the Kodi video library, music library, and the database user for the Kodi application. You can do so separately or combined with all three parameters at the same time.

Klojum at 14:55, 25 January 2022

2022-01-25T14:55:20Z

← Older revision		Revision as of 14:55, 25 January 2022
Line 84:		Line 84:
	# EXIT		# EXIT
	</syntaxhighlight>		</syntaxhighlight>


			'''IMPORTING DATABASE EXPORT FILES'''

			<syntaxhighlight lang="bash" inline> mysqldump -u-p < exportfile.sql </syntaxhighlight>

Klojum at 14:40, 25 January 2022

2022-01-25T14:40:48Z

← Older revision		Revision as of 14:40, 25 January 2022
Line 1:		Line 1:
	Using MySQLdump in Linux is also ~~available~~, and is ~~tpyically~~ provided along with the mysql/mariadb-server installation.		Using MySQLdump in Linux is also possible, and is typically provided along with the mysql/mariadb-server installation.

	This is a script that can be used either manually or be hung into time-repetitive cron jobs. Log files are created with filenames that have a timestamp built-in, so older backups will not be overwritten.		This is a script that can be used either manually or be hung into time-repetitive cron jobs. Log files are created with filenames that have a timestamp built-in, so older backups will not be overwritten.

Klojum: Created page with "Using MySQLdump in Linux is also available, and is tpyically provided along with the mysql/mariadb-server installation. This is a script that can be used either manually or b..."

2022-01-25T14:36:19Z

Created page with "Using MySQLdump in Linux is also available, and is tpyically provided along with the mysql/mariadb-server installation. This is a script that can be used either manually or b..."

New page

Using MySQLdump in Linux is also available, and is tpyically provided along with the mysql/mariadb-server installation.

This is a script that can be used either manually or be hung into time-repetitive cron jobs. 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 .sh (bash) file into the location+filename of your chosing, and make the file executable with:
<syntaxhighlight lang="bash" inline>chmod +x yourfilename.sh</syntaxhighlight>

You can export database contents for the Kodi video library, music library, and the database user for the Kodi application. You can do so separately or combined with all three parameters at the same time.

<syntaxhighlight lang="bash">
#!/usr/bin/env bash
#set -x # enable in case of trouble

echo ' '
echo 'MYSQLDUMP databases Kodi v19+ video & music'
echo '-------------------------------------------'

# TESTED ON UBUNTU DESKTOP 21.10 with MYSQL SERVER 5.7.36 ON UBUNTU SERVER 18.04

timestamp=$(date +"%Y%m%d_%H%M");

# EXPORT PATH, ADJUST TO YOUR OWN CONVENIENCE
path="/home/user/Dropbox/MySQL/kodidtbs_v19_""$timestamp""_"

# FILENAMES
video_export="$path""video.sql"
music_export="$path""music.sql"
user_export="$path""user.sql"

# USER PARAMETERS TO EDIT ACCORDING TO YOUR DATABASE SERVER, CREDENTIALS AND PORT SITUATION
user=" --user=kodi --password=kodi"
srvr=" --host=srvr1 "
port=" --port=3306 "

# FIXED PARAMETERS FOR KODI DATABASES
params=" --add-drop-database --add-drop-table --add-drop-trigger --routines --triggers "

# VARIABLE PARAMETERS FOR KODI DATABASES
video=" --databases MyVideos119 "
music=" --databases MyMusic82 "

# ---------------------------------------------------------------------------------------

# CHECK IF USER-GIVEN PARAMETERS ARE PRESENT
if [ $# -gt 0 ]; then
echo ' ';
# LOOP THROUGH PARAMETERS GIVEN
while test $# -gt 0
do
case "$1" in
v|video|all)
echo "Exporting video to : ""$video_export";
mysqldump $user $srvr $params $video > $video_export
;;
m|music|all)
echo "Exporting music to : ""$music_export";
mysqldump $user $srvr $params $music > $music_export
;;
u|user|all)
params="--databases mysql --tables user --skip-add-drop-table --no-create-info"
echo "Exporting user to : ""$user_export";
mysqldump $user $srvr $params --where="User='kodi'" > $user_export
;;
esac
# NEXT VARIABLE
shift
done
echo ' ';
else
echo 'EXAMPLE: ./dtbs-export 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

# EXIT
</syntaxhighlight>