On Monday, March 07, 2005 22:19, digvijoy chatterjee wrote: > I have Mysql 4.1.9 on RHES-3.0 installed by rpms..the default socket > path and database creation directory is /var/lib/mysql....now there > is a a dearth of space in /var therefore i would like to move the > database files to something like /usr which has lots of free space , > creating Symlinks does not seem to help.....what is the way out
If you are moving all of the databases you can do the following: -Shutdown mysql -Move the that database files from /var/lib/mysql to /my/new/path -Edit /etc/my.cnf - change datadir=/var/lib/mysql to datadir=/my/new/path -Start mysql Here is some info on symbolic links and databases from the manual: http://dev.mysql.com/doc/mysql/en/symbolic-links-to-databases.html -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]