wood burning stoves 2.0*
The moose likes Cattle Drive and the fly likes Using MySQL for work and Cattledrive at same time? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » This Site » Cattle Drive
Bookmark "Using MySQL for work and Cattledrive at same time?" Watch "Using MySQL for work and Cattledrive at same time?" New topic
Author

Using MySQL for work and Cattledrive at same time?

Matt Fry
Ranch Hand

Joined: Mar 06, 2006
Posts: 60
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

Joined: Jul 22, 2000
Posts: 9044
    
  10
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.


JavaBeginnersFaq
"Yesterday is history, tomorrow is a mystery, and today is a gift; that's why they call it the present." Eleanor Roosevelt
Matt Fry
Ranch Hand

Joined: Mar 06, 2006
Posts: 60
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
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

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

Joined: Sep 14, 1999
Posts: 2813
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?


SCWCD: Online Course, 50,000+ words and 200+ questions
http://www.examulator.com/moodle/course/view.php?id=5&topic=all
Matt Fry
Ranch Hand

Joined: Mar 06, 2006
Posts: 60
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

Joined: Jul 22, 2000
Posts: 9044
    
  10
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Using MySQL for work and Cattledrive at same time?