mysql path

Thread view:

Mr. X. - 29 Mar 2008 23:11 GMT

Hello.

If I create a new schema on mysql :
Which folder is the schema created,
and how external program "know" where the schema is ?

Is there any general attitude, that I should know exactly where is the db
file exists ?
What is on connection string ?
(Not always there is on connection string the full path !).

Thanks :)

Reply to this Message

Mr. X. - 29 Mar 2008 23:20 GMT

... I meant :
Where is physically the database file exists,
and how can any external program with simple connection string connect to
the specific db ?

Thanks :)

Reply to this Message

Lew - 30 Mar 2008 00:09 GMT

> ... 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.

Signature

Lew

Reply to this Message

Arne Vajhøj - 30 Mar 2008 00:15 GMT

> ... 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

Reply to this Message

David Harper - 30 Mar 2008 07:41 GMT

>> ... I meant :
>> Where is physically the database file exists,
[quoted text clipped - 4 lines]
> 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

Reply to this Message

mysql path

Free Magazines