How do I uninstall a MySQL source installation on Linux ?

[Sharksforum]

How do I uninstall a MySQL source installation on Linux ?

Regards Jacob



-
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: Apache + php + MYSQL

[Reynaldo Valera]

Hi,

try to use phpinfo()... it will list all php configuration and support
modules.




-Original Message-
From: Sameer Maggon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 4:37 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Apache + php + MYSQL


Hi,
  How do i check whether PHP has MYsql support built or not

  Please help
  Sameer

--
you wrote:

On Tuesday 21 May 2002 09:51, Robert Vetter wrote:
> On Tuesday 21 May 2002 10:38, Sameer Maggon wrote:
> in /var/www/html/rcmms/appl.php on line 5
>
> Hello,
>
> 1. make shure the PHP module is compiled into Apache, or runs as
CGI.

rubbish, sorry. Make shure PHP is compiled with MySQL support.

Robert Vetter

-
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







--
http://www.dypatil.edu For Better tomorrow

-
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: Apache + php + MYSQL

[Sameer Maggon]

Hi,
  How do i check whether PHP has MYsql support built or not

  Please help
  Sameer

--
you wrote:

On Tuesday 21 May 2002 09:51, Robert Vetter wrote:
> On Tuesday 21 May 2002 10:38, Sameer Maggon wrote:
> in /var/www/html/rcmms/appl.php on line 5
>
> Hello,
>
> 1. make shure the PHP module is compiled into Apache, or runs as 
CGI.

rubbish, sorry. Make shure PHP is compiled with MySQL support.

Robert Vetter

-
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







--
http://www.dypatil.edu For Better tomorrow

-
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: can't connect to server2

[龔惠樑(Borus.Kung)]

you can try command "ps -ef | grep mysql"
to see if "safe_mysqld" is alive
and also one or more "mysqld" processes are running

to check the socket

type command "netstat -na | grep 3306" see if you can see
the processes are listening to the socket
if the socket if not being listen, you cannot connect to it

for errors, check the file  [mysql installation dir]/var/[server name].err

borus

- Original Message -
±H¥óªÌ: "Hoa Doan" <[EMAIL PROTECTED]>
¦¬¥óªÌ: <[EMAIL PROTECTED]>
¶Ç°e¤é´Á: 2002¦~5¤ë23¤é PM 01:49
¥D¦®: can't connect to server2


> Okay so it says that I can't connect through socket
> '/var/lib/mysql/mysql.sock'.  So I checked and the UNIX socket is located
> here: /tmp/mysql.sock.  I'm relatively new to Linux.  What does this mean?
>
> -Hoa
>
> _
> Join the world’s largest e-mail service with MSN Hotmail.
> http://www.hotmail.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

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

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL on iSCSI or IPSAN?

[Dan Nelson]

In the last episode (May 22), Jeremy Zawodny said:
> On Wed, May 22, 2002 at 03:52:33PM +0800, Patrick Hsieh wrote:
> > Hello Dan Nelson <[EMAIL PROTECTED]>,
> > 
> > Is there any lock problem on iSCSI or SAN environment? Say,
> > mutliple mysql server mount the backend iSCSI or SAN storage
> > device. Is it safe?
> 
> It is safe if you use MySQL's external (file) locking.

You will also need a filesystem that supports shared storage. 
Sistina's Global File System (GFS) is the only such filesystem
available for Linux, afaik (at only $995 per node; shared storage is
NOT easy to implement).  If you do not have such a filesystem, you will
most likely completely trash your filesystem when you mount it from the
2nd machine.

iSCSI/FibreChannel is not NFS.  It is block-level access to raw storage
just like SCSI or IDE.

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

Using LDAP with mysql.

[ally]

Dear all,

my company is currently using mysql database with php. Now there's this
company which is using LDAP with Oracle and we need to be able to link them
together.

They suggest tht we use LDAP with Mysql. I've tried looking for information
abt using ldap and mysql but invain.

Can you please enlighten and advice me?

thank you vey much

ally.


-
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

can't connect to server2

[Hoa Doan]

Okay so it says that I can't connect through socket 
'/var/lib/mysql/mysql.sock'.  So I checked and the UNIX socket is located 
here: /tmp/mysql.sock.  I'm relatively new to Linux.  What does this mean?

-Hoa

_
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.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: MyISAM internal algorithms

[Jeremy Zawodny]

On Tue, May 21, 2002 at 08:09:36AM -0400, Nick Stuart wrote:

> Ok, so know you got me interested. What exactly are R-Trees.

http://www.google.com/search?hl=en&q=r-tree

:-)

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.47-max: up 0 days, processed 987,089 queries (172/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: MySQL on iSCSI or IPSAN?

[Jeremy Zawodny]

On Wed, May 22, 2002 at 03:52:33PM +0800, Patrick Hsieh wrote:
> Hello Dan Nelson <[EMAIL PROTECTED]>,
> 
> Is there any lock problem on iSCSI or SAN environment?
> Say, mutliple mysql server mount the backend iSCSI or SAN storage device.
> Is it safe?

It is safe if you use MySQL's external (file) locking.

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.47-max: up 0 days, processed 976,330 queries (174/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

can't connect to server

[Hoa Doan]

Hello,

I have the mysql server running.  I can't connect to it though.  It reads, 
"Can't connect to local MySQL server through socket 
'/var/lib/mysql/mysql.sock'.

-Hoa

_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx


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

[Jason Soza]

I apologize for not including that in my original post. Here's my create
table statement:
For albums, artists, tracks:
CREATE TABLE artists (artists VARCHAR(50), id MEDIUMINT NOT NULL
AUTO_INCREMENT PRIMARY KEY)

For albums_artists, artists_tracks, tracks_albums:
CREATE TABLE albums_artists (album_id MEDIUMINT NOT NULL, artist_id
MEDIUMINT NOT NULL)

Insert statement:
LOAD DATA LOCAL INFILE "albumsartists.txt" INTO TABLE albums_artists

For tracks, albums, and songs, their .txt files are simply a one column
list. The other column is auto_increment. So a sample from tracks:
11am
1979
3 Libras
32 Flavors
4 Degrees
46 & 2
99 Red Balloons
A Place For My Head
A Place In The Sun
Abracadabra

>From albums:
311
14:59
8
(unknown)<---generic, unknown album. really a record.
13 Ways To Bleed Onstage
24/7
40oz To Freedom
A Boy Named Goo
A Few Small Repairs
A Little South Of Sanity

>From artists:
311
10,000 Maniacs
3 Doors Down
311
A Perfect Circle
AC/DC
Adema
Aerosmith
Afghan Whigs
AK1200

For albumsartists.txt, tracksalbums.txt, and artiststracks.txt, they're a
two-column, tab delimited text file. Examples from albumsartists.txt:
1   1
2   258
3   35
4   14
4   76
4   167
4   230
5   53
6   223
7   256

>From tracksalbums.txt:
1   237
2   221
3   222
4   41
5   354
6   16
7   315
8   176
9   12
10  2

>From artiststracks.txt:
1   15
1   19
1   250
2   40
3   38
3   138
3   281
3   303
3   363
5   3
5   62

I thought 2 links would be enough as well, but I tried this query using just
the tracks_albums and albums_artists table and couldn't get it working. For
example, using this:
SELECT tracks.tracks, albums.albums, artists.artists FROM tracks, albums,
artists, tracks_albums, albums_artists
WHERE tracks.id = tracks_albums.track_id
AND albums.id = tracks_albums.album_id
AND albums.id = albums_artists.album_id
AND artists.id = albums_artists.artist_id

I get 718 returns instead of 614. If more than one artist is linked to one
album, only the song from the first artist shows in the tracks column and it
shows for all artists (no other songs by the different artists appear). Am I
just missing something in this query?

Thanks for your help,
Jason

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Sammy Lau
Sent: Wednesday, May 22, 2002 8:18 PM
To: Jason Soza
Cc: [EMAIL PROTECTED]
Subject: Re: Query Problem


to make it easier for others to help you. you should have posted the
create table statement, insert statement for a small set of data so that
anyone of us could easier reproduce your problem.

btw, are you sure you need 3 links between those 3 tables. please
correct me if i'm wrong. i think 2 links should be enough. ie. artist
<-> album <-> tracks.


Jason Soza wrote:
>
> I'm trying to compile 75 playlists of 25+ songs each into a database
> sortable by date the show was produced, track, album, and artist. I got
> advice from someone as to how to layout the table structure, and basically
> it was said that I should have a basic structure of 6 tables, one for
> artists, one for albums, and one for tracks. These tables should contain
> whatever info I want, i.e. song title, albums, etc., and a unique id for
> each. I should have 3 more tables, each linking the unique id's of each
> other table together.
>
> So, I have 3 tables as was suggested, one for songs, one for albums, one
for
> artists. Each has two columns, one being whatever information I'm
entering,
> and the other a MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY column.
>
> I have 3 other tables containing two MEDIUMINT columns, these link each of
> the 3 others. I have:
> artists_tracks
> tracks_albums
> albums_artists
>
> Each is setup so that the records represent 'links' - for example,
> artists_tracks has artist_id and track_id columns. Each record is made up
of
> an artist_id and a matching track_id.
>
> My problem is, when querying some records are lost. But only on a certain
> query. For instance:
> SELECT tracks.tracks, artists.artists
> FROM tracks, artists, artists_tracks
> WHERE tracks.id = artists_tracks.track_id AND artists.id =
> artist_tracks.tracks_id
>
> This works. It returns 614 records, each track mated with it's relative
> artist. This same query works using albums and the tracks_albums table,
> returning 614 records as well. Matching up albums to artists returns 413
> records, which is the correct number.
>
> However, the following query returns 451 instead of the expected 614 and I
> can find no distinguishable pattern as to the records dropped:
> SELECT tracks.tracks, albums.albums, artists.artists
> FROM tracks, albums, artists, tracks_albums, albums_artists,
artists_tracks
> WHERE tracks.id = tracks_albums.track_id AND albums.id =
> tracks_albums.album_id
> AND albums.id = albums_artists.album_id  AND artists.id =
> albums_artists.artist_id
> AND artists.id = artists_tra

Re: Replication error

[Jeremy Zawodny]

On Thu, May 23, 2002 at 10:10:26AM +0530, Kannan R wrote:
> 
> I have come across a wierd error in my replication setup..I run
> mysql 3.23.49 on two servers .one is the master and the other the
> slave..I have jus one DB with jus a single table in it. I 'm getting
> the follwoing error on my slave
> 
> error 'unexpected success or fatal error' on query '' and replication stops..
> 
> I do a set SQL_SLAVE_SKIP_COUNTER=1; and then a slave start.then
> replication starts and immediately after reading a few positions
> replication stops with the same error..I hope somebody can thro some
> light on this..

Run a "CHECK TABLE" on the problematic table(s) on the master and
slave.  It's busted on one and not the other.

I just had this happen the other day...

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.47-max: up 0 days, processed 799,273 queries (275/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: strange fulltext behavior

[Vadim P.]

This simply can't be correct - if a match produces "0" score (no
relevance), the whole condition part after "AND" in this example could
be reduced to "0" (=FALSE), hence the query *should* produce 0
records:

SELECT ISBN,TITLE FROM tBooks WHERE tBooks.ISBN="1876340436" AND 0;

...and here is a real-life example of the correct behavior:

mysql> select indatetime from archivel where addr="FN20" and match
(header) against ("not_a_word");
Empty set (0.00 sec)

mysql> select indatetime from archivel where addr="FN25" and match
(header) against ("reagan");
++
| 1988120101 |
| 19990610115359 |
| 2515123714 |
| 1988112201 |
| 1988112201 |
++
5 rows in set (0.08 sec)

Regards,
Vadim P.

Victoria Reznichenko wrote:
> 
> Przemyslaw,
> Wednesday, May 22, 2002, 2:02:52 AM, you wrote:
> 
> PP> SELECT ISBN,TITLE FROM tBooks
> PP> WHERE tBooks.ISBN="1876340436"
> PP> AND MATCH (tBooks.TITLE) AGAINST ("britannica")
> 
> PP> ++-+
> PP> | ISBN   | TITLE   |
> PP> ++-+
> PP> | 1876340436 | 2000 Lonely Planet Calendar |
> PP> ++-+
> PP> 1 row in set (0.00 sec)
> 
> PP> Why is it so?  I suspected to get an empty result set.
> PP> MYSQL Ver 11.16 Distrib 3.23.49, for Win95/Win98 (i32)
> 
> MATCH() returnes you relevance value. So, it is always true in
> WHERE clause. As a result you get result where ISBN=1876340436. In
> your case you can re-write you query:
> 
>SELECT ISBN,TITLE, MATCH (tBooks.TITLE) AGAINST ("britannica")
>as aa FROM tBooks
>WHERE tBooks.ISBN="1876340436"
>HAVING aa>0;
> 
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita.net/
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
>  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
><___/   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

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

[Kannan R]

  Placed At :


Hi..

I have come across a wierd error in my replication setup..I run mysql 3.23.49 on
two servers .one is the master and the other the slave..I have jus one DB with
jus a single table in it. I 'm getting the follwoing error on my slave

error 'unexpected success or fatal error' on query '' and replication stops..

I do a set SQL_SLAVE_SKIP_COUNTER=1; and then a slave start.then replication
starts and immediately after reading a few positions replication stops with the
same error..I hope somebody can thro some light on this..

regards
kannan


**

Quality Policy

"To be  the  best-in-class  service  provider by  practising international
standards
 in providing world-class services and end-to-end network solutions."
**



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

[Sammy Lau]

to make it easier for others to help you. you should have posted the
create table statement, insert statement for a small set of data so that
anyone of us could easier reproduce your problem.

btw, are you sure you need 3 links between those 3 tables. please
correct me if i'm wrong. i think 2 links should be enough. ie. artist
<-> album <-> tracks.


Jason Soza wrote:
> 
> I'm trying to compile 75 playlists of 25+ songs each into a database
> sortable by date the show was produced, track, album, and artist. I got
> advice from someone as to how to layout the table structure, and basically
> it was said that I should have a basic structure of 6 tables, one for
> artists, one for albums, and one for tracks. These tables should contain
> whatever info I want, i.e. song title, albums, etc., and a unique id for
> each. I should have 3 more tables, each linking the unique id's of each
> other table together.
> 
> So, I have 3 tables as was suggested, one for songs, one for albums, one for
> artists. Each has two columns, one being whatever information I'm entering,
> and the other a MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY column.
> 
> I have 3 other tables containing two MEDIUMINT columns, these link each of
> the 3 others. I have:
> artists_tracks
> tracks_albums
> albums_artists
> 
> Each is setup so that the records represent 'links' - for example,
> artists_tracks has artist_id and track_id columns. Each record is made up of
> an artist_id and a matching track_id.
> 
> My problem is, when querying some records are lost. But only on a certain
> query. For instance:
> SELECT tracks.tracks, artists.artists
> FROM tracks, artists, artists_tracks
> WHERE tracks.id = artists_tracks.track_id AND artists.id =
> artist_tracks.tracks_id
> 
> This works. It returns 614 records, each track mated with it's relative
> artist. This same query works using albums and the tracks_albums table,
> returning 614 records as well. Matching up albums to artists returns 413
> records, which is the correct number.
> 
> However, the following query returns 451 instead of the expected 614 and I
> can find no distinguishable pattern as to the records dropped:
> SELECT tracks.tracks, albums.albums, artists.artists
> FROM tracks, albums, artists, tracks_albums, albums_artists, artists_tracks
> WHERE tracks.id = tracks_albums.track_id AND albums.id =
> tracks_albums.album_id
> AND albums.id = albums_artists.album_id  AND artists.id =
> albums_artists.artist_id
> AND artists.id = artists_tracks.artist_id  AND tracks.id =
> artists_tracks.track_id
> 
> I've tried LEFT JOIN as well, and have tried numerous other suggestions out
> of the manual, but everything turns up 451 records. I haven't been able to
> track down WHY records are missing - it seems almost random. If I sort by
> album, sometimes all songs from an album have been listed, sometimes only 3
> of 5 or 7 of 10 are missing.
> 
> Any help would be greatly appreciated. Thanks in advance.
> 
> Jason Soza
> 
> Jason Soza
> '92 Twin Classic Red Miatae
> Juneau, Alaska
> http://www.phrog-net.com/sparkles/
> http://www.miatapix.net <--Is YOUR Miata here?
> 
> -
> 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

-- 
Sammy Lau
mailto: [EMAIL PROTECTED]
- Tell me what you want and I'll tell you how you can live without 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

Re: 4.0.1 Bugs

[Michael Grover]

I had problems with unions that result in large queries too.
I found that MySQL 4 was using Heap tables for Unions.
One can Increase the Heap Table size to help, but
What about alot of conncurrent users running unions?
This could eat up alot of memory.
Is there a switch to stop unions from using heap tables?

mike


Heikki Tuuri wrote:
> 
> Richard,
> 
> > I will look at the UNION problem later.
> 
> I think MySQL uses a HEAP type temporary table when it calculates the UNION.
> 
> HEAP type tables are allocated from the main memory. The message 'Table is
> full' tells that MySQL cannot allocate more memory.
> 
> Regards,
> 
> Heikki
> 
> > Best regards,
> >
> > Heikki Tuuri
> > Innobase Oy
> > ---
> > Order technical MySQL/InnoDB support at https://order.mysql.com/
> > See http://www.innodb.com for the online manual and latest news on InnoDB
> >
> > - Original Message -
> > From: "Richard Clarke" <[EMAIL PROTECTED]>
> > To: "Heikki Tuuri" <[EMAIL PROTECTED]>
> > Sent: Sunday, May 19, 2002 12:02 PM
> > Subject: Re: 4.0.1 Bugs
> >
> >
> > > Heikki,
> > > As for my crashes. This one is a little hard, see, we have two
> > machines
> > > that do this. Both however, display little to no information in the log.
> > One
> > > server just says mysql restarted followed by mysql was shut down
> > > incorrectly. The second server once gave an error like this,
> > > 020426 12:26:31  InnoDB: Started
> > > /usr/local/mysql-4.0.1-alpha/libexec/mysqld: ready for connections
> > > 020511  1:09:25  read_key: Got error 146 when reading table
> > > './counter/br_type'
> > > 020516  2:27:31  read_key: Got error 146 when reading table
> > > './counter/br_type'
> > > 020518  1:25:36  read_key: Got error 146 when reading table
> > > './counter/br_type'
> > > InnoDB: Error: undo->id is 136712960
> > > InnoDB: Assertion failure in thread 869069824 in file trx0undo.c line
> 1316
> > > InnoDB: We intentionally generate a memory trap.
> > > InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
> > > mysqld got signal 11;
> > > This could be because you hit a bug. It is also possible that this
> binary
> > > or one of the libraries it was linked against is corrupt, improperly
> > built,
> > > or misconfigured. This error can also be caused by malfunctioning
> > hardware.
> > > We will try our best to scrape up some info that will hopefully help
> > > diagnose
> > > the problem, but since we have already crashed, something is definitely
> > > wrong
> > > and this may fail.
> > >
> > > key_buffer_size=16773120
> > > record_buffer=1044480
> > > sort_buffer=1048568
> > > max_used_connections=190
> > > max_connections=500
> > > threads_connected=90
> > > It is possible that mysqld could use up to
> > > key_buffer_size + (record_buffer + sort_buffer)*max_connections =
> 1038376
> > K
> > > bytes of memory
> > > Hope that's ok; if not, decrease some variables in the equation.
> > >
> > > 020518 01:30:27  mysqld restarted
> > > InnoDB: Database was not shut down normally.
> > > InnoDB: Starting recovery from log files...
> > > InnoDB: Starting log scan based on checkpoint at
> > > InnoDB: log sequence number 589 1379690513
> > > InnoDB: Doing recovery: scanned up to log sequence number 589 1379756032
> > > InnoDB: Doing recovery: scanned up to log sequence number 589 1379821568
> > > InnoDB: Doing recovery: scanned up to log sequence number 589 1379887104
> > > InnoDB: Doing recovery: scanned up to log sequence number 589 1379952640
> > > InnoDB: Doing recovery: scanned up to log sequence number 589 1380018176
> > > InnoDB: Doing recovery: scanned up to log sequence number 589 1380083712
> > >
> > > The 146 errors can be ignore, they were deadlocks ocurring in a
> > > select/insert being run simultaneously. This server only gave this
> signal
> > 11
> > > once. The other times it just did its restart/recover routine as
> described
> > > above. One thing I have noticed, though not something I have monitored
> > > specifically is the memory usage of mysql. When the daemon first starts
> it
> > > has a size of about 800megs and a res(ources) of about 700/800. Over
> time
> > > however the size can grow to 1gig and the res drop to around 200. We
> have
> > a
> > > third mysql box which doesn't seem to crash, currently it is reporting.
> > >
> > > last pid: 47508;  load averages:  0.60,  0.40,  0.25
> > > up 47+19:17:15  08:49:53
> > > 116 processes: 3 running, 111 sleeping, 2 zombie
> > > CPU states: 21.4% user,  0.0% nice,  4.5% system,  0.0% interrupt, 74.1%
> > > idle
> > > Mem: 244M Active, 246M Inact, 107M Wired, 33M Cache, 112M Buf, 373M Free
> > > Swap: 1012M Total, 713M Used, 299M Free, 70% Inuse
> > >
> > >   PID USERNAME PRI NICE  SIZERES STATE  C   TIME   WCPUCPU
> COMMAND
> > > 44577 mysql 31   0  1085M 79544K RUN1  34.6H  5.37%  5.37% mysql
> > >
> > > This server is also 4.0.1, though its not crashing. It does however play
> a
> > > different role in our system and hence it doesn't perform the s

FreeBSD & LinuxThreads from BK Tree?

[Jeremy Zawodny]

Has anyone built MySQL 4.x from the BitKeeper tree using LinuxThreads
on FreeBSD?

If so, how'd you do it?

Thanks,

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

-
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

Query Problem

[Jason Soza]

I'm trying to compile 75 playlists of 25+ songs each into a database
sortable by date the show was produced, track, album, and artist. I got
advice from someone as to how to layout the table structure, and basically
it was said that I should have a basic structure of 6 tables, one for
artists, one for albums, and one for tracks. These tables should contain
whatever info I want, i.e. song title, albums, etc., and a unique id for
each. I should have 3 more tables, each linking the unique id's of each
other table together.

So, I have 3 tables as was suggested, one for songs, one for albums, one for
artists. Each has two columns, one being whatever information I'm entering,
and the other a MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY column.

I have 3 other tables containing two MEDIUMINT columns, these link each of
the 3 others. I have:
artists_tracks
tracks_albums
albums_artists

Each is setup so that the records represent 'links' - for example,
artists_tracks has artist_id and track_id columns. Each record is made up of
an artist_id and a matching track_id.

My problem is, when querying some records are lost. But only on a certain
query. For instance:
SELECT tracks.tracks, artists.artists
FROM tracks, artists, artists_tracks
WHERE tracks.id = artists_tracks.track_id AND artists.id =
artist_tracks.tracks_id

This works. It returns 614 records, each track mated with it's relative
artist. This same query works using albums and the tracks_albums table,
returning 614 records as well. Matching up albums to artists returns 413
records, which is the correct number.

However, the following query returns 451 instead of the expected 614 and I
can find no distinguishable pattern as to the records dropped:
SELECT tracks.tracks, albums.albums, artists.artists
FROM tracks, albums, artists, tracks_albums, albums_artists, artists_tracks
WHERE tracks.id = tracks_albums.track_id AND albums.id =
tracks_albums.album_id
AND albums.id = albums_artists.album_id  AND artists.id =
albums_artists.artist_id
AND artists.id = artists_tracks.artist_id  AND tracks.id =
artists_tracks.track_id

I've tried LEFT JOIN as well, and have tried numerous other suggestions out
of the manual, but everything turns up 451 records. I haven't been able to
track down WHY records are missing - it seems almost random. If I sort by
album, sometimes all songs from an album have been listed, sometimes only 3
of 5 or 7 of 10 are missing.

Any help would be greatly appreciated. Thanks in advance.

Jason Soza

Jason Soza
'92 Twin Classic Red Miatae
Juneau, Alaska
http://www.phrog-net.com/sparkles/
http://www.miatapix.net <--Is YOUR Miata here?



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

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL on CYGWIN installtion

[RBRoa]

Anybody has tried installing MySQL on CygWin?




R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No.(Office) 858-1028
(Home) 858-8889
Mobile No. (63) (919-3085267)



-
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: DELETE syntax and auto_increment 'reset'

[Paul DuBois]

At 18:29 -0400 5/22/02, Jule wrote:
>Hey guys,
>when i delete a row using the query DELETE FROM $table WHERE id = "3" LIMIT 1;
>
>how can i make it that the id column (auto_increment) starts over from 1 and
>build up to however many rows there are without counting 1 2 4 5 6 etc.?

If you're asking how to fill in holes created by deleting rows from the
middle of the sequence, you can't.

Why would you want to?

If you're really determined to do this, you can renumber the entire
column so that the rows are sequential beginning with one.

>
>any ideas?
>
>Jule
>--
>
>|\/\__/\/|
>|   Jule Slootbeek  |
>|   [EMAIL PROTECTED]   |
>|   http://blindtheory.cjb.net  |
>|   __  |
>|/\/ \/\|


-
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: change default root user name?

[Jeff Field]

That seems like it should work as well.  Just want to make sure that root
doesn't have any privileges over and beyond what a regular added user with
all privileges would have.  I wouldn't think so, but sometimes this is
something that's not specifically documented.  Thanks!

Jeff

> -Original Message-
> From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 22, 2002 5:58 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: change default root user name?
>
>
>   Hi,
>  You should be able to do it with a tweak.. You can create a user and give
> all the priviliges to that user in the user table of mysql database, and
> then takeaway the privileges from the user root. Would that work for you?
>
> Gurhan
>
> -Original Message-
> From: Jeff Field [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 22, 2002 5:27 PM
> To: [EMAIL PROTECTED]
> Subject: change default root user name?
>
>
> I've had a question that I haven't really seen addressed anywhere...
>
> Is it okay to change the default "root" user name to a different
> name?  Any
> issues involved by doing so?
>
> The reason I ask is that it seems to me that, because everyone knows that
> MySQL installs with the root user, one simple extra security measure would
> be to change the name; then someone pounding your server trying
> all possible
> password combos with root won't stand a chance.  Am I missing anything?
>
> Jeff
>
>
> -
> 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: Backslash BUG?

[龔惠樑(Borus.Kung)]

I think this is a bug
it seems it is reasonable since UNIX/C does consider back slash a
escape prefix for a sequence, in some case, it is not as nice as you think.

in multi-character set, back slash can be included in one of the
multi-characters.

I fix the problem by writing a VB program and a special handling in UNIX/C
program. Method is just to add another back slash whenever a back slash
is detected.
this is sure also a problem in load data, insert ...infile , etc commands.

let me say it another way
if there is a X sequence in UNIX/C
whenever "X" is encountered , you must add another "X" to it in order to
let the string normally insert into table, what do you think?
the problem is whether you think back slash can be part of a string.

FYI, database like oracle, informix, sybase all support multicharacter set
with back slash contained string support, consider it, please~

:)


Borus

- Original Message -
寄件者: "Benjamin Pflugmann" <[EMAIL PROTECTED]>
收件者: "Bruno Batarelo" <[EMAIL PROTECTED]>
副本: <[EMAIL PROTECTED]>
傳送日期: 2002年5月23日 AM 06:58
主旨: Re: Backslash BUG?


> Hi.
>
> Because the backslash is the escaping character and therefore has a
> special meaning, you have to escape it itself to get a plain
> backslash. I.e.
>
> mysql> insert into table (Field1) values ('\\');
>
> This will insert one backslash. This is documented here:
> http://www.mysql.com/doc/m/y/mysql.html
>
> The above statement is only true for the command line client and any
> other interface which uses backslash this way (e.g. C/C++ strings).
>
> Regards,
>
> Benjamin.
>
>
>
> On Wed, May 22, 2002 at 11:58:15PM +0200, [EMAIL PROTECTED]
wrote:
> > Greetings
> >
> > I use latest stabile version of MySQL. Please, try to create temp table
or
> > normal table and from mysql.exe try to insert a backslash symbol into a
> > field. Here is an example:
> >
> > Enter password: **
> > Welcome to the MySQL monitor.  Commands end with ; or \g.
> > Your MySQL connection id is 441 to server version: 3.23.49-max
> >
> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> >
> > mysql> \u elba
> > Database changed
> > mysql> create temporary table TTable(Field1 mediumtext);
> > Query OK, 0 rows affected (0.04 sec)
> >
> > mysql> insert into ttable (Field1) values ('\');
> > '>
> > '>
> > '>
> > '>
> >
> >
> > That means that query ok message is skipped. The same problem occur if I
try
> > the same operation with blob data type. Please report me about this.
> >
> > Bruno
>
>
> --
> [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

RE: Duplicate Record

[Gurhan Ozen]

The answer is there ... :
http://www.mysql.com/doc/L/O/LOAD_DATA.html

Gurhan


-Original Message-
From: Wong Zach-CHZ013 [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 8:18 PM
To: Wong Zach-CHZ013; '[EMAIL PROTECTED]'
Subject: RE: Duplicate Record




>  -Original Message-
> From: Wong Zach-CHZ013
> Sent: Wednesday, May 22, 2002 7:11 PM
> To:   [EMAIL PROTECTED]
> Subject:  Duplicate Record
>
> Hi
> 1) Suppose, in a file, say testfile.sql,
> it contains a line
> eg:
> LOAD DATA INFILE "mlc_stat_" INTO table mlc FIELDS TERMINATED BY '|' ;
> And further suppose the record in file mlc_stat_ already exists in the
> table mlc.
>
> Does MySQL have the ability to stop inserting this duplicated record
> when I ran a command
>
> mysql -u root -penter < testfile.sql ?
>
> Thank you

-
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: Duplicate Record

[Wong Zach-CHZ013]

>  -Original Message-
> From: Wong Zach-CHZ013  
> Sent: Wednesday, May 22, 2002 7:11 PM
> To:   [EMAIL PROTECTED]
> Subject:  Duplicate Record
> 
> Hi
> 1) Suppose, in a file, say testfile.sql, 
> it contains a line
> eg:
> LOAD DATA INFILE "mlc_stat_" INTO table mlc FIELDS TERMINATED BY '|' ;
> And further suppose the record in file mlc_stat_ already exists in the
> table mlc.
> 
> Does MySQL have the ability to stop inserting this duplicated record 
> when I ran a command
> 
> mysql -u root -penter < testfile.sql ?
> 
> Thank you

-
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

Duplicate Record

[Wong Zach-CHZ013]

Hi
1) Suppose, in a file, say testfile.sql, 
it contains a line
eg:
LOAD DATA INFILE "mlc_stat_" INTO table mlc FIELDS TERMINATED BY '|' ;
And further suppose the record in file mlc_stat_ already exists in the
table mlc.

Does MySQL have the ability to stop inserting this duplicated record 
when I ran a command

mysql -u root -penter < testfile.sql ?

Thank you

-
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

Duplicate Record

[Wong Zach-CHZ013]

Hi
1) Suppose, in a file, say testfile.sql, 
it contains a line
eg:
LOAD DATA INFILE "mlc_stat_" INTO table mlc FIELDS TERMINATED BY '|' ;
And further suppose the record in file mlc_stat_ already exists in the
table mlc.

Does MySQL have the ability to stop inserting this duplicated record 
when I ran a command

mysql -u root -penter < testfile.sql ?

Thank you

-
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

Caching

[Ravi Verma]

Greetings Friends,

How could cache the whole mysql database in the memory? Which parameters
would help?

Regards.

Ravi Verma
916 705 3261


-
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

Moving Data Between Proprietary Database and MySQL

[Bruce Vander Werf]

I am adding a web interface to a Windows application I have written
that uses another proprietary database system. To allow for my
customers to use both Linux and WinNT based web servers, I have
settled on MySQL for the web database. I am working on a strategy for
allowing my customers to move the database from one platform to the
other as needed. Here are the issues I am facing at this point:

Because most web providers will not allow direct TCP/IP access to
MySQL servers, I am considering the following strategy:

a) Save the proprietary database to a file containing a series of SQL
CREATE TABLE and INSERT INTO calls.

b) Upload the SQL file to the server via FTP.

c) Launch a PHP script on the web server from my program that executes
the SQL file to insert the data into the MySQL database.

Going the other way would be similar:

a) Launch a PHP script on the web server from my program to save the
MySQL database to a file containing a series of SQL CREATE TABLE and
INSERT INTO calls.

b) Download the SQL file from the server via FTP.

c) Execute the SQL file in my program to insert the data into the
proprietary database.

At this point, it's going to be a wholesale send and replace of the
whole database. At some point in the future, I would like to add some
synchronization logic, but that is a subject for another day.

Another issue I am running into is the difference between the
proprietary database and MySQL in how quotes are escaped. The
proprietary database wants two sequential quote characters, MySQL uses
a backslash before the quote character.

Has anyone else gone down this road before? Any comments on this
strategy? Are there any tools or routines available to help facilitate
this process?

--
Bruce Vander Werf
[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

including text or blob in large table that is freaquently searched.

[Ken Easson]

hello,
i have a table as follows:
Members  (
 teamID   int(6) unsigned default '0',
 ID   int(11) unsigned NOT NULL auto_increment,
 name varchar(30) default NULL,
 number   smallint(5) unsigned default NULL,
 height   tinyint(3) unsigned default NULL,
 weight   tinyint(3) unsigned default NULL,
 DOB  varchar(21) default NULL,
 Hometown varchar(30) default NULL,
 yearsPlaying tinyint(3) unsigned default NULL,
 gamesPlayed  tinyint(3) unsigned default NULL,
 Points   smallint(6) unsigned default NULL,
 emailvarchar(60) default NULL,
 retired  tinyint(3) unsigned default NULL,
 detailsIDint(11) unsigned default NULL,
   PRIMARY KEY ( ID  ),
   KEY   teamID  (   teamID  )

i am trying to determine which will make this table work faster in my web 
applications.
if i keep detailsID as a tinyint that refers to a new table of the structure:
memberDetails(
 ID   int(11) unsigned NOT NULL auto_increment,
 details  blob,
   PRIMARY KEY ( ID  ),

OR if i alter detailsID int(11) to details blob,
i'm not interested so much in normalization, but optimization where i may 
be searching for records regularly based on teamID, ID, name, number, and 
name AND number.
i doubt i'll ever need to search the details records.
but with so many criteria for indexing - i'm wondering if having the blob 
in the main table will slow things down.
this table is my primary table in a very hi volume website, and should 
expect some 3000 - 5000 hits per day.

i've looked thru table optimization in the manual, but i'm not confident 
with how mysql sets up its searches based on indexes. and find that it 
doesn't always use the indexes i create to assist in the searches.

i'm designing for around 15,000 records in this table. where details can be 
several lines of text (on average 150 words).


ken easson
justken.net
[EMAIL PROTECTED]
justken web programming and technical support.


-
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: strange fulltext behavior

[Przemyslaw Popielarski]

"Sergei Golubchik" <[EMAIL PROTECTED]> wrote:
> It looks like a bug. Can you create a test case for this ?

create table tBooks (
isbn char(10) not null primary key,
title varchar(60) not null,
fulltext index (title)
);

insert into tBooks (isbn,title) values
('1876340436','2000 Lonely Planet Calendar');

insert into tBooks (isbn,title) values
('0852297904','Britannica 2002 on CD-ROM Expanded ed');

SELECT isbn,title FROM tBooks
WHERE tBooks.isbn="1876340436"
AND MATCH (tBooks.title) AGAINST ("britannica")

++-+
| isbn   | title   |
++-+
| 1876340436 | 2000 Lonely Planet Calendar |
++-+
1 row in set (0.00 sec)

mysql  Ver 11.16 Distrib 3.23.49, for Win95/Win98 (i32)
Windows 98 SE

-- 
./ premax
./ [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: Installing / Running

[Gurhan Ozen]

How did you try to connect it??? IS your mysql server running? If yes is the
mysql.sock location correct?

Gurhan

-Original Message-
From: Glenn Hancock [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 4:48 PM
To: MySql
Subject: Installing / Running


I have installed MySQL on my RH Linux 7.3 box.  I am trying to use it with
the Apache web server but haven't gotten that far.  I downloaded the source
version because I am new to Linux and felt that I would understand better
where everything was as far as the files and source code.

The original attempt was to install the rpm file and it did so without a
problem.  However, when I started going through some testing I couldn't find
some of the files I needed so I opted to install the source.  The reason I
mention this is just in case that might be a problem.

I have MySQL installed in the /usr/local/mysql folder and everything appears
to have compiled and installed just fine.  All tasks listed on your website
for installing the source worked without an issue until I get to the part
where I am actually testing it.

Starting the server seems to work as I have the processes running, however,
when I attempt to connect to the server in any way (and this happened with
the rpm and the source) I receive a message stating the following:

Can't connect to local MySQL server through socket 'tmp/mysql.sock' (2)

Can anyone tell me what I have done wrong and what I need to do in order to
get the database server operational?

Thanks in advance,

Glenn Hancock

-glenn hancock
[EMAIL PROTECTED] 

SofTek Software Int'l, Inc.
www.softeksoftware.com 
678-583-8439


-
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: Backslash BUG?

[Benjamin Pflugmann]

Hi.

Because the backslash is the escaping character and therefore has a
special meaning, you have to escape it itself to get a plain
backslash. I.e.

mysql> insert into table (Field1) values ('\\');

This will insert one backslash. This is documented here:
http://www.mysql.com/doc/m/y/mysql.html

The above statement is only true for the command line client and any
other interface which uses backslash this way (e.g. C/C++ strings).

Regards,

Benjamin.



On Wed, May 22, 2002 at 11:58:15PM +0200, [EMAIL PROTECTED] wrote:
> Greetings
> 
> I use latest stabile version of MySQL. Please, try to create temp table or
> normal table and from mysql.exe try to insert a backslash symbol into a
> field. Here is an example:
> 
> Enter password: **
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 441 to server version: 3.23.49-max
> 
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> 
> mysql> \u elba
> Database changed
> mysql> create temporary table TTable(Field1 mediumtext);
> Query OK, 0 rows affected (0.04 sec)
> 
> mysql> insert into ttable (Field1) values ('\');
> '>
> '>
> '>
> '>
> 
> 
> That means that query ok message is skipped. The same problem occur if I try
> the same operation with blob data type. Please report me about this.
> 
> Bruno


-- 
[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: change default root user name?

[Gurhan Ozen]

  Hi,
 You should be able to do it with a tweak.. You can create a user and give
all the priviliges to that user in the user table of mysql database, and
then takeaway the privileges from the user root. Would that work for you?

Gurhan

-Original Message-
From: Jeff Field [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 5:27 PM
To: [EMAIL PROTECTED]
Subject: change default root user name?


I've had a question that I haven't really seen addressed anywhere...

Is it okay to change the default "root" user name to a different name?  Any
issues involved by doing so?

The reason I ask is that it seems to me that, because everyone knows that
MySQL installs with the root user, one simple extra security measure would
be to change the name; then someone pounding your server trying all possible
password combos with root won't stand a chance.  Am I missing anything?

Jeff


-
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: Backslash BUG?

[domi]

Hi Bruno !!

Nope, the query OK is NOT skipped but the query has not
been executed at all !!
And this is not a bug !!!

The backslash in Your query escapes the following single quote
and the query will not be terminated by ";" . 
You should propably escape the backslash instead like this
mysql> insert into ttable (Field1) values ('');

=d0Mi=


> Greetings
> 
> I use latest stabile version of MySQL. Please, try to create temp table or
> normal table and from mysql.exe try to insert a backslash symbol into a
> field. Here is an example:
> 
> Enter password: **
> Welcome to the MySQL monitor.  Commands end with ; or g.
> Your MySQL connection id is 441 to server version: 3.23.49-max
> 
> Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
> 
> mysql> u elba
> Database changed
> mysql> create temporary table TTable(Field1 mediumtext);
> Query OK, 0 rows affected (0.04 sec)
> 
> mysql> insert into ttable (Field1) values ('');
> '>
> '>
> '>
> '>
> 
> 
> That means that query ok message is skipped. The same problem occur if I try
> the same operation with blob data type. Please report me about this.
> 
> Bruno
> 
>
> -
> 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: date_format question

[Gurhan Ozen]

Yes, there is .. You can use %D (note that it is capital D) instead of %e to
get what you wanna get.

See: http://www.mysql.com/doc/D/a/Date_and_time_functions.html

Gurhan


-Original Message-
From: Lee P Reilly [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 5:51 PM
To: MySQL
Subject: date_format question


Hi,

I have a quick question concerning date/time functions. If I query
MySQL:
   SELECT date_format(date, '%W %M %e %Y') FROM experiments where
expid=3706
  It returns: Wednesday May 2 1979

Are there existing methods for determining whether to add "st", "nd" or
"rd" after the %e?
e.g. in this case, it would instead read:
   Wednesday May 2nd 1979

Thanks very much in advance for any help.

- Best regards,

Lee Reilly


-
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: Backslash BUG?

[Gurhan Ozen]

MySQL is doing the right thing, \' will mean single-quote character, so you
will have to close it with another one. If you want to enter just a
backslash do '\\' .

See: http://www.mysql.com/doc/S/t/String_syntax.html

Gurhan

-Original Message-
From: Bruno Batarelo [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 5:58 PM
To: [EMAIL PROTECTED]
Subject: Backslash BUG?


Greetings

I use latest stabile version of MySQL. Please, try to create temp table or
normal table and from mysql.exe try to insert a backslash symbol into a
field. Here is an example:

Enter password: **
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 441 to server version: 3.23.49-max

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> \u elba
Database changed
mysql> create temporary table TTable(Field1 mediumtext);
Query OK, 0 rows affected (0.04 sec)

mysql> insert into ttable (Field1) values ('\');
'>
'>
'>
'>


That means that query ok message is skipped. The same problem occur if I try
the same operation with blob data type. Please report me about this.

Bruno


-
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 design mysql clusters with 30,000 clients?

[Dave Watkins]

At 16:02 22/05/2002 +0800, Patrick Hsieh wrote:
>Hello list,
>
>I am expecting to have 30,000 http clients visting my website at the
>same time. To meet the HA requirement, we use dual firewall, dual
>Layer-4 switch and multiple web servers in the backend. My problem is,
>if we use the user-tracking system with apache, php and mysql, it will
>surely brings a huge amount of database traffic. How can I balance mysql
>load among multiple mysql server yet assure the data consistency among
>them? My idea is:
>
>1. use 3 or more mysql servers for write/update and more than 5 mysql
>servers for read-only. Native mysql replication is applied among them.
>In the mysql write servers, use 1 way replication like A->B->C->A to
>keep the data consistency. But I am afraid the loss of data, since we
>can't take the risk on it, especially when we are relying our billing
>system on it.

This will not work. MySQL replication does not work like that. With MySQL 
replication you have one master and all others replicate from it. It is 
also the only server that can write to the DB. Your options for following 
this route would be to either use the experimantal 2 way replication 
support in the beta of MySQL4. Or use a different DB

Dave


-
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: Backslash BUG?

[Paul DuBois]

At 23:58 +0200 5/22/02, Bruno Batarelo wrote:
>Greetings
>
>I use latest stabile version of MySQL. Please, try to create temp table or
>normal table and from mysql.exe try to insert a backslash symbol into a
>field. Here is an example:
>
>Enter password: **
>Welcome to the MySQL monitor.  Commands end with ; or \g.
>Your MySQL connection id is 441 to server version: 3.23.49-max
>
>Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
>mysql> \u elba
>Database changed
>mysql> create temporary table TTable(Field1 mediumtext);
>Query OK, 0 rows affected (0.04 sec)
>
>mysql> insert into ttable (Field1) values ('\');

Double it: '\\'

> '>
> '>
> '>
> '>
>
>
>That means that query ok message is skipped. The same problem occur if I try
>the same operation with blob data type. Please report me about this.
>
>Bruno

-
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

DELETE syntax and auto_increment 'reset'

[Jule]

Hey guys,
when i delete a row using the query DELETE FROM $table WHERE id = "3" LIMIT 1;

how can i make it that the id column (auto_increment) starts over from 1 and
build up to however many rows there are without counting 1 2 4 5 6 etc.?

any ideas?

Jule
--

|\/\__/\/|
|   Jule Slootbeek   |
|   [EMAIL PROTECTED]|
|   http://blindtheory.cjb.net   |
|   __   |
|/\/  \/\|

-
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

Installation / Running

[Glenn Hancock]

I have installed MySQL on my RH Linux 7.3 box.  I am trying to use it with
the Apache web server but haven't gotten that far.  I downloaded the source
version because I am new to Linux and felt that I would understand better
where everything was as far as the files and source code.

The original attempt was to install the rpm file and it did so without a
problem.  However, when I started going through some testing I couldn't find
some of the files I needed so I opted to install the source.  The reason I
mention this is just in case that might be a problem.

I have MySQL installed in the /usr/local/mysql folder and everything appears
to have compiled and installed just fine.  All tasks listed on your website
for installing the source worked without an issue until I get to the part
where I am actually testing it.

Starting the server seems to work as I have the processes running, however,
when I attempt to connect to the server in any way (and this happened with
the rpm and the source) I receive a message stating the following:

Can't connect to local MySQL server through socket 'tmp/mysql.sock' (2)

Can anyone tell me what I have done wrong and what I need to do in order to
get the database server operational?

Thanks in advance,
-glenn hancock
[EMAIL PROTECTED] 

SofTek Software Int'l, Inc.
www.softeksoftware.com 
678-583-8439


-
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

Grant tables

[Glenn Hancock]

I have  had trouble with the script that creates my user access tables.
I am assuming those tables should get created in the ./var/mysql folder.
Its my fault but I removed those tables just to see if they had anything to
do with me not being able to use the mysql database server.  I figured it
was ok because I thought they had been created by the script but now they
are no longer their and subsequent runs of the script are not creating them.
Am I missing something?

Thanks,

-glenn hancock
[EMAIL PROTECTED] 

SofTek Software Int'l, Inc.
www.softeksoftware.com 
678-583-8439


-
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

Backslash BUG?

[Bruno Batarelo]

Greetings

I use latest stabile version of MySQL. Please, try to create temp table or
normal table and from mysql.exe try to insert a backslash symbol into a
field. Here is an example:

Enter password: **
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 441 to server version: 3.23.49-max

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> \u elba
Database changed
mysql> create temporary table TTable(Field1 mediumtext);
Query OK, 0 rows affected (0.04 sec)

mysql> insert into ttable (Field1) values ('\');
'>
'>
'>
'>


That means that query ok message is skipped. The same problem occur if I try
the same operation with blob data type. Please report me about this.

Bruno


-
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

date_format question

[Lee P Reilly]

Hi,

I have a quick question concerning date/time functions. If I query
MySQL:
   SELECT date_format(date, '%W %M %e %Y') FROM experiments where
expid=3706
  It returns: Wednesday May 2 1979

Are there existing methods for determining whether to add "st", "nd" or
"rd" after the %e?
e.g. in this case, it would instead read:
   Wednesday May 2nd 1979

Thanks very much in advance for any help.

- Best regards,

Lee Reilly


-
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

change default root user name?

[Jeff Field]

I've had a question that I haven't really seen addressed anywhere...

Is it okay to change the default "root" user name to a different name?  Any
issues involved by doing so?

The reason I ask is that it seems to me that, because everyone knows that
MySQL installs with the root user, one simple extra security measure would
be to change the name; then someone pounding your server trying all possible
password combos with root won't stand a chance.  Am I missing anything?

Jeff


-
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: Ibdata1 file thats just too big...

[MikeParton]

I am keen to here a response to this as well!

TIA

Mike
- Original Message -
From: "Williamson, David" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 22, 2002 4:38 PM
Subject: Ibdata1 file thats just too big...


> Hi there,
>
> My Ibdatafile is set too big (the disk is full to the point that nothing
is
> executing properly) I am wondering is it safe to delete this file and then
> in the my.cnf file reset the size to something smaller... - how does the
> Ibdata file work in conjunction with mysql...
> Will I lose data if I do this?
>
> Many thanks,
>
> David
>
>
> -
> 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: columb structure

[Myk Melez]

Chris Knipe wrote:

 >Multiple subnets :/
 >
 >columns like this:
 >octet1, octet2, octet3, octet4
 >195,196,192,23
 >232,196,231,11
 >
 >This would then be seen as a duplicate

Not if you have a single index spanning all four columns (as opposed to
four indexes, one on each column).  With the single index, individual
columns can contain values that are duplicated in other rows as long as
the combination of values is unique.

-myk

--
[sql, mysql, query]


-
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: Help linking c++ program

[comp boy]

I ran: nm /usr/local/lib/libmysqlclient.a  | grep mysql
and all of the function that are undefined are there.

-
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: Transaction isolation

[Ryan Hatch]

are you familiar with the different MySQL table types?

they are:
MyISAM
BDB
Gemini
InnoDB

but InnoDB is the most robust, supports row-level locking, ACID transactions (no dirty 
reads), and foreign key restraints... read up on it here:  http://www.innodb.com   
but InnoDB does multi-versioning, so be sure to read carefully

Ki Mien wrote:

> Hi all,
>
> We need to prevent Dirty Reading.
>
> How can we perform transaction isolation in mySQL? Are the following: 
>TRANSACTION_SERIALIZABLE, TRANSACTION_REPEATABLE_READ, TRANSACTION_READ_COMMITTED, 
>TRANSACTION_READ_UNCOMMITTED, TRANSACTION_NONE supported by MySQL? Or has anyone 
>tried any other alternatives?
>
> cheers,
> Ki Mien
>
> 
> Take part in the Penning on Squares Chinese Essay Writing Contest.
> Submit your masterpieces or vote for your favourite works, and win attractive prizes.
> Be there or be SQUARE!
> http://sea.litcontest.lycosasia.com
>
> cOntact @ Lycos 
> = 20MB for email and filestore + lots of other goodies...
>
> -
> 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

Can't connect to MySQL server on 'localhost' (10061)

[Gunnar Giesinger]

when i try to run phpMyAdmin on an apache server on Windows 2000 I always
get the following message:

Can't connect to MySQL server on 'localhost' (10061)

could anyone please tell me how to configure MySQL to run via tcp/ip on
localhost?
thanks a lot
gunnar


-
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: 4.0.1 Bugs

[Heikki Tuuri]

Richard,

> I will look at the UNION problem later.

I think MySQL uses a HEAP type temporary table when it calculates the UNION.

HEAP type tables are allocated from the main memory. The message 'Table is
full' tells that MySQL cannot allocate more memory.


Regards,

Heikki


> Best regards,
>
> Heikki Tuuri
> Innobase Oy
> ---
> Order technical MySQL/InnoDB support at https://order.mysql.com/
> See http://www.innodb.com for the online manual and latest news on InnoDB
>
> - Original Message -
> From: "Richard Clarke" <[EMAIL PROTECTED]>
> To: "Heikki Tuuri" <[EMAIL PROTECTED]>
> Sent: Sunday, May 19, 2002 12:02 PM
> Subject: Re: 4.0.1 Bugs
>
>
> > Heikki,
> > As for my crashes. This one is a little hard, see, we have two
> machines
> > that do this. Both however, display little to no information in the log.
> One
> > server just says mysql restarted followed by mysql was shut down
> > incorrectly. The second server once gave an error like this,
> > 020426 12:26:31  InnoDB: Started
> > /usr/local/mysql-4.0.1-alpha/libexec/mysqld: ready for connections
> > 020511  1:09:25  read_key: Got error 146 when reading table
> > './counter/br_type'
> > 020516  2:27:31  read_key: Got error 146 when reading table
> > './counter/br_type'
> > 020518  1:25:36  read_key: Got error 146 when reading table
> > './counter/br_type'
> > InnoDB: Error: undo->id is 136712960
> > InnoDB: Assertion failure in thread 869069824 in file trx0undo.c line
1316
> > InnoDB: We intentionally generate a memory trap.
> > InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
> > mysqld got signal 11;
> > This could be because you hit a bug. It is also possible that this
binary
> > or one of the libraries it was linked against is corrupt, improperly
> built,
> > or misconfigured. This error can also be caused by malfunctioning
> hardware.
> > We will try our best to scrape up some info that will hopefully help
> > diagnose
> > the problem, but since we have already crashed, something is definitely
> > wrong
> > and this may fail.
> >
> > key_buffer_size=16773120
> > record_buffer=1044480
> > sort_buffer=1048568
> > max_used_connections=190
> > max_connections=500
> > threads_connected=90
> > It is possible that mysqld could use up to
> > key_buffer_size + (record_buffer + sort_buffer)*max_connections =
1038376
> K
> > bytes of memory
> > Hope that's ok; if not, decrease some variables in the equation.
> >
> > 020518 01:30:27  mysqld restarted
> > InnoDB: Database was not shut down normally.
> > InnoDB: Starting recovery from log files...
> > InnoDB: Starting log scan based on checkpoint at
> > InnoDB: log sequence number 589 1379690513
> > InnoDB: Doing recovery: scanned up to log sequence number 589 1379756032
> > InnoDB: Doing recovery: scanned up to log sequence number 589 1379821568
> > InnoDB: Doing recovery: scanned up to log sequence number 589 1379887104
> > InnoDB: Doing recovery: scanned up to log sequence number 589 1379952640
> > InnoDB: Doing recovery: scanned up to log sequence number 589 1380018176
> > InnoDB: Doing recovery: scanned up to log sequence number 589 1380083712
> >
> > The 146 errors can be ignore, they were deadlocks ocurring in a
> > select/insert being run simultaneously. This server only gave this
signal
> 11
> > once. The other times it just did its restart/recover routine as
described
> > above. One thing I have noticed, though not something I have monitored
> > specifically is the memory usage of mysql. When the daemon first starts
it
> > has a size of about 800megs and a res(ources) of about 700/800. Over
time
> > however the size can grow to 1gig and the res drop to around 200. We
have
> a
> > third mysql box which doesn't seem to crash, currently it is reporting.
> >
> > last pid: 47508;  load averages:  0.60,  0.40,  0.25
> > up 47+19:17:15  08:49:53
> > 116 processes: 3 running, 111 sleeping, 2 zombie
> > CPU states: 21.4% user,  0.0% nice,  4.5% system,  0.0% interrupt, 74.1%
> > idle
> > Mem: 244M Active, 246M Inact, 107M Wired, 33M Cache, 112M Buf, 373M Free
> > Swap: 1012M Total, 713M Used, 299M Free, 70% Inuse
> >
> >   PID USERNAME PRI NICE  SIZERES STATE  C   TIME   WCPUCPU
COMMAND
> > 44577 mysql 31   0  1085M 79544K RUN1  34.6H  5.37%  5.37% mysql
> >
> > This server is also 4.0.1, though its not crashing. It does however play
a
> > different role in our system and hence it doesn't perform the same
queries
> > as the other two.
> > I have iteratively developed the queries on the other server, all the
> while
> > monitoring innodb monitor output amongst other things. I am certain no
> > transactions are stuck or otherwise.
> > One of the crashing systems crashed yesterday infact, the log output
just
> > said restared/shutdown incorrectly etc (no caught signals). Whether its
> any
> > help or not, I don't know but here is some innodb_monitor output.
>
>



-
Before posting, please check:
   http://www

Re: columb structure

[Chris Knipe]

And who said you ever get to old to learn :)

Never knew I could do unique indexes like this.. Definitely what I'm
looking for... Thanks guys :)

--
me

- Original Message -
From: "Ryan Hatch" <[EMAIL PROTECTED]>
To: "Chris Knipe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, May 22, 2002 9:59 PM
Subject: Re: columb structure


> you're not making much sense to me
>
> in your first post... you wanted make sure every IP you have is unique,
correct?
>
> Do an ALTER TABLE  with "UNIQUE(octet1, octet2, octet3, octet4)".
>
> or am I not understanding your question?
>
> Regards,
>
> -Ryan Hatch
> * remember me? yesterday #php on DALNet, G3X7
>
>
> Chris Knipe wrote:
>
> > Multiple subnets :/
> >
> > columns like this:
> > octet1, octet2, octet3, octet4
> > 195,196,192,23
> > 232,196,231,11
> >
> > This would then be seen as a duplicate
> >
> > Kind Regards,
> >
> > Chris Knipe
> > MegaLAN Corporate InterNetworking Services
> > Tel: +27 21 854 7064
> > Cell: +27 72 434 7582
> >
> > - Original Message -
> > From: "Myk Melez" <[EMAIL PROTECTED]>
> > To: "Chris Knipe" <[EMAIL PROTECTED]>
> > Cc: "mysql" <[EMAIL PROTECTED]>
> > Sent: Wednesday, May 22, 2002 8:43 PM
> > Subject: Re: columb structure
> >
> > > Chris Knipe wrote:
> > >
> > > >I'm currently storing them into varchar(16), although I've been
thinking
> > of
> > > >doing it as for smallint columns, but then I can't be 100% certain I
> > won't
> > > >get duplicates.
> > > >
> > > Why not?  Just define a UNIQUE index across all four smallint columns,
> > > and MySQL will throw an error if you attempt to insert a duplicate
> > > record into the table.
> > >
> > > -myk
> > >
> > >
> > >
> >
> > -
> > 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

Ibdata1 file thats just too big...

[Williamson, David]

Hi there,

My Ibdatafile is set too big (the disk is full to the point that nothing is
executing properly) I am wondering is it safe to delete this file and then
in the my.cnf file reset the size to something smaller... - how does the
Ibdata file work in conjunction with mysql...
Will I lose data if I do this?

Many thanks,

David


-
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

Help linking c++ program

[comp boy]

I am trying to compile a custom program I wrote some c++ wrapper classes
around the mysql c function.  I have the mysqlclient_r lib installed in
/usr/local/lib/

ls -l /usr/local/lib/libmysqlclient_r.a
rw-r--r--1 root root   287356 May 22 13:28
/usr/local/lib/libmysqlclient_r.a

The files compile fine but when make tries to link them all together I get a
bunch of undefined reference.  I am using MYSQL 3.23.49.

g++ -v
Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.3 2.96-110)

Anyone have an idea what I am doing wrong?  Below is the output from make.

TIA
Jason

make[1]: Entering directory `/home/jason/ias'
### Making Linux_server
make "CC=g++" "CFLAGS=-O -g -I/home/jason/mysql/include "
"CPPFLAGS=-O -g -I/home/jason/mysql/include "
"LIBS=-L/usr/local/lib/ -lm -lmysqlclient_r -lz -lnsl -lrt -lpthread "
realTime
make[2]: Entering directory `/home/jason/ias'
g++ -O -g -I/home/jason/mysql/include  -L/usr/local/lib/ -lm -lmysqlclient_r
 -lz -lnsl -lrt -lpthread -L/usr/local/lib/ -o realTime main.o Timer.o ...
UserEvent.o IASConnection.o Date.o SendStateMessage.o
MySQLStatement.o: In function `MySQLStatement::query(char const *, int)':
/home/jason/ias/MySQLStatement.cpp:14: undefined reference to
`mysql_real_query'
MySQLStatement.o: In function `MySQLStatement::getResults(void)':
/home/jason/ias/MySQLStatement.cpp:18: undefined reference to
`mysql_store_result'
/home/jason/ias/MySQLStatement.cpp:20: undefined reference to
`MySQLResultSet::MySQLResultSet(st_mysql_res *)'
MySQLStatement.o: In function `MySQLStatement::numRowsAffect(void)':
/home/jason/ias/MySQLStatement.cpp:24: undefined reference to
`mysql_affected_rows'
MySQLConnection.o: In function `Connection type_info function':
/home/jason/ias/MySQLDatabase.h(.text+0x14): undefined reference to
`mysql_init'
MySQLConnection.o: In function `MySQLConnection::connect(char const *, char
const *, char const *, char const *, unsigned int, char const *, unsigned
int)':
/home/jason/ias/MySQLConnection.cpp:8: undefined reference to
`mysql_real_connect'
MySQLConnection.o: In function `MySQLConnection::isConnected(void)':
/home/jason/ias/MySQLConnection.cpp:12: undefined reference to `mysql_ping'
MySQLConnection.o: In function `MySQLConnection::getError(void)':
/usr/include/g++-3/std/bastring.h:183: undefined reference to `mysql_error'
MySQLConnection.o: In function `MySQLConnection::getErrorCode(void)':
/home/jason/ias/MySQLConnection.cpp:21: undefined reference to `mysql_errno'
MySQLConnection.o: In function `MySQLConnection::close(void)':
/home/jason/ias/MySQLConnection.cpp:25: undefined reference to `mysql_close'
MySQLConnection.o: In function `MySQLConnection::getConnectionInfo(void)':
/usr/include/g++-3/std/bastring.h:183: undefined reference to
`mysql_get_host_info'
MySQLPreparedStatement.o: In function `MySQLPreparedStatement::query(char
const *, int)':
/home/jason/ias/MySQLPreparedStatement.cpp:148: undefined reference to
`mysql_real_query'
MySQLPreparedStatement.o: In function
`MySQLPreparedStatement::getResults(void)':
/home/jason/ias/MySQLPreparedStatement.cpp:152: undefined reference to
`mysql_store_result'
/home/jason/ias/MySQLPreparedStatement.cpp:154: undefined reference to
`MySQLResultSet::MySQLResultSet(st_mysql_res *)'
MySQLPreparedStatement.o: In function
`MySQLPreparedStatement::numRowsAffect(void)':
/home/jason/ias/MySQLPreparedStatement.cpp:158: undefined reference to
`mysql_affected_rows'
MySQLPreparedStatement.o: In function
`MySQLPreparedStatement::encodeString(char const *, unsigned long)':
/home/jason/ias/MySQLPreparedStatement.cpp:163: undefined reference to
`mysql_real_escape_string'
collect2: ld returned 1 exit status
make[2]: *** [realTime] Error 1
make[2]: Leaving directory `/home/jason/ias'
make[1]: *** [Linux_server] Error 2
make[1]: Leaving directory `/home/jason/ias'
make: *** [all] Error 2



-
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

Re: transferring databases

[Myk Melez]

abw wrote:

> Is it possible to zip up database directories on one server and move 
> them to another server, then simply unzip them?

Yes.

> If so, once that is done, does something need to be done to mysql so 
> it is aware of the databases? Is there some file that has a list of 
> databases that must be updated or something?

No.

> Mysql is running, because I see it in the process list, and from what 
> the customer told me, he does see the databases, but he cannot access 
> them.

This is probably a file permissions problem.  Make sure the user mysqld 
runs as (probably "mysql") has access to the database directory and 
files ("chown -R [name of mysql user] [directory name]" should do the 
trick).

-myk



-
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

Transaction isolation

[Ki Mien]

Hi all,

We need to prevent Dirty Reading. 

How can we perform transaction isolation in mySQL? Are the following: 
TRANSACTION_SERIALIZABLE, TRANSACTION_REPEATABLE_READ, TRANSACTION_READ_COMMITTED, 
TRANSACTION_READ_UNCOMMITTED, TRANSACTION_NONE supported by MySQL? Or has anyone tried 
any other alternatives?

cheers,
Ki Mien


Take part in the Penning on Squares Chinese Essay Writing Contest.
Submit your masterpieces or vote for your favourite works, and win attractive prizes.
Be there or be SQUARE!
http://sea.litcontest.lycosasia.com

cOntact @ Lycos 
= 20MB for email and filestore + lots of other goodies...

-
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: columb structure

[Ryan Hatch]

you're not making much sense to me

in your first post... you wanted make sure every IP you have is unique, correct?

Do an ALTER TABLE  with "UNIQUE(octet1, octet2, octet3, octet4)".

or am I not understanding your question?

Regards,

-Ryan Hatch
* remember me? yesterday #php on DALNet, G3X7


Chris Knipe wrote:

> Multiple subnets :/
>
> columns like this:
> octet1, octet2, octet3, octet4
> 195,196,192,23
> 232,196,231,11
>
> This would then be seen as a duplicate
>
> Kind Regards,
>
> Chris Knipe
> MegaLAN Corporate InterNetworking Services
> Tel: +27 21 854 7064
> Cell: +27 72 434 7582
>
> - Original Message -
> From: "Myk Melez" <[EMAIL PROTECTED]>
> To: "Chris Knipe" <[EMAIL PROTECTED]>
> Cc: "mysql" <[EMAIL PROTECTED]>
> Sent: Wednesday, May 22, 2002 8:43 PM
> Subject: Re: columb structure
>
> > Chris Knipe wrote:
> >
> > >I'm currently storing them into varchar(16), although I've been thinking
> of
> > >doing it as for smallint columns, but then I can't be 100% certain I
> won't
> > >get duplicates.
> > >
> > Why not?  Just define a UNIQUE index across all four smallint columns,
> > and MySQL will throw an error if you attempt to insert a duplicate
> > record into the table.
> >
> > -myk
> >
> >
> >
>
> -
> 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: Forcing case sensitivity via a query?

[Keith C. Ivey]

On 22 May 2002, at 14:52, Richard Bolen wrote:

> Is there any way via a SQL query to force case sensitivity to be
> used for a non-binary char field?  i.e.: for comparing strings in a
> case sensitive way.

SELECT * FROM users WHERE BINARY password = 'cAsE_MAttErS';

http://www.mysql.com/doc/C/a/Case_Sensitivity_Operators.html

-- 
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org

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

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: InnoDB, possible bug?

[Michael Widenius]

Hi!

> "Heikki" == Heikki Tuuri <[EMAIL PROTECTED]> writes:

Heikki> Andrei,
Heikki> this is probably not a bug in InnoDB. In theory, 4000 random disk seeks
Heikki> would use more time than scanning the whole table of 700 000 rows.

Heikki> The optimizer was tuned .48 (not yet in 4.0.1) to favor index searches over
Heikki> table scans. That may solve the problem here.

Heikki> On the other hand, the fact that MySQL refuses to use the index specified in
Heikki> the USE INDEX clause may be a bug. I have forwarded this email to MySQL
Heikki> developers.

USE INDEX ... only tells MySQL that it should only consider using one
of the named index to resolve the query.  MySQL is however still free
to use a table scan if finds the given index not suitable for
resolving the query.





Heikki> Best regards,

Heikki> Heikki Tuuri
Heikki> Innobase Oy
Heikki> ---
Heikki> Order technical MySQL/InnoDB support at https://order.mysql.com/
Heikki> See http://www.innodb.com for the online manual and latest news on InnoDB

Heikki> - Original Message -
Heikki> From: "Andrei Cojocaru" <[EMAIL PROTECTED]>
Heikki> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; "Mysql List"
Heikki> <[EMAIL PROTECTED]>
Heikki> Sent: Wednesday, May 22, 2002 3:16 AM
Heikki> Subject: Re: InnoDB, possible bug?


>> I am using mysql 4.0.1-alpha on Linux 2.4.18, the info you requested is:
>> select count(*) from newsentries10 where playerid=28575 and type=2;
>> +--+
>> | count(*) |
>> +--+
>> | 4218 |
>> +--+
>> 1 row in set (13.81 sec)
>> 
mysql> select count(*) from newsentries10 where playerid=28575 and type=2;
>> +--+
>> | count(*) |
>> +--+
>> | 3705 |
>> +--+

Do you know why the result differs in this case ?

mysql> explain select straight_join
>> pn.timestamp,ne.viewpoint,pn.id,pn.type,ne.type,ne.newsid,ne.hidestamp
Heikki> from
>> newsentries10 ne, pnews pn where ne.playerid=28575 and ne.type=2 and
>> pn.newsid=ne.newsid;

Heikki> +---++---+-+-+---+--
>> --++
>> | table | type   | possible_keys | key | key_len | ref   |
>> rows   | Extra  |
>> 
Heikki> +---++---+-+-+---+--
>> --++
>> | ne| ALL| list_news,delete_news | NULL|NULL | NULL  |
>> 774878 | where used |
>> | pn| eq_ref | PRIMARY   | PRIMARY |   4 | ne.newsid |
>> 1 ||
>> 
Heikki> +---++---+-+-+---+--

> show index from newsentries10;



>> > > | newsentries10 |  1 | list_news   |1 | playerid
>> |
>> > A
>> > > |   0 | NULL | NULL   | |
>> > > | newsentries10 |  1 | list_news   |2 | type



Heikki, something is a bit strange here.
In this case MySQL will ask the InnoDB table handler of how many rows
matches the key range (ne.playerid,ne.type) 

[28575, 2]

In this case, InnoDB should return about 4000 rows, but it appears
that it returns 77 rows.

"Andrei", could you upload a copy of the tables to
ftp://support.mysql.com/pub/mysql/secret

so that Heikki could test this ?

Regards,
Monty



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

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Innodb Error

[Edilson Vasconcelos de Melo Junior]

Hi,

I was converting my table from MyISAM to Innodb, but i had a trouble. I had
to kill an alter table command (It was an ADD INDEX in a DATETIME field) but
it didn't stop. So i restarted the mysql but the mysql starts only if i
disable innodb. Did i lost all my innodb tables? Is there anyway to save the
data or should i recreate the innodb space?

Thank u very much,
Edilson.

Edilson Vasconcelos de Melo Junior
[EMAIL PROTECTED]
(19) 3256-3577
ICQ 136192234


-
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: Root user Access denied - Please Help

[Ryan Hatch]

yes, you needed to use the PASSWORD( )  function

mysqladmin -h hostname -u user password 'new password'

-Ryan Hatch

"Miretsky, Anya" wrote:

> I tried to create a password for the root user in a new installation of
> MySQL by  typing
> % mysql -u root mysql
> Then typing and update statement like
> > Update user set password = "somepassword" where user="root";
> After doing this I typed because I could still get into mysql without a
> password % mysqladmin -u root status % mysqladmin -u root reload
>
> I think what I should have done is typed - update user SET password =
> PASSWORD("somepassword") where user ="root".
>
> Now I can't get into mysql at all as root, with the password I set.
>
> I get the error message "Access denied for user 'root@localhost' (using
> password =YES)"
>
> I have tried to restart mysql with the --skip-grant-tables option but I
> still can't get in as root?
>
> How do I fix this? Can anyone help?
>
> Anya Miretsky
> Computer Technology Dept.
> Brooklyn Botanic Garden
> 1000 Washington Avenue
> Brooklyn, NY  11225
>
> (718)623-7265
> [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

Feature request 4.0.x MAX_SLOW_QUERY_PER_HOURS

[Andrew Sitnikov]

Hello,

  I think that MAX_SLOW_QUERY_PER_HOURS is useful options for

  GRANT ... WITH MAX_QUERIES_PER_HOUR = N1
 MAX_UPDATES_PER_HOUR = N2
 MAX_CONNECTIONS_PER_HOUR = N3;
  
  statment.


  Thank.

Best regards,
 Andrew Sitnikov 
 e-mail : [EMAIL PROTECTED]
 GSM: (+372) 56491109


-
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

0xADA1 in ujis character set

[Warren Pollans]

A colleague who is connecting to mysqld started as "/u/local/mysql/bin/safe_mysqld 
--user=mysql --safe-show-database --default-character-set=ujis -O 
wait_timeout=$WAITTIMEOUT -O max_connections=$MAXCONNECTIONS &" has encountered the 
following problem:


"We could not add data which contains 0xADA1 (2 byte char that shows circled '1').  
The char seemed to be stored as '?' into the table."


Any ideas about what the problem is? Or perhaps the appropriate forum in which to ask 
this question?

Thanks,

Warren

-
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

transferring databases

[abw]

Hopefully this is the right list. We have multiple servers going, and one 
user just set up a dedicated machine with mysql. He had about 5 databases 
going on another server for months with no problem. The new server has a 
different version of mysql on it. I copied the database directories over 
exactly and tried to simply drop them in. They don't seem to be working.

So my questions are:

Is it possible to zip up database directories on one server and move them 
to another server, then simply unzip them?

If so, once that is done, does something need to be done to mysql so it is 
aware of the databases? Is there some file that has a list of databases 
that must be updated or something? Mysql is running, because I see it in 
the process list, and from what the customer told me, he does see the 
databases, but he cannot access them.

Have I done something wrong?


-
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: case-sensitivity broken in FK clause for MySQL+InnoDB

[Heikki Tuuri]

Hi!

The fact that foreign key definitions do not honor lower_case_table_names=1
is mentioned in the manual. I have added the fix to this on the TODO list
for July 2002.

You have found the right place, this mailing list is the right place to
report bugs in InnoDB.

Best regards,

Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com

- Original Message -
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, May 22, 2002 9:52 PM
Subject: case-sensitivity broken in FK clause for MySQL+InnoDB


> >Description:
> When using MySQL with InnoDB table type, and turning on the
> table case-insensitivity flag in the config file
> (set-variable = lower_case_table_names=1), MySQL/InnoDB does not
> correctly handle the case-insensitivity of the target table name in
> the REFERENCES part of the FOREIGN KEY clause.  This is true for
> both the CREATE TABLE and ALTER TABLE variations.  Note the
> column names and the referer table name (in the case of the ALTER
> TABLE clause) are correctly treated as case insensitive.
>
> This problem may need to be posted to InnoDB, but I couldn't
> locate any method of notifying them of bug reports.
>
> Example script which shows the cases that work and the one that
> doesn't is attached in the How-To-Repeat.
> 
> >How-To-Repeat:
> drop table if exists foo1;
> create table foo1(
> pk1 integer NOT NULL,
> primary key(pk1)
> ) type = innodb;
>
>
> ##
> ## This will work fine
> ##
> drop table if exists foo2;
> create table foo2(
> pk1 integer NOT NULL,
> fk1 integer,
> foreign key (fk1) references foo1 (pk1),
> index ix1 (fk1)
> ) type = innodb;
>
>
> ##
> ## As will this
> ##
> drop table if exists foo2;
> create table foo2(
> pk1 integer NOT NULL,
> fk1 integer,
> foreign key (FK1) references foo1 (PK1),
> index ix1 (fk1)
> ) type = innodb;
>
>
> ##
> ## But this won't
> ## In my case, the specific error was:
> ##ERROR 1005: Can't create table './dbname/foo2.frm' (errno: 150)
> ##
> drop table if exists foo2;
> create table foo2(
> pk1 integer NOT NULL,
> fk1 integer,
> foreign key (fk1) references FOO1 (pk1),
> index ix1 (fk1)
> ) type = innodb;
>
>
> >Fix:
> 
>
> >Submitter-Id: 
> >Originator: Eugene Bekker
> >Organization:
>  
> >MySQL support: none
> >Synopsis: case-sensitivity broken in FK clause for MySQL+InnoDB
> >Severity: serious
> >Priority: medium
> >Category: mysql
> >Class: sw-bug
> >Release: mysql-3.23.50 (Official MySQL RPM)
>
> >Environment:
> RedHat 7.1
> Using pre-packaged 3.23.50 (Max) from www.mysql.com
> 
> System: Linux betelgeuse.powervision.com 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT
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/i386-redhat-linux/2.96/specs
> gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81)
> Compilation info: CC='gcc'
 CFLAGS='-O6 -fno-omit-frame-pointer -mcpu=pentiumpro'  CXX='gcc'
CXXFLAGS='-O6 -fno-omit-frame-pointer   -felide-constructors -fno-ex
ceptions -fno-rtti -mcpu=pentiumpro'  LDFLAGS=''
> LIBC:
> lrwxrwxrwx1 root root   13 Feb  2 07:17 /lib/libc.so.6 ->
libc-2.2.2.so
> -rwxr-xr-x1 root root  1236396 Apr  6  2001 /lib/libc-2.2.2.so
> -rw-r--r--1 root root 26350254 Apr  6  2001 /usr/lib/libc.a
> -rw-r--r--1 root root  178 Apr  6  2001 /usr/lib/libc.so
> Configure command:
./configure  --disable-shared --with-mysqld-ldflags=-all-static --with-clien
t-ldflags=-all-static --with-other-libc=/usr/local/mysql-glibc --without-ber
keley-db --without-innodb --enable-assembler --enable-local-infile --with-my
sqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/
 --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --s
ysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir
=/usr/info --includedir=/usr/include --mandir=/usr/man
'--with-comment=Official MySQL RPM'
>
>
>
> -
> 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
>



-
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

Re: Forcing case sensitivity via a query?

[Luciano Barcaro]

Hi Richard,

Richard Bolen wrote:

>If I understand correctly, you have to define a char field as binary if you want the 
>database to treat it as a 'case sensitive' field.  Is there any way via a SQL query 
>to force case sensitivity to be used for a non-binary char field?  i.e.: for 
>comparing strings in a case sensitive way.  Or is there some way to force the 
>database to use case sensitive string comparisons all the time (even for non-binary 
>char fields)?
>
Yes, try this:

select * from yourtable where binary field1= 'CASEsensitive';

>
>I'm using the mm.mysql jdbc driver to access the database and it returns the data 
>differently if a field is defined as binary. This is causing my string data to be 
>garbled in my application for binary char fields.
>
>Rich
>
>
>Rich Bolen
>Senior Software Developer
>GretagMacbeth Advanced Technologies Center
>79 T. W. Alexander Drive - Bldg. 4401 - Suite 250
>PO Box 14026
>Research Triangle Park, North Carolina 27709-4026  USA
>Phone:  919-549-7575 x239,  Fax: 919-549-0421  
>
>http://www.gretagmacbeth.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
>
>
>  
>

-- 
--
\|/   __\|/
`@"  / o  . \   "@' Microsoft? Por acaso é alguma nova
/___| \/ |___\  marca de papel higiênico?
 \___U__/
   .^. Luciano Barcaro - Linux User # 99517
   /v\ Registre-se gratuitamente em
  // \\http://counter.li.org
 //(.)\\   ICQ # 17266954
  ^`~'^
--




-
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: Embedding MySQL...

[Mark Robson]

Nick,

You're going to be mostly out of luck.

You can ship a MySQL binary with a pre-configured config, and get the java 
app to exec the binary, and send a shutdown command when it's finished.

Alternatively you can assist me in developing my Type II driver for MySQL, 
then embed libmysqld in a native DLL which can be loaded with 
System.loadLibrary() or whatever it is.

Currently the Type II driver isn't very good though, because it doesn't 
support any operation except Statement.executeUpdate() which isn't much use.

unfortunately I have little time to develop this so it's unlikely to progress 
much - also my approach has been wrong - I've developed an independent driver 
when what I should really do is extend Mark Matthews' excellent type IV 
driver.

Cheers
Mark

-
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: columb structure

[Chris Knipe]

Multiple subnets :/

columns like this:
octet1, octet2, octet3, octet4
195,196,192,23
232,196,231,11

This would then be seen as a duplicate


Kind Regards,

Chris Knipe
MegaLAN Corporate InterNetworking Services
Tel: +27 21 854 7064
Cell: +27 72 434 7582

- Original Message -
From: "Myk Melez" <[EMAIL PROTECTED]>
To: "Chris Knipe" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Wednesday, May 22, 2002 8:43 PM
Subject: Re: columb structure


> Chris Knipe wrote:
>
> >I'm currently storing them into varchar(16), although I've been thinking
of
> >doing it as for smallint columns, but then I can't be 100% certain I
won't
> >get duplicates.
> >
> Why not?  Just define a UNIQUE index across all four smallint columns,
> and MySQL will throw an error if you attempt to insert a duplicate
> record into the table.
>
> -myk
>
>
>


-
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

Development environment for MySQL

[Lam,Thuvan N.]

Hi,

How should I setup MySQL development environment?  We run MySQL from Sun

Solaris.  I have a script file to create tables and load data which will

be distributed to all developers.  The developer will "own" his set of
data where he is the only one who can modify it.

In Oracle, each user account is associated with his own space,so he can
modify his data and do not interfere with data from other developers.
Can MySQL be setup in a similar way? and how should I set it up?

I try to avoid having 5 different database names for 5 different
developers where each database consists of the same set of tables.

Thanks,

Thuvan Lam


-
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

Forcing case sensitivity via a query?

[Richard Bolen]

If I understand correctly, you have to define a char field as binary if you want the 
database to treat it as a 'case sensitive' field.  Is there any way via a SQL query to 
force case sensitivity to be used for a non-binary char field?  i.e.: for comparing 
strings in a case sensitive way.  Or is there some way to force the database to use 
case sensitive string comparisons all the time (even for non-binary char fields)?

I'm using the mm.mysql jdbc driver to access the database and it returns the data 
differently if a field is defined as binary. This is causing my string data to be 
garbled in my application for binary char fields.

Rich


Rich Bolen
Senior Software Developer
GretagMacbeth Advanced Technologies Center
79 T. W. Alexander Drive - Bldg. 4401 - Suite 250
PO Box 14026
Research Triangle Park, North Carolina 27709-4026  USA
Phone:  919-549-7575 x239,  Fax: 919-549-0421   

http://www.gretagmacbeth.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: columb structure

[Myk Melez]

Chris Knipe wrote:

>I'm currently storing them into varchar(16), although I've been thinking of
>doing it as for smallint columns, but then I can't be 100% certain I won't
>get duplicates.
>
Why not?  Just define a UNIQUE index across all four smallint columns, 
and MySQL will throw an error if you attempt to insert a duplicate 
record into the table.

-myk



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

[Myk Melez]

Amy Zediak wrote:

>I'm trying to install Bugzilla and according to the instructions you
>have to make a few changes to MySQL and i'm a little confused.  It says
>that you have to add mysqld to init script and then add -0
>max_allowed_packet=1M to the command that starts mysqld.  I'm not
>completely sure how to do this.  Can anyone help?
>
It looks like you have been reading the following page:

http://www.bugzilla.org/docs/html/stepbystep.html#install-mysql

The part about adding mysqld to your init scripts just means you should 
ensure mysqld starts whenever your machine boots.  Depending on how you 
installed MySQL, this may already be set up for you.  If not, the 
following page of the MySQL documentation contains more information 
about how to do this:

http://mysql.com/doc/A/u/Automatic_start.html

The part about changing the value of the max_allowed_packet parameter 
may also be unnecessary.  The last time I installed MySQL (from an RPM), 
the parameter was already set to 1M by default.  Execute the following 
command to discover the value of this parameter:

mysqladmin variables

If it isn't 1M (or more), fix this by adding the following line to your 
my.cnf file:

set-variable = max_allowed_packet=1M

See the following pages of the MySQL manual for more info about this 
parameter and the my.cnf file:

http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html
http://www.mysql.com/doc/O/p/Option_files.html

Note that the value of this parameter limits the size of attachments 
that can be attached to bug reports in Bugzilla, and 1M stands for 1 
megabyte (MB).  If you expect users to submit larger attachments, 
increase the value of this parameter.

-myk



-
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: Union does not work

[Gurhan Ozen]

  Sorry to jump into the conclusions:) IT wasn't evena sub select and union
is used to join the results of SELECT statements...

  Your statement can be written as "SELECT location FROM visiExPr WHERE
(location=1  OR location=0) GROUP BY location;

   What version of MySQL are you running? UNION is implemented in 4.0.0. IF
you have 3.x.x it won't work...

Gurhan

-Original Message-
From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 12:31 PM
To: Dan Liu; >
Subject: RE: Union does not work


Sub-selects are not permitted in MySQL yet..

See: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html

Gurhan

-Original Message-
From: Dan Liu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 11:58 AM
To: >
Subject: Union does not work


Hi,
Could anybody tell me why the following query does not work?
SELECT location FROM visiExPr where location=1  union (SELECT location FROM
visiExPr where location=0);
Thanks!

Dan


-
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

case-sensitivity broken in FK clause for MySQL+InnoDB

[ebekker]

>Description:
When using MySQL with InnoDB table type, and turning on the
table case-insensitivity flag in the config file
(set-variable = lower_case_table_names=1), MySQL/InnoDB does not
correctly handle the case-insensitivity of the target table name in
the REFERENCES part of the FOREIGN KEY clause.  This is true for
both the CREATE TABLE and ALTER TABLE variations.  Note the
column names and the referer table name (in the case of the ALTER
TABLE clause) are correctly treated as case insensitive.

This problem may need to be posted to InnoDB, but I couldn't
locate any method of notifying them of bug reports.

Example script which shows the cases that work and the one that
doesn't is attached in the How-To-Repeat.

>How-To-Repeat:
drop table if exists foo1;
create table foo1(
pk1 integer NOT NULL,
primary key(pk1)
) type = innodb;
 
 
##
## This will work fine
##
drop table if exists foo2;
create table foo2(
pk1 integer NOT NULL,
fk1 integer,
foreign key (fk1) references foo1 (pk1),
index ix1 (fk1)
) type = innodb;
 
 
##
## As will this
##
drop table if exists foo2;
create table foo2(
pk1 integer NOT NULL,
fk1 integer,
foreign key (FK1) references foo1 (PK1),
index ix1 (fk1)
) type = innodb;
 
 
##
## But this won't
## In my case, the specific error was:
##ERROR 1005: Can't create table './dbname/foo2.frm' (errno: 150)
##
drop table if exists foo2;
create table foo2(
pk1 integer NOT NULL,
fk1 integer,
foreign key (fk1) references FOO1 (pk1),
index ix1 (fk1)
) type = innodb;


>Fix:


>Submitter-Id:  
>Originator:Eugene Bekker
>Organization:
 
>MySQL support: none 
>Synopsis:  case-sensitivity broken in FK clause for MySQL+InnoDB
>Severity:  serious
>Priority:  medium
>Category:  mysql
>Class: sw-bug
>Release:   mysql-3.23.50 (Official MySQL RPM)

>Environment:
RedHat 7.1
Using pre-packaged 3.23.50 (Max) from www.mysql.com

System: Linux betelgeuse.powervision.com 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 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/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81)
Compilation info: CC='gcc'  CFLAGS='-O6 -fno-omit-frame-pointer -mcpu=pentiumpro'  
CXX='gcc'  CXXFLAGS='-O6 -fno-omit-frame-pointer   -felide-constructors 
-fno-exceptions -fno-rtti -mcpu=pentiumpro'  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 Feb  2 07:17 /lib/libc.so.6 -> libc-2.2.2.so
-rwxr-xr-x1 root root  1236396 Apr  6  2001 /lib/libc-2.2.2.so
-rw-r--r--1 root root 26350254 Apr  6  2001 /usr/lib/libc.a
-rw-r--r--1 root root  178 Apr  6  2001 /usr/lib/libc.so
Configure command: ./configure  --disable-shared --with-mysqld-ldflags=-all-static 
--with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-glibc 
--without-berkeley-db --without-innodb --enable-assembler --enable-local-infile 
--with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ 
--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin 
--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql 
--infodir=/usr/info --includedir=/usr/include --mandir=/usr/man 
'--with-comment=Official MySQL RPM'



-
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

Root user Access denied - Please Help

[Miretsky, Anya]

I tried to create a password for the root user in a new installation of
MySQL by  typing 
% mysql -u root mysql
Then typing and update statement like
> Update user set password = "somepassword" where user="root";
After doing this I typed because I could still get into mysql without a
password % mysqladmin -u root status % mysqladmin -u root reload

I think what I should have done is typed - update user SET password =
PASSWORD("somepassword") where user ="root".

Now I can't get into mysql at all as root, with the password I set.

I get the error message "Access denied for user 'root@localhost' (using
password =YES)"

I have tried to restart mysql with the --skip-grant-tables option but I
still can't get in as root?

How do I fix this? Can anyone help? 

Anya Miretsky
Computer Technology Dept.
Brooklyn Botanic Garden
1000 Washington Avenue
Brooklyn, NY  11225

(718)623-7265
[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

Feature request 4.0.x MAX_SLOW_QUERY_PER_HOURS

[Andrew Sitnikov]

Hello,

  I think that MAX_SLOW_QUERY_PER_HOURS is useful options for

  GRANT ... WITH MAX_QUERIES_PER_HOUR = N1
 MAX_UPDATES_PER_HOUR = N2
 MAX_CONNECTIONS_PER_HOUR = N3;
  
  statment.


  Thank.

Best regards,
 Andrew Sitnikov 
 e-mail : [EMAIL PROTECTED]
 GSM: (+372) 56491109


-
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

columb structure

[Chris Knipe]

Hi all,

What's the best way to store a numeric IP address into a table with the
least possible size and overhead on the mysql server?

I'm talking millions of records here With not one single duplicate IP
address (unique index)..

Currently, the database hosts just over 1.2 million unique addresses, and
including the index, the table's size is over 170MB... I'd like to cut this
down DRASTICALLY... And yes, the way I have it now, I'm *sure* there must be
a better way, hence' the email.

I'm currently storing them into varchar(16), although I've been thinking of
doing it as for smallint columns, but then I can't be 100% certain I won't
get duplicates.

Any ideas?

--
me




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

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

newbie - Old Samp_db question

[Eugene McQuade]

I searched the archive found the issue but not the answer.

Configuration:
I'm running win2000, mysql is loaded and I can manually create databases and
tables per "MySQL" manual (via Amazon).  I've loaded samp_db in sub
directory of mysql.

Problem:
mysql> samp_db < create_president.sql;

Result:
ERROR 1064: You have an error in your SQL syntax near 'samp_db <
create_president' at line 1

Why?


Thanks,
Gene

RE: timestamp primary key's value improperly changing on sql update

[Salada, Duncan]

The is the proper, documented functionality of the timestamp field.  An
exerpt from http://www.mysql.com/doc/D/A/DATETIME.html is below:

The TIMESTAMP column type provides a type that you can use to automatically
mark INSERT or UPDATE operations with the current date and time. If you have
multiple TIMESTAMP columns, only the first one is updated automatically. 

Automatic updating of the first TIMESTAMP column occurs under any of the
following conditions: 

 The column is not specified explicitly in an INSERT or LOAD DATA INFILE
statement. 
 The column is not specified explicitly in an UPDATE statement and some
other column changes value. (Note that an UPDATE that sets a column to the
value it
 already has will not cause the TIMESTAMP column to be updated, because
if you set a column to its current value, MySQL ignores the update for
efficiency.) 
 You explicitly set the TIMESTAMP column to NULL. 



Duncan
--
Duncan Salada | Titan | www.titan.com/testeval
Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 22, 2002 11:05 AM
> To: [EMAIL PROTECTED]
> Subject: timestamp primary key's value improperly changing on 
> sql update
> 
> 
> >Description:
> 
>   Given a table that has a timestamp field which is 
> either the primary key or
>   one field in a multi-column primary key, the value in 
> this field is
>   updated to the current time any time an SQL UPDATE is done, even
>   when the timestamp field is not intended to be updated.
> 
> 
> >How-To-Repeat:
> 
> mysql> CREATE TABLE foo(field1 TIMESTAMP PRIMARY KEY, field2 INT);
> Query OK, 0 rows affected (0.01 sec)
> 
> mysql> INSERT INTO foo VALUES(now(), 10);
> Query OK, 1 row affected (0.00 sec)
> 
> mysql> SELECT * FROM foo;
> +++
> | field1 | field2 |
> +++
> | 20020522105353 | 10 |
> +++
> 1 row in set (0.00 sec)
> 
> mysql> UPDATE foo SET field2=11;
> Query OK, 1 row affected (0.00 sec)
> Rows matched: 1  Changed: 1  Warnings: 0
> 
> mysql> SELECT * FROM foo;
> +++
> | field1 | field2 |
> +++
> | 20020522105405 | 11 |
> +++
> 1 row in set (0.00 sec)
> 
>  -- NOTICE that the time in field1 changed after the update.  
> This is wrong.
> 
> >Fix:
>   A workaround is to set the timestamp field to itself on 
> an update.
>   ex: "UPDATE foo SET field1=field1, field2=11"
> 
> >Submitter-Id:
> >Originator:  Jeff Messner
> >Organization:
>  
> >MySQL support: none
> >Synopsis:timestamp primary key's value improperly 
> changing on sql update
> >Severity:serious
> >Priority:medium
> >Category:mysql
> >Class:   sw-bug
> >Release: mysql-3.23.49a (Official MySQL Binary)
> >Server: /usr/local/mysql/bin/mysqladmin  Ver 8.23 Distrib 
> 3.23.49a, for pc-linux-gnu on i686
> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> This software comes with ABSOLUTELY NO WARRANTY. This is free 
> software,
> and you are welcome to modify and redistribute it under the 
> GPL license
> 
> Server version3.23.49a
> Protocol version  10
> ConnectionLocalhost via UNIX socket
> UNIX socket   /tmp/mysql.sock
> Uptime:   29 days 45 min 32 sec
> 
> Threads: 1  Questions: 2658  Slow queries: 0  Opens: 28  
> Flush tables: 1  Open tables: 18 Queries per second avg: 0.001
> >Environment:
>   
> System: Linux pc-00183 2.4.7-10 #1 Thu Sep 6 17:21:28 EDT 
> 2001 i586 unknown
> Architecture: i586
> 
> 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/i386-redhat-linux/2.96/specs
> gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98)
> Compilation info: CC='gcc'  CFLAGS='-Wimplicit -Wreturn-type 
> -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W 
> -Wchar-subscripts -Wformat -Wimplicit-function-dec 
> -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings 
> -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer'  
> CXX='gcc'  CXXFLAGS='-Wimplicit -Wreturn-type -Wid-clash-51 
> -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat 
> -Wimplicit-function-dec -Wimplicit-int -Wparentheses 
> -Wsign-compare -Wwrite-strings -Woverloaded-virtual 
> -Wextern-inline -Wsign-promo -Wreorder -Wctor-dtor-privacy 
> -Wnon-virtual-dtor -felide-constructors -fno-exceptions 
> -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer'  LDFLAGS=''
> LIBC: 
> lrwxrwxrwx1 root root   13 Mar 11 12:11 
> /lib/libc.so.6 -> libc-2.2.4.so
> -rwxr-xr-x1 root root  5716491 Sep  4  2001 
> /lib/libc-2.2.4.so
> -rw-r--r--1 root root 27304836 Sep  4  2001 
> /usr/lib/libc.a
> -rw-r--r--1 root root  178 Sep  4  2001 
> /usr/lib/libc.s

Root user Access denied - Please Help!

[Miretsky, Anya]

I tried to create a password for the root user in a new installation of
MySQL by  typing 
% mysql -u root mysql
Then typing and update statement like
> Update user set password = "somepassword" where user="root";
After doing this I typed because I could still get into mysql without a
password
% mysqladmin -u root status
% mysqladmin -u root reload

I think what I should have done is typed - update user SET password =
PASSWORD("somepassword") where user ="root".

Now I can't get into mysql at all as root, with the password I set.

I get the error message "Access denied for user 'root@localhost' (using
password =YES)"

I have tried to restart mysql with the --skip-grant-tables option but I
still can't get in as root?

How do I fix this? Can anyone help? 


Anya Miretsky
Computer Technology Dept.
Brooklyn Botanic Garden
1000 Washington Avenue
Brooklyn, NY  11225

(718)623-7265
[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: Union does not work

[Sam Masiello]

He is not doing a sub select...he is doing a union.  Unions are
implemented in MySQL 4.x

HTH

Sam Masiello
Software Quality Assurance Engineer
Synacor
(716) 853-1362 x289
[EMAIL PROTECTED]


-Original Message-
From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, May 22, 2002 12:31 PM
To: Dan Liu; >
Subject: RE: Union does not work

Sub-selects are not permitted in MySQL yet..

See: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html

Gurhan

-Original Message-
From: Dan Liu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 11:58 AM
To: >
Subject: Union does not work


Hi,
Could anybody tell me why the following query does not work?
SELECT location FROM visiExPr where location=1  union (SELECT location
FROM
visiExPr where location=0);
Thanks!

Dan


-
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

mysqld

[Amy Zediak]

I'm trying to install Bugzilla and according to the instructions you
have to make a few changes to MySQL and i'm a little confused.  It says
that you have to add mysqld to init script and then add -0
max_allowed_packet=1M to the command that starts mysqld.  I'm not
completely sure how to do this.  Can anyone help?  

Thanks~

Amy

-
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: Loading massive data set from CSV

[Gavin Brown]

- Original Message -
From: "Dan Harrington" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 22, 2002 5:41 PM
Subject: Loading massive data set from CSV


> Greetings everyone,
>
> I have an ASCII CSV or Tab Delimited file that is
> roughly 3.5 gigabytes, and I want to load it into a mysql
> database so I can do some analysis.
>
> First of all, I'm wondering, is there anything I should be aware of,
> or worried about, size-wise?
>
> I know that I can't even look at the file using basic text functions
> in my Linux box like 'head' or 'split'
>
> Initially, I was thinking I'd use 'split' to break it into smaller chunks
> but split won't read it.
>
> I can't even use 'wc -l' to find out how many lines or records are in the
file.

I thought most linux utils was quite good at dealing with files ie only
reading what was needed into memory, but I suppose it depends on the
program.

But then again I have never tried to manage a 3.5 gig file :)

>
> There is a list of the fields in the file, so I know what my table should
> look like, but I don't want to crash the SQL server if its too large a
file,
> or something else like that.  I didn't know how big it was originally, so
I
> was just going to use phpMyAdmin to load the file through a web
browser
> though I don't know if that will work either.  Is there a size limitation
> to HTTP-POST (I assume it uses that method to upload).

I wouldn't think that phpMyAdmin  / Apache (guessing at web server here)
would be able to handle such a big file through CGI.
It would depend on how php handles POST cgi - if like most porgrams it just
tries to read all of the uploaded file into memory then something is going
to keel over, either apache or php.

You might be able to load the file into mysql from the mysql client prog -
ie do a select into from (I can't remember the actual command , the one that
lets you load a db from a file) again this will depend on how the program
handles files.

If that doesn't work my advice would be to split the file up into managable
chucks.

I would say a few hundered megs at most, and try them one at a time.

Will 'grep' parse the filet - ie can you do "grep someWord myBigFile.txt" ?
If so is there anything "splitable" in the file - ie if the file is a log
file with a date field then you could try
 grep "Sun 5th May" myBigFile.txt > 5thMay.txt , etc.

Just out of curiosity where did you get the file from?

If grep won't look at it ;

Hows your C?

You could write a c prog to split the file ,  just reading and writing a few
thousand lines at a time.

If you don't know C then you could either, try and learn it (if you are a
programmer) or alternativley give me a shout and I I'll try and knock
something together for you. (I'm a bit rusty with my C though :)

I have no idea about the max size of data mysql can hold , I have never had
to deal with anything that was over a few hundred thousand records
unfortunately. Maybe someone else can shed light on that - I keep hearing
that mysql can handle a LOT of rows.

Hope some of this helps...

Gav Brown

>
> Comments?
>
> Thanks
> Dan
>
>
> -
> 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: Loading massive data set from CSV

[Eberhard Lisse]

In message <[EMAIL PROTECTED]>, "Dan Harrington" write
s:

> I have an ASCII CSV or Tab Delimited file that is roughly 3.5
> gigabytes, and I want to load it into a mysql database so I can do
> some analysis.  First of all, I'm wondering, is there anything I
> should be aware of, or worried about, size-wise?

Any ideas of how many records?
 
> I know that I can't even look at the file using basic text functions
> in my Linux box like 'head' or 'split'

But, you can hack a small perl script that reads line by line flushing
output, so you can at least look at it,.
 
> There is a list of the fields in the file, so I know what my table
> should look like, but I don't want to crash the SQL server if its
> too large a file, or something else like that.

I'd doubt that MySQL would crash about a few Million records. Well,
you'd check if the disk space is there, too :-)-O

> I didn't know how big it was originally, so I was just going to use
> phpMyAdmin to load the file through a web browser  though I
> don't know if that will work either.  Is there a size limitation to
> HTTP-POST (I assume it uses that method to upload).

Pumping 3.5 GB through an network unnecessarily is fairly silly,
actually :-)-O

el
-- 
Dr. Eberhard W. Lisse  \/  Obstetrician & Gynaecologist (Saar)
<[EMAIL PROTECTED]> el108*   | Swakopmund State Hospital
Private Bag 5004\ / Telephone: +49 177 214 3196 (cell)
Swakopmund, Namibia ;/  Currently on Post Graduate Study Leave

-
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: Union does not work

[Jocelyn Fournier]

Hi,

Perhaps try to remove the brackets ?
SELECT location FROM visiExPr where location=1  UNION SELECT location FROM
visiExPr where location=0;

(I assume you're using MySQL 4.0.x ?)

Regards,
  Jocelyn Fournier

- Original Message -
From: "Dan Liu" <[EMAIL PROTECTED]>
To: ">" <<[EMAIL PROTECTED]>
Sent: Wednesday, May 22, 2002 5:57 PM
Subject: Union does not work


Hi,
Could anybody tell me why the following query does not work?
SELECT location FROM visiExPr where location=1  union (SELECT location FROM
visiExPr where location=0);
Thanks!

Dan


-
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: strange fulltext behavior

[Sergei Golubchik]

Hi!

On May 22, Victoria Reznichenko wrote:
> Przemyslaw,
> Wednesday, May 22, 2002, 2:02:52 AM, you wrote:
> 
> PP> SELECT ISBN,TITLE FROM tBooks
> PP> WHERE tBooks.ISBN="1876340436"
> PP> AND MATCH (tBooks.TITLE) AGAINST ("britannica")
> 
> PP> ++-+
> PP> | ISBN   | TITLE   |
> PP> ++-+
> PP> | 1876340436 | 2000 Lonely Planet Calendar |
> PP> ++-+
> PP> 1 row in set (0.00 sec)
> 
> PP> Why is it so?  I suspected to get an empty result set.
> PP> MYSQL Ver 11.16 Distrib 3.23.49, for Win95/Win98 (i32)

It looks like a bug. Can you create a test case for this ?

> MATCH() returnes you relevance value. So, it is always true in
> WHERE clause. As a result you get result where ISBN=1876340436. In
> your case you can re-write you query:
> 
>SELECT ISBN,TITLE, MATCH (tBooks.TITLE) AGAINST ("britannica")
>as aa FROM tBooks
>WHERE tBooks.ISBN="1876340436"
>HAVING aa>0;

Relevance value of 0 is treated as false. Adding HAVING should not
really help. It even makes the query slower, as MySQL cannot use
fulltext index to resolve the query.

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

How to enable suffix for database dirs?

[Alexander Newald]

Hello,

I'm currently building a free mySQL database service. I have managed to
solve the quota problem with this list. Thanks to all!

Now I have another problem:

If a large number of databases have been created (>1000) it takes some time
to change a database. I do know that I can ommit the problem with -A at
mysql> . Because I will open the service for all I think not everyone knows
all options to tune performance.

I hope to reduce the time a database change takes by using suffix for the
database dirs like

$datadir/a/al/alex for the database alex

Can I get this transparent to users so if a user do "CREATE DATABASE alex"
it will work?


Thanks,

Alexander Newald

btw:

 - I can't use reiserfs
 - I use linux kernel 2.4.17
 - I use IDE disks
 - I have a PIII 500 with 256 ram with more 50% free
 - I use mySQL 3.23.43



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

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Union does not work

[Dan Liu]

Hi,
Could somebody tell me what is wrong with this query?
select location from visiExPr where location=1 union (select location from 
demandInfoAd where location=0);

ERROR 1064: You have an error in your SQL syntax near 'union (select location from 
demandInfoAd where location=0)' at line 1

Thanks!
Dan


-
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: Union does not work

[Victoria Reznichenko]

Dan,
Wednesday, May 22, 2002, 6:57:49 PM, you wrote:

DL> Could anybody tell me why the following query does not work?
DL> SELECT location FROM visiExPr where location=1  union (SELECT location FROM 
visiExPr where location=0);
DL> Thanks!

What exactly doesn't work? Have you got an error or wrong result?
Note: if location has the same value in both SELECTs there will be
displayed only one row.

DL> Dan




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   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

Loading massive data set from CSV

[Dan Harrington]

Greetings everyone,

I have an ASCII CSV or Tab Delimited file that is 
roughly 3.5 gigabytes, and I want to load it into a mysql
database so I can do some analysis.

First of all, I'm wondering, is there anything I should be aware of, 
or worried about, size-wise?

I know that I can't even look at the file using basic text functions
in my Linux box like 'head' or 'split'

Initially, I was thinking I'd use 'split' to break it into smaller chunks
but split won't read it.

I can't even use 'wc -l' to find out how many lines or records are in the file.

There is a list of the fields in the file, so I know what my table should 
look like, but I don't want to crash the SQL server if its too large a file,
or something else like that.  I didn't know how big it was originally, so I 
was just going to use phpMyAdmin to load the file through a web browser
though I don't know if that will work either.  Is there a size limitation
to HTTP-POST (I assume it uses that method to upload).

Comments?

Thanks
Dan


-
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: about get field's length of text type in query

[Gurhan Ozen]

It works for me in text columns.. Can you give more insights? your table
structure and exact query you issued?

Gurhan

-Original Message-
From: J) A 2( <[EMAIL PROTECTED]> [mailto:J) A 2( <[EMAIL PROTECTED]>]
Sent: Wednesday, May 22, 2002 12:02 PM
To: [EMAIL PROTECTED]
Subject: about get field's length of text type in query


i want to get really length of text field,but function
length() allways return 8,how can i get it with sql?

thanks.

__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.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


-
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: Union does not work

[Gurhan Ozen]

Sub-selects are not permitted in MySQL yet..

See: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html

Gurhan

-Original Message-
From: Dan Liu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 11:58 AM
To: >
Subject: Union does not work


Hi,
Could anybody tell me why the following query does not work?
SELECT location FROM visiExPr where location=1  union (SELECT location FROM
visiExPr where location=0);
Thanks!

Dan


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

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


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

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL InnoDB startup problem

[Heikki Tuuri]

David,

if the corruption happens again, please run CHECK TABLE and report what you
get to 'hostname'.err. 3.23.52 will also contain diagnostic code which will
help to track the problem.

Best regards,

Heikki

- Original Message -
From: "David Piasecki" <[EMAIL PROTECTED]>
To: "'Heikki Tuuri'" <[EMAIL PROTECTED]>
Sent: Wednesday, May 22, 2002 7:05 PM
Subject: RE: MySQL InnoDB startup problem


> I already restored the database as I described on the mysql mailing
> list, so I won't be able to run 'check table'. Everything is now running
> smoothly. Thanks.
>
> David Piasecki
> Software Engineer
>
> -Original Message-
> From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 22, 2002 12:17 AM
> To: "David Piasecki"
> Subject: Re: MySQL InnoDB startup problem
>
> David,
>
> you should use the my.cnf option
>
> set-variable = innodb_force_recovery=4
>
> to get mysqld up.
>
> Please run CHECK TABLE on your InnoDB tables and report to me what it
> prints
> to the MySQL error log 'hostname'.err.
>
> Regards,
>
> Heikki
>
> - Original Message -
> From: ""David Piasecki"" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.mysql
> Sent: Wednesday, May 22, 2002 8:04 AM
> Subject: MySQL InnoDB startup problem
>
>
> > I'm running MySQL 3.23.49. Everything was going good until today. I
> did
> > a couple of large table reads/inserts/deletes on the InnoDB tables
> which
> > appeared to go fine. I then restarted MySQL which also appeared to go
> > fine. From that point on, however, I kept losing connection with the
> DB,
> > and couldn't run any queries. A check of the error log reveals the
> > following:
> >
> > ---start err log---
> > 020521 21:54:13  mysqld restarted
> > 020521 21:54:19  InnoDB: Database was not shut down normally.
> > InnoDB: Starting recovery from log files...
> > InnoDB: Starting log scan based on checkpoint at
> > InnoDB: log sequence number 0 2556753944
> > 020521 21:54:19  InnoDB: Flushing modified pages from the buffer
> pool...
> > 020521 21:54:19  InnoDB: Started
> > /usr/local/mysql/libexec/mysqld: ready for connections
> > InnoDB: Assertion failure in thread 508094464 in file btr0btr.c line
> 574
> > InnoDB: We intentionally generate a memory trap.
> > InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
> > mysqld got signal 11;
> > This could be because you hit a bug. It is also possible that this
> > binary
> > or one of the libraries it was linked agaist is corrupt, improperly
> > built,
> > or misconfigured. This error can also be caused by malfunctioning
> > hardware.
> > We will try our best to scrape up some info that will hopefully help
> > diagnose
> > the problem, but since we have already crashed, something is
> definitely
> > wrong
> > and this may fail
> >
> > key_buffer_size=268431360
> > record_buffer=131072
> > sort_buffer=524280
> > max_used_connections=0
> > max_connections=400
> > threads_connected=0
> > It is possible that mysqld could use up to
> > key_buffer_size + (record_buffer + sort_buffer)*max_connections =
> 518136
> > K
> > bytes of memory
> > Hope that's ok, if not, decrease some variables in the equation
> > ---end err log---
> >
> > I tried grabbing the latest source and recompiling the database, but
> > still no go. Unfortunately I don't have a backup of the InnoDB tables,
> > so there isn't a whole lot that I can do in that respect. The data
> > appears to still be in the tables, because I can on occasion do a
> select
> > and it will return data before the database dies.
> >
> > Anyone have any experience with this sort of problem? Thanks.
> >
> >
> > David Piasecki
> > Software Engineer
> >
> >
> >
> > -
> > 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 Error Code: (2003)

[Konrad Steynberg]

Hi,

Sometime when connecting to mysql I get 

mySQL Error Code: (2003)
Can't connect to MySQL server on '127.0.0.1' (10061)

even when the server is up and running.
I think it might happen cause it is very busy.
I there a way to maybe make it wait longer for the client to connect?

Thanx

Konrad.



-
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: transactions on MySQL (innoDB)

[Weaver, Walt]

First question: did you set autocommit=0?

--Walt Weaver
  Bozeman, Montana

-Original Message-
From: a a [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 9:27 AM
To: [EMAIL PROTECTED]
Subject: transactions on MySQL (innoDB) 


Hello 
I can't create innoDB tables in db MySQL to do
rollback and commit
transactions.
I try to modify the my.cnf file with the instructions
that I find in manuel.pdf but it don't work.
Can you help me please ?
Thanks.

Ps : i'm french. :-)


___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.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

-
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

timestamp primary key's value improperly changing on sql update

[jmessner]

>Description:

Given a table that has a timestamp field which is either the primary key or
one field in a multi-column primary key, the value in this field is
updated to the current time any time an SQL UPDATE is done, even
when the timestamp field is not intended to be updated.


>How-To-Repeat:

mysql> CREATE TABLE foo(field1 TIMESTAMP PRIMARY KEY, field2 INT);
Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO foo VALUES(now(), 10);
Query OK, 1 row affected (0.00 sec)

mysql> SELECT * FROM foo;
+++
| field1 | field2 |
+++
| 20020522105353 | 10 |
+++
1 row in set (0.00 sec)

mysql> UPDATE foo SET field2=11;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> SELECT * FROM foo;
+++
| field1 | field2 |
+++
| 20020522105405 | 11 |
+++
1 row in set (0.00 sec)

 -- NOTICE that the time in field1 changed after the update.  This is wrong.

>Fix:
A workaround is to set the timestamp field to itself on an update.
ex: "UPDATE foo SET field1=field1, field2=11"

>Submitter-Id:  
>Originator:Jeff Messner
>Organization:
 
>MySQL support: none
>Synopsis:  timestamp primary key's value improperly changing on sql update
>Severity:  serious
>Priority:  medium
>Category:  mysql
>Class: sw-bug
>Release:   mysql-3.23.49a (Official MySQL Binary)
>Server: /usr/local/mysql/bin/mysqladmin  Ver 8.23 Distrib 3.23.49a, for pc-linux-gnu 
>on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version  3.23.49a
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 29 days 45 min 32 sec

Threads: 1  Questions: 2658  Slow queries: 0  Opens: 28  Flush tables: 1  Open tables: 
18 Queries per second avg: 0.001
>Environment:

System: Linux pc-00183 2.4.7-10 #1 Thu Sep 6 17:21:28 EDT 2001 i586 unknown
Architecture: i586

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/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98)
Compilation info: CC='gcc'  CFLAGS='-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch 
-Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec 
-Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro 
-O3 -fno-omit-frame-pointer'  CXX='gcc'  CXXFLAGS='-Wimplicit -Wreturn-type 
-Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat 
-Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings 
-Woverloaded-virtual -Wextern-inline -Wsign-promo -Wreorder -Wctor-dtor-privacy 
-Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 
-fno-omit-frame-pointer'  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 Mar 11 12:11 /lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x1 root root  5716491 Sep  4  2001 /lib/libc-2.2.4.so
-rw-r--r--1 root root 27304836 Sep  4  2001 /usr/lib/libc.a
-rw-r--r--1 root root  178 Sep  4  2001 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler 
--with-extra-charsets=complex --enable-thread-safe-client 
--with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static 
--with-other-libc=/usr/local/mysql-glibc '--with-comment=Official MySQL Binary' 
--prefix=/usr/local/mysql --with-extra-charset=complex --enable-thread-safe-client 
--enable-local-infile 'CFLAGS=-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch 
-Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec 
-Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro 
-O3 -fno-omit-frame-pointer' 'CXXFLAGS=-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch 
-Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec 
-Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual 
-Wextern-inline -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor 
-felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpr!
o -O3 -fno-omit-frame-pointer' CXX=gcc


-
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

load data infile

[Tewfic Kidess]

Hi,

I'm running the following query:
Load data infile 'data.txt' into table records fields terminated by ';'
IGNORE 1 LINES

The field-order in my txt file is different than that in my table, can i
rearrange the order of the data being loaded and load blank fields in
between?

Any help will be greatly appreciated.

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

[David Piasecki]

I have been using .49 for well over 1 month now. Not sure how it was
corrupted but it happened. I followed the instructions with some
variation and was able to recover everything. In my.cnf I added '
set-variable = innodb_force_recovery=4'. I was then able to start the
database, and did a mysqldump to dump the affected tables/databases into
files. I then stopped the database, and deleted the innodb files. I
removed the line from my.cnf, restarted mysql. It recreated the innodb
files and I dumped the data back in. Perhaps there may have been a
faster way, but this way seemed to go smoothly.

David Piasecki
Software Engineer

-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, May 21, 2002 11:45 PM
To: [EMAIL PROTECTED]
Subject: Re: MySQL InnoDB startup problem

David,

did you upgrade from a very old version of MySQL to .49? The sorting
order
of latin1 accent characters was changed about 8 months ago, and that may
cause the assertion you have encountered. You should dump and reimport
your
tables if you have accent characters.

Anyway, the B-tree index is now corrupt.

Please use the instructions of section 6.1 in
http://www.innodb.com/ibman.html to force recovery. Then dump + drop +
reimport.

Best regards,

Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and latest news on
InnoDB


- Original Message -
From: ""David Piasecki"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, May 22, 2002 8:04 AM
Subject: MySQL InnoDB startup problem


> I'm running MySQL 3.23.49. Everything was going good until today. I
did
> a couple of large table reads/inserts/deletes on the InnoDB tables
which
> appeared to go fine. I then restarted MySQL which also appeared to go
> fine. From that point on, however, I kept losing connection with the
DB,
> and couldn't run any queries. A check of the error log reveals the
> following:
>
> ---start err log---
> 020521 21:54:13  mysqld restarted
> 020521 21:54:19  InnoDB: Database was not shut down normally.
> InnoDB: Starting recovery from log files...
> InnoDB: Starting log scan based on checkpoint at
> InnoDB: log sequence number 0 2556753944
> 020521 21:54:19  InnoDB: Flushing modified pages from the buffer
pool...
> 020521 21:54:19  InnoDB: Started
> /usr/local/mysql/libexec/mysqld: ready for connections
> InnoDB: Assertion failure in thread 508094464 in file btr0btr.c line
574
> InnoDB: We intentionally generate a memory trap.
> InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
> mysqld got signal 11;
> This could be because you hit a bug. It is also possible that this
> binary
> or one of the libraries it was linked agaist is corrupt, improperly
> built,
> or misconfigured. This error can also be caused by malfunctioning
> hardware.
> We will try our best to scrape up some info that will hopefully help
> diagnose
> the problem, but since we have already crashed, something is
definitely
> wrong
> and this may fail
>
> key_buffer_size=268431360
> record_buffer=131072
> sort_buffer=524280
> max_used_connections=0
> max_connections=400
> threads_connected=0
> It is possible that mysqld could use up to
> key_buffer_size + (record_buffer + sort_buffer)*max_connections =
518136
> K
> bytes of memory
> Hope that's ok, if not, decrease some variables in the equation
> ---end err log---
>
> I tried grabbing the latest source and recompiling the database, but
> still no go. Unfortunately I don't have a backup of the InnoDB tables,
> so there isn't a whole lot that I can do in that respect. The data
> appears to still be in the tables, because I can on occasion do a
select
> and it will return data before the database dies.
>
> Anyone have any experience with this sort of problem? Thanks.
>
>
> David Piasecki
> Software Engineer
>
>
>
> -
> 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.mysq

Re: update query fails

[Ryan Hatch]

be aware... linux/unix table names are case sensitive.  if you're using Win32 MySQL
on your system, the query might work, but on the ISP side, if it's a *NIX system...
you must have the correct capitalization.

moreover, if any of your variables contain a single quote character ( ' ), it will
screw up your SQL statement.  make sure you run all your variables through a filter
to check for single quotes.   either backslash them out ( \ ) or prevent your users
from using them.

-Ryan Hatch

Sven Bentlage wrote:

> Hi everyone!
>
> Are there any limitations on update queries, like on how many fields one
> can update at the same time?
>
> The first  update query works just fine, the second does not work at all:
>
> working :
> " update memberscopy set password='$password' where name =
> '$f_name' and surname ='$f_surname' "
>
> not working:
> " update memberscopy
> set rank='$rank',
> cname='$cname',
> caddress='$caddress',
> ctel='$ctel',
> cfax='$cfax',
> cmobile='$cmobile',
> cemail='$cemail',
> curl='$curl',
> btype='$btype',
> hq='$hq',
> quali='$quali',
> experi='$experi',
> inhouse='$inhouse',
> resid='$resid',
> ptel='$ptel',
> pfax='$pfax',
> pmobile='$pmobile',
> pemail='$pemail',
> marital='$marital',
> spouse='$spouse',
> children_number='$children_number',
> children_names='$children_names',
> hobbies='$hobbies',
> membership='$membership',
> pcont='$pcont',
> lastup=now()
> where name = '$f_name' and surname = '$f_surname'  "
>
> The 2nd query works (for some fields only) on my local machine, but not
> on the ISP's server
>
> Thanks for your help.
>
> Sven
>
> -
> 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

about get field's length of text type in query

[Ê©]

i want to get really length of text field,but function
length() allways return 8,how can i get it with sql?
 
thanks.

__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.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

Union does not work

[Dan Liu]

Hi,
Could anybody tell me why the following query does not work?
SELECT location FROM visiExPr where location=1  union (SELECT location FROM visiExPr 
where location=0);
Thanks!

Dan


-
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