mysql-max 3.23.41 beta
Hello all, I had installed mysql-max 3.23.41 beta some time back. Now I was trying to get the binary , but cannot find it anywhere! Also, if I use the stable 3.23.41 do I make some installation etc. changes? Any advice will be greatly appreciated. Thanks, Sheena. - 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: cannot get mysqld to start
HMM. Now I dont know why I always failed to get mysql up with the 'right' command... I am looking into setting my root password right now But please tell me if I am doing something wrong by running just safe_mysqld instead of with the parameters... Thanks, Sheena. -Original Message- From: Dana Powers [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 12:19 PM To: Sheena Sidhu; Mysql (E-mail) Subject: Re: cannot get mysqld to start Quoteth the install guide: shell> cd mysql_installation_directory shell> ./bin/mysql_install_db shell> ./bin/safe_mysqld --user=mysql & This is always the way to start a fresh mysql install. Note that safe_mysqld gets the --user arg ( and is run in the background with & ). Also remember to set your root password! Check the manual for this as well. dpk - Original Message - From: "Sheena Sidhu" <[EMAIL PROTECTED]> To: "Dana Powers" <[EMAIL PROTECTED]>; "Sheena Sidhu" <[EMAIL PROTECTED]>; "Mysql (E-mail)" <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 11:41 AM Subject: RE: cannot get mysqld to start > Dana, > Thanks for looking into this further. I did all that, and ran the > command mysql_install_db instead of mysql_install_db --user=mysql & as they > said in the install guide! I have no clue of the difference between the two > and reason why it should work on one and not on another. > Would appreciate if you could shed some light on this. > > Thanks, > Sheena. > > -Original Message- > From: Dana Powers [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 28, 2001 4:20 PM > To: Sheena Sidhu; Mysql (E-mail) > Subject: Re: cannot get mysqld to start > > > This is covered in the mysql manual here: > http://www.mysql.com/doc/P/o/Post-installation.html > > First, you need to install the default databases ( installs > mysql/host.frm ): > > bash> mysql_install_db > > Then tell mysql not to use InnoDB: > put this in your /etc/my.cnf file: > > [mysqld] > skip-innodb > > > dpk > > - Original Message - > From: "Sheena Sidhu" <[EMAIL PROTECTED]> > To: "Mysql (E-mail)" <[EMAIL PROTECTED]> > Sent: Tuesday, August 28, 2001 2:42 PM > Subject: cannot get mysqld to start > > > > Hello, > > I just installed mysql-max-3.23.41 on Linux. All went smooth but > > alas cannot get myqld to start. here is the log from the .err > > file in mysql/data directory: > > > > 010828 14:26:30 mysqld started > > Can't initialize InnoDB as 'innodb_data_file_path' is not set > > 010828 14:26:30 > /usr/local/mysql-max-3.23.41-pc-linux-gnu-i686/bin/mysqld: > > Can't find file: './mysql/host.frm' (errno: 13) > > 010828 14:26:30 mysqld ended > > > > Now, I am interested in BDB only, so don't care about Innodb. Seems like I > > have to . But what do I do about the host.frm file ? > > Gosh , can someone PLEASE help me here ??? > > > > Thanks, > > Sheena. > > > > - > > 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 > > - 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: cannot get mysqld to start
Dana, Thanks for looking into this further. I did all that, and ran the command mysql_install_db instead of mysql_install_db --user=mysql & as they said in the install guide! I have no clue of the difference between the two and reason why it should work on one and not on another. Would appreciate if you could shed some light on this. Thanks, Sheena. -Original Message- From: Dana Powers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 4:20 PM To: Sheena Sidhu; Mysql (E-mail) Subject: Re: cannot get mysqld to start This is covered in the mysql manual here: http://www.mysql.com/doc/P/o/Post-installation.html First, you need to install the default databases ( installs mysql/host.frm ): bash> mysql_install_db Then tell mysql not to use InnoDB: put this in your /etc/my.cnf file: [mysqld] skip-innodb dpk - Original Message - From: "Sheena Sidhu" <[EMAIL PROTECTED]> To: "Mysql (E-mail)" <[EMAIL PROTECTED]> Sent: Tuesday, August 28, 2001 2:42 PM Subject: cannot get mysqld to start > Hello, > I just installed mysql-max-3.23.41 on Linux. All went smooth but > alas cannot get myqld to start. here is the log from the .err > file in mysql/data directory: > > 010828 14:26:30 mysqld started > Can't initialize InnoDB as 'innodb_data_file_path' is not set > 010828 14:26:30 /usr/local/mysql-max-3.23.41-pc-linux-gnu-i686/bin/mysqld: > Can't find file: './mysql/host.frm' (errno: 13) > 010828 14:26:30 mysqld ended > > Now, I am interested in BDB only, so don't care about Innodb. Seems like I > have to . But what do I do about the host.frm file ? > Gosh , can someone PLEASE help me here ??? > > Thanks, > Sheena. > > - > 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 - 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
cannot get mysqld to start
Hello, I just installed mysql-max-3.23.41 on Linux. All went smooth but alas cannot get myqld to start. here is the log from the .err file in mysql/data directory: 010828 14:26:30 mysqld started Can't initialize InnoDB as 'innodb_data_file_path' is not set 010828 14:26:30 /usr/local/mysql-max-3.23.41-pc-linux-gnu-i686/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010828 14:26:30 mysqld ended Now, I am interested in BDB only, so don't care about Innodb. Seems like I have to . But what do I do about the host.frm file ? Gosh , can someone PLEASE help me here ??? Thanks, Sheena. - 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
BDB questions
Greetings everyone! I had 2 questions related to using BDB and mysql. I don't see any startup options for BDB, so can I safely assume that there are'nt any , so don't need a my.cnf file? Also, how do I specify 'autocommit off' every time BDB starts, instead of specifying it explicitly whenever needed, also I believe even if it is on, I can use begin and end transaction to achieve the same ? Thanks! Sheena. - 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
FW: sql
Hi All, I have installed mysql-max. Previously I had the mysql verion 3.23.40 without max libraries on the same machine. When I start the server , I get the following messages: Please help ! Urgent! *** > [root@arulacc mysql-max-3.23.41-pc-linux-gnu-i686]# vi INSTALL-BINARY > [root@arulacc mysql-max-3.23.41-pc-linux-gnu-i686]# ./bin/safe_mysqld > --user=mysql & > [1] 30123 > [root@arulacc mysql-max-3.23.41-pc-linux-gnu-i686]# Starting mysqld daemon > with databases from /usr/local/mysql-max-3.23.41-pc-linux-gnu-i686/data > 010827 12:20:13 mysqld ended > > > [1]+ Done./bin/safe_mysqld --user=mysql > [root@arulacc mysql-max-3.23.41-pc-linux-gnu-i686]# ps -ef | grep mysql > [root@arulacc mysql-max-3.23.41-pc-linux-gnu-i686]# - 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: Choosing between Databases.
Hi Paul, Will not contest your claim at all since you must have tried it to make that claim. So if I agree with you, then don't you think that the statement which is posted earlier :"Berkeley DB does not support SQL queries. All access to data is through the Berkeley DB API." is misleading esp. to a novice like me or is it that I misunderstood? -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 1:38 PM To: Sheena Sidhu; Mysql (E-mail) Subject: RE: Choosing between Databases. At 1:23 PM -0700 8/27/01, Sheena Sidhu wrote: >Hi Paul, >Thanks for responding. I am not sure if I understand you fully here. SO >you mean to say that BDB DOES support SQL, meaning that I send statements >like 'Select * from user' to a BDB table from my C++ code? If that is >possible, then great. If not, then kindly let me know if Innodb has the same >issue? You're not interacting directly with the BDB or InnoDB table handlers. You're interacting with the MySQL server. You send the server SQL statements, it performs the appropriate translation from SQL onto the operations supported by the table handlers. It doesn't matter whether the table handlers understand SQL as long as the MySQL server does -- which it does. You can easily convince yourself of this by writing a C++ program that talks to the MySQL server to manipulate a BDB table. >Regards, >Sheena. > >-Original Message- >From: Paul DuBois [mailto:[EMAIL PROTECTED]] >Sent: Monday, August 27, 2001 1:19 PM >To: Sheena Sidhu; [EMAIL PROTECTED] >Subject: Re: Choosing between Databases. > > >At 11:10 AM -0700 8/27/01, Sheena Sidhu wrote: >>Hello, >>I am looking into choosing between Innodb and BDB. One thing about BDB >which >>I am quoting from the official site :" >>Berkeley DB does not support SQL queries. All access to data is through the >>Berkeley DB API. Developers must learn a new set of interfaces in order to >>work with Berkeley DB. Although the interfaces are fairly simple, they are >>non-standard. " >>has me worried. When I looked into Innodb, I see not similar reference so >>can I assume that it supports SQL. Can someone please let me know if I am >>wrong here? >>Thanks in advance, >>Sheena. > > >The MySQL server maps SQL statements onto the internals of the BDB or >InnoDB table handlers. The BDB statement is probably more with reference >to accessing it directly rather than through a SQL engine. > >-- >Paul DuBois, [EMAIL PROTECTED] -- Paul DuBois, [EMAIL PROTECTED] - 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
RE: Choosing between Databases.
Hi Paul, Thanks for responding. I am not sure if I understand you fully here. SO you mean to say that BDB DOES support SQL, meaning that I send statements like 'Select * from user' to a BDB table from my C++ code? If that is possible, then great. If not, then kindly let me know if Innodb has the same issue? Regards, Sheena. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 1:19 PM To: Sheena Sidhu; [EMAIL PROTECTED] Subject: Re: Choosing between Databases. At 11:10 AM -0700 8/27/01, Sheena Sidhu wrote: >Hello, >I am looking into choosing between Innodb and BDB. One thing about BDB which >I am quoting from the official site :" >Berkeley DB does not support SQL queries. All access to data is through the >Berkeley DB API. Developers must learn a new set of interfaces in order to >work with Berkeley DB. Although the interfaces are fairly simple, they are >non-standard. " >has me worried. When I looked into Innodb, I see not similar reference so >can I assume that it supports SQL. Can someone please let me know if I am >wrong here? >Thanks in advance, >Sheena. The MySQL server maps SQL statements onto the internals of the BDB or InnoDB table handlers. The BDB statement is probably more with reference to accessing it directly rather than through a SQL engine. -- Paul DuBois, [EMAIL PROTECTED] - 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
Urgent
Hi, I have mysql version 3.32.40 installed on my system. Please let me know what I need to take care of (besides the db backup) if I need to upgrade to mysql-max? I need this on an urgent basis, so please help! Thanks, Sheena. - 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
Choosing between Databases.
Hello, I am looking into choosing between Innodb and BDB. One thing about BDB which I am quoting from the official site :" Berkeley DB does not support SQL queries. All access to data is through the Berkeley DB API. Developers must learn a new set of interfaces in order to work with Berkeley DB. Although the interfaces are fairly simple, they are non-standard. " has me worried. When I looked into Innodb, I see not similar reference so can I assume that it supports SQL. Can someone please let me know if I am wrong here? Thanks in advance, Sheena. - 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
Choosing between databases.
Hello, I am very new to mySQL and researching on the various databases options. Since I needed transactions enabled, so after a lot of research, I narrowed down to innodb and Bdb. But realized that Innodb is in alpha but BDB is very stable. Although I like the features that innodb has to offer, but for stability purposes I am leaning to BDB! Please let me know if there is anything that I missed in my research, or links that I should look into before I make up my mind. Thanks, really appreciate your help. Sheena. - 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