RE: How to change default mysql data-dir in Linux server ?
Peter, Thanks for the reply... Infact my.cnf wasn't there when I installed. So I created it... Could you pass me the line to include in my.cnf for changing directory... Unfortunately I couldn't find anything in the web site regarding this... Once again thanks for the reply... -- On Thu, 27 Jun 2002 00:26:06 Peter Lovatt wrote: Search for 'my.cnf' on mysql.com This is the config file that you can use to set the data dr You may need to create it if it doesn't already exist. HTH Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: va ku [mailto:[EMAIL PROTECTED]] Sent: 26 June 2002 20:26 To: [EMAIL PROTECTED] Subject: How to change default mysql data-dir in Linux server ? Hi, I have installed MySQL 4.0 on Linux box using RPM. Everything is working fine, but the database directory is set to /var/lib/mysql. So everytime I create a database it is getting created on /var/lib/mysql. What I would like to have is to create database under /var/lib/mysql/data_dir, where as 'data-dir' stands for database directory. I beliebe I have to change configuration file. How can I do that... where can I find such configuration file for a typical installation. Any help is appreciated... Regards Win a first-class trip to New Orleans and vacation Elvis Style!. Enter NOW! http://r.lycos.com/r/sagel_mail/http://www.elvis.lycos.com/sweepstakes/ - End Forwarded Message - Win a first-class trip to New Orleans and vacation Elvis Style!. Enter NOW! http://r.lycos.com/r/sagel_mail/http://www.elvis.lycos.com/sweepstakes/ - 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 Win a first-class trip to New Orleans and vacation Elvis Style!. Enter NOW! http://r.lycos.com/r/sagel_mail/http://www.elvis.lycos.com/sweepstakes/ - 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
RE: How to change default mysql data-dir in Linux server ?
Peter, Thanks for the reply... Infact my.cnf wasn't there when I installed. So I created it... Could you pass me the line to include in my.cnf for changing directory... Unfortunately I couldn't find anything in the web site regarding this... Once again thanks for the reply... -- On Thu, 27 Jun 2002 00:26:06 Peter Lovatt wrote: Search for 'my.cnf' on mysql.com This is the config file that you can use to set the data dr You may need to create it if it doesn't already exist. HTH Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: va ku [mailto:[EMAIL PROTECTED]] Sent: 26 June 2002 20:26 To: [EMAIL PROTECTED] Subject: How to change default mysql data-dir in Linux server ? Hi, I have installed MySQL 4.0 on Linux box using RPM. Everything is working fine, but the database directory is set to /var/lib/mysql. So everytime I create a database it is getting created on /var/lib/mysql. What I would like to have is to create database under /var/lib/mysql/data_dir, where as 'data-dir' stands for database directory. I beliebe I have to change configuration file. How can I do that... where can I find such configuration file for a typical installation. Any help is appreciated... Regards Win a first-class trip to New Orleans and vacation Elvis Style!. Enter NOW! http://r.lycos.com/r/sagel_mail/http://www.elvis.lycos.com/sweepstakes/ - End Forwarded Message - Win a first-class trip to New Orleans and vacation Elvis Style!. Enter NOW! http://r.lycos.com/r/sagel_mail/http://www.elvis.lycos.com/sweepstakes/ - 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 Win a first-class trip to New Orleans and vacation Elvis Style!. Enter NOW! http://r.lycos.com/r/sagel_mail/http://www.elvis.lycos.com/sweepstakes/ - 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
RE: How to change default mysql data-dir in Linux server ?
got it thank everybody for the help... it is appreciated... -- On Thu, 27 Jun 2002 15:13:31 Peter Lovatt wrote: [mysqld] datadir=/var/lib/mysql tmpdir=/home/mysql_temp HTH Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: va ku [mailto:[EMAIL PROTECTED]] Sent: 27 June 2002 14:19 To: [EMAIL PROTECTED]; Peter Lovatt Subject: RE: How to change default mysql data-dir in Linux server ? Peter, Thanks for the reply... Infact my.cnf wasn't there when I installed. So I created it... Could you pass me the line to include in my.cnf for changing directory... Unfortunately I couldn't find anything in the web site regarding this... Once again thanks for the reply... -- On Thu, 27 Jun 2002 00:26:06 Peter Lovatt wrote: Search for 'my.cnf' on mysql.com This is the config file that you can use to set the data dr You may need to create it if it doesn't already exist. HTH Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: va ku [mailto:[EMAIL PROTECTED]] Sent: 26 June 2002 20:26 To: [EMAIL PROTECTED] Subject: How to change default mysql data-dir in Linux server ? Hi, I have installed MySQL 4.0 on Linux box using RPM. Everything is working fine, but the database directory is set to /var/lib/mysql. So everytime I create a database it is getting created on /var/lib/mysql. What I would like to have is to create database under /var/lib/mysql/data_dir, where as 'data-dir' stands for database directory. I beliebe I have to change configuration file. How can I do that... where can I find such configuration file for a typical installation. Any help is appreciated... Regards Win a first-class trip to New Orleans and vacation Elvis Style!. Enter NOW! http://r.lycos.com/r/sagel_mail/http://www.elvis.lycos.com/sweepstakes/ - End Forwarded Message - Win a first-class trip to New Orleans and vacation Elvis Style!. Enter NOW! http://r.lycos.com/r/sagel_mail/http://www.elvis.lycos.com/sweepstakes/ - 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 Win a first-class trip to New Orleans and vacation Elvis Style!. Enter NOW! http://r.lycos.com/r/sagel_mail/http://www.elvis.lycos.com/sweepstakes/ - 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 Win a first-class trip to New Orleans and vacation Elvis Style!. Enter NOW! http://r.lycos.com/r/sagel_mail/http://www.elvis.lycos.com/sweepstakes/ - 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
How to change default mysql data-dir in Linux server ?
Hi, I have installed MySQL 4.0 on Linux box using RPM. Everything is working fine, but the database directory is set to /var/lib/mysql. So everytime I create a database it is getting created on /var/lib/mysql. What I would like to have is to create database under /var/lib/mysql/data_dir, where as 'data-dir' stands for database directory. I beliebe I have to change configuration file. How can I do that... where can I find such configuration file for a typical installation. Any help is appreciated... Regards Win a first-class trip to New Orleans and vacation Elvis Style!. Enter NOW! http://r.lycos.com/r/sagel_mail/http://www.elvis.lycos.com/sweepstakes/ - End Forwarded Message - Win a first-class trip to New Orleans and vacation Elvis Style!. Enter NOW! http://r.lycos.com/r/sagel_mail/http://www.elvis.lycos.com/sweepstakes/ - 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
Database replication on mirrored servers
Hi, I have installed mysql 4.0 in redhat 7.2 now. I have two such servers with mysql on it and I am now trying to configure them for replication. 1. I could not find my.cnf or my.ini on the box after installing mysql. Won't mysql create those file during installation or do I need to create manually ? Do I need both files ..? 2. I choose to shutdown the master mysql server for replication. When I try to bring it back it says it cannot find mysql.sock in the path. That particular file is not present in the box. How can I get the file ? 3. As I told I have two similar unix box one of which will be main server where the master database is. During failover of Ist server the 2nd server will be taking over Ist servers work additional to second servers work. The 2nd server have slave mysql database. During failover of ist database do I need to make slave database in 2nd server as master..or keep it as slave? How does it work..? Any help will be appreciated Regards _ Communicate with others using Lycos Mail for FREE! http://mail.lycos.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
Help needed ..mysql replication on mirrored servers...
Hi, I will appreciate for any suggesstion on best plan... I am working on setting up a production environment with mirrored servers working on redhat 7.2. To balance the load, each servers have its own primary applications but all of them are mirrored. When the Ist server fails the floating alias name is tranferred to the second server manually. 2nd server then inherits the application running on 1st server. So when failover happeneds the 2nd server should run all the applications. When first server comes back on line ist servers applications are transferred to 1st server back. One of the application is using PHP and MYSQl. I have replicated databases using MYSQL replication such a way that Ist server contains master and 2nd server contains slave. This part is working properly. My question is regarding effect on MYSQL database on failover. I have to design the stratergy for failover. My intention is to keep least work during failover so that people who deal with failover do not need to bothered about database stuff. I can think about two options. When failover happeneds : 1. Make 2nd server database master, so that when 1st server comes on line it will start as slave and update databases. Then I can switch back Ist server to master again like before failover. (Or may be does mysql slave update master... or I can force updation of master again...) 2. Take a back up of 2nd server database and update ist server database when it comes on line again. Which is error prone.. I am just wondering is there any better plan How you guys are doing this...? Any input is appreciated... Regards _ Communicate with others using Lycos Mail for FREE! http://mail.lycos.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
Mysql sockets in redhat 7.2
Hi, I have installed mysql 4.0 in redhat 7.2 now. I have two such servers with mysql on it and I am now trying to configure them for replication. 1. I could not find my.cnf or my.ini on the box after installing mysql. Won't mysql create those file during installation or do I need to create manually ? Do I need both files ..? 2. I choose to shutdown the master mysql server for replication. When I try to bring it back it says it cannot find mysql.sock in the path. That particular file is not present in the box. How can I get the file ? 3. As I told I have two similar unix box one of which will be main server where the master database is. During failover of Ist server the 2nd server will be taking over Ist servers work additional to second servers work. The 2nd server have slave mysql database. During failover of ist database do I need to make slave database in 2nd server as master..or keep it as slave? How does it work..? Any help will be appreciated Regards ___ WIN a first class trip to Hawaii. Live like the King of Rock and Roll on the big Island. Enter Now! http://r.lycos.com/r/sagel_mail/http://www.elvis.lycos.com/sweepstakes - 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
Re: WHERE codition test
Hi, Don't you think you should use select * from test WHERE a=0 ; not select * from test where 0; Isn't the correct usage of WHERE -Original Message- From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 2:00 PM To: Mysql List; Christopher Thompson Subject: RE: WHERE codition test mysql select x.a from test x where 1; 1 evaluates to be true, so this should select all rows. And it does. 5 rows in set (0.00 sec) mysql select * from test where 0; This evaluates to false, so this should not select any rows. And it does. Empty set (0.00 sec) mysql select x.a from test x where x.a; This should select all rows where the a column's value evaluates to true. And it does. 3 rows in set (0.00 sec) The tree cases above is a typical C/C++ behavior, so nothing is wired here. But the next one does not. (Rather it behave like a typical C/C++ fault in handling/checking integrity/consistency of pointers somewhere.) mysql select x.a from test x where 'a'; Empty set (0.00 sec) I'm not quite sure why this doesn't return anything, to tell the truth. Neither I, it seams strange. This value has to be stored in some kind of pointer to an object or char * in the program it self. I would first assume that the content of the pointer is tested, but that cant be true since the content in this case is the number 65. So then you would suspect that they test a pointer instead. But that does not make sence either. Thre pointer should exists, right? But maybe there is something really strange going on with the interpretation of the SQL query insteed? I kind of recognize this situation with the BASIC interpreted built in the system I did work with before. One could build really funny (working) BASIC statement due to that the interpreter went confused with the sysntax sometimes. I don't know how MySQL tokenizes the SQL query, but if it breaks up the token in a certain way, then it is possible that the interpreter finds the string 'a', and then assumes it MUST have an operator, but the operator might then point to NULL, an dthen nobody know what happens after that, except that the end results evaluates to zero. Hmmm... this is indeed interesting to know what really happens, maybe I should download the source code and stepdebug just top see what actually happens. But that has to be a later project... That said, I cannot understand why you'd ever set up a query like these. I did actually try to provoke a 'syntax error' message will all test cases, but they failed. However I learnt something important from this: If an applications programmer does something like this: SELECT whatever FROm a bunch of tables WHERE lots of primary key lookup between tables and a bunch of nested SELECT statements AND Attribute /* and the app programmer took a coffee break here, and ** when returned forgot to add = some hardcoded value */ lots of other junk Since the query compiler does not generates a syntax error here, this might be a source of introducing faults in the system. That's why it is important to know exactly how the system behaves. No I know this, but is there other surprises that I would like to know about? On Tuesday 16 April 2002 11:21 am, Svensson, B.A.T. (HKG) wrote: Basically I am just curious, and I did perform some few small test. But, I was suspecting to get all rows when I did something like WHERE valid string, but had to write something like WHERE NOT valid string which feels a little bit upside down for me considering that integers apart from zero evaluates to true. Also it seams like this is not ISO SQL, so it could be a bit tricky to predict the outcome without actually having some specification of the behavior. //Anders -Original Message- From: Christopher Thompson Sent: Tuesday, April 16, 2002 6:24 PM To: Svensson, B.A.T. (HKG); Mysql List Subject: Re: WHERE codition test I'm not sure what you are asking. Everything is working correctly as far as I can see. See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp - 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
Re: Web based search
Hi, Thanks for the reply. Currently We are using fulltext index search only. What I am looking forward is another effective way of doing it -- On Wed, 10 Apr 2002 15:15:08 Cathy Cunningham (Blue World Lasso Evangelist) wrote: At 1:08 PM -0700 4/10/02, va ku wrote: We are developing a webbased serch application on MYSQL and PHP. I am sure most of you must have already implemented such application. Could you share with me the logic of such application. We were planning to keep a keyword search and my people feel that that will require additional load of keeping track of keyword and they are not interested in that. The other option is fulltext serch on all the data for one table, but concern about of the performance issue. Wondering how you guys are doing out there ? Which is the best way ? Any suggesstion appreciated . We need some more details to provide meaningful assistance. That having been said, if you're going to be doing a project with massive amounts of text and want to provide full text searching capabilities, definitely take a look at MySQL v4 which provides some great enhancements along the lines of full text indexing/searching. Indexing is purportedly 100x faster and full text searching is purportedly 2x faster. There's also a wealth of new search operators planned (I don't know yet it they're implemented) which help with defining the search. HTH CC -- - Cathy Cunningham [EMAIL PROTECTED] Lasso Evangelist Blue World Communications, Inc. http://www.blueworld.com/ - Lasso Studio is the easiest way to create a database-driven Web site - Macworld Magazine See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp - 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
MYSQL 4.0 Beta
Hi, We want to use only MYSQL4.0 for our production database. Please let us know when the Beta release is scheduled. Regards See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp - 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
Beta release of MYSQL4.0
Hi, We want to use only MYSQL4.0 for our production database. Please let us know when the Beta release is scheduled. Regards See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp - 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
Web based search
Hi, We are developing a webbased serch application on MYSQL and PHP. I am sure most of you must have already implemented such application. Could you share with me the logic of such application. We were planning to keep a keyword search and my people feel that that will require additional load of keeping track of keyword and they are not interested in that. The other option is fulltext serch on all the data for one table, but concern about of the performance issue. Wondering how you guys are doing out there ? Which is the best way ? Any suggesstion appreciated . See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp - 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
mysql
mysql See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp - 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
Reg MYSQL and JAVA
Hi, I don't know is this is the correct form. I am looking for some help in developing report on Java. I am using MYSQL and Java for development. I need to generate a formatted output which contains values from database, some paragraphs etc. I am expecting a report in 'doc' or 'rtf' or 'pdf' format. Can you suggest any free software for this purpose. Regards See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp - 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
Re: Reg MYSQL and JAVA
Hi, Thanks for the reply. I also need few 'doc' features such as 1. Bold letters 2. Formatted paragraphs The document I want to take a report is a student declaration form where on top it will display student details in the middle the declaration and at the end Signature. The document consists of predefined declaration with bold and italics, Big text size etc Any help is appreciated ? Regards -- On Mon, 8 Apr 2002 11:55:23 Christopher Thompson wrote: On Monday 08 April 2002 11:22 am, va ku wrote: I don't know is this is the correct form. Not really. I am looking for some help in developing report on Java. I am using MYSQL and Java for development. I need to generate a formatted output which contains values from database, some paragraphs etc. I am expecting a report in 'doc' or 'rtf' or 'pdf' format. Can you suggest any free software for this purpose. You will basically not be able to create any output in doc format, partly because it isn't a standard and partly because it isn't open. That said, you could easily use Java and MySQL to query a database and present the output in some format, such as comma-delimited. You wouldn't need anything other than Java and MySQL to do this. See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp - 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