Last week, we had the author of TDD for a Shopping Website LiveProject. Friday at 11am Ranch time, Steven Solomon will be hosting a live TDD session just for us. See for the agenda and registration link
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Frits Walraven
Bartenders:
  • Piet Souris
  • Himai Minh

Using MySQL for work and Cattledrive at same time?

 
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?
 
Sheriff
Posts: 9109
12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Marshal
Posts: 27211
87
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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...)
 
arch rival
Posts: 2813
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 9109
12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
incandescent light gives off an efficient form of heat. You must be THIS smart to ride this ride. Tiny ad:
Free, earth friendly heat - from the CodeRanch trailboss
https://www.kickstarter.com/projects/paulwheaton/free-heat
reply
    Bookmark Topic Watch Topic
  • New Topic