'MySQL' Thread RSS Feed

MySQL

Tue, 06 Dec 2005 03:11:24 -0700

Hi Experts and Developers,

I am just starting out on using MySQL and dbExpress in Delphi. Since I have been developing Database applications using BDE in Delphi I have always kept my database [tables] in a subdirectory of my application directory.

My question is: Is it possible to still use the same layout for my new projects using MySQL or does MySQL impose a restriction on the location of the database. I have noted there is a data subdirectory in MySQL home directory that houses all databases. I would still wish to keep my databases in my project directory outside MySQL!

Re: MySQL

Tue, 06 Dec 2005 04:09:32 -0700

This message was edited by zibadian at 2005-12-6 4:10:48

: Hi Experts and Developers,
:
: I am just starting out on using MySQL and dbExpress in Delphi. Since I have been developing Database applications using BDE in Delphi I have always kept my database [tables] in a subdirectory of my application directory.
:
: My question is: Is it possible to still use the same layout for my new projects using MySQL or does MySQL impose a restriction on the location of the database. I have noted there is a data subdirectory in MySQL home directory that houses all databases. I would still wish to keep my databases in my project directory outside MySQL!
:
This website might help: http://dev.mysql.com/doc/refman/5.0/en/windows-create-option-file.html

I found it using the search terms: "mysql "data directory"" in google.

MySQL: "mysql "data directory""

Wed, 07 Dec 2005 09:39:48 -0700

Hi,

Thanks a lot for the prompt reply. Am reading it right now.

MySQL Database path

Wed, 07 Dec 2005 09:52:42 -0700

Hi,

I read the article but still I haven't been satisfied with the proposed solution. All databases are still kept under the MySQL data directory while I would like to specify the path to my database that is outside the normal data directory under MySQL. My data directory will be under my project directory for example: C:\CodeBase\HotelMan\Data. Is it possible for me to access a database using dbExpress and Mysql that is located outside MySQL?

Re: MySQL Database path

Thu, 08 Dec 2005 00:36:26 -0700

: Hi,
:
: I read the article but still I haven't been satisfied with the proposed solution. All databases are still kept under the MySQL data directory while I would like to specify the path to my database that is outside the normal data directory under MySQL. My data directory will be under my project directory for example: C:\CodeBase\HotelMan\Data. Is it possible for me to access a database using dbExpress and Mysql that is located outside MySQL?
:
In the option file place this line:

# set datadir to the location of your data directory
datadir=C:\CodeBase\HotelMan\Data

as described in the article.
Or you could create a batch file, which launches your MySQL server with the --datadir option (also in the article).
As far as I can tell from reading the article this will tell MySQL to look for the data in the specified directory.

MySQL Database path

Thu, 08 Dec 2005 02:58:43 -0700

Hi,

My point is that different projects will have their databases in different locations! These different locations may be scattered on the drive(filesystem) and not necessarily under a single parent directory.

Re: MySQL Database path

Fri, 09 Dec 2005 02:45:08 -0700

: Hi,
:
: My point is that different projects will have their databases in different locations! These different locations may be scattered on the drive(filesystem) and not necessarily under a single parent directory.
:
This is beyond my knowledge. Perhaps you have more success on the MySQL messageboard, because it is not really a Delphi problem as more a MySQL problem.

MySQL Database path

Fri, 09 Dec 2005 09:08:54 -0700

Hi,

Thanks a lot. I'll try my luck.