Re:asm constraint problem

2001-09-02 Thread Heikki Tuuri
Vladislav, gcc-2.96 does not compile the assembly while 2.95 and 3.0 do. But the asm code is actually not needed. You can just comment out the two offending functions in mysql/innobase/sync/sync0sync.c. Regards, Heikki http://www.innodb.com >There is a problem with mysql-3.23.41 >when compiled

asm constraint problem

2001-09-02 Thread Vladislav Malyshkin
There is a problem with mysql-3.23.41 when compiled by gcc-2.96-85 (RedHat) gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include-DDBUG_OFF -O3 -DDBUG_OFF -O3 -DDEBUG_OFF -DUNIV_INTEL_X86 -c sync0sync.c sync0sync.c: In function `sync_gnuc_intelx86_test_and_set': sync0sync.c:187:

Re: MySQL & Delphi

2001-09-02 Thread j.urban
Is it actually truncating data or is the width simply short? If it's the latter, you might want to have a look at the MyODBC settings for the connection. There is an option called something like, "Don't optimize column widths". If this is checked, MyODBC should return the entire column width.

Re: MySQL & Delphi

2001-09-02 Thread Mike
I use D5 and ZEOS without any problems other than it chocked on BLOBS but that was fixed. I also use ASTA http://www.astatech.com/freetools/EvalComps.htm and the ASTA MySQL Server. Works great. Cheers M;) Quote of the day; Programming is like sex: one mistake and you have to support it for the

mysqld as root

2001-09-02 Thread Michael Widenius
Hi! > "Ken" == Ken Menzel <[EMAIL PROTECTED]> writes: Ken> Wasn't there something awhile back that was supposed to prevent Ken> running the daemon as root? When the daemon was started through Ken> safe_mysqld it would tell you to select a user as root you had to Ken> use --user=root, this

Re: mysqld or kernel bug?

2001-09-02 Thread Trond Eivind Glomsrød
Robert La Ferla <[EMAIL PROTECTED]> writes: > I saw this message in the log. Is this a mysql or kernel? I also saw > one of the mysqld processes (threads?) in the process list as a Zombie. > I think it happened at the same time of this log but I don't remember so > it's not definite but likely.

Continuing Win98 install problems...

2001-09-02 Thread Mathew Hamilton
Hello, Adding in skip-innodb has indeed helpedbut the server still does not start. If I go into the mysql.err filethis the message I'm getting.. Table 'mysql.host' doesn't exist Anyhelp would be appreciated... Mathew ---

High Availability for 2 MySQL servers

2001-09-02 Thread Wendell Dingus
I've searched the lists, newsgroups, etc... The info that's out there is somewhat confusing or not as complete as it should be. This is a bit more of a Linux question than a MySQL one but folks on here are likely to be the ones to know the answer. Can anyone give a suggestion as to the best way t

Re: MySQL & Delphi

2001-09-02 Thread Elizabeth Alderton
Hi Well, I've no experience with ADO's, but I'm using Zeos components and I've not had any () problems. Here's the url http://www.zeoslib.org/. They're free and they don't use ODBC, but rather libmysql.dll which was described to me by my ISP as 'more secure' - whatever that means! They have

Re: Win98 Installation problems

2001-09-02 Thread Gerald R. Jensen
Mathew: Under the [mysqld] section of c:\my.cnf, make sure there is a line that reads: skip-innodb Unless, of course, you intend to use innodb. Since you are new with MySQL, there are some excellent resources you should check before posting ... http://www.mysql.com/manual.php (the manual),

RE: Win98 Installation problems

2001-09-02 Thread Heikki Tuuri
Mathew, if you do not want to use transactional InnoDB tables, add skip-innodb to the [mysqld] section of your my.cnf or my.ini. However, your startup parameters for InnoDB look right. If you have created the directories \ibdata and \iblogs, it should start (unless you are using mysqld.exe in

Re: WHERE IN ( MAX ) in MySQL

2001-09-02 Thread Benjamin Pflugmann
Hi. This is mentioned in the fine manual: http://www.mysql.com/doc/e/x/example-Maximum-column-group-row.html Bye, Benjamin. On Fri, Aug 31, 2001 at 01:46:43PM +0200, [EMAIL PROTECTED] wrote: [...] > Normally I would go about like this: > SELECT currency_rate.currency_id, currency_dat

Re: Mysql 3.23.41 fails to install as service on Win 2000 Professional

2001-09-02 Thread Dmitry Mityugov
> I'm using > > Ver 3.23.41-max-debug for Win95/Win98 on i32 > > And command > > mysqld-nt --install > > Displays error dialog box > > "Failed to install service" > > In Event viewer the messages simply says: > > The MySql service terminated unexpectedly. It has done this 1 >

Re: mysqlshow shows list of blank (not empty) tables (FAQ?)

2001-09-02 Thread Simon J Mudd
[EMAIL PROTECTED] (Sinisa Milivojevic) writes: > Also, there was a bug in 3.23.36. Can you try .41 ?? I've just upgraded to 3.23.41-1 (rpm) and things now seem fine. [sjmudd@phoenix sjmudd]$ mysqlshow --host=phoenix ++ | Databases| ++ | bounces| | c

Re: Mysql 3.23.41 fails to install as service on Win 2000 Professional

2001-09-02 Thread Sinisa Milivojevic
Jari Aalto writes: > > I'm using > > Ver 3.23.41-max-debug for Win95/Win98 on i32 > > And command > > mysqld-nt --install > > Displays error dialog box > > "Failed to install service" > > In Event viewer the messages simply says: > > The MySql service terminated unexpectedl

Re: mysqld or kernel bug?

2001-09-02 Thread Sinisa Milivojevic
Robert La Ferla writes: > I forgot to include the info on the zombied mysql process. > > mysql10389 0.0 0.0 00 pts/0Z12:51 0:00 [mysqld > ] > > Robert > That was definitely kernel. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Mili

Re: mysqlshow shows list of blank (not empty) tables (FAQ?)

2001-09-02 Thread Simon J Mudd
On Sun, 2 Sep 2001, Sinisa Milivojevic wrote: > What does SHOW GRANTS presents for that user ?? [sjmudd@phoenix sjmudd]$ mysql --host=phoenix Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 3.23.36 Type 'help;' or '\h' for help. Type '\

Re: Is mysql_query() reentrant ?

2001-09-02 Thread Sinisa Milivojevic
Marc A. Mueller writes: > > Hi, > > I want my application (LINUX, C++) to send periodically an information > to a MySQL-Server, regardless of whats it is actually doing at the > moment. Can I use the alarm signal for this (is mysql_query() > signal-reentrant) ? > > I'm using the normal mysql-li

Re: mysqlshow shows list of blank (not empty) tables (FAQ?)

2001-09-02 Thread Sinisa Milivojevic
Simon J Mudd writes: > On Sat, 1 Sep 2001, Sinisa Milivojevic wrote: > This gives me: > > [sjmudd@phoenix sjmudd]$ mysql --host=phoenix > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 20 to server version: 3.23.36 > > Having not been subscribed to this

Mysql 3.23.41 fails to install as service on Win 2000 Professional

2001-09-02 Thread Jari Aalto
I'm using Ver 3.23.41-max-debug for Win95/Win98 on i32 And command mysqld-nt --install Displays error dialog box "Failed to install service" In Event viewer the messages simply says: The MySql service terminated unexpectedly. It has done this 1 time(s). The following

RE: Bulk mailing

2001-09-02 Thread John Coggeshall
Sure... |-Original Message- |From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] |Sent: Saturday, September 01, 2001 1:51 AM |To: [EMAIL PROTECTED] |Subject: Bulk mailing | | |Hi list members, | |I want to mail a newsletter to about 500+ email addresses. |Can anyone give php script that

Re: Problem while compiling mysql-4.0

2001-09-02 Thread Michael Widenius
Hi! > "Fournier" == Fournier Jocelyn writes: Fournier> Sorry, I've just seen the problem has been already fixed by tonu in the Fournier> mysql-4.0 tree. If you have any problems compiling MySQL 4.0 from the bk repository, please post these question to [EMAIL PROTECTED] list. I am just no

MySQL & Delphi

2001-09-02 Thread Ales Vaupotic
Hello, I've got a problem with MySQL 3.23.41 on Solaris 8 and Delphi 5 Ent. on Windows 98. I installed the latest MyODBC a week ago and am using ADO components to connect to the server. The connection itself works but when I open the field editor of a table, char(50) is interpreted in Delphi as s

[MYSQL - Windows Version 3.23.41] Invalid Field Size

2001-09-02 Thread Chee Chong Hwa
Hi My PC environment are as follows : - Pentoum 933 Mhz - 1.128G RAM - Windows 2000, SP2 - Raid 5 - 32G HDD - MYSQL Windows version 3.23.41 - MYODBC 2.50 - Delphi 6 Using the Delphi Datapump, I successfully ported 200 tables to the test database. Using ADO connection, I successufully connected