Yes, you have to move the mysql and test databases - only one directory
for all files.

Shut down mysqld
Modify the my.cnf
Move the data files 
Start up mysqld

You might want to check the /etc/init.d/mysqld file - the path is hard
coded there.

-----Original Message-----
From: Patrick Fowler [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 05, 2004 4:08 PM
To: [EMAIL PROTECTED]
Subject: database dir change


Folks,
 
I want to change the database dir to a new dir.  When I change the
my.cnf and add [mysqld] datadir=\data
 
Do I have to do anyting to the  mysql and test databases?  This is a
fresh install rpm install.
 

Patrick Fowler 
Unix Admin/database Admin 
Wynit, Inc. 
6847 Ellicott Drive 
East Syracuse, NY 13057 
V (315)437-1086 x2172 
F (315)437-0432 

 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to