Re: mysql path
- From: David Harper <devnull@xxxxxxxxxxxxxxxxxxx>
- Date: Sun, 30 Mar 2008 06:42:29 GMT
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
.
- References:
- mysql path
- From: Mr. X.
- Re: mysql path
- From: Mr. X.
- Re: mysql path
- From: Arne Vajhøj
- mysql path
- Prev by Date: Re: missing SET keyword
- Next by Date: JDBC
- Previous by thread: Re: mysql path
- Next by thread: JDBC
- Index(es):
Relevant Pages
|
|
