See the following example:
mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | iff | | mysql | | test | | tt | | tt3 | +--------------------+ 6 rows in set (0.02 sec) mysql> show global variables like 'datadir'; +---------------+----------------------------------------+ | Variable_name | Value | +---------------+----------------------------------------+ | datadir | c:\mysql-noinstall-5.0.51b-win32\data\ | +---------------+----------------------------------------+ 1 row in set (0.00 sec)
What’s the path of the tt3 db-directory?
a) c:\data\ b) c:\mysql-noinstall-5.0.51b-win32\data c) c:\mysql-noinstall-5.0.51b-win32\data\mysql\tt3 d) c:\mysql-noinstall-5.0.51b-win32\data\tt3
[ MySQL Architecture (10%) - How MySQL uses Disk Space ]
d
The database directories are below the data-directory.