+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: Error whit restart mysql (/thread-10647.html)
Error whit restart mysql - theprincy - 05-10-2010 06:09 AM
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
RE: Error whit restart mysql - Linkforsoad - 05-10-2010 06:33 AM
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.
RE: Error whit restart mysql - theprincy - 05-10-2010 06:55 AM
# 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
RE: Error whit restart mysql - Linkforsoad - 05-10-2010 07:21 AM
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 :-)