Re: Creating a database with MySQLTcl
From: Lord Floyd (nospam_at_biteme.invalid)
Date: 02/11/05
- Next message: wai shun au: "clock scan"
- Previous message: Bruce Hartweg: "Re: question on funny behaviour of binary scan"
- In reply to: Helmut Giese: "Re: Creating a database with MySQLTcl"
- Next in thread: Helmut Giese: "Re: Creating a database with MySQLTcl"
- Reply: Helmut Giese: "Re: Creating a database with MySQLTcl"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Fri, 11 Feb 2005 16:53:52 GMT
hgiese@ratiosoft.com (Helmut Giese) sputtered incoherently in
news:420b81a2.929703@News.Individual.DE:
> Now, this "system database": What's this? I never heard the term
> before (but then I was never doing database stuff before,
> either).
>
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, local install of
MySQL, TCL 8.4.x, mysqltcl 3.01 and WinXP Pro. YMMV --
You are a fluke of the Universe
You have no right to be here
And whether you can hear it or not,
the Universe is laughing behind your back
"Five-eleven's your height, one-ninety your weight
You cash in your chips around page ninety-eight."
- Next message: wai shun au: "clock scan"
- Previous message: Bruce Hartweg: "Re: question on funny behaviour of binary scan"
- In reply to: Helmut Giese: "Re: Creating a database with MySQLTcl"
- Next in thread: Helmut Giese: "Re: Creating a database with MySQLTcl"
- Reply: Helmut Giese: "Re: Creating a database with MySQLTcl"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
