Thanks a lot,

But another problem. I did the changes in my.cnf and restarted mysql. It
stops immediately, shows the following:

Starting mysqld daemon with databases from /base1
010613 14:22:38  mysqld ended

But when I changed the 'datadir' values in the my.cnf back to the default
directory, it works fine. 

Any idea what the problem is?

- Suvarsha


On Wed, 13 Jun 2001, Gabriele Bartolini wrote:

> Ciao!
> 
> >I am new to both Linux and MySQL. I used the source to
> >compile MySQL on Linux 7.0 with the default options.
> >It's working fine.
> 
> What's Linux 7.0? :-)
> 
> >But can i change the data directory where all the
> >databases are stored to something other than the
> >default, without having to compile again?
> 
> Well, you could use a symbolic link, if you don't wanna compile it. 
> Otherwise, which is better and wiser, just put this line in the /etc/my.cnf 
> file.
> 
> [mysqld]
> datadir=/usr/local/mysql/var
> 
> Obviously, change the path! ;-)
> 
> Ciao
> -Gabriele
> 
> -------------------------------------------------
> Gabriele Bartolini - Computer Programmer
> U.O. Rete Civica - Comune di Prato
> Prato - Italia - Europa
> e-mail: [EMAIL PROTECTED]
> http://www.po-net.prato.it
> -------------------------------------------------
> A "Supernova" is the celestial
> equivalent of "rm -rf /*" with
> root permissions.
> -------------------------------------------------
> 
> 
> ---------------------------------------------------------------------
> 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
> 


---------------------------------------------------------------------
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