A knowledge sharing repository of AdSpeed, our popular commercial ad serving solution
3 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
Post a Comment
3 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
Post a Comment
Home