Doug Thompson wrote:
(snip)>
> Perhaps you have misunderstood how mysql organizes everything and you are wanting to
>do something that you don't need
> to do.
I haven't misunderstood anything, I think. I know how to create
additional databases with CREATE DATABASE. My problem is that I want
to create additional databases at a place other than c:\mysql\data,
such as by using commands like:
mysqld --datadir=c:/mydocs/data
mysql create ...
The above will refuse to run because there is no "mysql database"
at that location; I discovered this through experimentation. Nor
will this do anything:
mysqladmin --datadir=c:/mydocs/data create mydb
or any variant thereof.
So I want to create a "mysql database" at the new location; i.e.,
I want something like c:/mydocs/data/mysql/<mysql tables>, and I
want some mysql process to do it, not by some brute force technique
like copying the distribution files (which I know will work).
Let's put it another way. Suppose the default binary installation
did not create a c:\mysql\data directory structure, i.e., there
was no "mysql database". How would I go about creating one? I
claim there is no way to do this, or at least there is no discernible
documentation on it. You can't do CREATE DATABASE because neither
mysqld nor mysql will run unless the "mysql database" exists, and
that is what I'm trying to do.
Thanks for your reponse.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
