Re: Creating a database with MySQLTcl

From: Helmut Giese (hgiese_at_ratiosoft.com)
Date: 02/11/05

  • Next message: Carlos Crosetti: "iWidgets, tclodbc and ActiveTcl compiler"
    Date: Fri, 11 Feb 2005 21:57:18 GMT
    
    

    On Fri, 11 Feb 2005 16:53:52 GMT, Lord Floyd <nospam@biteme.invalid>
    wrote:

    >MySQL uses the database mysql as it's system database. Depending
    >upon the install the database folder will be located under
    >\..\..\data\mysql.
    >
    >If you are using the tcl/mysql connector from
    >http://www.xdobry.de/mysqltcl/, then there shouldn't be a problem.
    >
    >Connecting to a db server doesn't require a database name, ie
    >"set db [::mysql::connect -host server -user aname -password
    >passwd]", works just fine. If you are connecting to the local
    >server, the server parameter can be omitted. The usual caveats
    >about permissions apply, see MySQL docs for info...
    >
    >Once connected ::mysql::exec $db "create database dbName", should
    >work just fine. To connect to the newly created db just use the
    >::mysql::use $db dbName.
    >
    >FWIW - all of the above worked okay for me
    Magic, it worked for me, too. Looking at it, it appears rather obvious
    and straight forward now - why didn't I think of something as easy as
    this :)

    Thanks for the info and best regards
    Helmut Giese


  • Next message: Carlos Crosetti: "iWidgets, tclodbc and ActiveTcl compiler"