Page 1 of 1

MySQL database selection

Posted: Sun Aug 13, 2006 1:02 pm
by 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.

Posted: Sun Aug 13, 2006 1:04 pm
by MichaelNesmith
Hi Steve,

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

Posted: Sun Aug 13, 2006 1:28 pm
by 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.