The directory space in which mysqld places the data is capable of containing multiple databases (related groups of tables) and tables (related groupings of data) up to the physical limits of your computer system.
The "mysql database" contains the tables that hold information concerning user privileges. I agree that it's mostly irrelevant on a win98 system, but the relevance is a function of the OS and not mysql. You should not add tables to the mysql database. For the installation default, the Test database is available for adding tables such as the ones you name. You can also create your own databases with the simple sql command: CREATE DATABASE databasename and populate them with any related tables you want. Perhaps you have misunderstood how mysql organizes everything and you are wanting to do something that you don't need to do. Otherwise, I don't know if win98 is capable of hosting multiple instances of mysql which, AFAIK, is what is necessary to accomplish your objective. Regards, Doug On Mon, 18 Mar 2002 16:41:56 -0800, Richard Trahan wrote: >I'm running 3.23.43 on Windows 98. I've done the default binary >installation, which created the mysql and test databases in >c:\mysql\data, and I've added the menagerie and other sample databases >to it. I would like to leave that structure in place but create another >database somewhere else. I can't find a way to recreate the >mysql\data\mysql tables at the new location, without which mysqld will >not run, regardless of any command line options or my.cnf settings. I >could save the current c:\mysql\data directory structure and re-run >the installation, then copy mysql\data\mysql to the new location, but >that seems rather bad form. I can't simply copy the mysql table db >because it contains irrelevant data. There should be a way to create >a new db directory structure. > >Any help, please. --------------------------------------------------------------------- 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