Re: What are basic db files MySQL creates?

* 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?

Dear Will, > When I create a new db using MySQL... > What files does MySQL create? CREATE DATABASE mynewone will create a directory called "mynewone" in the MySQL datadir. You can check where this is by issuing "SHOW VARIABLES LIKE 'datadir'" on the SQL command line. HTH! -- Stefan Hinz <[EMAI

re: What are basic db files MySQL creates?

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?

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