MySQL database selection

[stevew]

Hi, I am trying to run a MySQL script using the installAware plug in and i am getting "ERROR" returned. I believe I have two problems. My script is creating tables, but I never say the database name to create. How does installAware know the database name to execute against? Under SQL Server I see there is a Database parameter, but not for MySQL.
Secondly, is there any place i can find any more detailed diagnostic as to why my script is not succeeding? My script is very old and solid so i know it is not any syntax error, just likely a connection error, but I am unsure how to troubleshoot the details.

[MichaelNesmith]

Hi Steve,

I believe the database is specified in the script...is this not the case?

[stevew]

Wow! You have recieved my award for the fastest response ever ... 2 minutes ... just enough time to read my message and post a reply.

Your comment was what i was thinking too. So i added a line at the top of my script "USE mydatabase". This caused the failure. Now that it is a new day and i reviewed my script i notice it should end with a semicolon, as "USE mydatabase;". Now it works great and i wonder why I ever had a problem.