Re: What are basic db files MySQL creates?

2002-12-06 Thread Roger Baklund
* Will Standley > Question: > > When I create a new db using MySQL... > > What files does MySQL create? None. It creates a new directory only. When you create a table, and the used table handler is MyIsam, three new files are created: *.frm, *.MYI (index) and *.MYD (data). If the table handler is

Re: What are basic db files MySQL creates?

2002-12-06 Thread Stefan Hinz, iConnect \(Berlin\)
To: <[EMAIL PROTECTED]> Sent: Friday, December 06, 2002 6:01 AM Subject: What are basic db files MySQL creates? > Question: > > When I create a new db using MySQL... > > What files does MySQL create? > > I'm asking because a MySQL sample db was created on the machi

re: What are basic db files MySQL creates?

2002-12-06 Thread Victoria Reznichenko
Will, Friday, December 06, 2002, 7:01:47 AM, you wrote: WS> When I create a new db using MySQL... WS> What files does MySQL create? MySQL create the directory with database name in the MySQL data dir. WS> I'm asking because a MySQL sample db was created on the machine I am using WS> and they do

RE: What are basic db files MySQL creates?

2002-12-06 Thread Will Standley
Roger, Are the files that you mentioned stored in the directory for the db ? thanks for the help, Will -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED]] Sent: Friday, December 06, 2002 6:31 AM To: [EMAIL PROTECTED] Cc: Will Standley Subject: Re: What are basic db files

What are basic db files MySQL creates?

2002-12-05 Thread Will Standley
Question: When I create a new db using MySQL... What files does MySQL create? I'm asking because a MySQL sample db was created on the machine I am using and they don't seem to be where I think they should be... and I want to search for them... (I looked in root/var/lib/mysql/ and didn't see the