Error whit restart mysql

[theprincy]

torino:~# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
torino:~# /usr/share/mysql/debian-start.inc.sh: line 21: MYSQL: unbound variable
/usr/share/mysql/debian-start.inc.sh: line 25: MYSQL: unbound variable


ispcp : 1.0.5 trunk version

[Linkforsoad]

Can you post

line 21 from /usr/share/mysql/debian-start.inc.sh
and
line 25 from /usr/share/mysql/debian-start.inc.sh

here in a reply so we can check the lines?

G,

Simon.

[theprincy]

# Checking for $? is unreliable so the size of the output is checked.
# Some table handlers like HEAP do not support CHECK TABLE.
tempfile=`tempfile`
# We have to use xargs in this case, because a for loop barfs on the
# spaces in the thing to be looped over.
21 LC_ALL=C $MYSQL --skip-column-names --batch -e "
22 SELECT CONCAT('SELECT COUNT(*) INTO @discard FROM \`',
23 TABLE_SCHEMA, '\`.\`', TABLE_NAME, '\`' )
24 FROM information_schema.TABLES WHERE ENGINE='MyISAM'" | \
25 xargs -i $MYSQL --skip-column-names --silent --batch \
26 --force -e "{}" >$tempfile
27 if [ -s $tempfile ]; then
28 (
29 /bin/echo -e "\n" \
30 "Improperly closed tables are also reported if clients are accessing\n" \
31 "the tables *now*. A list of current connections is below.\n";
32 $MYADMIN processlist status
33 ) >> $tempfile

[Linkforsoad]

Hmmm.. It's the same on my server. I only know that he don't know what to do with the variable $MYSQL. Maybe there another person who knows it :-)