>>>>> "DAVE" == DAVE THOMAS <DAVET@stripped> writes:
DAVE> I am trying to create a file in the directory that the .frm, .MYI, and .MYD
DAVE> files are located for a particular table. I can create the file by
DAVE> hard-coding the path and specifying a filename but I need to be able to
DAVE> create the file in the folder of the database the table belongs to. How do I
DAVE> get the path that the database files are located? and the database name?
Why would you ever need to store a file in the database directory?
Normally this should not be done as this hampers MySQL ability to
To do this, you must know the database name yourself.
You can get the base of the MySQL data directory with
'mysqladmin variables | grep datadir'
You can get the name of all databases with 'mysqlshow'
To know the directory, just concatenate the data directory with the