Stability of MySQL 5.1.11

Hi, I'm wondering what the status of MySQL 5.1.11 is regarding the roadmap for 5.1 changing from "beta" to "generally available"? Regards --jm -- Jacques Marneweck http://www.powertrip.co.za/ http://www.powertrip.co.za/blog/ #include -- MySQL General Mailing List For list archives: http://

Re: where may I find sqlplus.hh??

On Thursday, 3 August 2006 at 22:56:54 -0700, Ratnadeep Nayak wrote: > Hello, > I have downloaded a code on c++ to talk to MySQL database from net which > included a file "sqlplus.hh" , where may I find the file?Please help me > soon. It's not in our code. It must be in the code you downloaded.

Re: Replicating -- sort of 2 way

--On August 6, 2006 2:01:15 PM -0700 Enrique Sanchez Vela <[EMAIL PROTECTED]> wrote: One thing that you could do, is to setup a replicating slave server, freeze the replication, perform backups (to tape/disks etc), then re-enable the replication activity, this way you provide a non-stop serv

Re: Replicating -- sort of 2 way

Enrique Sanchez Vela wrote: Chris, Replicating for the sake of backups is in general a bad idea, since once you delete/update a record, it will be automatically propagated to the slave server. Replication, should be used to provide better availabilty/load balancing but that would need to be se

RE: replication maybe?

Hi Brian, Try having a good read here : http://dev.mysql.com/doc/refman/5.0/en/replication.html Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/

replication maybe?

hey i have a question ; if i have a MySQL database on our local intranet server, but i wanna be able to replicate that database to our internet site thats also a MySQL database so whenver something changes on our intranet it also changes on our Internet Database,,how do i do this ?

Re: Replicating -- sort of 2 way

Chris, Replicating for the sake of backups is in general a bad idea, since once you delete/update a record, it will be automatically propagated to the slave server. Replication, should be used to provide better availabilty/load balancing but that would need to be setup as part of a bigger plan to

Re: Error 1032 : Can't find Record in

Detlev, It is possible that mysql is interpreting adr-0 as a arithmetic operation, why don't you try quoting the table name to prevent mysql trying to interpret it as anything... insert into `adr-0` values ('TestAdr','1') on duplicate key update qty = qty +1; regards, Enrique. --- Detlev J

Possible to use multiple conditions in SET/Declare?

Hi All, I know that we can do stuffs like declare @temp1 varchar(20), @temp2 varchar(20) set @temp1 = A set @temp2 = Z select * from table where table.column = @temp1 I would like to do something like this. set @temp1 = ('A','B','C') select * from table where table.column IN @temp1 Is it poss

Re: Can't get v5.0.22 to work;alternatives?

Hi, Earlier, I forgot to CCed the reply to the list and, accidentally, posted a blank reply instead. So, here is the copy of the reply that I sent to the original poster - in case, someone else has the same problem. Additionally, I have found that the MySQL ODBC driver installs best when you do

text mode listing

Hi Can you remind me how to tell mysql to list vertically instead of horiz in text mode? Ex: select all * from a_tablesends field1 field2 . I want field1 field2 field... Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:htt

Replicating -- sort of 2 way

Before I go reading too deep into the documentation I would like to know if this is even possible or if it is just a bad idea. I have Server A with DB X, and server B with DB Y. I would like to set up Server A and B as both a replication master and slave. Where Server A would be the Master f

Re: SELECT with Result Ordered by Minimum of Fields

David T. Ashley wrote: On 8/6/06, Chris W <[EMAIL PROTECTED]> wrote: David T. Ashley wrote: > Can I just write something like: > > SELECT * FROM mytable WHERE fieldofinterest field2) ASC; I think this will work.. SELECT *, IF(a-b < 0,a, b) as SortField FROM table WHERE whatever ORDER BY S

Re: SELECT with Result Ordered by Minimum of Fields

On 8/6/06, Chris W <[EMAIL PROTECTED]> wrote: David T. Ashley wrote: > Can I just write something like: > > SELECT * FROM mytable WHERE fieldofinterest field2) ASC; I think this will work.. SELECT *, IF(a-b < 0,a, b) as SortField FROM table WHERE whatever ORDER BY SortField Question: Is

Problems connecting using "-h hostname" with new installation

Hello, I installed MySQL on a remote server and am having a problem. I am connected to it via SSH and I can do "mysql -u root -h localhost" just fine and connect. However, when I try to connect via "mysql -u root -h web1.server.com", I get the following message: "ERROR 1130 (0): Host '75.1

Error 1032 : Can't find Record in

Hello, I'm curently testing partitioning with mysql 5.1.11 on linux (.rpm from mysql.com site). Table Structure: CREATE TABLE `adr-0` ( Adr varchar(255) COLLATE latin1_german1_ci NOT NULL DEFAULT '', Qty int(10) NOT NULL, PRIMARY KEY (Adr), ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE

Re: SELECT with Result Ordered by Minimum of Fields

David T. Ashley wrote: Can I just write something like: SELECT * FROM mytable WHERE fieldofinterest I think this will work.. SELECT *, IF(a-b < 0,a, b) as SortField FROM table WHERE whatever ORDER BY SortField a and b being the names of the fields you are interested in. -- Chris W KE5GIX