enter into /etc/my.cnf or ~/.my.cnf
datadir=/mnt/data/mysql
login to mysql and do
SHOW VARIABLES LIKE '%data%'
That should do it.
Best regards
Nils Valentin Tokyo/Japan
On Fri, 30 May 2003 15:06:35 +0200, Jean Christophe <[EMAIL PROTECTED]> wrote:
Hi,
I have mysql running on a redhat-9. (rpm files)
I tried to change the datadir from /etc/my.conf without succes.
What do I have to do to change the directory of my databases from /var/lib/mysql (default) to /mnt/data/mysql ?
is the fact that /mnt/data a vfat partition a problem (if it is, I can make it to a ext3 !)
Thank's
;-)
Jean Christophe
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]