A knowledge sharing repository of AdSpeed, our popular commercial ad serving solution.
5 comments
Thanks dude,just saved me some time :)Marcel
ehm, just try:echo "show tables;" |mysql $DBNAME --skip-column-names
or you can do it in one line -- like this:mysql database -e "show tables;" | awk '{print "optimize table database." $1}' | xargs -n 1 mysql -e
Mr.test's script works but missing some quotes...mysql database -e "show tables;" | awk '{print "\"optimize table database." $1 "\""}' | xargs -n 1 mysql -e
just try:mysqlcheck --optimize -Athat should do the job as well, and a bit less code :P
Post a Comment
5 Comments:
Thanks dude,
just saved me some time :)
Marcel
ehm, just try:
echo "show tables;" |mysql $DBNAME --skip-column-names
or you can do it in one line -- like this:
mysql database -e "show tables;" | awk '{print "optimize table database." $1}' | xargs -n 1 mysql -e
Mr.test's script works but missing some quotes...
mysql database -e "show tables;" | awk '{print "\"optimize table database." $1 "\""}' | xargs -n 1 mysql -e
just try:
mysqlcheck --optimize -A
that should do the job as well, and a bit less code :P
Post a Comment
Home