RE: Connection Terminated

[Venu]

Hi Prabhu, 

> -Original Message-
> From: Prabhu Venkata [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 22, 2001 11:14 PM
> To: '[EMAIL PROTECTED]'
> Subject: Connection Terminated
> 
> 
> Hi all
> 
> I have my mysql database installed on NT.
> I have written small VB application to upload .txt files into database.
> If I work from NT to NT is working fine.
> 
> If I install my vb application on Win98 and having the database at NT then
> after couple of line reading from the text file. It gives me an error
> stating "Cannot connect to mysql on Server {ip address}".

This means that, the driver is not able to connect to the server specified
using either the m/c name or IP address. Check your network and/or ISP 
issues. Are you able to ping to the specified host/IP ?

Regards, venu
-- 
For technical support contracts, go to https://order.mysql.com
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /  Mr. Venu <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/  /_/\_, /___/\___\_\___/ California, USA
   <___/ www.mysql.com


> 
> Remember it upload the file and write to the databases after sometime only
> it gives an error.  There is no error in SQL Insert command.
> 
> Using Novell Netware.
> 
> What would be the reason for it.
> 
> I am really struggling to get this done.
> 
> Thanx for your timely help.
> 
> Regards
> Prabu
> 
> 
> -
> 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

corrputed tabel questions...database,sql,query,table

[Jim Ray, @WD]

database,sql,query,table
database,sql,query,table

If you just reply to this message, and include the entire text of it in the
reply, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. Just typing the word MySQL once will be sufficient, for example.

You have written the following:

I have a tabel that seems to be corrupted. Is there a way to fix it?  It is
running on a Lynx box.

Thank you

Jim R.


-
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

Compile errors...GCC or MySQL?

[Ashley M. Kirchner]

Okay, so I decided to test a few things out.  If I try to compile
mysql+gemini-3.23.41 with no additional options, everything compiles
fine, and MySQL works just fine.  However, if I add --with-gemini to my
configure line, it bombs during compile with:

gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../incl -I../msgs -O3 -DDBUG_OFF -c
dsmindex.c
In file included from dsmindex.c:39:
/usr/include/string.h:245: parse error before `('
/usr/include/string.h:245: warning: conflicting types for built-in
function `memset'
/usr/include/string.h:245: parse error before `int'
make[4]: *** [dsmindex.o] Error 1
make[4]: Leaving directory
`/usr/local/src/mysql+gemini-3.23.41/gemini/api'

And, if I try using --with-innodb, it bombs with:

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 1
make[4]: Leaving directory
`/usr/local/src/mysql+gemini-3.23.41/innobase/sync'


Okay, so why does it compile, and function just fine when no options
are specified, and it blows up miserably whenever I try to use either
Gemini or InnoDB?

System is still RH 7.1, with GCC 2.96 (no, it hasn't changed since I
posted earlier, and I'm not about to go through the hassle of
downgrading my GCC just because MySQL can't compile properly, when every
other application does - I find it hard to justify pointing a finger at
GCC for this.)

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



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

[Venu]

Hi Satish, 

> -Original Message-
> From: K. Satish Kumar [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 22, 2001 10:55 PM
> To: [EMAIL PROTECTED]
> Cc: Apparsamy perumal
> Subject: Driver problem
> 
> 
> Hi!
> 
> This is Satish.  I am using your mysql software for administering my
> database.  We have developed an application using VB as the front end and
> mysql as the back end on all the windows plaforms(NT, 95,98,2000,ME). The
> problem where we are facing is while installing the driver.  It works fine
> with NT and not with any other windows platform and we are exhausted hunting
> for the reason.  The installation quits telling that a particular .dll is
> already running and sometimes quits from the installation.
> 
> It would be highly appreciable if you would look into the matter and give us
> a right solution at the earliest since we are struggling with the software
> very badly.

Please read the manual from www.mysql.com/doc (section 8.3.1), 
which has the detailed information on what needs to be done 
when the above installation error occurs.

http://www.mysql.com/doc/I/n/Installing_MyODBC.html

> 
> And hope you don't make us to feel bad for selecting your software by
> delaying the reply.  Also, if the mail id what I have chosen for my query is
> not right suggest me the right mail id/site where I can get the solution
> immediately.
> 
This is also a right place, but use [EMAIL PROTECTED] for any 
MyODBC related queries.

Regards, venu
-- 
For technical support contracts, go to https://order.mysql.com
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /  Mr. Venu <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/  /_/\_, /___/\___\_\___/ California, USA
   <___/ 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

Connection Terminated

[Prabhu Venkata]

Hi all

I have my mysql database installed on NT.
I have written small VB application to upload .txt files into database.
If I work from NT to NT is working fine.

If I install my vb application on Win98 and having the database at NT then
after couple of line reading from the text file. It gives me an error
stating "Cannot connect to mysql on Server {ip address}".

Remember it upload the file and write to the databases after sometime only
it gives an error.  There is no error in SQL Insert command.

Using Novell Netware.

What would be the reason for it.

I am really struggling to get this done.

Thanx for your timely help.

Regards
Prabu


-
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

Driver problem

[K. Satish Kumar]

Hi!

This is Satish.  I am using your mysql software for administering my
database.  We have developed an application using VB as the front end and
mysql as the back end on all the windows plaforms(NT, 95,98,2000,ME). The
problem where we are facing is while installing the driver.  It works fine
with NT and not with any other windows platform and we are exhausted hunting
for the reason.  The installation quits telling that a particular .dll is
already running and sometimes quits from the installation.

It would be highly appreciable if you would look into the matter and give us
a right solution at the earliest since we are struggling with the software
very badly.

And hope you don't make us to feel bad for selecting your software by
delaying the reply.  Also, if the mail id what I have chosen for my query is
not right suggest me the right mail id/site where I can get the solution
immediately.

Thank you,

Regards,

Satish.



-
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

Mac OS X text encoding

[Kundan Kumar]

Hi all,

I need to read some tab delimited text files into mysql. The files are in
Mac Roman (Western) encoding. This encoding support is not there in the
default installation of Mysql.

Can anybody provide me the pointers as to from where can I get a binary
distribution for Mac OS X with support for Mac Roman Western encoding.

Any idea on how to configure Mysql if there is none...

Thanks for help,
With regards,
Kundan



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

[Venu]

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


-
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: OS omissions from manual?

[Paul DuBois]

At 4:21 PM -0500 11/21/01, Kurt Tappe wrote:
>Why does the MacOS X build of MySQL 3.23 include a "manual.html" 
>that contains install instructions for only Linux and Windows?  I'm 
>stuck trying to figure out how to install this thing.  MacOS has no 
>"groupadd" command (due to the existence of the NetInfo system), so 
>the manual install instructions are unusable from step #1 as well.

Then use NetInfo to add a user and group.

http://www.latencyzero.com/macosx/mysql.html
http://www.entropy.ch/software/macosx/mysql/

>
>Thanks,
>-Kurt
>--
>I haven't failed, I've found 10,000 ways that don't work.
>   --  Benjamin Franklin

-
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 each database connect cause mysqld to fork?

[Paul DuBois]

At 7:14 PM -0800 11/21/01, Bennett Haselton wrote:
>Each time I open a database handle (in perl code), does that cause a 
>new process to run, a new instance of mysqld?  And each time I 
>disconnect the database handle ($dbh->disconnect() in perl code), 
>does that cause the number of running instances of mysqld to go down 
>by one?

This is explained in the manual.

http://www.mysql.com/doc/L/i/Linux.html says:

When using LinuxThreads you will see a minimum of three processes
running. These are in fact threads. There will be one thread for the
LinuxThreads manager, one thread to handle connections, and one
thread to handle alarms and signals.


So what you're seeing is the way Linux reports threads as processes.

>
>The process list on my Linux server includes several instances of mysqld:
>
>server1:/home/bhaselto/web/html$ ps auwx | grep mysqld
>root  1014  0.0  0.0  16720 ?SW   Nov05   0:00 [safe_mysqld]
>mysql 1037  0.0  3.6 15172 9484 ?SNov05  22:10 
>/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
>mysql 1039  0.0  3.6 15172 9484 ?RNov05  19:02 
>/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
>mysql 1040  0.0  3.6 15172 9484 ?SNov05   0:04 
>/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
>mysql 4518  0.0  0.0 00 ?Z21:07   0:00 
>[mysqld ]
>mysql 4519  0.0  3.6 15172 9484 ?R21:07   0:00 
>/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
>
>so I was wondering if that was the explanation -- I know I have 
>multiple running scripts that use the database at the same time, 
>although I thought they generally didn't leave the handles open that 
>long.
>
>   -Bennett
>
>[EMAIL PROTECTED] http://www.peacefire.org
>(425) 649 9024


-
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

SQL Problem

[Manish Mehta]

Hello Everyone,

I wants to find the max. date and Login status of employee for Attendance
table.
The qurey runs fine but it shows me the wrong status.

select max(a.dAtt_Date),a.nLog_Status from tbl_attendance a,tbl_attendance b
where a.nEmp_id = 1 and a.nLog_Status = b.nLog_Status
group by b.nEmp_id

for example :- the data is

dAtt_Date nLog_Status
- ---
2001-11-20 2
2001-11-22 1
2001-11-23 1
2001-11-24 1
2001-11-24 2

Result is

max(a.dAtt_Date) nLog_Status
  -
2001-11-24 2
2001-11-20 2

Thanks


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

InnoDB Compiler error (as well)

[Ashley M. Kirchner]

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 1
make[4]: Leaving directory
`/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.



-
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

[Chris Cooper]

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

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

>>output
mysql> CREATE TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY, message
CHAR(20));
Query OK, 0 rows affected (0.02 sec)

mysql> CREATE TABLE t2 (a INT AUTO_INCREMENT PRIMARY KEY, message
CHAR(20));
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO t1 (message) VALUES ("Testing"),("table"),("t1");
Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> INSERT INTO t2 (message) VALUES ("Testing"),("table"),("t2");
Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> CREATE TABLE total (a INT NOT NULL, message CHAR(20), KEY(a))
TYPE=MERGE UNION=(t1,t2) INSERT_METHOD=LAST;
ERROR 1064: You have an error in your SQL syntax near
'INSERT_METHOD=LAST' at line 1
>>end_output

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

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

--
coop




-
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

Different tables and their purposes

[v0idnull]

Hey, I was reading over some of the stuff on this list, and I was just
wondering, where I could find information on the different types of tables
and their purposes since I really don't know this... :/

1vs0 - Design by Dreams


-
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

Using ColdFusion with MySQL

[Sparta Cruz]

Has anyone setup MySQL 3.23.44 with ColdFusion 5.0 Enterprise Edition.  I
have heard that there may be problems with transactions.  I was wondering if
anyone knew how to do this, and if they could point me to some reading
material.

I was also wondering if MySQL 4.0 would include transactions and stored
procedures, and if so, when it would most likely be stable.  Note I have not
used 4.0, and was wondering if it would be advisable to use if I would be
populating it with a lot of data, and running intense queries with respect
to stability?


-
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

got the error when trying to run mysqld

[Wattanapol]

when I try to run mysqld on Solaris 2.6
there are the errors like this

ld.so.1:mysqld fatal : libCrun.so.1 :open failed : No such file or directory

please help me , thank you very much


-
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 and encryption

[Michael Widenius]

Hi!

> "Ken" == Ken Kinder <[EMAIL PROTECTED]> writes:

Ken> Monty, is this like a product you're selling? I would like more information, 
Ken> although I haven't gotten to this yet in my security sweep.

This is something a customer of our is sponsoring and that we will put
into MySQL 4.0 as soon as it's ready.

We will probably also make available a patch for 3.23, but we don't
have any plans to put this code into the standard 3.23 code tree to
not accidently break anything for a lot of users..

>> We are working on a solution to this which will be available in about
>> 3 weeks. Some of the features of this are:
>> 
>> - We will use a strong encryption function: (des_encrypt()/des_decrypt())

...

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

remove duplicates

[Malkova]

Hi all,

Is there anyway to delete the duplicate records in mysql
without creating new tables. I am wondering what query
will achieve this task where mysql doesnt supports like ROWID and sub queries.

I appreciate if some one help me out.

thankyou.
-malkova. 


-
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

Upgrade gcc on Linux

[Mike(mickalo)Blezien]

Please excuse the OT posting, but I'm am somwhat in a bind and wasn't sure where
to post this question. and I've many references to upgrading from the gcc 2.91
to 2.95

I've installed all the dependency for gcc 2.95.1 and when I attempt to install
the rpm gcc-2.95.1 I keep getting this message:

[justligh@justlightening ~]# rpm -ivh gcc-*
Preparing...### [100%]
file /usr/bin/egcs from install of gcc-2.95.1-3 conflicts with file from package
egcs-1.1.2-30
file /usr/bin/gcc from install of gcc-2.95.1-3 conflicts with file from package
egcs-1.1.2-30
file /usr/bin/gcov from install of gcc-2.95.1-3 conflicts with file from package
egcs-1.1.2-30
file /usr/bin/i386-redhat-linux-gcc from install of gcc-2.95.1-3 conflicts with
file from package egcs-1.1.2-30
file /usr/bin/protoize from install of gcc-2.95.1-3 conflicts with file from
package egcs-1.1.2-30
file /usr/bin/unprotoize from install of gcc-2.95.1-3 conflicts with file from
package egcs-1.1.2-30
file /usr/i386-redhat-linux/lib/libiberty.a from install of gcc-2.95.1-3
conflicts with file from package egcs-1
.1.2-30

Not being fimilar with rpm's could some one be so kind, reponding off the list,
as what is need to upgrade our gcc compilier..

Much appreciated and again, my appologise to the list for the OT posting

database mysql

Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=


-
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 
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

4.0.0 on Linux: errmsg.sys not found; some docu bugs.

[Axel Boldt]

Hi,

using the binary distribution mysql-4.0.0-alpha-pc-linux-gnu-i686, installed 
in the standard location /usr/local, running on 
Debian GNU Linux, I noticed the following buglets:

INSTALL-BINARY and manual.txt both refer to bin/safe_mysqld which doesn't 
exist; they mean bin/mysqld_safe.

  ---

Symptom: After following all instructions in INSTALL-BINARY and running 
bin/mysqld_safe in /usr/local/mysql, the server dies immediately. The 
error log file shows the message

   /usr/local/mysql/bin/mysqld: Fatal error: Can't find messagefile 
'mysql-4.0.0-alpha-pc-linux-gnu-i686/share/mysql/english/errmsg.sys'

This file is in /usr/local/mysql-4.0.0-alpha-pc-linux-gnu-i686/share/mysql/english, 
but apparently the server doesn't look there. Symlink from /usr/local/mysql to 
/usr/local/mysql-4.0.0-alpha-pc-linux-gnu-i686 is in place.

Work around: start mysqld from /usr/local/mysql as 
  bin/mysqld_safe --language=/usr/local/mysql/share/mysql/english

  ---

Symptom: When starting mysql-test-run, the alias test reports "fail", the 
script complains that "time was not found", then stops.

Reason: the mysql-test-run script uses the "time" command as $TIME (line 956);
this doesn't work in my bash (2.04) since "time" is a shell builtin. 
Replacing $TIME by time will fix it and all tests pass.

  ---

The benchmark tests work only with perl and DBI.pm installed; that should be 
documented somewhere.

Thanks,
  Axel


>Severity:  non-critical
>Priority:  low
>Category:  mysql
>Class:   sw-bug, doc-bug
>Release: mysql-4.0.0-alpha (Official MySQL binary)

>Environment:   Debian GNU Linux distribution
System: Linux justin 2.2.18pre21-compact #1 Sat Nov 18 09:23:46 MST 2000 i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.2/specs
gcc version 2.95.2 2220 (Debian GNU/Linux)
Compilation info: CC='gcc'  CFLAGS='-O3 -mpentium '  CXX='gcc'  CXXFLAGS='-O3 
-mpentium  -felide-constructors'  LDFLAGS='-static'
LIBC: 
lrwxrwxrwx1 root root   13 Jul  5 15:58 /lib/libc.so.6 -> libc-2.2.3.so
-rwxr-xr-x1 root root  1124904 Jun 10 09:50 /lib/libc-2.2.3.so
-rw-r--r--1 root root  2543574 Jun 10 09:52 /usr/lib/libc.a
-rw-r--r--1 root root  178 Jun 10 09:52 /usr/lib/libc.so
Configure command: ./configure  --prefix=/usr/local/mysql '--with-comment=Official 
MySQL binary' --with-extra-charsets=complex --with-server-suffix= 
--enable-thread-safe-client --enable-assembler --with-mysqld-ldflags=-all-static 
--with-client-ldflags=-all-static --disable-shared



-
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: indexing question

[Richard R. Harms]

If you have an index consisting of member_id & mail_id (opposite 
order), you'll need just one index.

A good explanation of why may be found at:

http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Optimisation.html#Multiple-column_indexes

-rh

>I for sure need an index on the mail_id field (the primary key will be
>between member_id and mail_id), so an index of mail_id AND member_id makes
>sense. This index would work for queries like:
>
>WHERE mail_id = XXX
>WHERE mail_id = XXX AND member_id = YYY
>
>However, that leaves out queries like:
>
>WHERE member_id = YYY
>
>That is also a query I need to be able to do on a regular basis, and if this
>query yields 20,000 results, with 5 million rows in the table, it's going to
>take forever (I assume).
>
>So I was thinking about making two indexes:
>
>mail_id AND member_id
>member_id
>
>Would this take up way too much disk space?

-
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: Export just part of a table to a CSV file

[Richard R. Harms]

Check out the 'INTO OUTFILE' portion of the SELECT statement.

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SELECT

-rh

>Hello all,
>
>Usually I back-up my tables importing them to .csv files.
>
>What I do is I issue the following command :
>
>mysqldump - h localhost -u
>user -ppassword --tab="/tmp" --fields-terminated-by=";" database_name
>table_Name > table.csv
>
>This creates a file called table.csv by dumping all the contents of
>table_Name of database_name database and separating their fields
>with a ;.
>
>
>What I would like to do is to do the same but with an SQL statement.
>Meaning, I would like to dump just part of the table through a SQL
>statement.
>
>Is there any way to do it?
>
>
>Thank you,
>
>Carlos Fernando.
>
>
>-
>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 update part of a field ?

[Richard R. Harms]

Take a look at using a regular expression in the where clause of the 
UPDATE SQL statement to match them.

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#IDX1206 
http://www.mysql.com/documentation/mysql/bychapter/manual_Regexp.html#Regexp

 From there, MySQL's string functions - LOCATE() to find the domain 
you want to replace, inside a SUBSTRING function to pull out just the 
'email1@' part, inside a CONCAT() function to append the new domain 
onto the end.

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#String_functions

Its not too hard once you play with the string functions a little bit 
- be careful and make a table with some test data before doing it on 
the real data.

-rh

>Hello all,
>
>I've got some e-mails addresses on an e-mails database where one domain has
>been changed to another.
>
>So I have :
>
>email1@domain1
>email2@domain1
>
>I need to change @domain1 to @domain2 on this e-mail field and keep the user
>name.
>
>Some e-mails of an specific ISP had their domains changed but the usernames
>remained the same. So I need to update this table that has some hundreds
>addresses of this particular domain that had been changed.
>
>Is there any way to do it through a SQL statement?
>
>Thank you,
>
>Carlos Fernando.
>
>
>Linux User #207984
>
>
>-
>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: Problem: myisamchk: error: Checksum for key....

[Grzegorz Paszka]

Hi.

I hope I've solved problem with mysql. 

I've contacted with my motherboard vendor (Asus) and technical support suggest
me to upgrade bios. It is standard answer IMHO :), I haven't believed it can
help. But it helped. Now everything looks OK.

I'm sorry that I couse confusion. 
Best regards.
-- 
Grzegorz

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

[Miguel Angel Solórzano]

At 10:04 22/11/2001 +, Sandeep Murthy wrote:
Hi,

When you are having problems for to start the server as service on
NT/Win2000 machine. Follow the below troubleshooting:

1- Enter in the \mysql\bin directory opening a DOS prompt screen.
2- Execute the remove service command with any server e.g.:
mysqld-max-nt --remove
Even the service doesn't exist, this command doesn't create any
problem.
IMPORTANT: When performing command for install and remove the
   MySQL service in the shell prompt, the SCM (Service
   Control Manager) should be closed.
3- Now with the SCM (Service Control Manager) take a look if effectively
the service called mysql doesn't exists.
If you see, the service above this means that for any reason your
SCM is in bad state, so you need to re-boot the machine.
4- If you are using any Max server:
mysqld.exe
mysqld-max.exe
mysqld-max-nt.exe
You should need the use of the /winnt/my.ini file for to set the
variables for InnoDB table or adding the variable skip-innodb if
you don't want to use this type of table. You need to read
complementary instructions for to set the InnoDB in our Manual.
Also if you installation directory is other than the default
c:\mysql, you need to set the variables basedir and datadir.
Below I show you, the my.ini file that there is on my machine,
as a sample:

[mysqld]
basedir=c:\mysql
datadir=c:\mysql\data
innodb_data_file_path = ibdata1:200M
innodb_data_home_dir = c:\ibdata
set-variable = innodb_mirrored_log_groups=1
innodb_log_group_home_dir = c:\iblogs
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=30M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_arch_dir = c:\iblogs
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=80M
set-variable = innodb_additional_mem_pool_size=10M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50

You should use the notepad.exe or other ASCII editor like the
edit.exe or Xemacs for Win32 for to create the my.ini file.
5- Back for the DOS screen shell.
Do the below command with the server you want, e.g.:

Microsoft Windows 2000 [Versão 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.

C:\>cd\mysql\bin

C:\mysql\bin>mysqld-max-nt --standalone --console
011122 21:54:27  InnoDB: Started
mysqld-max-nt: ready for connections

In the sample above I had a successfully start. However below I
show you, a failed start:

C:\mysql\bin>mysqld-max-nt --standalone --console

mysqld-max-nt: Fatal error: Can't find messagefile
'c:\mysql\share\english\errmsg.sys'

011122 21:57:03  Aborting

Then how you can guess that the purpose to try the server as
standalone mode is to find the message error which cause the
failed start. Also you can find in the /mysql/data/mysql.err
file, useful information about.
6- If necessary fix the problems found in the step above.
7- Stop the server using the mysqladmin tool:
mysqladmin shutdown
Maybe you need to perform twice the command above. This problem
should will fixed as soon as possible.
8- Install the service:
mysqld-max-nt --install
9- Start the service:
net mysql start

I hope this help you.

Regards,
Miguel

>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

-- 
For technical support contracts, goto https://order.mysql.com/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Miguel A. Solórzano <[EMAIL PROTECTED]>
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Mogi das Cruzes - São Paulo, Brazil
<___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To req

Re: Gemini compile error

[Arjen G. Lentz]

Hi Ashley,

- Original Message -
From: "Ashley M. Kirchner" <[EMAIL PROTECTED]>


> While compiling MySQL+Gemini-3.23.41 i received the following error:
> [...]
> System is RedHat 7.1, with their GCC 2.96-85

No idea about Gemini, but we do have an advisory against using gcc 2.96 on
RedHat to compile MySQL, it appears to produce faulty code. We currently use
gcc 2.95 to create our binary distribution.


> While I'm on the subject, does BDB tables provide the same type of
> locking that Gemini does?  Is there any reason to favor Gemini over BDB?

BDB locks on page level. You'll want to have a look at the InnoDB tables,
which provide row-level locking and many other features. See
http://www.mysql.com/doc/I/n/InnoDB.html

If you're just starting out, I would recommend you grab the latest version
from www.mysql.com (3.23.44 or 4.0.0 at the time of writing this message, but
3.23.45 will be out soon).
Also, only compile from source if you really need to, otherwise it is
recommended to use the binaries as provided by MySQL AB which have been
compiled with optimal settings, and tested with our test suite before release.


Regards,
Arjen.

--
MySQL Training Worldwide, http://www.mysql.com/training/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Technical Writer
/_/  /_/\_, /___/\___\_\___/   Brisbane, QLD Australia
   <___/   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: Gemini compile error

[Paul DuBois]

At 9:43 AM +0100 11/22/01, Attila Beno wrote:
>-BEGIN PGP SIGNED MESSAGE-
>Hash: SHA1
>
>On Thu, 22 Nov 2001, Ashley M. Kirchner wrote:
>
>>  While compiling MySQL+Gemini-3.23.41 i received the following error:
>>
>>  System is RedHat 7.1, with their GCC 2.96-85
>
>Same here, althogh the binary version starts up fine.
>
>>  While I'm on the subject, does BDB tables provide the same type of
>>  locking that Gemini does?  Is there any reason to favor Gemini over BDB?
>
>While on the subject: has anyone seen a WORKING gemini table? I've tried 2
>different redhat systes, and 3 different debian systems, and always got
>the same result: starts up fine, dies in about 15 seconds, safe_mysqld
>tries to bring it up, so it recoveres from the crash, repeats the whole
>thing a few times, and then no longer recovers.

I've not had any problems with GEMINI tables, though I've seen something
like what you describe with BDB tables.

RedHat 7.0, gcc 2.96-85.

-
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: opinion - voating

[Paul DuBois]

At 12:45 PM -0500 11/21/01, Auri Net SAC wrote:
>Hi
>
>it is possible
>
>"select * from table where col1 <= now and col2>=now"
>
>where col1 and col2 are date type
>
>thnaks

Yes, except that it should be now() rather than now.

-
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

HOW TO : Run wave files stored in BLOB field ???

[Delphi Guy's]

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








=

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

Thanks in advance

__
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: default values

[Carl Troein]

Mark writes:

> When I do a describe statement, I see some default values assigned
> automatically to columns in the table.  What statement will assign a column
> to blank, so that there is no default value assigned?

Short answer: you can't. There was a long thread about this a week
or two ago, and apparently the lack of default-free columns is due
to some internal details, as well at to the paradigm of letting
applications verify data instead of having the RDBMS do it.
Note though that for strings, ENUMs and SETs you can specify a
default of '', the special ENUM value '' and the empty set
respectively. Also, columns that can be NULL can have a default
of NULL.

On an altogether unrelated matter: Your time zone is set to
pacific time, but your time reveals that you're somewhere on
the American east coast. You might want to correct your TZ.

//C - defaults to being tired

-- 
 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 Newbie and Access Database

[Venu]

Hi Jose,

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jose
> Gerardo Amaya Giron
> Sent: Thursday, November 22, 2001 1:11 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL Newbie and Access Database
>
>
> Hello all, I just start up with mysql so I have some stupid questions to
> ask.
>
> right now I have an MS Access database with one table that has 25 fields
> and like 2000 records in it. I'm trying to move to MySQL in order to
> have a better DB. I can define the database and the table manually
> that's not a problem, My problem is how can I export the 2000+ records
> from the Access DB to MySQL DB. does an export file from access do the
> job???
> I read a little bit about myODBC, does myODBC help me in this situation,
> does it help me export all the records to the new database???

Yes. You can make use of MyODBC to export tables and/or associted
data from MS Access to MySQL.

Here is the snippet from new MyODBC manual on how to export data
from MS Access to MySQL.

Q. Export a table or query to MySQL using MyODBC data source

Note: You can only export a table or query to MySQL server,
  if you have installed the latest MyODBC driver 2.50.38
  or grater, else you will experince problems with text
  and varchar data types.

1. In the Database window (The window that appears when you
   open an Access database or an Access project. It displays
   shortcuts for creating new database objects and opening
   existing objects.), click the name of the table or
   query you want to export, and then on the File menu, click
   Export.

2. In the Export Object Type 'Object name' To dialog box, in the
   Save As Type box, click ODBC Databases ().

3. In the Export dialog box, enter a name for the file (or use
   the suggested name), and then click OK.

   The Select Data Source dialog box is displayed; it lists the
   defined data sources for any ODBC drivers installed on your
   computer.

4. Click either the File Data Source or Machine Data Source tab,
   and then double-click the MyODBC data source that you want to
   export to

   To define a new data source for MyODBC driver, please follow
   the instructions from:


http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#Installi
ng_MyODBC

5. Microsoft Access connects to the MySQL server through MyODBC
   data source and creates the new table in the server.


Regards, venu
--
For technical support contracts, go to https://order.mysql.com
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /  Mr. Venu <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/  /_/\_, /___/\___\_\___/ California, USA
   <___/ 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

default values

[Mark]

When I do a describe statement, I see some default values assigned
automatically to columns in the table.  What statement will assign a column
to blank, so that there is no default value assigned?


-
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: query

[Neil Zanella]

I think you want to do the following (notice the parentheses next to the
mysql function named now):

SELECT * FROM Table WHERE col1 <= now() AND col2 >= now();

Bye,

Neil

On Wed, 21 Nov 2001, Auri Net SAC wrote:

> > Hi
> >
> > it is possible
> >
> > "select * from table where col1 <= now and col2>=now"
> >
> > where col1 and col2 are date type
> >
> > thnaks
> >
> >
> > -
> > 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: bin files

[Richard Ward]

the bin log files are actually files for binary logs fused in
replication.
To do rollbacks and such, you need to use innodb table types.
Innodb has table locking, commits, rollbacks, etc and also special log
files to handle the rollbacks.
Read more about innodb table types in the Mysql help.
Otherwise, you can rotate the bin logs buy doing 
mysqladmin  flush-logs

This will create a new bin log file, incrementing the file extension by
one.
If you are not doing replication, then there is no need to have the bin
log files and you can disable them in you /etc/my.cnf (or wherever your
my.cnf file is) file by hashing out the line with:
log-bin
server-id = x   (where x is a number)
to 
#log-bin
#server-id

hope this helps.
cheers

richard ward


>>> "Richard Clarke" <[EMAIL PROTECTED]> 11/22/01 11:06PM >>>
So I have found out that mysql creates bin logs of all queries so that
it
can do rollbacks and such. But is it really necessary for it to
maintain
these logs forever so that they end up to be 10gigs + for only a few
thousand current rows.

Ric


-
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 Newbie and Access Database

[Jose Gerardo Amaya Giron]

Hello all, I just start up with mysql so I have some stupid questions to
ask.

right now I have an MS Access database with one table that has 25 fields
and like 2000 records in it. I'm trying to move to MySQL in order to
have a better DB. I can define the database and the table manually
that's not a problem, My problem is how can I export the 2000+ records
from the Access DB to MySQL DB. does an export file from access do the
job???
I read a little bit about myODBC, does myODBC help me in this situation,
does it help me export all the records to the new database???

thank you

Gerardo Amaya


-
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

bin files

[Richard Clarke]

So I have found out that mysql creates bin logs of all queries so that it
can do rollbacks and such. But is it really necessary for it to maintain
these logs forever so that they end up to be 10gigs + for only a few
thousand current rows.

Ric


-
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: argument to --with-mysql option for PHP

[Erik Price]

Happy thanksgiving everyone!  And I especially thank those involved in
MySQL development and other open source projects -- you really make the
computer world a better place for all of us!

I also have a problem that I hope some can help me with ;-)

I wrote earlier in this thread, trying to compile PHP 4.0.6 as a DSO
for Apache with MySQL.  With helpful feedback from Ravi, I used
./configure with the following options:

--with-xml --with-zlib --with-mysql=/usr/local/mysql
--with-apxs=/usr/sbin/apxs

And it compiled -- but returned a warning.  I can't copy and paste the
warning because it's on my other machine, but I have transcribed it as
verbatim as I can:

=
WARNING:
This library needs some functionality provided by -lmysqlclient.  I
have the capability to make that library automatically link in when you
link to this library.  But I can only do this if you have a shared
version of the library, which you do not appear to have.
=

This warning was repeated, and then another warning:

=
WARNING:
libtool could not satisfy all declared inter-library dependencies of
module libphp4.  Therefore, libtool will create a static module, that
should work as long as the dlopening application is linked with the
-dlopen flag.
=

I searched all over my drive for lmysqlclient.so, but could only find
lmysqlclient.?a .  (I forget the exact letter, it was either
lmysqlclient.sa or lmysqlclient.la .)  This file was located in the
source tree from the build area where I first gnutarred mysql-3.23.44 .

I'm not very familiar with the workings of compilers, but I take it
that I am missing some library needed for PHP to operate as a DSO in
Apache, and that this library is lmysqlclient.so .  I'm surprised that
it isn't located in my source compile of MySQL.  Should I download this
file from somewhere else?

If I try to run 'make install' without linking this file first, I get
the following message at the end of the install:

. . . (install messages) . . .
cp libs/libphp4.so /usr/libexec/httpd/libphp4.so
cp: libs/libphp4.so: no such file or directory
apxs:Break: Command failed with rc=1
make[1]: *** [install-sapi] Error 1
make: *** [install-recursive] Error 1
Bash2.05$

Seems that libphp4.so did not get built during the 'make'.  And I
assume that this happened because the 'make' process could not find the
lmysqlclient.so .  Am I very far off the mark in this guess?

Thanks to any who can help with this quandary!

Sincerely,

Erik Price



--- Ravi Raman <[EMAIL PROTECTED]> wrote:
> 
> You're right.
> ./configure --help for more information.
> 
> 
> -Original Message-
> If anyone can tell me which directory I should add, that would be
> great.  I assume that it is '--with-mysql=/usr/local/mysql' , but I
> wanted to make sure.


=
Microsoft e[X]tra [P]roprietary
-- Is this where you really wanted to go today ? --

http://www.redhat.com/about/opinions/xp.html

__
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

How do I count using two tables

[Karl Uscroft]

Hi

Having a bit of bother with this one, wondering if anyone has the answer,

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.

Cheers Karl.


-
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 each database connect cause mysqld to fork?

[Dan Nelson]

In the last episode (Nov 21), Bennett Haselton said:
> Do you mean processes instead of threads?
> 
> (ps lists each *process* separately, along with its process ID, but
> doesn't list separate threads within each process.  If mysqld handles
> each new connection by calling fork(), then I think fork() creates a
> new process, not a new thread.)

Linux's threads implementation creates a process for each thread. 

-- 
Dan Nelson
[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: How to send multiple SQL statements using C API mysql_query?

[Gordon Burditt]

>> I would like to send multiple SQL statements using the C
>> API mysql_query.  I have a large string with 20 SQL statements.  When
>> I call mysql_query with that string, only the first one is processed.
>> 
>> Is there a way to do what I'm doing without separating the statements
>> into individual calls to mysql_query?
>
>I beleive this is not possible. If it were, it would give lots of people
>many hours of headache. Imagine a badly written script, where you can
>"escape out" from the original query, like

>update articles set author='$author'

>If you can make several statements with one query, you could make

>$author = "whatever'; drop database"

It's STILL dangerous even without being able to insert a separate
query.  Granted, with a select the attacker could probably only dump
your entire database, using something like 
$author = "whatever' or 1"

If you have a MySQL-driven web page and putting special characters
like single quotes into an input field can draw SQL errors, you've
got a BIG problem, unless you really don't care about having your
site and/or database hacked (In which case I'd prefer you take it
down, as I don't want SPAM relayed through your site showing up in
my mailbox.)  Quote your input properly (as with mysql_escape_string())
or validate it before feeding it to MySQL.

Also, be very careful about allowing stuff INTO your database which
will be blatted out unchecked into a web page.  It's easy to insert
malicious Javascript or an offensive banner ad into even a moderately
long text field, like one intended for a Subject: line.

Gordon L. Burditt

-
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: Webdav

[Jeremy Zawodny]

On Thu, Nov 22, 2001 at 09:25:47PM +0200, Scott Alexander wrote:
> Hi,
> 
> Does anyone have any experience in using webdav with apache to
> update a mysql db?
> 
> Any pointers?
> 
> I'd like that when a user uploads a file using webdav to then move
> the file to a new location on the server and enter the filename and
> file location into a mysql database.
> 
> my system is using
> linux rh, mysql, mod_perl, apache etc.

There are probably WebDAV modules available for Perl/mod_perl.  If so,
it's just a Simple Matter of Programming. :-)

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.41-max: up 77 days, processed 1,690,142,428 queries (251/sec. avg)

-
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: Got error 127 from table handler

[Sergei Golubchik]

Hi!

On Nov 22, Stuart Scamman wrote:
> I'm getting "Got error 127 from table handler" on specific tables quite
> regularly, what does this indicate and how do I avoid it ?

% perror 127
127 = Record-file is crashed

So - repair your tables.
If the error still persists, report the bug.

Regards,
Sergei

-- 
MySQL Development Team
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
   <___/

-
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

Webdav

[Scott Alexander]

Hi,

Does anyone have any experience in using webdav with apache to update a
mysql db?

Any pointers?

I'd like that when a user uploads a file using webdav to then move the
file to a new location on the server and enter the filename and file
location into a mysql database.

my system is using
linux rh, mysql, mod_perl, apache etc.

thanks in advance

Scott


-
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

Got error 127 from table handler

[Stuart Scamman]

I'm getting "Got error 127 from table handler" on specific tables quite
regularly, what does this indicate and how do I avoid it ? 

RE: MySQL with MyODBC & Access

[Venu]

Hi, 

> -Original Message-
> From: Adam Douglas [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 22, 2001 6:54 AM
> To: '[EMAIL PROTECTED]'; Mysql@Lists. Mysql. Com (E-mail)
> Subject: RE: MySQL with MyODBC & Access
> 
> 
>   Hi I recently upgraded MyODBC as you stated on our terminal server
> and two PCs. Now I tried running the install.bat file but it didn't seem to
> work so I just looked at the batch file and did it all manually. I believe
> for some odd reason the variable %windir% wasn't working. Either way the
> upgrade seem to go over well. The only issue I noticed since upgrading
> MyODBC to 2.50.39.00 is that now I have two MySQL drivers installed or so it
> appears. The first driver is "MySQL" and the second is "MySQL Driver". Both
> show the version at 2.50.39.00 and company as "MySQL AB". Is this a problem?
> The main reason I ask is for some odd reason on our terminal server the
> users using MyODBC are prompted with the MyODBC dialog box and seems to be
> missing the password. I've checked the registry and it's in their perfectly.
> If you enter the password manually when the dialog box appears it works with
> no problem. I do not want the users knowing this password (even though they
> could look it up in the registry, smile). How do I stop this dialog popping
> up and use the password I providing the System DSN profile? Is this issue
> maybe related to me having to MySQL drivers?

It should be {MySQL} only, might be the .rsp file got the wrong driver name.
Any way, that shouldn't cause any problems in the driver behaviour as both 
of them are listening to the same driver DLL. 

You can correct it by removing the other one :)

PS :  Please, don't put everything in a single paragraph, as this is 
  making hard to read.

Regards, Venu
-- 
For technical support contracts, go to https://order.mysql.com
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /  Mr. Venu <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/  /_/\_, /___/\___\_\___/ California, USA
   <___/ www.mysql.com



> 
> 
> > -Original Message-
> > From: Venu [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, November 02, 2001 6:17 AM
> > To: Adam Douglas
> > Subject: RE: MySQL with MyODBC & Access
> > 
> > Just download the driver files and copy them to system directory by
> > ovveriting previous files.
> 

-
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

Test

[Brown, Mike]

Sorry, new MySql user test.




-
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

Export just part of a table to a CSV file

[Carlos Fernando Scheidecker Antunes]

Hello all,

Usually I back-up my tables importing them to .csv files.

What I do is I issue the following command :

mysqldump - h localhost -u
user -ppassword --tab="/tmp" --fields-terminated-by=";" database_name
table_Name > table.csv

This creates a file called table.csv by dumping all the contents of
table_Name of database_name database and separating their fields
with a ;.


What I would like to do is to do the same but with an SQL statement.
Meaning, I would like to dump just part of the table through a SQL
statement.

Is there any way to do it?


Thank you,

Carlos Fernando.


-
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

How to update part of a field ?

[Carlos Fernando Scheidecker Antunes]

Hello all,

I've got some e-mails addresses on an e-mails database where one domain has
been changed to another.

So I have :

email1@domain1
email2@domain1

I need to change @domain1 to @domain2 on this e-mail field and keep the user
name.

Some e-mails of an specific ISP had their domains changed but the usernames
remained the same. So I need to update this table that has some hundreds
addresses of this particular domain that had been changed.

Is there any way to do it through a SQL statement?

Thank you,

Carlos Fernando.


Linux User #207984


-
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: replication howto

[Attila Beno]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi,

On Thu, 22 Nov 2001, Sergei Golubchik wrote:

> > I have a quick question about replication: how does it process
> > transactions? Does it store all the commands, or does it just store the
> > ones that were commited?
> 
> Only committed.
> 
> > Let's say I have innodb tables on the master, for row-level locking
> > (speed). And I just have myisam tables on the slave, which would just be
> > used for backup purposes. Myisam takes up less space.
> 
> No - it's a useful trick, indeed.
> It would work.

Thanks a lot. I think this will be very useful. (Probably for others, too.
:))

Attila

...
Actual newspaper headline, 1/17/77: "Cold Wave Linked to Temperatures"

- ---
Public key: http://civ.hu/attila.asc

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE7/TXADeyfLhmXxQwRAtmuAKCKhwL66jRGLET02WBTgUTG4fq0jwCgkivl
ZuUdEuqhIZ9iBxjR4I7ZK64=
=zWcf
-END PGP SIGNATURE-


-
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: replication howto

[Sergei Golubchik]

Hi!

On Nov 22, Attila Beno wrote:
> 
> I have a quick question about replication: how does it process
> transactions? Does it store all the commands, or does it just store the
> ones that were commited?

Only committed.

> And: can I use replication with different table fortams on teh master and
> slave?

Yes.

> Let's say I have innodb tables on the master, for row-level locking
> (speed). And I just have myisam tables on the slave, which would just be
> used for backup purposes. Myisam takes up less space.
>
> Would this work, or because of inodb transactions, I need to have innodb
> tables on the slave as well?

No - it's a useful trick, indeed.
It would work.

Regards,
Sergei

-- 
MySQL Development Team
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
   <___/

-
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: error when running myql on Linux 7.1

[Mike(mickalo)Blezien]

Dana,

What I did, to set up a second MySQL on our Linux box, compiled the second copy
from source, which gives you a lot more control on how MySQL is installed. then
created a my.cnf file with all the relavent settings for the second server, port
and socket, pid ...etc..  then put this in the datadir folder. Then when I start
up the second server i simple do:

safe_mysqld --defaults-file=/path/to/datadir/my.cnf &

then it starts up the second serve without any problems.

We are current running two separate servers. 3.23.40 and 3.23.44 and it's been
working fine for about a month now. :)


>On Thu, 22 Nov 2001 10:38:56 -0600, Dana Sharvit <[EMAIL PROTECTED]>   
>wrote:

>>Hello,
>>As you probably know mysql comes installed in Linux 7.1 as default.
>>I installed my own mysql server in a different location in the file system,
>>In safe_mysqld I indicated the path in which I want the mysql.sock to be
>>created in but when I start my mysql server I get an error message:
>>Can't start server : Bind on unix socket: No such file or direc
>>tory
>>06  9:56:26  Do you already have another mysqld server running on
>>socket: /v
>>ar/lib/mysql/mysql.sock ?
>>06  9:56:26  Aborting
>>
>>the default mysql server on Linux 7.1 is not running but even though I can
>>not run my own mysql server.
>>In order to solve this I created a symbolic link between
>>/var/lib/mysql/mysql.sock to the path of my mysql server and that works fine
>>but I am looking for a better solution - does some one have an idea?
>>
>>Thanks
>>Dana
>>
>>-
>>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

Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=


-
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 when running myql on Linux 7.1

[Dana Sharvit]

Hello,
As you probably know mysql comes installed in Linux 7.1 as default.
I installed my own mysql server in a different location in the file system,
In safe_mysqld I indicated the path in which I want the mysql.sock to be
created in but when I start my mysql server I get an error message:
Can't start server : Bind on unix socket: No such file or direc
tory
06  9:56:26  Do you already have another mysqld server running on
socket: /v
ar/lib/mysql/mysql.sock ?
06  9:56:26  Aborting

the default mysql server on Linux 7.1 is not running but even though I can
not run my own mysql server.
In order to solve this I created a symbolic link between
/var/lib/mysql/mysql.sock to the path of my mysql server and that works fine
but I am looking for a better solution - does some one have an idea?

Thanks
Dana

-
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

replication howto

[Attila Beno]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

hi,

I have a quick question about replication: how does it process
transactions? Does it store all the commands, or does it just store the
ones that were commited?

And: can I use replication with different table fortams on teh master and
slave?

Let's say I have innodb tables on the master, for row-level locking
(speed). And I just have myisam tables on the slave, which would just be
used for backup purposes. Myisam takes up less space.

Would this work, or because of inodb transactions, I need to have innodb
tables on the slave as well?

Thanks a lot,

Attila

...
I was court-martialled in my absence, and sentenced to death in my absence,
so I said they could shoot me in my absence. -Brendan Francis Behan,
playwright (1923-1964)

- ---
Public key: http://civ.hu/attila.asc

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE7/SOGDeyfLhmXxQwRAqufAKCYRl0BWhDglVsnxPdfqhUkXxCwcACeP4LE
gTx3kSayATlX2WjVcai/2Uw=
=Bowh
-END PGP SIGNATURE-


-
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: .pid file missing

[Mike(mickalo)Blezien]

On Thu, 22 Nov 2001 05:56:21 -0800 (PST), Michael Bevan <[EMAIL PROTECTED]>
wrote:

>>I think I erased my .pid file in a misguided effort
>>to reset my password, does anyone know how to
>>re-create it or do I need to do a full SQL re-install?
>>
>>Thanks - Mike

No, simple restart the MySQL server. Make sure it's properly been shutdown, then
restart it. I will automatically create the pid file.


Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=


-
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

ANN: EMS MySQL Manager 1.21 released

[Igor Brynskich]

Dear Sirs and Madams,

EMS HiTech company is announcing the next version (1.21) of MySQL
Manager -- A Powerful MySQL Administration and Development Tool for
Windows95/98/ME/NT/2000/XP.

You can download the latest version from
http://www.mysqlmanager.com/download.phtml

Since now MySQL Manager will be releasing in two editions - Lite and
Professional. MySQL Manager Lite is an expensive but effective and
powerful tool for MySQL server administration. It includes all MySQL
Manager features except of BLOB Viewer/Editor, Visual Query Builder,
metadata printing, data export/import and something more. The full list
of difference between Lite and Professional editions you can find at
http://www.mysqlmanager.com


What's new in version 1.21?

1. Database Registration: Database Font Charset parameter was added. Now
you can define a character set to represent data in the grid. Charsets
available are DOS866, ISO8859-2, KOI8-R, KOI8-U, WIN1250 and WIN1251.

2. Fixed bug with number of records to limit in the Data View. Now this
setting works properly.

3. Fixed bug with editing of the field that is a part of primary key.

4. Fixed bug in User Manager. Now users with empty name also can be
edited.

5. Some minor bugfixes and improvements.


What is the EMS MySQL Manager?

EMS MySQL Manager provides you powerful and effective tools for MySQL
Server administration and objects management. Its Graphical User
Interface (GUI) allows you to create/edit of all MySQL database objects
most easy and simple way, run SQL scripts, manage users and administrate
users' privileges, visually build SQL queries, extract or print
metadata, export/import data, view/edit BLOBs and many more services
that will make you work with MySQL server as easy as you want...

Best regards,
EMS HiTech development team.
http://www.ems-hitech.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: MySQL with MyODBC & Access

[Adam Douglas]

Hi I recently upgraded MyODBC as you stated on our terminal server
and two PCs. Now I tried running the install.bat file but it didn't seem to
work so I just looked at the batch file and did it all manually. I believe
for some odd reason the variable %windir% wasn't working. Either way the
upgrade seem to go over well. The only issue I noticed since upgrading
MyODBC to 2.50.39.00 is that now I have two MySQL drivers installed or so it
appears. The first driver is "MySQL" and the second is "MySQL Driver". Both
show the version at 2.50.39.00 and company as "MySQL AB". Is this a problem?
The main reason I ask is for some odd reason on our terminal server the
users using MyODBC are prompted with the MyODBC dialog box and seems to be
missing the password. I've checked the registry and it's in their perfectly.
If you enter the password manually when the dialog box appears it works with
no problem. I do not want the users knowing this password (even though they
could look it up in the registry, smile). How do I stop this dialog popping
up and use the password I providing the System DSN profile? Is this issue
maybe related to me having to MySQL drivers?


> -Original Message-
> From: Venu [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 02, 2001 6:17 AM
> To: Adam Douglas
> Subject: RE: MySQL with MyODBC & Access
> 
> Just download the driver files and copy them to system directory by
> ovveriting previous files.

-
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

opinion - voating

[Christopher Book]

>> Any one have example Banking software written in PERL or PHP with MySql
Database. if you have one mail me or provide me the URL of such software. 
I don't think there are many banks that don't pay insane amounts for Oracle
or IBM to come in and design all their systems.

-
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: Newbie query

[Ivano Luberti]

At 10.08 21/11/01 -0700, Steve Meyers wrote:
>Wait for 4.1, it will have multi-table updates in it.  Until then,
>you'll have to use two separate queries.
>
>Steve

i'm also new to mysql but i think you can use MERGE tables.
Couldn't you ?



==
dott. Ivano Mario Luberti
Archimede Informatica societa' cooperativa a r. l.
Via G. Ferraris 12 - 56121- Ospedaletto- Pisa
tel.: +39-050-3132300
fax: +39-050-3132301
e-mail: [EMAIL PROTECTED]
web: http://www.archicoop.it




-
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

.pid file missing

[Michael Bevan]

I think I erased my .pid file in a misguided effort
to reset my password, does anyone know how to
re-create it or do I need to do a full SQL re-install?

Thanks - Mike

__
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

OLE DB Problem

[Karthikeyan]

Dear members,
I am using mySQL in Windows platform.
Through OLEDB I am connecting to the ASP page.
For simple queries, it is working fine.
If I use for outer join means it is giving error "Provider could not support
asynchronous execution"
I am using myOLEDB.
Help me
Thanks in advance
yours
Karthikeyan



-
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

Database system architecture

[lcalero]

  Hi. We're in the process of making a database driven website for a
client and I'd like to clear one doubt. There are going to be two frontend
machines w/ apache on linux and one shared NAS on the back for the all
data (possibly a Netapp box).

  My question is: is it a good idea to have the database files on a NAS
mounted partition on each frontend and a MySQL server on each too? This
way both servers are going ot access the same set of data, but I was
fearing of file locking errors or something like that. BTW, DB use on
inserts/updates is not going to be very heavy.

  If this isn't a good idea... any insights about how to make this setup
to be optimal?

  Thanks.

--
  Luis




-
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: mysqlgui

[Sinisa Milivojevic]

Glenn English writes:
> RH7.2
> 
> When I run 1.7.5 either static or semi static, I get 
> 
>Can't connect to local MySQL server through socket " (111)
> 
> Host name is "localhost" ("120.0.0.1" doesn't work either).
> 
> I do have access rights - running as root.
> -- 
> Glenn English
> [EMAIL PROTECTED]

Hi!

All you have to do is follow instructions from README that came with
distro. 

Here is a relevant part :

When you start mysqlgui for the first time, you'll need to tell it how to
connect to the MySQL server.  To do this, click on the ``Options'' button.
Select the ``Server'' tab and fill in the fields that indicate where to
find the server.  On Unix, if you have problems with mysqlgui not knowing
the location of the socket file for connections to localhost, enter the
full pathname of the socket file in the ``SQL command on the start-up''
field.  On Windows, this field is used if you wish to specify the named pipe
option.  Then select the ``Client'' tab and fill in your MySQL user name.
Take care to select the right value for the ``Ask for password'' button,
depending on whether or not you want mysqlgui to prompt you for your
MySQL password.  After you have filled in the server and client values,
click on the ``Save'' button.  From then on, each time mysqlgui starts up,
it will connect to the MySQL server automatically.


-- 
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: MySQL-4 compile / configure error

[Sinisa Milivojevic]

dan writes:
> Towards the end of running the end of the configure script (./configure 
> --prefix=/usr/local/mysql - and yes I know I can optimise better than 
> this), I get:
> 
> creating ./config.status
> creating Makefile
> sed: file conftest.s1 line 6: Unterminated `s' command
> creating os/Makefile
> sed: file conftest.s1 line 6: Unterminated `s' command
> creating ut/Makefile
> sed: file conftest.s1 line 6: Unterminated `s' command
> creating btr/Makefile
> sed: file conftest.s1 line 6: Unterminated `s' command
> creating buf/Makefile
> sed: file conftest.s1 line 6: Unterminated `s' command
> creating com/Makefile
> sed: file conftest.s1 line 6: Unterminated `s' command
> 
> etc ... it goes on & on but you get the idea.
> 
> I'm running Slackware 8 with Autoconf 2.13 (not sure if this is 
> relevant, but anyway I had to downgrade it to be able to compile 
> Enlightenment 0.17 cvs)
> Anyone know what's happening? Alternatively, has anyone made a package 
> for Slackware? The rpms segfault on executing.
> Please email me if you want more info (I tried attaching the config.log 
> but apparently it's too big...). I'm subscribed to the digest - but that 
> will take a day, and I'd like to get this show on the road [;)]
> Thanks in advance!
> 
> Dan

Hi!

I have no problems with autoconf 2.13. This is a recommended version.

It is with sed that you experience problems.

For Slackware download binary .tar.gz package.

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

SV: Need help with SELECT 2 tables from choice of 3

[Torgil Zechel]

You can join all three tables together

select d.members_id, m.name, old.name from data as d
left join members as m on m.members_id=d.members_id
left join oldmembers as old on old.members_id=d.members_id

If the members_id belongs to an old member, all fields from the member table
will be null. If it's a new member, all fields from the old member table
will be null .. That way you only need to query the database once. Then, in
your PHP/ASP code you check if id > 1000 and if it is you use the fields
from the new members table...

d.members_id, m.name, old.name
1   NULLname1
100 NULLname2
2000name2   NULL

/torgil


> I left joined the DATA with MEMBERS and in a loop when displaying records,
> when I see that the MEMBER_ID belongs to the old member, I open another
> recordset that get's me his name from OLDMEMBERS table.
>
> I thought that this is better than the first solution because
> when my database
> grows, all of the new messages will be from new members, not old, so the
> condition to open recordset in for...next loop would not be executed.
>
> Is my thinking valid?
>
> Yours
>
> Jerry
>
>
> -
> 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

hanging slaves and slave_read_timeout

[Martin Waite]

Hi,

We're replicating databases across a firewall with 
a 300 second reflective ACL timeout set.

This causes occasional problems with replication, 
where if the master is idle for more than 300 
seconds, the connections are closed by the firewall 
in such a way that the slaves never notice.  That is,
"show slave status" reports that the slave is running
when in fact it has stalled.

I see that in the manual there is a slave_read_timeout
option which looks like it might fix this problem (
if I upgrade my servers) - but I'm not sure I'm reading the 
document properly.  

Is it the case that if slave_read_timeout is set to 
150 seconds, and if the connection goes quiet for 
150 seconds, then the slave will close and reopen 
the connection ?  (Which is what I want)

regards,
Martin

-
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 installation problem on NT

[Joachim Klöfers]

Hi, all,
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.

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.

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.

I hope somebody will help me.

Many thanks in advance
Joachim

-
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: Need help with SELECT 2 tables from choice of 3

[Jerry]

>Can't you just make a check before you make a call to the DB?

>if( member_id > 1000 )
>   // old member query here
>else
>   // new member query here

Now I did just that, but that means I have to open recordset 20 times a page
(for each record separately)...

I am a begginer, I don't know if this is a speed defect, but I would think it
is... Opening recordset 20 times and selecting one record instead of 1 time
selecting 20 records...

If penality is not much, I would take the solution, I don't have 100 users
a day (only about 500).

Actually I did something simmilar:

I left joined the DATA with MEMBERS and in a loop when displaying records,
when I see that the MEMBER_ID belongs to the old member, I open another
recordset that get's me his name from OLDMEMBERS table.

I thought that this is better than the first solution because when my database
grows, all of the new messages will be from new members, not old, so the
condition to open recordset in for...next loop would not be executed.

Is my thinking valid?

Yours

Jerry


-
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

how to change the port

[francesco taglino]

Hi,
I'd like to know how to change the port to use for connection
I work under WINNT. I tried with mysqld-nt --port=1234
but it seems it enters in a loop.

Thanks in advance
Francesco

--
FRANCESCO TAGLINO
LEKS - Laboratory for Enterprise Knowledge and Systems, at IASI-CNR
Viale Manzoni 30, 00185 Rome (Italy)
mailto:[EMAIL PROTECTED]
ph. 067716433
url: http://leks.iasi.rm.cnr.it/home



-
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

Size of blobs?!

[Giuseppe Maxia]

>Hello! How do I get the size of a blob? 
>I want to do something like this:  
>SELECT * FROM blob_table WHERE size(blob_column) > 1024; 

replace "size" with "LENGTH" and it will work.

SELECT * FROM blob_table WHERE LENGTH(blob_column) > 1024; 

Giuseppe Maxia






-
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-3.23.4[34] fails to pass tests

[serpent]

>Description:
$ rm -f config.cache
$ ./configure --prefix=/home/crystal/local/mysql-3.23.44 \
$   --with-berkeley-db \
$   --with-innodb \
$   --with-charset=big5 \
$   --with-extra-charsets=latin1,gb2312
$ make clean
$ make 
$ make test
$ # mysql-3.23.39, 3.23.40, 3.23.42 can pass all tests.

$ 
$ rm -f config.cache
$ ./configure --prefix=/home/crystal/local/mysql-3.23.44 \
$   --with-berkeley-db \
$   --with-innodb
$ make clean
$ make 
$ make test
$# this configuration can pass all tests.


>How-To-Repeat:
pls. ref. Description.
>Fix:
NA

>Submitter-Id:  
>Originator:
>Organization:
 
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:  Failure to pass tests.
>Severity:  critical
>Priority:  high
>Category:  mysql
>Class: sw-bug
>Release:   mysql-3.23.44 (Source distribution)

>Environment:

System: Linux c2 2.4.10-4GB #1 Fri Sep 28 17:20:21 GMT 2001 i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs
gcc version 2.95.3 20010315 (SuSE)
Compilation info: CC='gcc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''  LDFLAGS=''
LIBC: 
-rwxr-xr-x1 root root  1384168 Sep 20 11:52 /lib/libc.so.6
-rw-r--r--1 root root 25215580 Sep 20 11:28 /usr/lib/libc.a
-rw-r--r--1 root root  178 Sep 20 11:28 /usr/lib/libc.so
-rw-r--r--1 root root   856542 Oct 26 00:13 /usr/lib/libc-client.a
lrwxrwxrwx1 root root   20 Nov 20 12:39 /usr/lib/libc-client.so -> 
libc-client.so.2000c
-rwxr-xr-x1 root root   718160 Oct 26 00:13 /usr/lib/libc-client.so.2000c
Configure command: ./configure  --prefix=/home/crystal/local/mysql-3.23.44 
--with-berkeley-db --with-innodb --with-charset=big5 
--with-extra-charsets=latin1,gb2312


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

[Sandeep Murthy]

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

MySQL + WIN 2000

[Sandeep Murthy]

hi,

I had posted a few days back regarding having problems running MySQL on WIN
2000...

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

mysql-3.23.44 fails to pass tests,3.23.43 also fails.

[Crystal]

>Description:
$ rm -f config.cache
$ ./configure --prefix=/home/crystal/local/mysql-3.23.44
$   --with-berkeley-db \
$   --with-innodb \
$   --with-charset=big5 \
$   --with-extra-charsets=latin1,gb2312
$ make clean
$ make
$ make test
$ # mysql-3.23.39, 3.23.40, 3.23.42 can pass all tests.
$
$ rm -f config.cache
$ ./configure --prefix=/home/crystal/local/mysql-3.23.44 \
$   --with-berkeley-db \
$   --with-innodb
$ make clean
$ make
$ make test
$# this configuration(without charset big5/gb2312) can pass all tests.


>How-To-Repeat:
pls. ref. Description.
>Fix:
NA

>Submitter-Id:  
>Originator:
>Organization:
 
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:  Failure to pass tests.
>Severity:  critical
>Priority:  high
>Category:  mysql
>Class: sw-bug
>Release:   mysql-3.23.44 (Source distribution)

>Environment:

System: Linux c2 2.4.10-4GB #1 Fri Sep 28 17:20:21 GMT 2001 i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs
gcc version 2.95.3 20010315 (SuSE)
Compilation info: CC='gcc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''  LDFLAGS=''
LIBC:
-rwxr-xr-x1 root root  1384168 Sep 20 11:52 /lib/libc.so.6
-rw-r--r--1 root root 25215580 Sep 20 11:28 /usr/lib/libc.a
-rw-r--r--1 root root  178 Sep 20 11:28 /usr/lib/libc.so
-rw-r--r--1 root root   856542 Oct 26 00:13
/usr/lib/libc-client.a
lrwxrwxrwx1 root root   20 Nov 20 12:39
/usr/lib/libc-client.so-> libc-client.so.2000c
-rwxr-xr-x1 root root   718160 Oct 26 00:13
/usr/lib/libc-client.so.2000c
Configure command:
./configure  --prefix=/home/crystal/local/mysql-3.23.44 --with-berkeley-db -
-with-innodb --with-charset=big5 --with-extra-charsets=latin1,gb2312



-
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 can I download and learn this database.

[Ulf Bäckman]

Hi.

You will get far just by downloading it and read the manual
at www.mysql.com


ABDULLAH ERDOÐAN wrote:
> 
> Mysql, On Linux and win2000 or Win9x.
> Thanks I am beginner.
> 
> _
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.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

-- 
Ulf Bäckman
System developer
Skanova Networks 
Network Security

-
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: Need help with SELECT 2 tables from choice of 3

[Torgil Zechel]

Can't you just make a check before you make a call to the DB?

if( member_id > 1000 )
// old member query here
else
// new member query here


-Ursprungligt meddelande-
Fran: Jerry [mailto:[EMAIL PROTECTED]]
Skickat: den 21 november 2001 21:24
Till: [EMAIL PROTECTED]
Amne: Re: Need help with SELECT 2 tables from choice of 3


>>Why no have 3 tables:

>>Members
>>Data
>>TheseMembersAreOld

>>Members and Data are as you have them defined. TheseMembersAreOld
>>contains only the Member_ID field.

>>You then make the Member_ID field primary key on TheseMembersAreOld and
>>Members. You can then perform a very fast joins.

>Hm, thank you for the idea... I think my problem is the OLD members and
>members are not the same people. That is why I have renamed them (added
>10 number to every one of them), so Data table now has

>numbers from 1-1000 (my new members)
>numbers from 10 to 101000 (my old members).

>From old members I only need the name, nothing else! From new members I
need
>all the data.

>Now because in the forum topic (yes, I am builing a custom forum) there
must
>be a member, I need

>1. If this is an old member from the old forum to disply only name
>2. If member is new to display all the data.

>Now I have a problem of joining the 3 tables because obviously in Data
field
>Member_ID there is a number that represents a member OR a number that
>represents a old member, never both (none is the same). In SQL I can not do
>the AND and compare both MEMBER_ID's because it would never return
anything.
>If I use or I do get data, but not one, but multiplied number od times
(every
>new member is then resulted or every old member, depending on in which
table
>SQL finds the data).

>Yours

>Jerry
>Slovenia


-
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

How can I download and learn this database.

[ABDULLAH ERDOĞAN]

Mysql, On Linux and win2000 or Win9x.
Thanks I am beginner.


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.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

Re: mysqlgui

[sreedhar]

hi glenn,

try to connect from another system on network. because it is client
software. if i am connecting from another system on network it is
connecting.

urs,
sreedhar
- Original Message -
From: "Glenn English" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 22, 2001 3:58 AM
Subject: mysqlgui


> RH7.2
>
> When I run 1.7.5 either static or semi static, I get
>
>Can't connect to local MySQL server through socket " (111)
>
> Host name is "localhost" ("120.0.0.1" doesn't work either).
>
> I do have access rights - running as root.
> --
> Glenn English
> [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

Error 127 Table Handle

[Stuart Scamman]

What is Error 127 table handle error ?  Restarting mysqld takes care of
it.  ulimit = 1024.  Thanks.

Re: Gemini compile error

[Attila Beno]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Thu, 22 Nov 2001, Ashley M. Kirchner wrote:

> While compiling MySQL+Gemini-3.23.41 i received the following error:
> 
> System is RedHat 7.1, with their GCC 2.96-85

Same here, althogh the binary version starts up fine.

> While I'm on the subject, does BDB tables provide the same type of
> locking that Gemini does?  Is there any reason to favor Gemini over BDB?

While on the subject: has anyone seen a WORKING gemini table? I've tried 2
different redhat systes, and 3 different debian systems, and always got
the same result: starts up fine, dies in about 15 seconds, safe_mysqld
tries to bring it up, so it recoveres from the crash, repeats the whole
thing a few times, and then no longer recovers.

Max uptime, starting with a new database, ending with an unrecoverable
one, has never exceeded 30 minutes.

So I'm trying Innodb tables now. Initial tests (the ones that caused
gemini to die in less than a minute) have been runing for about 4 days in
a row now, and it's very stable.

I have yet to test what it does with 50-60k users at the same time.
(That's what is causing me problems with myisam table locks now.) I need
to modiy a lot of code to use row-level locks.

I'll let you know about the result. :)

BDB as far as I know does not support row-level locking, it has page-level
locks.

Attila

...
Actual newspaper headline, 1/17/77: "Cold Wave Linked to Temperatures"

- ---
Public key: http://civ.hu/attila.asc

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE7/LqgDeyfLhmXxQwRAkXyAJ9yj0BLVxqQrrH9UYkTWXX18/hrAQCgiSqX
7CMbRMZz2qhiy7y/fnwqyKw=
=NsLE
-END PGP SIGNATURE-


-
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

Gemini compile error

[Ashley M. Kirchner]

While compiling MySQL+Gemini-3.23.41 i received the following error:

gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../incl -I../msgs -O3 -DDBUG_OFF -c
dsmindex.c
In file included from dsmindex.c:39:
/usr/include/string.h:245: parse error before `('
/usr/include/string.h:245: warning: conflicting types for built-in
function `memset'
/usr/include/string.h:245: parse error before `int'
make[4]: *** [dsmindex.o] Error 1
make[4]: Leaving directory
`/usr/local/src/Apache/mysql+gemini-3.23.41/gemini/api'


System is RedHat 7.1, with their GCC 2.96-85


While I'm on the subject, does BDB tables provide the same type of
locking that Gemini does?  Is there any reason to favor Gemini over BDB?

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



-
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