Repair the session table of a Joomla database table.

jdbsession

#!/bin/sh

# jdbsession -- Repair the session table of a Joomla database table.
#
# This scripts supports Joomla versions 1.0 - 3.3
#
# Copyright 2014 Rene Kreijveld - [email protected]
#
# This program is free software; you may redistribute it and/or modify it.
#
# Warning! This script needs the file joomlafunctions. This has to be installed in the same directory as this script.
#

# General variables
VERSION=2.0

# Determine path of script
MYPATH=$( cd $(dirname $0) ; pwd -P )

# Include general functions
. ${MYPATH}/joomlafunctions

echo "jdbsession verion ${VERSION}, written by Rene Kreijveld"
echo "This is a Joomla! $versr.$versd site. Running session table repair..."

# Repair the session table
if mysqlcheck --user=${dbuser} --password=${password} --repair ${database} ${prefix}session ; then
	exit 0
else
	echo "Error repairing table."
	exit 1
fi