Re: MySQL server (4.0.18) crashed with the following error message

2004-09-12 Thread Heikki Tuuri
Pandu, this may be the '4 billion bug'. Please upgrade to 4.0.21, and report if the crashes persist. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.in

Re: Dump question: transactions vs. locking

2004-09-12 Thread Heikki Tuuri
Csongor, in InnoDB, it is better to use SELECT ... FOR UPDATE to lock the result set of a SELECT. A plain SELECT in InnoDB is a consistent, non-locking read that reads a snapshot of the database at an earlier time. It does not lock anything. Best regards, Heikki Tuuri Innobase Oy Foreign keys

Re: Wrong query result

2004-09-12 Thread Heikki Tuuri
Mauricio, I believe in latin1, MySQL indeed identifies n-tilde with n. Please test with the UTF-8 charset. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http:/

__libc_read() hangs using MySQL-devel-4.0.18-0

2004-09-12 Thread Lung Fan Ying Lung
Dear All, I am using mysql C API for my multi-thread program development (using C++ to develop, Using Redhat 7.2 with 2.4.18-3 kernel version, MySQL-devel-4.0.18-0). In some threads, I will open a new mysql database connection to get the data. While sometime I have the problem in mysql_real_connec

recreating the multi-page html docs from BK?

2004-09-12 Thread Ian Holsman
hi. I want to create the one-page per chapter style of HTML docs on my local hard disk. how do I do this? I have create the single page html document, but I can't find any docs on the split one. TIA Ian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Still problem with MyODBC :((

2004-09-12 Thread Daniel Kasak
Danesh Daroui wrote: Hi all, I have still problem with MyODBC. When I want to connect to my Database server which is a Linux machine, it returns an error: Client does not support authentication protocol requested by server; consider upgrading MySQL client I visited MySQL documents but the suggest

Re: Joins Syntax

2004-09-12 Thread Michael Stassen
Graham wrote: In the query below, I want to obtain all options_totals table records(500 or so), except for those users_options records where the userID=3. i.e. Not retrieve options the user has already selected. If I understand correctly, user_options is a relational table for a many-to-many rela

Lost connection to MySQL server during query & bind-address

2004-09-12 Thread Marten Lehmann
Hello, I'm experiencing a strange thing: When bind is running without "bind-address" everything works fine. But when I'm doing a "bind-address = ..." the clients get "Lost connection to MySQL server during query". I don't understand this, because ot worked once before and the ip-address the cli

Re: Fwd: Best way to get Access DB structures into MySQL ??

2004-09-12 Thread Chris Martin
GH wrote: -- Forwarded message -- From: GH <[EMAIL PROTECTED]> Date: Sun, 12 Sep 2004 02:49:02 -0400 Subject: Re: Best way to get Access DB structures into MySQL ?? To: Chris Martin <[EMAIL PROTECTED]> Does this also allow for the importation of the data as well? On Sat, 11 Sep 200

Dates confusion for real system

2004-09-12 Thread Stuart Felenstein
I'm having a hard time getting my arms around how a system's date process should work. Interested in knowing how a real, online system that delivers services or products to customers might work. Right now I'll just be operating in North America. As an example - a user does online banking. A bi