Shell Programming and Scripting

I am trying to run this code from script.

Code:

mysqladmin -u root --password='******' --socket=/tmp/mysql.sock drop ROAD_HAULAGE_TEMP

Though it does what i want it asks for me to click 'y' then enter. This is not appropriate because i want it to run from cron. Can i get mysqladmin to drop a database without the need for the prompt? Or should i be using expect here?

---------- Post updated at 05:10 AM ---------- Previous update was at 05:02 AM ----------

duh sorry to waste your time. man mysqladmin showed me that using -f switch is what i was looking for

try :

yes | mysqladmin -u root --password='******' --socket=/tmp/mysql.sock drop ROAD_HAULAGE_TEMP

This should work