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