MySQL clear query cache via commandline

mysqlclearcache

#!/bin/bash

# Created by: Josue Rodriguez <[email protected]> (c) 2010.

# Clear MySQL Cache
# Download file into directory "/usr/bin" then run "sudo chmod +x /usr/bin/mysqlclearcache"

mysql_options=$1

if [ "$mysql_options" == "--help" ]; then
	
	echo -e "\nUsage: mysqlclearcache [OPTIONS]\n"
	echo -e "- options are same as when you use the regular 'mysql' command."
	echo -e "- example: mysqlclearcache -uroot -p ....\n"

else

	mysql $mysql_options -e "RESET QUERY CACHE" && echo -e "\nMySQL Cache Query Cleared\n"

fi