shutdown mysql, move all the files in your current data directory to the new location

in your my.cnf file (ie. unix: /etc/my.cnf)

[mysqld]
datadir=/my

-------
all data files are in /my

- hcir

On Friday, January 3, 2003, at 07:56 AM, aman raheja wrote:

Hi All
Right now I have all my MySQL database files getting stored in
/var/lib/mysql/
If I want to change that to another location, say, /home/mysql or something
else, how do I do it?

---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to