by David Harper <devnull@[EMAIL PROTECTED]
>
Mar 30, 2008 at 06:42 AM
Arne Vajhøj wrote:
> Mr. X. wrote:
>> ... I meant :
>> Where is physically the database file exists,
>> and how can any external program with simple connection string connect
>> to the specific db ?
>
> For MyISAM tables you get:
> MySQL data dir / database name / table name . MYD for data
> MySQL data dir / database name / table name . MYI for indexes
The command
show variables like 'datadir';
will display the location of the MyISAM data directory.
> For InnoDB tables the data get stored in the data file you define
> in the MySQL config file.
The command
show variables like 'innodb_data_home_dir';
will display the name of the directory which contains the InnoDB
tablespace files.
David Harper
Cambridge, England
