Use symbolic links :) > -----Original Message----- > From: Richard Trahan [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 19 March 2002 3:13 AM > To: [EMAIL PROTECTED] > Subject: Re: (newbie) how can I regenerate the data/mysql tables? > > 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 <mysql-unsubscribe- > [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--------------------------------------------------------------------- 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
