Current time: 11-23-2024, 12:53 PM Hello There, Guest! (LoginRegister)


Post Reply 
Error whit restart mysql
Author Message
theprincy Offline
Member
***

Posts: 311
Joined: Nov 2008
Reputation: 2
Post: #3
RE: Error whit restart mysql
# 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
05-10-2010 06:55 AM
Visit this user's website Find all posts by this user Quote this message in a reply
Post Reply 


Messages In This Thread
Error whit restart mysql - theprincy - 05-10-2010, 06:09 AM
RE: Error whit restart mysql - Linkforsoad - 05-10-2010, 06:33 AM
RE: Error whit restart mysql - theprincy - 05-10-2010 06:55 AM
RE: Error whit restart mysql - Linkforsoad - 05-10-2010, 07:21 AM

Forum Jump:


User(s) browsing this thread: 2 Guest(s)