mysql path

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 ?

<http://dev.mysql.com/doc/refman/6.0/en/installation-layouts.html>
> The installation directory has the following subdirectories:
> data | Log files, databases

mysql.com is a good source for information about MySQL.

--
Lew
 >> Stay informed about: mysql path 

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

For InnoDB tables the data get stored in the data file you define
in the MySQL config file.

Arne
 >> Stay informed about: mysql path 

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
 >> Stay informed about: mysql path