(newbie) how can I regenerate the data/mysql tables?
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
Re: (newbie) how can I regenerate the data/mysql tables?
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
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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: (newbie) how can I regenerate the data/mysql tables?
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
Re: (newbie) how can I regenerate the data/mysql tables?
Stephano Mariani wrote: Use symbolic links :) Actually, that's a good idea; it does let me put my table data somewhere else, but it's my fault that I didn't reveal my secret motivation in my original post. I have a general backup scheme which backs up everything in a set of directories containing important data, which typically does not include program code that I can reinstall, like MySQL. Hence the separation of the MySQL stuff from my database. If I use symbolic links and stick to my backup scheme, I will risk destruction of my table and index structures, and whatever else may be in the mysql database. I have been able to reach a compromise solution by copying the entire mysql\data tree to another location, which allowed me to run mysqld --datadir, whereupon I merely deleted databases I didn't want from the new location. It still seems desirable to have a utility to create a fresh mysql database. - 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
Re: (newbie) how can I regenerate the data/mysql tables?
Richard Trahan responded: Stephano Mariani wrote: Use symbolic links :) Actually, that's a good idea; it does let me put my table data somewhere else, but it's my fault that I didn't reveal my secret motivation in my original post. I have a general backup scheme which backs up everything in a set of directories containing important data, which typically does not include program code that I can reinstall, like MySQL. Hence the separation of the MySQL stuff from my database. Ehhhtto. You're using windows, right? Have you checked in your php.ini file? This is mentioned in the manual, where it describes the install process. I have my data directories on a different drive, no problems. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - 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
Re: (newbie) how can I regenerate the data/mysql tables?
Some airhead wrote: Ehhhtto. You're using windows, right? Have you checked in your php.ini file? I think that airhead must have meant the my.ini file. Or the my.cnf file. :^, PS: The MySQL Reference Manual, section 2.1.2.2 for MSWindows and section 4.1.2 in general. Airhead Alps Giken Kansai Systems Develoment Suita, Osaka - 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