(newbie) how can I regenerate the data/mysql tables?

2002-03-18 Thread Richard Trahan
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

Re: (newbie) how can I regenerate the data/mysql tables?

2002-03-18 Thread Doug Thompson
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

Re: (newbie) how can I regenerate the data/mysql tables?

2002-03-18 Thread Richard Trahan
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

RE: (newbie) how can I regenerate the data/mysql tables?

2002-03-18 Thread Stephano Mariani
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

Re: (newbie) how can I regenerate the data/mysql tables?

2002-03-18 Thread Richard Trahan
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

Re: (newbie) how can I regenerate the data/mysql tables?

2002-03-18 Thread Joel Rees
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

Re: (newbie) how can I regenerate the data/mysql tables?

2002-03-18 Thread Joel Rees
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