RE: Migrating...

[Witness]

Thanks! I used the file transfer; I don't think the grants/revokes
completely transferred, but that's easy enough to fix. :)

Benjamen R. Meyer

> Hi.
>
> I had the same problem awhile back.
>
> What i did was just copy the db files to the linux server
> provided the mysql versions are exactly the same and
> the db structures are the same it works.
>
> Otherwise mysqldump and read it into the new db:)
>
> //Uffe
> Witness wrote:
> >
> > Hello. I am running a MySQL server (3.23.43) on WinME, and another
> > server (same version) on libc6 Linux.  The server on WinME is a
> > development server, or rather has been until now, and the
> Linux one is
> > my production server. At this time the Linux one is completely empty
> > with the exception of the defaults, and I would like to migrate the
> > WinME one over onto the Linux system and then drop the one
> on WinME from
> > my line of development (I don't really need it).  In
> looking through the
> > documentation I have noticed that I could do the following:
> >
> > 1) Uni-direction Replication - a bit of a pain just for a transfer.
> > 2) Dump to a file, and load
> > 3) Back-up & Re-load
> >
> > Or I could just rebuild the entire thing.
> >
> > I would like to have the migration be as simple as possible, and am
> > wondering what method is the best way to do that.  Could
> someone please
> > help? It would be greatly appreciated.
> >
> > Thanks in advance.
> >
> > Benjamen R. Meyer
> >
> > ---
> > E-mail: [EMAIL PROTECTED]
> > Web: http://bmeyer67.resnet.calvin.edu/
> > ---
> >
> >
> -
> > 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: InnoDB Compiler error (as well)

[Heikki Tuuri]

Ashley,

>Okay, so seeing Gemini failing, it was InnoDB's turn:
>gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include
>-DDBUG_OFF -O3 -DDBUG_OFF-DDEBUG_OFF -DUNIV_INTEL_X86 -c sync0sync.c
>sync0sync.c: In function `sync_gnuc_intelx86_test_and_set':
>sync0sync.c:187: impossible register constraint in `asm'
>sync0sync.c:187: impossible register constraint in `asm'
>sync0sync.c:187: impossible register constraint in `asm'
>sync0sync.c:1259: confused by earlier errors, bailing out
>make[4]: *** [sync0sync.o] Error 1make[4]: Leaving directory

compile the latest source 3.23.44. I removed the inline assembly in 3.23.41
because gcc-2.96 cannot compile it. gcc-2.95 and 3.0 can compile inline
assmbly, but in 2.96 that seems to be totally broken.

>`/usr/local/src/Apache/mysql+gemini-3.23.41/innobase/sync'
>And while I'm sure someone is bound to tell me to stop using
>RedHat's GCC 2.96 because of "bad code", I'm sorry.  Everything else
>that I need/use compiles just fine and I never have problems with them,
>except MySQL.
>--
>H | "Life is the art of drawing without an eraser." - John Gardner
>  +
>  Ashley M. Kirchner    .   303.442.6410 x130
>  Director of Internet Operations / SysAdmin. 800.441.3873 x130
>  Photo Craft Laboratories, Inc.. 3550 Arapahoe Ave, #6
>  http://www.pcraft.com . .  ..   Boulder, CO 80303, U.S.A.

Regards,

Heikki
http://www.innodb.com
--
Order commercial MySQL/InnoDB support at https://order.mysql.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

Re: How do I count using two tables

[Aleksandar Bradaric]

Hi,

> I've got two tables one is News items

> News_IDNewsetc...
> 1  Today in .etc
> 2  Hello world .etc
> 3  Blar di blaretc
> 4  And now time for something else
> .
> .
> 100The last thing

> and the other is comments on the news items (as well as other things on the
> web site)

> TypeComment_IDComment  etc...
> News1 What about today then...
> News1 This is still today...
> News4 This parot is dead..
> NotNews 4 Hello..

> What I am trying to get is one SELECT statment that will give me

> News_IDNews   Comment_Count  etc...
> 1   Today in ...   2
> 2   Hello world.   0
> 3   Blar di blar0
> 4   And now ...etc  1


select news.newsid, news.news, count(comment.comment_id)
from news left join comment on news.newsid = comment.comment_id and comment.type = 
'News'
group by news.newsid, news.news;


Sasa



-
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: corrUPted tabLE questions...

[Carl Troein]

Jim Ray, @WD writes:
> 
> I have a tabel that seems to be corrupted. Is there a way to fix it?  It is
> running on a Lynx box.

Atari Lynx? Does MySQL really run on that? Or did you mean Linux? Hmm...
Anyway, look in the manual. REPAIR TABLE is good place to start, as
is myisamchk. And make sure that you don't repeat whatever you did to
get the table corrupted. killall -9 mysqld is a BAD idea, as is
messing with the table files when mysqld is running.

//C

-- 
 Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
 Amiga user since '89, and damned proud of it too.


-
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 problem

[Zhi Huan YU system admin]

Dear support officer,

 The followings are generated by the mysqlbug script:

SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: yuzh
To: [EMAIL PROTECTED]
Subject: [50 character or so descriptive subject here (for reference)]

>Description:

>How-To-Repeat:

>Fix:


>Submitter-Id:  
>Originator:Greg Yu
>Organization:
 
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:  
>Severity:  <[ non-critical | serious | critical ] (one line)>
>Priority:  <[ low | medium | high ] (one line)>
>Category:  mysql
>Class: <[ sw-bug | doc-bug | change-request | support ] (one line)>
>Release:   mysql-3.23.39-max (Official MySQL-max binary)
>Server: /usr/local/mysql/bin/mysqladmin  Ver 8.21 Distrib 3.23.39, for pc-solaris2.8 
>on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version  3.23.39-max
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 2 hours 11 min 0 sec

Threads: 1  Questions: 22  Slow queries: 0  Opens: 6  Flush tables: 1  Open tables: 0 
Queries per second avg: 0.003
>Environment:

System: SunOS ictest 5.8 Generic_108529-12 i86pc i386 i86pc
Architecture: i86pc

Some paths:  /usr/bin/perl /usr/ccs/bin/make /usr/local/bin/gcc /usr/ucb/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/i386-pc-solaris2.8/3.0.1/specs
Configured with: ../configure --with-as=/usr/local/bin/as --with-ld=/usr/local/bin/ld
Thread model: posix
gcc version 3.0.1
Compilation info: CC='gcc'  CFLAGS='-O3 -fno-omit-frame-pointer'  CXX='gcc'  
CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'  
LDFLAGS=''
LIBC: 
-rw-r--r--   1 root bin  1588040 Nov 17 07:10 /lib/libc.a
lrwxrwxrwx   1 root root  11 Nov 20 11:48 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x   1 root bin   943052 Nov 17 07:10 /lib/libc.so.1
-rw-r--r--   1 root bin  1588040 Nov 17 07:10 /usr/lib/libc.a
lrwxrwxrwx   1 root root  11 Nov 20 11:48 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x   1 root bin   943052 Nov 17 07:10 /usr/lib/libc.so.1
Configure command: ./configure  --prefix=/usr/local/mysql '--with-comment=Official 
MySQL-max binary' --with-extra-charsets=complex --with-server-suffix=-max 
--disable-shared --with-berkeley-db --with-innodb
Perl: This is perl, version 5.005_03 built for i86pc-solaris

1. libaray file libncurses.so.5 is missing.
yuzh@ictest[/usr/local/mysql/bin] 231# mysql_fix_privilege_tables
This scripts updates the mysql.user, mysql.db, mysql.host and the
mysql.func table to MySQL 3.22.14 and above.

This is needed if you want to use the new GRANT functions or
want to use the more secure passwords.

If you get Access denied errors, you should run this script again
and give the MySQL root user password as a argument!

If your tables are already up to date or partially up to date you will
get some warnings about 'Duplicated column name' or
'Table 'func' already exists'. You can safely ignore these!
ld.so.1: /usr/local/mysql/bin/mysql: fatal: libncurses.so.5: open failed: No such file 
or directory
Killed

Creating Grant Alter and Index privileges if they don't exists
You can ignore any Duplicate column errors
ld.so.1: /usr/local/mysql/bin/mysql: fatal: libncurses.so.5: open failed: No such file 
or directory
Killed

Creating the new table and column privilege tables
ld.so.1: /usr/local/mysql/bin/mysql: fatal: libncurses.so.5: open failed: No such file 
or directory
Killed
Changing name of columns_priv.Type -> columns_priv.Column_priv
You can ignore any errors from this
ld.so.1: /usr/local/mysql/bin/mysql: fatal: libncurses.so.5: open failed: No such file 
or directory
Killed
Fixing the func table
You can ignore any Duplicate column errors
ld.so.1: /usr/local/mysql/bin/mysql: fatal: libncurses.so.5: open failed: No such file 
or directory
Killed

2. Access denied for user defined in mysql group:

yuzh@ictest[/home/yuzh] 213# mysqlshow mysql
mysqlshow: Access denied for user: '@localhost' to database 'mysql'

yuzh@ictest[/etc/rc3.d] 249# mysqlshow
mysqlshow: Access denied for user: 'root@localhost' (Using password: NO)


Please tell me how to fix the about problems.

Thanks!


-- 
Regards
Greg Yu
--
Zhi Huan Yu  
Computer Systems Administrator  
School of Engineering & Mathematics
Edith Cowan University   Email:  [EMAIL PROTECTED] 
100 Joondalup Drive  Tel:int +61 8 9400 5846
Western Australia 6027   Fax:int +61 8 9400 5811

Is there any alternative to MEMO field in MYSQL database?

[Hamzat kamal]

Hi,

I need to store a string variable which is more than 255 character that 
varchar field in mysql can contain. I have check the available docs with me 
I can see anything referring to  this.
Any support will be highly appreciated.

Thanks
Kamal.


-
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

Bug report

[Кулаков Сергей]

Hello. We use MySQL 3.23.38 with our website http://www.rlsnet.ru. This new
MySQL version is much better than the previous one (sorry, can't get the
exact version number), but I noticed one strange thing which I wanna write
about. When I make

select
 TN0MNN.torgn_id, Rlsprepr.prepr_id, Rlsbopis.opis_id,
 count(distinct Rlsbopis.opis_id) as c
from
 TN0MNN, Rlsprepr
 left join Rlsopipr using(prepr_id)
 left join Rlsbopis using(opis_id)
where TN0MNN.torgn_id=Rlsprepr.torgn_id
group by
 torgn_id
having c=0

I get one result, and when I make

select
 TN0MNN.torgn_id, Rlsprepr.prepr_id, Rlsbopis.opis_id
from
 TN0MNN, Rlsprepr
 left join Rlsopipr using(prepr_id)
 left join Rlsbopis using(opis_id)

where TN0MNN.torgn_id=Rlsprepr.torgn_id
group by
 torgn_id
having count(distinct Rlsbopis.opis_id) =0


I get a different one.

The only difference between them is that in the first I get "count(distinct
Rlsbopis.opis_id) as c" as a result field and then I have "having c=0" in
the end, while in the second query I do the same thing by "having
count(distinct Rlsbopis.opis_id) =0", that's I don't have the count as a
result field. I thought the queries should yield the same results, but
that's not so.

The queries are supposed to get the names of medicines that have no text
description. Every medicine name (so called tradename, torgn_id) is
connected with one or more medicines (prepr_id) that have it, each of
medicines may have a text description (opis_id). Thus, any tradename, via
all its medicines may have zero or more text descriptions. As I found, the
difference in the results of the queries is caused by those tradenames that
have both medicines with description and those without. That is, if a
tradename has some medicines and all of them have a description, both the
queries consider that the number of the descriptions is more than zero. If a
tradename has some medicines and none of them has a description, both the
queries consider that the number of descriptions is zero. But if a tradename
has some medicines and some of them have descriptions while others don't,
the first query (which is correct!) considers that the number of
descriptions is more than zero, while the second (incorrect!) considers it
to be zero.

Is this a bug or my misunderstanding of the situation?












-
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

MERGE tables and INSERT_METHOD

[Michael Widenius]

Hi!

> "Chris" == Chris Cooper <[EMAIL PROTECTED]> writes:

Chris> Has anyone else tried to set the INSERT_METHOD for MERGE tables? It
Chris> keeps throwing a syntax error for me. 

Chris> Following the docs verbatim (http://www.mysql.com/doc/M/E/MERGE.html),
Chris> here's what I get:



Chris> I checked the release notes/changelog, but there's no mention of the
Chris> INSERT_METHOD being broken or fixed.

Chris> I'm running MySQL version 3.23.42-log on RH 7.1. 

The INSERT_METHOD is only available in MySQL 4.0.0;  I have now
updated the documentation about this.

Regards,
Monty

-
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

SV: Is there any alternative to MEMO field in MYSQL database?

[Torgil Zechel]

TEXT and BLOB types. 
http://www.mysql.com/doc/B/L/BLOB.html

> -Ursprungligt meddelande-
> Fran: Hamzat kamal [mailto:[EMAIL PROTECTED]]
> Skickat: den 23 november 2001 09:56
> Till: [EMAIL PROTECTED]
> Amne: Is there any alternative to MEMO field in MYSQL database?
> 
> 
> Hi,
> 
> I need to store a string variable which is more than 255 character that 
> varchar field in mysql can contain. I have check the available 
> docs with me 
> I can see anything referring to  this.
> Any support will be highly appreciated.
> 
> Thanks
> Kamal.
> 
> 
> -
> 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: HOW TO : Run wave files stored in BLOB field ???

[Abdulrahman Abahsain]

I try what Venu suggests and it is working fine ...

Send it to you to know about it , may be you need it
in future thanks venu.

Abdulrahman.

--- Venu <[EMAIL PROTECTED]> wrote:
> Hi, 
> 
> > -Original Message-
> > From: Delphi Guy's
> [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, November 22, 2001 2:06 PM
> > To: [EMAIL PROTECTED]
> > Subject: HOW TO : Run wave files stored in BLOB
> field ???
> > 
> > 
> > Hi all, This the first post for me to this lists I
> > appreciate If  I take a good picture as I hear...
> > 
> > I creat table in MySQL like this 
> > CREATE TABLE test
> > (
> >  ItemID   INT NOT NULL
> AUTO_INCREMENT,
> >  FirstNameCHAR(50),
> >  LastName CHAR(50) NOT NULL,
> >  SoundLONGBLOB,
> >  PRIMARY KEY (ItemID)
> >  );
> > 
> > the Sound field is for storing wave files , it is
> > stored ok 
> > now I want to run this wave from this field .
> > I'm trying to use this methode by using ASP with
> > MySQL...
> > 
> > == Listenwav.asp File ==
> > 
> ><%@ LANGUAGE="VBSCRIPT" %>
> ><%
> >' Clear out the existing HTTP header
> information
> >Response.Expires = 0
> >Response.Buffer = TRUE
> >Response.Clear
> > 
> >' Change the HTTP header to reflect that an
> audio
> > is being passed.
> >Response.ContentType = "audio/wave"
> > 
> >StrConnection =
> > "driver={MySQL};server=127.0.0.1;database=test"
> >Set ADODataConn =
> > Server.CreateObject("ADODB.Connection") 
> >ADODataConn.Open strConnection
> >
> >Set rs = ADODataConn.Execute("SELECT Sound FROM
> > Test WHERE ItemID=1 ;")
> >Response.BinaryWrite rs("Sound")
> >Response.End
> >%>
> > 
> > 
> > 
> > the HTML File will be 
> > 
> > == Listen.htm FILE ==
> > 
> > 
> > 
> >  > src="ListenWav.asp" 
> > autostart=true 
> > loop=false 
> > >
> > 
> > 
> > 
> > 
> > =
> > 
> > this way is not working  ... I don't know way ...
> > 
> > Can any one tell me way , or how can I do it with
> > another way...
> > 
> > NOTE THAT I DO SAME WAY TO DISPLAY IMAGE AND IT IS
> > WORKING FINE !!!
> > 
> 
> I am not quite sure of ASP. As per the comments from
> 
> another MyODBC user, the following code works fine
> to play back your wav file. 
> 
> 
> 
> 
> 
> 
> 
> Can you try whether it works with you ? 
> 
> Regards, venu
> -- 
> For technical support contracts, go to
> https://order.mysql.com
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /  Mr. Venu
> <[EMAIL PROTECTED]>
>  / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
> /_/  /_/\_, /___/\___\_\___/ California, USA
><___/ www.mysql.com
> 


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1

-
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: problem running mysql from the command line

[DL Neil]

> I hope I'm not being really stupid, but this does not seem to work:
> 
> mysql -h localhost -u xxx -p
> 
> I get the command line usage error. It appears I can't use any other option
> if I use the -h. This works fine
> 
> mysql -u xxx -p
> 
> I'm running mysql version 3.23.43-nt


Glenn,

Is the MySQL\bin (wherever it is) sub-directory the current directory, or is it in the 
PATH?

=dn



-
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: Mysql & Win200 problem (telnet localhost)

[DL Neil]

Sandeep,
1 virus check
2 check .ini files
3 check PATH
4 check DNS
5 give more specific information, read the manual (again), ie help yourself before 
making complaints that you
get no answers
=dn

- Original Message -
From: "Sandeep Murthy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: 22 November 2001 10:04
Subject: Mysql & Win200 problem (telnet localhost)


> hi,
>
> I had posted a few days back regarding having problems running MySQL on WIN
> 2000...
>
> I forgot to add before, I can ping my localhost but unable to do a telnet
> localhost too...
> I had installed and was running MySQL and PHP with IIS successfully for
> nearly 2 mths now... All of sudden since a few days back the MySQL service
> refuses to start and keeps giving various errors such as unable to find path
> etc...
>
> I uninstalled and reinstalled MySQL a couple of times all in vain..
>
> What could have happened and how may I rectify this problem...
>
> Would appreciate much if anyone can help me out on this..
>
> TIA,
> sandeep
>
>
>
> -
> 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: Mysql installation problem on NT

[DL Neil]

Hi Joachim

I tried to install mySQL on Windows NT (Service Pack 6).
That means: Unzipping, installing, then starting mySQL as a service with
: mysqld-nt --install.
Until now everything worked fine and we saw the service in the NT's
Service list.
But we could not start the service. Neither with NT nor with "NET START
mysql" from the DOS box.
There was an error 1067.

=in the Services list what were the values? Was the status "started" and is startup 
automatic or manual.

=When mine installed, it came up auto and started automatically. Thus there was no 
need to use the DOS box/NET
command!

One more thing to explain: We installed mySQL in a directory
D:\inst\\
When we started: mysqld-nt --install there was no file my.cnf.
(Because my installation in the office is in C:\mysql I forgot to save
my.cnf in WINNT).
Maybe thats the problem. But I don´t know.

=use Windows Explorer or My Computer, navigate to the MySQL\bin sub-directory. Execute 
the WinMySQLAdmin program
and customise the relevant directory fields, then restart the MySQL server.

Second question: How to get rid of the mysql-service in the NT service
list.
You see I'm not very accustomed to WIN NT.

=the above answers this - it should start automatically. You should be able to use the 
admin GUI to stop and
restart it, if/when necessary, otherewise it will start automatically on every NT boot.

I hope somebody will help me.

=hope it has been helpful,
=dn



-
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 do I count using two tables

[DL Neil]

Karl

> I've got two tables one is News items
>
> News_IDNewsetc...
> 1Today in .etc
> 2Hello world .etc
> 3Blar di blaretc
> 4And now time for something else
> .
> .
> 100The last thing
>
> and the other is comments on the news items (as well as other things on the
> web site)
>
> TypeComment_IDComment  etc...
> News1What about today then...
> News1This is still today...
> News4This parot is dead..
> NotNews   4Hello..
>
> What I am trying to get is one SELECT statment that will give me
>
> News_IDNews   Comment_Count  etc...
> 1   Today in ...   2
> 2   Hello world.   0
> 3   Blar di blar0
> 4   And now ...etc  1
>
>
> I've tried quite a few SELECTs using LEFT JOIN and HAVING and the best I can
> do is a news list showing only Items that have Comments so the above would
> have returned only NEWS_ID 1 and 4 but not giving 2 and 3 were I want
> 1,2,3,4.100.
>
> Please help, sorry if this is kids stuff but I'm only just starting with
> MySQL.

=it is fairly straight-forward and you don't need to get into overly complicated joins 
- stick to the simple
Comment_ID = News_ID.

=However, as a beginner I advise you to start with a simple query and then build it up 
- and like many things,
start at the 'far end' and work backwards, eg go for a SELECT of ID and Count first:-

=in the manual, track down the COUNT() function, you might also need to read up on the 
GROUP BY clause of a
SELECT statement.

=now add the WHERE (join) clause and the News column, and the parrot lives again!
=dn



-
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

[BUG: mysqldump incorrectly generates INSERTs for AUTO_INCREMENT columns]

[dima]

>Description:
 Say we have column named id int NOT NULL AUTO_INCREMENT
 Say we have record, where id=0 (why not?)
 Say we used mysqldump to  backup our table.
 One day we tryied to restore our table, but we will never get record
 where id=0 back, becouse rule for AUTO_INCREMENT rows will apply. So
 insert into table set id=0; will be treated as subject to apply next
 value for AUTO_INCREMENT row. And we never get id=0 record restored.
>How-To-Repeat:
shell> mysql test

CREATE TABLE Products (
id int  unsigned NOT NULL auto_increment,
PRIMARY KEY (id)
) TYPE=MyISAM;

INSERT INTO Products Values(0);
INSERT INTO Products Values(0);
INSERT INTO Products Values(0);
INSERT INTO Products Values(0);
INSERT INTO Products Values(0);
UPDATE Products set id=0 where id=3;

quit

shell> mysqldump test Products > /tmp/dmp
shell> echo 'drop table Products;' | mysql test
shell> mysql test < /tmp/dmp
shell> mysql test
mysql> select * from Products where id=0;
Empty set (0.02 sec)
>Fix:
 1. Patch for mysqldump utility required. So when Zero (or NULL) value found
in AUTO_INCREMENT source field, additional command emitted to the dump.
Like
Update Table set column = 0 where ...(depends on table spec).;
 2. If patch is not important from your point of view, please add a note to
the documentation for those who want to have Zero values in AUTO_INCREMENT
fields about side effect of mysqldump utility.

>Submitter-Id:  
>Originator:Dmitry Dorofeev
>Organization:
  Deem0N** [EMAIL PROTECTED] **
  Natural born YASPer   http://www.yasp.com/
  Just Another Perl Monger  http://spb.pm.org/
  R U X Y founder   http://www.ruxy.org.ru/
>
>MySQL support: [none]
>Synopsis:
> 
>Severity:   
>Priority:  
>Category:  mysql
>Class: 
>Release:   mysql-3.23.41 (Source distribution)

>Environment:

System: FreeBSD rux 4.4-STABLE FreeBSD 4.4-STABLE #0: Wed Nov 14 17:26:30 MSK 2001 
butthead@rux:/usr/src/sys/compile/RUX40  i386


Some paths:  /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.3 20010315 (release) [FreeBSD]
Compilation info: CC='cc'  CFLAGS='-O -pipe '  CXX='c++'  CXXFLAGS='-O -pipe  
-felide-constructors -fno-rtti -fno-exceptions'  LDFLAGS=''
LIBC: 
-r--r--r--  1 root  wheel  1205812 31 ÏËÔ 14:52 /usr/lib/libc.a
lrwxr-xr-x  1 root  wheel  9 31 ÏËÔ 14:52 /usr/lib/libc.so -> libc.so.4
-r--r--r--  1 root  wheel  520516 15 ÁÐÒ  2000 /usr/lib/libc.so.3
-r--r--r--  1 root  wheel  573100 31 ÏËÔ 14:52 /usr/lib/libc.so.4
Configure command: ./configure  --localstatedir=/var/db/mysql --without-perl 
--without-debug --without-readline --without-bench --with-mit-threads=no 
--with-libwrap --with-low-memory --enable-assembler --with-berkeley-db 
--prefix=/usr/local i386--freebsd4.4
Perl: This is perl, version 5.005_03 built for i386-freebsd

-
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

C API problem, CREATE TABLE SELECT & SELECT

[Kristian Vlahovicek]

Hello, 

I seem to have a problem with the C API, briefly I try to select something
into a temporary table and then do three selects, two of which are from the
temporary table created. Program segfaults.
When I comment all but temp table creation, program works, and same happens
for a non-temp table select, but when both are present, the program simply
refuses to run.

code details (complete queries ommitted for clarity, queries are not problematic
- they were tested with the standalone mysql client):


query_len = sprintf(query, "CREATE TEMPORARY TABLE temp SELECT ");
fprintf(stderr, "QUERY: %s\nLEN: %d\n", query, query_len);

if (mysql_real_query(db_read, query, query_len)) {
free(query);
b_abort("CREATE TABLE temp unsuccessful: %s", mysql_error(db_read));
}

if (mysql_affected_rows(db_read) == 0) { /* no rows transferred to the temp table, 
skip entry */
fprintf(stderr, "CREATE TABLE selected no rows, skipping id %d\n", id);
free(query);
return 1; /* no self score found, but the query was OK */
}
fprintf(stderr, "Created table with results for id %d, affected rows %lu, errcode 
%d\n", id, (unsigned long) mysql_affected_rows(db_read), mysql_errno(db_read));

/* get group and self-score */
query_len = sprintf(query, "SELECT a1, a2 FROM t1,t2 GROUP BY ...");
fprintf(stderr, "QUERY: %s\nLEN: %d\n", query, query_len);

if (mysql_query(db_read, query)) {
b_abort("SELECT from BRP, Map unsuccessful: %s", mysql_error(db_read));
}
res_set = mysql_store_result(db_read);
fprintf(stderr, "SELECT FROM ResultPairs, affected rows %lu, result_set %lu rows\n", 
(unsigned long) mysql_affected_rows(db_read), (unsigned long) mysql_num_rows(res_set));

if (res_set && mysql_num_rows(res_set)){
if ((row = mysql_fetch_row(res_set)) != NULL){
mygrp = (unsigned long) atol(row[0]);
selfscore = (unsigned long) atol(row[1]);
}
mysql_free_result(res_set);
} else {
fprintf(stderr, "SELF SCORE selected no rows, skipping id %d", id);
free(query);
return 1; /* no self sacore found, but the query was OK */
}
fprintf(stderr, "selected group (%d) & selfscore (%d) results for id %d\n", mygrp, 
selfscore, id);

when both queries are uncommented the program segfaults in:

Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 1024 (LWP 11049)]
chunk_alloc (ar_ptr=0x401d0a00, nb=49) at malloc.c:2929
2929malloc.c: No such file or directory.
in malloc.c
(gdb) where
#0  chunk_alloc (ar_ptr=0x401d0a00, nb=49) at malloc.c:2929
#1  0x4011c108 in __libc_malloc (bytes=40) at malloc.c:2811
#2  0x4003c12d in my_malloc () from /usr/lib/mysql/libmysqlclient.so.10
#3  0x40037e4c in read_rows () from /usr/lib/mysql/libmysqlclient.so.10
#4  0x40039554 in mysql_read_query_result () from
/usr/lib/mysql/libmysqlclient.so.10
#5  0x400395ff in mysql_real_query () from
/usr/lib/mysql/libmysqlclient.so.10
#6  0x400393bb in mysql_query () from /usr/lib/mysql/libmysqlclient.so.10
#7  0x0804b285 in do_statistics (db_read=0x805c800, db_write=0x805fbf8,
id=102, type=3) at Stattest.c:291
#8  0x0804b82a in main (argc=6, argv=0xbb24) at Stattest.c:552
#9  0x400b8627 in __libc_start_main (main=0x804b3ec , argc=6,
ubp_av=0xbb24, init=0x8049a6c <_init>, 
fini=0x8056d00 <_fini>, rtld_fini=0x4000dcd4 <_dl_fini>,
stack_end=0xbb1c)
at ../sysdeps/generic/libc-start.c:129



when I comment either ow the two, the program runs OK. Any ideas?
Kristian


--
Dr. sc. Kristian Vlahovicek 
Protein structure & bioinformatics  Phone:  +39 0403757354
ICGEB   Fax:+39 040226555
Padriciano 99   E-mail: kristian(at)icgeb(dot)trieste(dot)it
Trieste 34012 Italy Web: http://www.icgeb.trieste.it/dna


-
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 on redhat 6.x and above

[aravind gorthy]

Hi,
I have some doubts regarding MySql on Linux
environment.
I'd like to install MySql on linux -redhat 6.x and
above.
Could you please guide me how to proceed.
I did not find a specific document on redhat 6.x and
above in the documentations provided in the site.
Thanks in advance.
Regards
Aravind



  *NEW*   over 2200 active jobs at Yahoo! Careers   *NEW*
Visit http://in.careers.yahoo.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

Error List

[Manish Mehta]

Hello Everyone ,

Some error mostly comes in MySQL;

Code Description

1 Operation not permitted

2 No such file or directory

3 No such process

4 Interrupted function call

5 Input/output error

6 No such device or address

7 Arg list too long

8 Exec format error

9 Bad file descriptor

10 No child processes

11 Resource temporarily unavailable

12 Not enough space

13 Permission denied

14 Bad address

16 Resource device

17 File exists

18 Improper link

19 No such device

20 Not a directory

21 Is a directory

22 Invalid argument

23 Too many open files in system

24 Too many open files

25 Inappropriate I/O control operation

27 File too large

28 No space left on device

29 Invalid seek

30 Read-only file system

31 Too many links

32 Broken pipe

33 Domain error

34 Result too large

36 Resource deadlock avoided

38 Filename too long

39 No locks available

40 Function not implemented

120 Didn't find key on read or update

121 Duplicate key on write or update

123 Someone has changed the row since it was read; Update with is
recoverable

124 Wrong index given to function

126 Index file is crashed / Wrong file format

127 Record-file is crashed

131 Command not supported by database

132 Old database file

133 No record read before update

134 Record was already deleted (or record file crashed)

135 No more room in record file

136 No more room in index file

137 No more records (read after end of file)

138 Unsupported extension used for table

139 Too big row (>= 16 M)

140 Wrong create options

141 Duplicate unique key or constraint on write or update

142 Unknown character set used

143 Conflicting table definition between MERGE and mapped table

144 Table is crashed and last repair failed

145 Table was marked as crashed and should be repaired

Enjoy .

Manish Mehta
E-mail: [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

Re: MySql on redhat 6.x and above

[Gordan Bobic]

On Friday 23 Nov 2001 11:27, you wrote:
> Hi,
> I have some doubts regarding MySql on Linux
> environment.
> I'd like to install MySql on linux -redhat 6.x and
> above.
> Could you please guide me how to proceed.
> I did not find a specific document on redhat 6.x and
> above in the documentations provided in the site.

Try with the RPMs. You may want to recompile it yourself to get the 
optimizations right for your application, though.

I'm running it on RH7.

Regards.

Gordan

-
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

more commands that don't work (yet)

[TD - Sales International Holland B.V.]

please CC [EMAIL PROTECTED] as i'm not a member

in addition to my earlier email this doesn't work either

regards

INPUT:
SQL> SELECT * FROM SOFTBALL
  2  MINUS
  3  SELECT * FROM FOOTBALL;

OUTPUT:
NAME

BAKER
DEAN
FALCONER

-
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

UNION/INTERSECT

[TD - Sales International Holland B.V.]

Hey there,

first of all please CC my email address as I'm no longer a member of this 
list. Recieving too much stuff already (1000+ mails a day)

Anyways I found a general SQL manual which uses oracle to show it's demos. So 
I tried some of the examples in there some work but don't do the expected 
others don't work at all.

For the questions...

This one I don't find really important. If you had a table a with a field 
tekst (text) containing "test" and a field tekst2 containing "test" according 
to the mysql course this statement
select tekst || tekst2 total from table;
should return a virtual column called total with as value
testtest
it returns a virtual column called total alright on it's value is 0
I also tried this with + instead of || in oracle this should give an error 
since it aren't numeric fields in mysql it does the same as || (or atleast so 
it appears)



INPUT:
SQL> SELECT * FROM FOOTBALL;

OUTPUT:
NAME

ABLE
BRAVO
CHARLIE
DECON
EXITOR
FUBAR
GOOBER

7 rows selected.


INPUT:
SQL> SELECT * FROM SOFTBALL;

OUTPUT:
NAME

ABLE
BAKER
CHARLIE
DEAN
EXITOR
FALCONER
GOOBER

7 rows selected.


How many different people play on one team or another?

INPUT/OUTPUT:
SQL> SELECT NAME FROM SOFTBALL
  2  UNION
  3  SELECT NAME FROM FOOTBALL;

NAME

ABLE
BAKER
BRAVO
CHARLIE
DEAN
DECON
EXITOR
FALCONER
FUBAR
GOOBER

10 rows selected.


UNION returns 10 distinct names from the two lists. How many names are on 
both lists (including duplicates)?

INPUT/OUTPUT:
SQL> SELECT NAME FROM SOFTBALL
  2  UNION ALL
  3  SELECT NAME FROM FOOTBALL;

NAME

ABLE
BAKER
CHARLIE
DEAN
EXITOR
FALCONER
GOOBER
ABLE
BRAVO
CHARLIE
DECON
EXITOR
FUBAR
GOOBER

14 rows selected.


ANALYSIS:

The combined list--courtesy of the UNION ALL statement--has 14 names. UNION 
ALL works just like UNION except it does not eliminate duplicates. Now show 
me a list of players who are on both teams. You can't do that with UNION--you 
need to learn INTERSECT. 



these both don't work. I searched the manual but don't see UNION at all, is 
it supported? I'm figuring it isn't

SQL> SELECT * FROM FOOTBALL
  2  INTERSECT
  3  SELECT * FROM SOFTBALL;

doesn't work either, i'm guessin intersect isn't implemented either?

kind regards and have a good weekend

-
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: C API problem, CREATE TABLE SELECT & SELECT

[Attila Soki]

| query_len = sprintf(query, "CREATE TEMPORARY TABLE temp SELECT ");

try it out with asprintf(). 
but you have to define at compile time the following -D_GNU_SOURCE

maybe you allocates not enough place for query. asprintf do it for you.

char *query;
int query_len;

query_len=asprintf(&query,"select...");
mysql_real_query(db_read, query, query_len);
free(query);
if (..){
...

cheers,

ati

-
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

Problem in Transaction handling

[Manoj Kumar.]

Hi,
We are using MySQL database for our project, first time. We are facing some
problem. Which are described below.
*   How to handle the transaction in MySQL. Presently when we are
passing the autocommit as false, it gives error saying it is not allowed, in
MySQL. We are not able to understand whether it is problem of configuration
or there is some other way to handle the autocommit problem.
*   Not able to connect MySQL database server from remote client. Please
tell us how we can handle this.

Any suggestion on the above issues will be welcomed, because we are new to
the MySQL environment. Hope to get some reply.


Regards,
Manoj Kumar

*
Disclaimer: The information in this e-mail and any attachments is
confidential / privileged. It is intended solely for the addressee or
addressees. If you are not the addressee indicated in this message, you may
not copy or deliver this message to anyone. In such case, you should destroy
this message and kindly notify the sender by reply email. Please advise
immediately if you or your employer does not consent to Internet email for
messages of this kind.
*

-
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 in production?

[johnlucas-Arluna]

Hi folks

I really need to use some of the new features of version 4, particularly the
UNION joins.

Has anyone had any experience with using the UNION, does it work ok and
fast?

Also, could you indicate your confidence level with regard to running ver
4.0 in production even though it's only beta? I know it's recommended for
development use now, do we know when it will be declared a stable release?

We would want to change to 4.0 very quickly, is migrating a ver 3.23.32
straightforward?

Many thanks for any help and advice.

John


-
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

Access denied for user: 'myuser@localhost'

[ice]

I'm a complete newbie in mysql, so I've got a very simple question (I hope so):

I've installed MySQL 3.23.44 on my Windows 2000Pro / IIS-5 /w PHP4 support.
I followed the installation instructions on Win2000, made the databse to run, I 
managed to set the root password as it was said in the manual, but I have a 
problem. When I try to this URL (it's access my sites home url):
http://195.244.133.***/start.php3 it doesn't show anything but:

Warning: MySQL Connection Failed: Access denied for user: 'myuser@localhost' 
(Using password: YES) in C:\Inetpub\wwwroot\php\dplib.php3 on line 523

I haven't changed anything in the mysql configuration exept the root password, 
the right directories and pathes and my my.ini looks like:

[mysqld]
basedir=c:/mysql
datadir=c:/mysql/data
skip-innodb
[WinMySQLAdmin]
Server=C:/mysql/bin/mysqld-max-nt.exe

Plz help me!




-
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: InnoDB Compiler error (as well)

[jaab]

Ashley,

On Thu, 22 Nov 2001, Ashley M. Kirchner wrote:
> And while I'm sure someone is bound to tell me to stop using
> RedHat's GCC 2.96 because of "bad code", I'm sorry.  Everything else
> that I need/use compiles just fine and I never have problems with them,
> except MySQL.

I would strongly recommend that you try the precompiled version you can
find on ftp.mysql.com and various mirrors. We have a fairly heavily laden
DB at http://www.20min.ch/, and after struggling with random crashes and
hangs, and trying various kernel and Linux distribution upgrades (probably
just adding confusion and possible error spots to the mess), I finally
decided to drop my notion of "doing it myself" and just downloaded the
latest MySQL-Max tarball. After that everything has been blissfully
silent.

Remark: installing the tarball might seem not-so-good, working on a
RPM-based (or any other package-based) system. However, the installation
is perfectly self-contained; just untar it to wherever you want it, and if
you later on think that it's no good, just delete that on directory and
it's gone. Brilliant if you ask me. And working software saves money, too.

Sincerely,
Jan

--
Mr. Jan-Aage Bruvoll IT Project Manager
20 Min Holding, Thurgauerstrasse 40, CH-8050 Zurich
Zurich office: +41 1 307 4293,  fax: +41 1 307 4281
Office/fax: +44 2072408283   Mobile: +44 7740291600


-
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 performance on different OS-es

[Ales Vaupotic]

Hello, list!

Has anyone made a test to find out under which OS MySQL performs best given
the same hardware? How much is the difference? I am a new user and I have to
choose a system. I am looking at Linux, Solaris or Win on x86.

Thanks,

Ales.


-
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: MySQL Field Names

[Sinisa Milivojevic]

David Ayliffe writes:
> Can I assume that you can't have a field in a table which is named
> 'Integer' or 'Datetime' or 'Byte'
> 
> Any input?
> I've had a quick look but I can't see much
> 
> Thanks lots
> David Ayliffe

Hi!

BYTE should be quite possible.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.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

Re: Question on auto_increment

[Carl Troein]

Alex Dowgailenko writes:

> If the colum is set to unique, it will fill in 2. If not, it'll
> automatically goto 4 (or vice versa if I'm mistaken).
> 
> > I knew that if record at the Largest number of index being delete, the
> > number will be reused, but i have  a question:
> > what happen if i delete the record which the index number is between the
> > largest and the smallest, let say "i have 3 records within my
> > table, by some
> > reason, i got to delete the record in index 2 which is between 1
> > and 3, then
> > will it leave a index gap between or it will move the record of index 3 up
> > to index 2???

You're both wrong. You should test it, and see for yourselves that
unless you're using the old and obsolete ISAM table format,
auto_increment values are NEVER reused. This, of course, is true if
the auto_increment is on the first part of an index, and you don't
delete all rows in the table with a DELETE without a WHERE.

//C

sql

-- 
 Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
 Amiga user since '89, and damned proud of it too.


-
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: MySql on redhat 6.x and above

[EdwardSPL]

aravind gorthy wrote:

> Hi,
> I have some doubts regarding MySql on Linux
> environment.
> I'd like to install MySql on linux -redhat 6.x and
> above.
> Could you please guide me how to proceed.
> I did not find a specific document on redhat 6.x and
> above in the documentations provided in the site.

Hello,

I'm using MySQL with RH 6.x...

Edward.





-
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: Question on auto_increment

[Alex Dowgailenko]

If the colum is set to unique, it will fill in 2. If not, it'll
automatically goto 4 (or vice versa if I'm mistaken).

> -Original Message-
> From: Jack [mailto:[EMAIL PROTECTED]]
> Sent: November 23, 2001 7:46 AM
> To: Mysql List
> Subject: Question on auto_increment
>
>
> I knew that if record at the Largest number of index being delete, the
> number will be reused, but i have  a question:
> what happen if i delete the record which the index number is between the
> largest and the smallest, let say "i have 3 records within my
> table, by some
> reason, i got to delete the record in index 2 which is between 1
> and 3, then
> will it leave a index gap between or it will move the record of index 3 up
> to index 2???
>
> Thx
>
> Jack
>
>
> -
> 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

Question on auto_increment

[Jack]

I knew that if record at the Largest number of index being delete, the
number will be reused, but i have  a question:
what happen if i delete the record which the index number is between the
largest and the smallest, let say "i have 3 records within my table, by some
reason, i got to delete the record in index 2 which is between 1 and 3, then
will it leave a index gap between or it will move the record of index 3 up
to index 2???

Thx

Jack


-
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 Field Names

[David Ayliffe]

Can I assume that you can't have a field in a table which is named
'Integer' or 'Datetime' or 'Byte'

Any input?
I've had a quick look but I can't see much

Thanks lots
David Ayliffe



-
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: MySQL performance on different OS-es

[Simon Green]

Ales
It would be a good start to look at the OS on its own.
Latest Linux versions are fast.
Solaris is not the fastest but is rock solid.
Win...well is windows.
So this info will reflect on what you run.
But how fast a system do you need? MySQL is very fast and so even on a low
spec system you should not have problems.

Simon

-Original Message-
From: Ales Vaupotic [mailto:[EMAIL PROTECTED]]
Sent: 23 November 2001 12:22
To: MySQL list
Subject: MySQL performance on different OS-es


Hello, list!

Has anyone made a test to find out under which OS MySQL performs best given
the same hardware? How much is the difference? I am a new user and I have to
choose a system. I am looking at Linux, Solaris or Win on x86.

Thanks,

Ales.

-
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: MYSQL 4.0 in production?

[Sinisa Milivojevic]

johnlucas-Arluna writes:
> Hi folks
> 
> I really need to use some of the new features of version 4, particularly the
> UNION joins.
> 
> Has anyone had any experience with using the UNION, does it work ok and
> fast?
> 
> Also, could you indicate your confidence level with regard to running ver
> 4.0 in production even though it's only beta? I know it's recommended for
> development use now, do we know when it will be declared a stable release?
> 
> We would want to change to 4.0 very quickly, is migrating a ver 3.23.32
> straightforward?
> 
> Many thanks for any help and advice.
> 
> John
> 

Hi!

There are (still) no reported problems with UNION's.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.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

does lmysqlclient.so exist in 3.23.44 ?

[Erik Price]

Well, I asked a lengthy question earlier with all kinds of extraneous
information pertaining to my problem.  Allow me to re-ask in a more
simple fashion --

does a file called 'lmysqlclient.so' exist in MySQL 3.23.44 ?  I built
this distribution from source and cannot find it anywhere.  I need it
for my PHP4 > Apache DSO compile.

Thank you,

Erik

__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1

-
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: does lmysqlclient.so exist in 3.23.44 ?

[Ravi Raman]

Hi again.

Why were you compiling php against the mysql source rather than using the
built-in mysql support in php?
>From what I've read, it's probably more trouble than it's worth on OSX...

-ravi.

-Original Message-
From: Erik Price [mailto:[EMAIL PROTECTED]]
Sent: November 23, 2001 10:10 AM
To: [EMAIL PROTECTED]
Subject: does lmysqlclient.so exist in 3.23.44 ?


Well, I asked a lengthy question earlier with all kinds of extraneous
information pertaining to my problem.  Allow me to re-ask in a more
simple fashion --

does a file called 'lmysqlclient.so' exist in MySQL 3.23.44 ?  I built
this distribution from source and cannot find it anywhere.  I need it
for my PHP4 > Apache DSO compile.

Thank you,

Erik

__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1

-
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

Mysql as a backend to openldap

[Morten Dreier]

I want to set up a openldap server that should import data from some 
tables on my mysql server.
There are different strategies.
1. Use the perl scripting APIs in OpenLdap
2. Go by way of BerkleyDB files
3. Some way of direct (odbc?) communication.

Does anyone have any experience with this?

-- 
Morten


-
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

FULLTEXT search and InnoDB tables

[Pedro Tiago dos Santos Monteiro]

I've searched carefully the online manual before I decide to write this,
however, there's always a change that I have missed something along the
way ...

Is there any problem in using FULLTEXT indexes with InnoDB tables?
Check this out:
 
(MySQL 3.23.43 compiled with CXXFLAGS=-DDONT_USE_DEFAULT_FIELDS and with
default-table-type=InnoDB)

mysql> CREATE Table Phrase (phrase_id INTEGER NOT NULL AUTO_INCREMENT,
phrase_data VARCHAR(255), FULLTEXT (phrase_data), PRIMARY KEY
(phrase_id));
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO Phrase (phrase_data) VALUES ('mysql is the
greatest');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Phrase (phrase_data) VALUES ('but fulltext searches
seem to have a problem');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Phrase (phrase_data) VALUES ('hope this example helps
us to understand what\'s wrong');
Query OK, 1 row affected (0.00 sec)

mysql> SELECT MATCH (phrase_data) AGAINST ('mysql') FROM Phrase;
+---+
| MATCH (phrase_data) AGAINST ('mysql') |
+---+
|  NULL |
|  NULL |
|  NULL |
+---+
3 rows in set (0.00 sec)

mysql> SELECT MATCH (phrase_data) AGAINST ('understand') FROM Phrase;
++
| MATCH (phrase_data) AGAINST ('understand') |
++
|   NULL |
|   NULL |
|   NULL |
++
3 rows in set (0.00 sec)


Now with a 3.23.41 (fresh install - Mandrake 8.1 RPM):

mysql> CREATE Table Phrase (phrase_id INTEGER NOT NULL AUTO_INCREMENT,
phrase_data VARCHAR(255), FULLTEXT (phrase_data), PRIMARY KEY
(phrase_id));
Query OK, 0 rows affected (0.08 sec)

mysql> INSERT INTO Phrase (phrase_data) VALUES ('mysql is the
greatest');
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO Phrase (phrase_data) VALUES ('but fulltext searches
seem to have a problem');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO Phrase (phrase_data) VALUES ('hope this example helps
us to understand what\'s wrong');
Query OK, 1 row affected (0.02 sec)

mysql> SELECT MATCH (phrase_data) AGAINST ('mysql') FROM Phrase;
+---+
| MATCH (phrase_data) AGAINST ('mysql') |
+---+
|  0.67756324121582 |
| 0 |
| 0 |
+---+
3 rows in set (0.00 sec)

mysql> SELECT MATCH (phrase_data) AGAINST ('understand') FROM Phrase;
++
| MATCH (phrase_data) AGAINST ('understand') |
++
|  0 |
|  0 |
|   0.66266459031789 |
++
3 rows in set (0.00 sec)


Can anyone tell me what's wrong with the first one?

Thanks in advance

Pedro


-
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