Re: change mysql data directory - Rajeev Rumale - com.mysql.lists.win32

4 messages in com.mysql.lists.win32Re: change mysql data directory

From	Sent On	Attachments
Rodney Green	10 Jun 2002 16:18
Rodney Green	10 Jun 2002 17:14
Jim McAtee	10 Jun 2002 17:24
Rajeev Rumale	10 Jun 2002 19:11

Subject:	Re: change mysql data directory
From:	Rajeev Rumale (raj...@myangel.com)
Date:	06/10/2002 07:11:17 PM
List:	com.mysql.lists.win32

This is an interesting question. I have some more doubts regarding the same. Refering to http://www.mysql.com/doc/C/R/CREATE_DATABASE.html

Since MYSQL allows us to create multiple databases, I wonder if we can specify sperate data directories when we create database.

Refering to the Create syntax http://www.mysql.com/doc/C/R/CREATE_TABLE.html We can infact specify a absolute directory path for each table.

I wonder if we can set the base data directory path for the database itself then we need not define the path for each table we create later.

regards

Rajeev

______________________________________________________________________ Only as high as we reach can we grow, Only as far as we seek can we grow, Only as deep as we Question can we know, Only as much as we dream,can we grow.

Add something like the following to my.ini, then stop and restart the service:

[mysqld] basedir=C:/mysql datadir=D:/data

----- Original Message ----- From: "Rodney Green" <rea...@stny.rr.com> To: "Correale, Ernest" <ecor...@Halkey-Roberts.com> Cc: <win...@lists.mysql.com> Sent: Monday, June 10, 2002 6:14 PM Subject: Re: change mysql data directory

Thanks for replying. All I find in the my.ini file is the two lines

below.

did a search on the hard drives and there is only one my.ini file and it only contains these two lines. What should I do next?

[WinMySQLAdmin] Server=C:/mysql/bin/mysqld-nt.exe

----- Original Message ----- From: "Correale, Ernest" <ecor...@Halkey-Roberts.com> To: "'Rodney Green '" <rea...@stny.rr.com> Sent: Monday, June 10, 2002 8:01 PM Subject: RE: change mysql data directory

Shut the database down, move the data directory to its new location, then edit the data path in the my.ini file to reflect the new location,

start

the

database.

You may want to do the restart from the command line to check for errors.

Hello. Is it possible to change the data directory for mysql without having to re-install? I have a few databases on a drive that hasn't much room and would like to move the data directory to another drive which has more space. How would one do this?