This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Re: Can not drop MySQL DB when uninstall
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Mar 23, 2010
10:52 PM
Can not drop MySQL DB when uninstall
Hi everybody!
When install, i create MySQL DB by SQL Scripts in Installscript MSI, it's done well.
When Uninstall/remove, i want to drop DB. I too use SQL scripts, SQL Script file ran OK but DB was not Droped.
My SQL Script file: "DROP DATABASE IF EXISTS DBname"
I try another script when uninstall such as: "Create table". It's done well.
I don't know, installshield can drop DB ?
Pls, help me?
When install, i create MySQL DB by SQL Scripts in Installscript MSI, it's done well.
When Uninstall/remove, i want to drop DB. I too use SQL scripts, SQL Script file ran OK but DB was not Droped.
My SQL Script file: "DROP DATABASE IF EXISTS DBname"
I try another script when uninstall such as: "Create table". It's done well.
I don't know, installshield can drop DB ?
Pls, help me?
(3) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Mar 25, 2010
02:10 AM
Make sure that the target database is not in use when you try to delete it. The case usually happens when your SQL script is associated with a connection targeting that database.
Hope that helps.
Hope that helps.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Mar 25, 2010
02:26 AM
I think that my DB is not accessed, but how to check that.
Could you tell me?
Could you tell me?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Mar 25, 2010
07:03 AM
Change the associated connection to connect to other database than one that you are trying to delete, or add the "USE MySQL" statement before your DROP DATATBASE statement, and see if it solves your issue.