Re: Default data dir
I get that point but is there any other way we can change the path . Thanks Niranjan --- Jeff Kilbride <[EMAIL PROTECTED]> wrote: > You can relocate an entire database with a symbolic > link: > > ln -s /path/to/database/files > /var/lib/mysql/database_name > > --jeff > > - Original Message - > From: "Niranjan Patel" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, October 14, 2002 10:50 AM > Subject: Default data dir > > > > Hello > > > > In my case Default data files directory is > > /var/lib/mysql. I want to store all files of one > > database in another directory. > > > > Is there a way we can specify data directory per > > database. Or else can we change the entire data > > directoy of mysql. > > I tried to change it using my.cnf but I guess i > missed > > something. can someone point me to exact steps > > > > Thanks > > Niranjan > > > > > > __ > > Do you Yahoo!? > > Faith Hill - Exclusive Performances, Videos & More > > http://faith.yahoo.com > > > > > - > > 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 > __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.yahoo.com - 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
Default data dir
Hello In my case Default data files directory is /var/lib/mysql. I want to store all files of one database in another directory. Is there a way we can specify data directory per database. Or else can we change the entire data directoy of mysql. I tried to change it using my.cnf but I guess i missed something. can someone point me to exact steps Thanks Niranjan __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.yahoo.com - 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
Error during make for mysql 3.23.45
Hello everybody, I am getting the following error during make of mysql 3.23.45 on solaris 2.5. Anybody has an idea please reply Thanks, Niranjan ake[1]: Entering directory `/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45' Making all in include make[2]: Entering directory `/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45/include' make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45/include' Making all in Docs make[2]: Entering directory `/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45/Docs' make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45/Docs' Making all in readline make[2]: Entering directory `/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45/readline' make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45/readline' Making all in libmysql make[2]: Entering directory `/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45/libmysql' make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45/libmysql' Making all in client make[2]: Entering directory `/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45/client' c++ -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I.. -I..-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_RWLOCK_T -DSOLARIS -c mysql.cc cc1plus: Invalid option `-fno-exceptions' cc1plus: Invalid option `-fno-rtti' In file included from client_priv.h:19, from mysql.cc:28: ./../include/global.h:680: warning: abstract declarator used as declaration In file included from mysql.cc:49: /usr/include/term.h:1043: warning: ANSI C++ forbids declaration `SGTTYS' with no type or storage class /usr/include/term.h:1043: parse error before `,' make[2]: *** [mysql.o] Error 1 make[2]: Leaving directory `/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45' make: *** [all-recursive-am] Error 2 __ Yahoo! - We Remember 9-11: A tribute to the more than 3,000 lives lost http://dir.remember.yahoo.com/tribute - 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
Error while installing
Hello Everybody, I am tring to install MYsql 3.23 on Solaris 2.5.1 AS there is no binary available . I have downloaded the source code and compiling . I am running gcc 2.6 I am getting the following error (as below) while compiling. Any help is appreciated. I checked the line 126 in file mf_tempfile.c I was not able to find anything. #> Hence do we have to do gcc above a certain version. #> Also do we have a binary for installing mysql as a user other than root in my directory structure. Thanks Niranjan ** make all-recursive make[1]: Entering directory `/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.52' Making all in include make[2]: Entering directory `/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.52/include' make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.52/include' Making all in Docs make[2]: Entering directory `/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.52/Docs' make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.52/Docs' Making all in readline make[2]: Entering directory `/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.52/readline' make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.52/readline' Making all in libmysql make[2]: Entering directory `/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.52/libmysql' /bin/sh ../libtool --mode=compile gcc -DDEFAULT_CHARSET_HOME="\"/homes/woprf/n/niranjan/mysql\"" -DDATADIR="\"/homes/woprf/n/niranjan/mysql/var\"" -DSHAREDIR="\"/homes/woprf/n/niranjan/mysql/share/mysql\"" -DUNDEF_THREADS_HACK -DDONT_USE_RAID -I./../include -I../include -I./.. -I.. -I..-O3 -DDBUG_OFF -DHAVE_BROKEN_GETPASS -DSOLARIS -DHAVE_RWLOCK_T -c mf_tempfile.c rm -f .libs/mf_tempfile.lo gcc -DDEFAULT_CHARSET_HOME=\"/homes/woprf/n/niranjan/mysql\" -DDATADIR=\"/homes/woprf/n/niranjan/mysql/var\" -DSHAREDIR=\"/homes/woprf/n/niranjan/mysql/share/mysql\" -DUNDEF_THREADS_HACK -DDONT_USE_RAID -I./../include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -DHAVE_BROKEN_GETPASS -DSOLARIS -DHAVE_RWLOCK_T -c mf_tempfile.c -fPIC -DPIC -o .libs/mf_tempfile.lo mf_tempfile.c:126: unterminated string or character constant make[2]: *** [mf_tempfile.lo] Error 1 make[2]: Leaving directory `/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.52/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.52' make: *** [all-recursive-am] Error 2 __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com - 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