Re: Changing the mysql data directory - Shamit Verma - com.mysql.lists.win32

7 messages in com.mysql.lists.win32Re: Changing the mysql data directory

From	Sent On	Attachments
Michael Klucher	06 Feb 2003 09:23
Public Folder: MySQL	07 Feb 2003 16:33
Loren McDonald	07 Feb 2003 22:06
Gerald R. Jensen	08 Feb 2003 07:36
Riaan Stander	10 Feb 2003 06:10
Paul DuBois	10 Feb 2003 20:25
Shamit Verma	12 Feb 2003 03:48

Subject:	Re: Changing the mysql data directory
From:	Shamit Verma (mys...@vshamit.com)
Date:	02/12/2003 03:48:42 AM
List:	com.mysql.lists.win32

You can use command line parameters for specifying data directory. You may specify the TCP port as well. You may run a new instance of server with the desired data dir and non-conflicting port if you do not want to disturb existing my sql server.

-b and -h command line options are used for specifying base directory and home directory respectively.

-shamit

At 16:10 +0200 2/10/03, Riaan Stander wrote:

Hi there

Does any of you know if it is possible to change the mysql data directory without restarting mysql & without changing the my.ini file.

No.

My app uses the mysql library to communicate, but I want it to use a specific directory as its data directory, without affecting any other apps using mysql.

Maybe you should run multiple servers and have this app use the second server?

Thanks Riaan Stander