Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Using MySQL for work and Cattledrive at same time?

 
Matt Fry
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Marilyn de Queiroz
Sheriff
Posts: 9066
12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Matt Fry
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the reply, Marilyn!

So for JDBC assignment 1, can I just create the database, tables, etc using the GUI tools? The version I have has a "Command Line Client" I could use also although I've only used the GUI.
 
Paul Clapham
Sheriff
Posts: 21298
32
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Don't confuse the management client you use with the database. They are different things. No matter whether you use a GUI or a command line to manage things, the database is still the same. There's no "GUI version" of MySQL.

I have a MySQL database that I created and I am certain that I didn't type things at the command line to create tables. So I must have used a GUI to do it. (It's been a few years...)
 
Marcus Green
arch rival
Rancher
Posts: 2813
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
As Paul says, the GUI is just a convenience front end that effectively generates the command line to manipulate the database. You can access an MySQL database directly from Access via ODBC. But hey, wha's all this talk of the devils own programming toy Visual Basic?
 
Matt Fry
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the advice Paul and Marcus. As far as the GUI stuff goes, I was more concerned with the JDBC-1 assignment. I understand the difference between the "management interface" and the actual database. But it seems that the version of MySQL I have installed doesn't work exactly like the instructions in the assignment list. I just assumed that that's what the command line client I mentioned was for and wanted to make sure I was doing everything correctly per the assignment list.
[ December 10, 2006: Message edited by: Matt Fry ]
 
Marilyn de Queiroz
Sheriff
Posts: 9066
12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think I might see what the command line can do for you since the assignments are set up using the mySQL command line. Once your database and your tables are set up, the rest is handled more or less automagically using jdbc. But I would recommend getting familiar with the command line because there are situations where a gui is unavailable and it helps to have that experience under your belt.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic