dcsimg
www.webdeveloper.com
Results 1 to 3 of 3

Thread: Newbie in MYSQL

  1. #1
    Join Date
    Apr 2006
    Posts
    13

    Newbie in MYSQL

    I m a newbie in MYSQL.Would somebody pls tell me the following questions-

    1. WHich is my original database after creating a Database(e.g. Student) in MySql .I mean in MSAcces DB I can find a .mdb file which is to be used.But in MySql which file to use. (If I create a database named- Student).Would I have to use the whole SQL folder including all files for a single DB.

    2. I want to use that DB in MYSQL with JAVA. Which should be the driver String for MySQL.
    I am new pls help me.
    Edit/Delete Message

  2. #2
    Join Date
    Aug 2005
    Location
    The Garden State
    Posts
    5,634
    You don't connect to a file the way you did in access, you connect to a server using TCP/IP.

    Maybe this article from our sister site would help you?
    http://www.developer.com/java/data/article.php/3417381

  3. #3
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    19,637
    1. Normally you don't need (or really want) to concern yourself with what files MySQL creates and uses for your database tables. If you need to copy, move, or otherwise replicate data, you should be using MySQL's built-in utilities for that, rather than messing directly with the files. All that being said, you should find the databases stored under your MySQL directory, probably in a directory called "data". Under that will be directories for each database, which will contain a number of files for each table.

    2. I'm not a Java expert, but you might want to start here: http://dev.mysql.com/usingmysql/java/
    "Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
    ~ Terry Pratchett in Nation

    eBookworm.us

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles