Originally posted by Matt Fry:
I have MySQL (GUI version) installed on my machine at work. I am developing an application in Visual Basic that eventually will replace a production app and it uses MySQL. I don't want to "mess up" the work database (it's not in production now). The app I'm developing begins by taking a MySQL dump from another database (from a Linux version of MySQL) and drops all existing tables and then rebuilds them with the dump.
Can all of this coexist together?
I'm not familiar with the GUI version, but mySQL can handle more than one database at a time. From what you say here, it sounds like you drop all the tables within one database. So as long as you create a different database for this project, it shouldn't be a problem.