foreign keys for relation ships

[van den Heuvel, Frank]

Hello,

I am creating tables within MySql  3.23.49. I want to add relation ships
between different tables. I tried to do this with foreign key statements.
For example:

CREATE TABLE domains (
  domain varchar(100) NOT NULL,
  registrarid int(10) NOT NULL,
  foreign key (registrarid) REFERENCES registrars(registrarid),
  PRIMARY KEY  (domain)
) TYPE=INNODB;

CREATE TABLE registrars (
  registrarid int(10) unsigned NOT NULL auto_increment,
  url varchar(200) default NULL,
  whois varchar(100) default NULL,
  tld varchar(100) default NULL,
  PRIMARY KEY  (registrarid)
) TYPE=INNODB

So the column registrarid in the domain table is a reference to the
registrars table(registrarid). When I put this in mysql it doesn't complain
about it. Then I use ODBC to link the database to Access. I use Access as my
front-end. There I cannot see the relationship. Also when I do a show create
table within mysql I cannot see the relationship. Is this the wrong way to
do this ? In other words, what is the right way to do this ?

Thanks Frank

-
Before posting, please check:
   http://www.mysql.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: Re: mysql server can'

[Äþº£½¢]

Thank you , The mysql server I using is downloaded from the internet.



> Äþº£½¢ wrote:
> > The mysql server can't work.Anyone know what will I do?
> > 
>   You can buy commercial support?
> or be a lot more specific about the problem.
> 
> 
> -- 
> Vincent Stoessel [EMAIL PROTECTED]
> Linux and Java Application Developer
> (301) 362-1750
> AIM, MSN: xaymaca2020 , Yahoo Messenger: vks_jamaica
> 
> 



===
 
ÊÖ»úºÅÂëÊǵçÓÊ£¬´Ó´Ë½»·Ñ²»ÓóһºÅÔÚÊÖ¡°ËæÉíÓÊ¡±
 
¡ª¡ª 163¡°ËæÉíÓÊ¡±ÊÖ»úÓÊÏä ¡ª¡ª
¡ò ÊÖ»úºÅÂë¾ÍÊǵç×ÓÓÊÏäµØÖ·£¬·½±ã¼ÇÒä
¡ò ²»ÓÃÉÏÍø£¬Í¸¹ýÊÖ»ú¶ÌÐÅ£¬ËæʱÕÆÎÕÓʼþµÄ½ÓÊÕÇé¿ö
¡ò ¾ö²»´í¹ýÈκÎÉÌÒµÁ¼»ú
¡ò ·½±ãµÄ°´ÔÂÊÕ·Ñ·½Ê½£¬×îµÍÿÔÂÖ»Ðè5Ôª
 
ÏêÇéÇëä¯ÀÀ
http://vip.163.net/mobile/mobile.htm
 
===

-
Before posting, please check:
   http://www.mysql.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: what's wrong with EXPLAIN?

[savaidis]

I give an example to make clear what I mean.
I had a table with about 100 records scanned from a book.
I scanned another 70 and when I finished with INSERT/correcting/INSERT ecc
cycle, my table had about 500 records. Of course I had in mind this, so one
field was set to '1' so I could delete them all new and re-insert to 70
records for last time.
If I could use EXPLAIN to examine the 70 records, I hadn't to do this.

Makis


> -Original Message-
> From: savaidis [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 11, 2002 11:25 AM
> To: [EMAIL PROTECTED]
> Subject: RE: what's wrong with EXPLAIN?
>
>
> Thanks. But I think, it would be more usefull to INSERT/UPDATE as they
> change the talbe's contents.
>
>
> Makis
>
>
> > -Original Message-
> > From: Cary [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, March 11, 2002 12:16 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: what's wrong with EXPLAIN?
> >
> >
> > I am probably wrong, but my assumption was that EXPLAIN was
> > used to help
> > optimize SELECT statements, not INSERT/UPDATE statements.
> > So if I am thinking correctly (this time :-), EXPALAIN is
> > erroring for you
> > because it only deals with SELECT statements.
> >
> > Cary
> >
> > At 12:10 PM 3/9/02, savaidis wrote:
> >
> > >I found - once again- strange behaviour on some MySQL
> > functions, i.e. with
> > >EXPLAIN command.
> > >I give one very simple query : explain update mytable set field1 =
> > >round(field1,2) where field1>0
> > >and it shows me an error!
> > >But when I execute it without 'explain', it updates the
> > fields correctly.
> > >Why?
> > >(field1 is a real of cource and I tried "where field1>0.0"
> > too with the same
> > >error)
> > >If I'm not shure 'explain' is working correctly, then how I
> > will trust to
> > >use it? To show me errors where they doesn't exist?
> > >
> > >Makis
> > >
> > >
> > >
> >
> >-
> > >Before posting, please check:
> > >http://www.mysql.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
>


-
Before posting, please check:
   http://www.mysql.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: Unicode support for MySQL

[Robin Tay]

Im interested in UTF-8 or anything at least that will give me support on
the database to hold both chinese, korean and english character sets at
one time or at least cheat at it.

-Original Message-
From: David Ayliffe [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 12 March 2002 6:10 a.m.
To: 'Victoria Reznichenko'; [EMAIL PROTECTED]
Subject: RE: Unicode support for MySQL


When you say:

"Unicode will be supported in 4.0.3 version of MySQL."

What do you mean - UTF-8 encoding or UTF-16 or what?

Can you clarify

-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: 11 March 2002 09:24
To: [EMAIL PROTECTED]
Subject: Unicode support for MySQL


Robin,
Monday, March 11, 2002, 6:55:51 AM, you wrote:

RT> I am just wondering if the latest stable build of MySQL has
RT> support for Unicode character set so I can use it to store english,
RT> chinese and korean characters. If so please let me know. And also if

RT> there is going to be any problems to perform SELECT statements to
RT> search for a particular pattern. Much appreciated.

Unicode will be supported in 4.0.3 version of MySQL.

RT> Robin Tay




--
For technical support contracts, goto https://order.mysql.com/ 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





-
Before posting, please check:
   http://www.mysql.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: site search

[Georg Richter]

On Tuesday, 12. March 2002 06:18, you wrote:
> I want to build a MySQL site search. Can anyone help with my 'overview'
>
> I have written a perl programme to open each html file, cut out all the
> tags and create a hash of hashes each word is a key, then the secondary key
> is the filename, then the value is the number of occurances in that
> document.
>
> So how should I make my SQL tables? I thought a 2 column
> (filename:occurances) table for each word would be the best way, but thats
> A LOT of tables. I'd get perl to do all the writing, and I'm sure I could
> get it to work this way.
>
> But is this the best way? I'm fairly new to MySQL so please be explicit!
>

Hello.

I'm not sure if building a search engine is the right task for a mysql 
beginner, but maybe this link could be helpful for you:

http://www.howstuffworks.com/search-engine.htm

Maybe its easier to use an existing engine/code like mnogosearch.

Regards

Georg

(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: Why v3.23.49 does not build on RedHat 6.2 ?????

[Sommai Fongnamthip]

Hi Benjamin,
 Uhmm, I have not success with Pre-compiled / Binary code from 
MySQL.  In the other hand (if I was success installed), could it placed all 
thing like static complied?  I have been concern this because I must to 
install other program or library to use with MySQL.  So, I have a little 
experience with *nix* platform and using MySQL with the basic instruction.
 By now, I will try the MySQL binary installed to avoid this problem.

Thanks any way,
Sommai.

At 03:05 12/3/2002 +0100, Benjamin Pflugmann wrote:
>Hi.
>
>On Tue, Mar 12, 2002 at 08:20:46AM +0700, [EMAIL PROTECTED] wrote:
> > Hi,
> > What's wrong with GNU-cc 2.96?
>
>AFAIK, stability problems have been reported which did go away
>when using a precompiled binary...
>
> > Why could we use 2.95 (and old > 2.91) or above 3.*?
>
>or one of these compiler versions.
>
> > Is this the junction of MySQL's user to choose which Linux version
> > and review the suitable Hardware and Software?  I mentioned this
> > statement because I have more MySQL Server for several purpose in my
> > organization.  Of course, I still wait for the better feature from
> > MySQL.  How should we do; if the future version need more hardware,
> > latest compiler or migration (3.xx --> 4.xx)?  Did we still have the
> > strength feature from MySQL (easy setup, run fast, need low
> > resource)?
>
>I am not fully able to follow your concerns... if you use the
>precompiled binaries, as Sinisa suggested, you have all that, don't
>you? Usually, there is no need to compile MySQL yourself. To compile
>yourself is an option, not a must.
>
>Bye,
>
> Benjamin.
>
>--
>[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

--
Please be informed that all e-mail which are addressing to
thaithanakit.co.th will need to be changed to
BTsecurities.com by March 1, 2002 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

Re: How to pass mysql connections across exec()

[Manvendra Bhangui]

Rick,

I have tried it and it works and there is no problem in executing any sql queries in 
the child. my application also is
working fine. But the issue I am facing is the value of the four variables in the 
MYSQL structure, which
I presume gets set only when doing mysql_real_connect(). I am worried that I could 
cause mysqld to crash because this is not the way to connect to mysqld. These four 
variables are not available to the child (I am thinking
of setting these four variables as env variables in the parent so that the child can 
pick it up and set it forcibly). In
fact the function mysqlreconnect() in try1.c is a hacked version of 
mysql_real_connect() from libmysql.c minus the
socket() and connect() system calls.

The purpose behind my experimentations is to modify the inetd server, open the 
connection to mysqld in inetd and
the child of inetd should be able to reuse the socket connected to mysqld.

mysql.server_version
mysql.thread_id
mysql.server_language
mysql.scramble_buff

Any help in figuring out how the mysql structure, the NET structure and the VIO 
structure gets set or can be set without doing mysql_real_connect() would be helpful 
to me.

Regards Manvendra

On Mon, 11 Mar 2002 15:04:47 -0600
"Rick Emery" <[EMAIL PROTECTED]> wrote:

> have you tried forking the process, then terminating the parent?  All open
> file desciptors, including sockets, would be available to the child.  The
> child would contain the code in try1.c.
> 
> -Original Message-
> From: Manvendra Bhangui [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 11, 2002 5:22 AM
> To: [EMAIL PROTECTED]
> Subject: How to pass mysql connections across exec()
> 
> 
> Hi,
> 
> I have a requirement where I should be able to open connection to mysql from
> a server
> which is running continuously and pass the connection to a child of this
> server after it
> does a exec to a totally different executable. This will enable me to reuse
> a mysql connection
> initiated by one process and used by another process - which though is a
> child of the
> first process but is a totally different executable. Thus, I will be able to
> initiate
> connection pooling for a daemon like smtp without keeping on initiating
> mysql_real_connect()
> on each and every mail.
> 
> I have done this by doing mysql_init() and mysql_real_connect() in the
> parent.
> In the exec'ed process, I do mysql_init() followed my vio_new() and
> my_net_init().
> The above logic works for me, But i am not sure if I am doing the right
> thing. Also there is a difference
> in the some of the values of the mysql structure in parent and the child.
> 
> Also enclosing two programs try.c and try1.c, which demonstrate the above.
> try does a mysql_real_connect()
> to open a mysql_connection with socket descriptor 3. The program try1 the
> uses this same descriptor to
> restablish the connection to the mysqld server without initiating a new
> socket connection.
> 
> The output of the mysql structure by try is
> 
> hostlocalhost
> uservpopmail
> passssh-1.5-
> sock/tmp/mysql.sock
> vers4.0.0-alpha-log
> Host Info   Localhost via UNIX socket
> info(null)
> db  vpopmail
> Affected Rows   0
> Insert id   0
> extra_info  0
> thread_id   103
> packet_length   0
> port3306
> client_flag 8333
> server_capabilities 44
> Protocol version10
> Field Count 0
> Server Status   2
> Server Language 8
> Mysql Status0
> Free me 0
> Reconnect   1
> Scramble0Q,$n~OR
> 
> The output of the mysql structure by try1 is
> 
> hostlocalhost
> uservpopmail
> passssh-1.5-
> sock/tmp/mysql.sock
> vers
> Host Info   Localhost via UNIX socket
> info(null)
> db  (null)
> Affected Rows   0
> Insert id   0
> extra_info  0
> thread_id   0
> packet_length   0
> port3306
> client_flag 8333
> server_capabilities 0
> Protocol version10
> Field Count 0
> Server Status   2
> Server Language 0
> Mysql Status0
> Free me 0
> Reconnect   1
> Scramble   
> 
> As you can see the following variables are not getting set in the exec'ed
> process.
> 
> mysql.server_version
> mysql.thread_id
> mysql.server_language
> mysql.scramble_buff
> 
> Is there anyting i am missing? (However, the program works fine and the
> query also works fine.
> The mysql show process list also shows that the connection is being reused.
> However I am not
> sure, if this method could cause any problems).
> 
> The programs try.c and try1.c are below
> 
> /* try.c */
> #include 
> #include 
> #include 
> main(

Re: mysql with java

[Vincent Stoessel]

Hmm,
I have done some java/linux development using mysql and it works
fine using the jdbc api. I highly recommend using Mark Mathews' jdbc
driver in your java development area. It is licensed under GNU LGPL.
http://mmmysql.sourceforge.net/
Be sure to join the  mysql-java mailing list for questions  to the java/mysql
community.

Denny wrote:
> Hi,
> 
> Is there any examples on developing a java interface with mysql?
> 
> Thanks,
> Denny
> 
> 
> -
> Before posting, please check:
>http://www.mysql.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



-- 
Vincent Stoessel [EMAIL PROTECTED]
Linux and Java Application Developer
(301) 362-1750
AIM, MSN: xaymaca2020 , Yahoo Messenger: vks_jamaica


-
Before posting, please check:
   http://www.mysql.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 with java

[Denny]

Hi,

Is there any examples on developing a java interface with mysql?

Thanks,
Denny


-
Before posting, please check:
   http://www.mysql.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 + ext3 + data=j

[Äþº£½¢]

On Mon, Mar 11, 2002 at 05:06:56PM +0100, Matthias Jaekle wrote:
> Hello,
> 
> I am running mysql with datafiles on a ext3 file system.  Is there
> an security advantage for mysql, if I mount the ext3 file system
> with the option data=journal ?

I don't know a lot about ext3 yet.  Is that full journaling or
metadata only?
-- 
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 32 days, processed 1,042,867,093 queries (374/sec. avg)





===
 
ÊÖ»úºÅÂëÊǵçÓÊ£¬´Ó´Ë½»·Ñ²»ÓóһºÅÔÚÊÖ¡°ËæÉíÓÊ¡±
 
¡ª¡ª 163¡°ËæÉíÓÊ¡±ÊÖ»úÓÊÏä ¡ª¡ª
¡ò ÊÖ»úºÅÂë¾ÍÊǵç×ÓÓÊÏäµØÖ·£¬·½±ã¼ÇÒä
¡ò ²»ÓÃÉÏÍø£¬Í¸¹ýÊÖ»ú¶ÌÐÅ£¬ËæʱÕÆÎÕÓʼþµÄ½ÓÊÕÇé¿ö
¡ò ¾ö²»´í¹ýÈκÎÉÌÒµÁ¼»ú
¡ò ·½±ãµÄ°´ÔÂÊÕ·Ñ·½Ê½£¬×îµÍÿÔÂÖ»Ðè5Ôª
 
ÏêÇéÇëä¯ÀÀ
http://vip.163.net/mobile/mobile.htm
 
===

-
Before posting, please check:
   http://www.mysql.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 server can't work.

[Äþº£½¢]

The mysql server can't work.Anyone know what will I do?



===
 
ÊÖ»úºÅÂëÊǵçÓÊ£¬´Ó´Ë½»·Ñ²»ÓóһºÅÔÚÊÖ¡°ËæÉíÓÊ¡±
 
¡ª¡ª 163¡°ËæÉíÓÊ¡±ÊÖ»úÓÊÏä ¡ª¡ª
¡ò ÊÖ»úºÅÂë¾ÍÊǵç×ÓÓÊÏäµØÖ·£¬·½±ã¼ÇÒä
¡ò ²»ÓÃÉÏÍø£¬Í¸¹ýÊÖ»ú¶ÌÐÅ£¬ËæʱÕÆÎÕÓʼþµÄ½ÓÊÕÇé¿ö
¡ò ¾ö²»´í¹ýÈκÎÉÌÒµÁ¼»ú
¡ò ·½±ãµÄ°´ÔÂÊÕ·Ñ·½Ê½£¬×îµÍÿÔÂÖ»Ðè5Ôª
 
ÏêÇéÇëä¯ÀÀ
http://vip.163.net/mobile/mobile.htm
 
===

-
Before posting, please check:
   http://www.mysql.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

site search

[julian haffegee]

Hi everyone,

I want to build a MySQL site search. Can anyone help with my 'overview'

I have written a perl programme to open each html file, cut out all the tags
and create a hash of hashes each word is a key, then the secondary key is
the filename, then the value is the number of occurances in that document.

So how should I make my SQL tables? I thought a 2 column
(filename:occurances) table for each word would be the best way, but thats A
LOT of tables. I'd get perl to do all the writing, and I'm sure I could get
it to work this way.

But is this the best way? I'm fairly new to MySQL so please be explicit!

thanks for your time

Jules


-
Before posting, please check:
   http://www.mysql.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

Multiple languages (was Re: Cyrillic characters)

[Joel Rees]

Sort of off topic, but here goes:

Jim Philips wrote:

> I am trying to understand how to store both Latin and Cyrillc characters
> in a database. I built in support for koi-8 and win1251, but I don't
> seem to be getting real support for Cyrillic. Cyrillic characters are
> stored as ASCII

Uhmmm, unless there is some parsing and conversion going on along with the
storing, "storing as ASCII" really doesn't mean anything. A 0x5c (decimal
92) is neither back slash nor the yen (JPY) mark. If you are reading text
from an American source (but not EBCDIC), you think it is backslash, but if
you are reading text from a Japanese (shift-JIS) source you think it is JPY.
What you think of it when reading Cyrillic, I don't recall off-hand.

> and are echoed back on the Web page that way.

At any rate, this is what the browser is doing, not what MySQL is doing. You
have to explicitly tell the browser to interpret those bits as one thing or
another. Most browsers won't let you display more than one character
set/encoding at a time.

This can be fudged a bit in certain cases. Shift-JIS, for instance, includes
most of US-ASCII in its original positions. (Tilde is the other exception,
but without clear rules.) But you still get funny treatment of English text
when you're mixing Japanese and English. Word breaks versus line breaks is a
place where things often break down.

Unicode should shortly provide the ability to display characters from
multiple languages in a single web document (if your machine has the fonts),
but it will probably take a bit longer to enable multiple locales in a
single web document. Switching between multiple sets of parsing rules on the
fly is a bit of a pain. And, just what multiple locales in a single document
should mean is not yet really well understood, either. Many Japanese people
think it is wrong to respect word breaks for English words at the end of the
line, for instance.

> Will MySQL
> support storing both Latin and Cyrillic characters in the same database?

I understand that the particular encoding of Cyrillic you are looking at is
an 8-bit encoding, and does not allocate any version of Latin in the
encoding. I think you might be able to use the HTTP encoding headers to
specify one frame as Cyrillic and another as Latin, but you may find some
browsers that choke on it.

MySQL, from what I understand, requires the encoding and the parsing rules
to be specified together in the initializations, so you won't be able to
switch from one locale to another on the fly.

(Someone confirm that, please?)

So, for sorting, collation, some aspects of indexing, case
conversion/sensitivity, etc., you will have to live with what the rules for
the one do to the other, if you use a single database server. For instance,
if you need to sort on both English and Cyrillic at the same time, you'll
need to do some extra work, maybe use C/perl/PHP/whatever to sort some
things in RAM.

For simple storage, however, you really don't care what the locale is. A
blob of English text in a record that is otherwise Cyrillic might not really
pose any problems. (But you'll want to think it out carefully beforehand.)

In other words, it's going to require some experimenting. Let us know how it
goes.

Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka

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: MySQL / XP / some expletive

[Tim]

I use the my.cnf file to direct MYSQL to look into different folders 
for the data files, you may not need to do that. 

When you say Services, you do mean a Service on NT, right?

MYSQL does not automatically add the service, you need to install it 
as a service manually after the normal installation of MYSQL has been 
performed.

Once you do that it will appear in the normal Services area of 
Administrative tools in Windows XP.

To install it, go into the mysql/bin directory and try something like 

mysqld-nt --install 
(or mysqld-max-nt --install)

Once you do this command it will add the service.

Good luck!

I am running on Windows XP professional by the way, cannot confirm 
whether it is a problem under the the home edition.

Cheers



Tim

> Hi, I'll try that. Re:
> 
> "Make sure you configure the my.cnf file and place it in the c:\ 
directory
> as appropriate."
> 
> Can you expand on this please?
> 
> Re starting it from 'Services'..have you done this from XP? I opened 
the
> services window and studied it for some time but could find no 
reference to
> MySQL! There appeared to be two service tabs at the bottom of the 
window -
> standard and advanced as I recall (both looked identical!) - and I 
couldn't
> find a MySQL server service (if a reboot is all that is needed then 
this
> doesn't matter).
> 
> Thanks
> 
> Paul.
> 
> 
> Hi Paul,
> 
> I am running it under XP without any problem.
> 
> You need to go into the mysql 'bin' directory and install the service
> (as you would have done under win2K).
> 
> e.g. to install mysqld-nt as a service do this from the command line.
> 
> mysqld-nt --install
> 
> Then either reboot (and the service will start automatically) or go
> into Services and start it manually.
> 
> Make sure you configure the my.cnf file and place it in the c:\
> directory as appropriate.
> 
> Hope this helps.
> 
> Cheers
> 
> 
> 
> Tim
> 
> 
> > Hello,
> >  This post pertaining to a previous one on the same subject.
> That  is I
> > cannot get MySQL to run on Win XP! I get the "ERROR  2003:  can't
> connect to
> > MySQL server on 'localhost' (10061)" when running  mysql  from
> c:\mysql\bin
> > in the command prompt. I have looked for the MySQL service to run 
it
> > manually to ensure it is running,  but there is no service to run.
> Like
> > other entries to the list,  I have it running on 2K with no 
problem.
> But on
> > XP  - no joy.
> >
> > All advice gratefully received.
> >
> > Paul.
> >
> >
> > ---
--
> > Before posting, please check:
> >http://www.mysql.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
> 
> 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: Order by list?

[Paul DuBois]

At 20:00 -0800 3/11/02, George Marnellos wrote:
>Hi all,
>
>I'm executing the follow very simple type of query to select entries from a
>list:
>
>"select entryid, entryinfo from mytable where entryid in ('id7', 'id4',
>'id2', 'id5')"
>
>and, even though I don't specify any sorting order, MySQL sorts
>alphabetically
>by the field "entryid" (which happens to be an index), i.e. it returns
>
>+--+---+
>| entryid  | entryinfo |
>+--+---+
>| id2   |   ... |
>| id4  |   ... |
>| id5  |   ... |
>| id7  |   ... |
>+--+---+
>
>I don't want this sorting order; I want the order to be that of the list. Is
>there a
>way to do this? It appears very simple but I cannot find how.

Use an ORDER BY clause that looks like this:

ORDER BY FIELD(entryid,'id7','id4','id2','id5')

>
>
>Thanks for any comments or help,
>George


-
Before posting, please check:
   http://www.mysql.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

Order by list?

[George Marnellos]

Hi all,

I'm executing the follow very simple type of query to select entries from a
list:

"select entryid, entryinfo from mytable where entryid in ('id7', 'id4',
'id2', 'id5')"

and, even though I don't specify any sorting order, MySQL sorts
alphabetically 
by the field "entryid" (which happens to be an index), i.e. it returns

+--+---+
| entryid  | entryinfo |
+--+---+
| id2|   ... |
| id4  |   ... |
| id5  |   ... |
| id7  |   ... |
+--+---+

I don't want this sorting order; I want the order to be that of the list. Is
there a
way to do this? It appears very simple but I cannot find how.


Thanks for any comments or help,
George

-
Before posting, please check:
   http://www.mysql.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: Where do I place a notice that my server hosts mysql databases?

[Mike]

Thanks for the info! I sent your link off to a friend in ca who's looking
for such a site. I think it would be of great help if MySQL site had a list
of hosting providers as well.

Cheers

M;)

-Original Message-
From: System Administrator a.k.a. The Root of the Problem
[mailto:[EMAIL PROTECTED]]
Sent: Monday, March 11, 2002 7:42 PM
To: [EMAIL PROTECTED]
Subject: Where do I place a notice that my server hosts mysql databases?


Could someone tell me where I could post/announce this question?

I am an ISP being in busniness for 7 years.

I support MySQL on my server and would welcome those of you who want
to host their database on our system.


--
contact:
Dave Yadallee  NetKnow  The Internet Knowledge Company
[EMAIL PROTECTED]  http://www.nl2k.ab.ca
990-3244

-
Before posting, please check:
   http://www.mysql.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 / XP / some expletive

[Tim]

Hi Paul,

I am running it under XP without any problem.

You need to go into the mysql 'bin' directory and install the service 
(as you would have done under win2K).

e.g. to install mysqld-nt as a service do this from the command line.

mysqld-nt --install

Then either reboot (and the service will start automatically) or go 
into Services and start it manually.

Make sure you configure the my.cnf file and place it in the c:\ 
directory as appropriate.

Hope this helps.

Cheers



Tim


> Hello,
>  This post pertaining to a previous one on the same subject. 
That  is I
> cannot get MySQL to run on Win XP! I get the "ERROR  2003:  can't 
connect to
> MySQL server on 'localhost' (10061)" when running  mysql  from 
c:\mysql\bin
> in the command prompt. I have looked for the MySQL service to run it
> manually to ensure it is running,  but there is no service to run. 
Like
> other entries to the list,  I have it running on 2K with no problem. 
But on
> XP  - no joy.
> 
> All advice gratefully received.
> 
> Paul.
> 
> 
> -
> Before posting, please check:
>http://www.mysql.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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Languages

[Joel Rees]

Dave queried:

> Does MySQL support the below languages?  I can find info about character
> sets but I can't find info to tell me what languages map to those
character
> sets.
>
> > Korean
> > Chinese ( Simplified and Traditional )
> > Japanese
> > Canadian French
> > Latin Spanish
> > Portuguese

Did you look in mysql/share/charsets? Check the Readme and the Index. Also,
the manual, around section 4.6. (That monolithic html is a pain. If you
download it, download the pdf.)

Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka




-
Before posting, please check:
   http://www.mysql.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: What type of Unicode?

[Joel Rees]

David Ayliffe queried:

> I hear MySQL 4.0.3 will support Unicode.  But what sort of Unicode do
> you mean
>
> UTF-8 encoding or UTF-16 or UCS or what?

>From what I've been reading on this list, it sounds like they have two
polarities of UTF-16 running, and are working on UTF-8. I might assume they
will also have UTF-32, but I might be wrong.

> Will the same sort be used
> internally as externally (UI)  what is used at the moment - standard
> ASCII?
>
> Can anyone clarify?

My guess is that there won't be any automatic conversion, but that is my
guess. It appears, from what little I've read so far, that they are not
doing any conversions at present, either, simply providing character
classification (ergo, C's ctype) tables/functions.

I also am interested in clarifications.

My POV -- because of differences of opinion concerning what characters are
equivalent to what, and similar problems, conversion is always risky, and
should be avoided in databases. Best to simply record what the encoding
should have been and store it as is.

Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka





-
Before posting, please check:
   http://www.mysql.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: MyODBC and .NET (C#)

[Scalper]

I just got it to work in VB.NET.  I played with the connection string.  In 
fact, I took everything out except the DSN.  Here is the code 
(VB.net).  For the most part it is exactly like VB6 except no SET commands 
and no default properties.  Try making your connection string minimal in C#.

 Dim c As New ADODB.Connection()
 Dim r As New ADODB.Recordset()

 c.Open("DSN=SchoolStuff")
 r = c.Execute("SELECT * FROM classtitles")
 While Not r.EOF
 MsgBox(r.Fields("classtitle").Value)
 r.MoveNext()
 End While

 r.Close()
 r = Nothing
 c.Close()
 c = Nothing


At 06:01 PM 3/11/2002 -0800, you wrote:
>Hi All,
>
>I'm having problems connecting to MySQL with C# via
>MyODBC 3.51.02; the DSN I created is called 'MySQL1'.
>The error I am receiving is: "The 'MySQL1' provider is
>not registered on the local machine". This is what my
>connection string looks like:
>
>string strConn = "Provider=MySQL1;DNS=MySQL1";
>
>Has anyone faced similar issues? Any advice?
>
>Thanks in advance,
>Jes
>
>__
>Do You Yahoo!?
>Try FREE Yahoo! Mail - the world's greatest free email!
>http://mail.yahoo.com/
>
>-
>Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Where do I place a notice that my server hosts mysql databases?

[System Administrator a.k.a. The Root of the Problem]

Could someone tell me where I could post/announce this question?

I am an ISP being in busniness for 7 years.

I support MySQL on my server and would welcome those of you who want 
to host their database on our system.  


-- 
contact:
Dave Yadallee  NetKnow  The Internet Knowledge Company
[EMAIL PROTECTED]  http://www.nl2k.ab.ca
990-3244

-
Before posting, please check:
   http://www.mysql.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: Why v3.23.49 does not build on RedHat 6.2 ?????

[Benjamin Pflugmann]

Hi.

On Tue, Mar 12, 2002 at 08:20:46AM +0700, [EMAIL PROTECTED] wrote:
> Hi,
> What's wrong with GNU-cc 2.96? 

AFAIK, stability problems have been reported which did go away
when using a precompiled binary...

> Why could we use 2.95 (and old > 2.91) or above 3.*?

or one of these compiler versions.

> Is this the junction of MySQL's user to choose which Linux version
> and review the suitable Hardware and Software?  I mentioned this
> statement because I have more MySQL Server for several purpose in my
> organization.  Of course, I still wait for the better feature from
> MySQL.  How should we do; if the future version need more hardware,
> latest compiler or migration (3.xx --> 4.xx)?  Did we still have the
> strength feature from MySQL (easy setup, run fast, need low
> resource)?

I am not fully able to follow your concerns... if you use the
precompiled binaries, as Sinisa suggested, you have all that, don't
you? Usually, there is no need to compile MySQL yourself. To compile
yourself is an option, not a must.

Bye,

Benjamin.

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

MySQL / XP / some expletive

[Paul Wallace]

Hello,
 This post pertaining to a previous one on the same subject. That  is I
cannot get MySQL to run on Win XP! I get the "ERROR  2003:  can't connect to
MySQL server on 'localhost' (10061)" when running  mysql  from c:\mysql\bin
in the command prompt. I have looked for the MySQL service to run it
manually to ensure it is running,  but there is no service to run. Like
other entries to the list,  I have it running on 2K with no problem. But on
XP  - no joy.

All advice gratefully received.

Paul.


-
Before posting, please check:
   http://www.mysql.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

MyODBC and .NET (C#)

[Jes Herman]

Hi All,

I'm having problems connecting to MySQL with C# via
MyODBC 3.51.02; the DSN I created is called 'MySQL1'.
The error I am receiving is: "The 'MySQL1' provider is
not registered on the local machine". This is what my
connection string looks like:

string strConn = "Provider=MySQL1;DNS=MySQL1";

Has anyone faced similar issues? Any advice?

Thanks in advance,
Jes

__
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/

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

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

Re: Request-URI Too Large

[delz]

Hi,

Can you help me edit my script because I'm used to doing the approach that I
did in the script editform01.php. I'm quite confused. Actually in my edit
script I used 3 php scripts. One is to view (editform01.php), the other one
is the form to display the fields that you want to edit (editform02.php),
and the last one is the update script whch does all the editing
(editing03.php). I would appreciate any help that you can provide. Attached
below are my 3 scripts for reference :

editform01.php
-


Mode International e-Bulletin Board




M o d e   I n t e r n a t
i o
n a l    I n c.
e - B u l l
e t
i n  B o a r d



D a t
e
S u b j e
c t
P o s t e
d  b y


";

while ($r = mysql_fetch_array($result)) {
$idx = $r["idx"];
$date = $r["date"];
$too = $r["too"];
$subject = $r["subject"];
$carbon = $r["carbon"];
$body = $r["body"];
$postedby = $r["postedby"];

//URL Encode

$idx = urlencode($idx);
$date = urlencode($date);
$too = urlencode($too);
$subject = urlencode($subject);
$carbon = urlencode($carbon);
$body = urlencode($body);
$postedby = urlencode($postedby);


//URL Decode

$date = urldecode($date);
$subject = urldecode($subject);
$carbon = urldecode($carbon);
$postedby = urldecode($postedby);


echo "
$date
$subject
$postedby
Edit
";

}

echo "";

} else {

echo "No data.";

}

mysql_free_result($result);

include("links.y");

?>






editform02.php








Mode International e-Bulletin Board




M o d e  I n t e r n a
t i
o n a l  I n c.
e - B u l l
e t
i n  B o a r d



Date:

  
  
To:
">
  

Subject:
">
  

Cc:
">
  

 

  

Postedby:



 

  


   

">
">
">









editform03.php
---

mysql_connect(localhost, root, mypassword) or die ("Problem connecting to
DataBase");

$query = "UPDATE czz SET
idx='$idx',date='$date',too='$too',subject='$subject',carbon='$carbon',body=
'$body',postedby='$postedby' WHERE idx='$idx'";

$result = mysql_db_query("e-bulletin", $query);
$query = "SELECT * FROM czz";
$result = mysql_db_query("e-bulletin", $query);
mysql_free_result($result);

include("links.y");

?>




- Original Message -
From: "ds" <[EMAIL PROTECTED]>
To: "delz" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, March 12, 2002 4:02 AM
Subject: Re: Request-URI Too Large


> If all the data is in your database, why are you passing it in your
> query-string ?!?!?!!?
> Why don't you simply pass the idx like:
>
> 
> Then, in editform02.php you only need to do a
>
> $query = "select * from czz where idx=$idx";
>
> to get your data to edit.
> Also, one more note: you encode and after you decode... You must decide
> your self! ;-)  You can get the results from database, show them while
> they are decoded, then encode the data and put the url "Edit".
> Hope this helps!
>
>




-
Before posting, please check:
   http://www.mysql.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: Request-URI Too Large

[delz]

Hi,

Can you help me edit my script because I'm used to doing the approach that I
did in the script editform01.php. I'm quite confused. Actually in my edit
script
I used 3 php scripts. One is to view (editform01.php), the other one is the
form
to display the fields that you want to edit (editform02.php), and the last
one is the
update script whch does all the editing (editing03.php). I would appreciate
any
help that you can provide. Attached below are my 3 scripts for reference :

editform01.php
-


Mode International e-Bulletin Board




M o d e   I n t e r n a t
i o
n a l    I n c.
e - B u l l
e t
i n  B o a r d



D a t
e
S u b j e
c t
P o s t e
d  b y


";

while ($r = mysql_fetch_array($result)) {
$idx = $r["idx"];
$date = $r["date"];
$too = $r["too"];
$subject = $r["subject"];
$carbon = $r["carbon"];
$body = $r["body"];
$postedby = $r["postedby"];

//URL Encode

$idx = urlencode($idx);
$date = urlencode($date);
$too = urlencode($too);
$subject = urlencode($subject);
$carbon = urlencode($carbon);
$body = urlencode($body);
$postedby = urlencode($postedby);


//URL Decode

$date = urldecode($date);
$subject = urldecode($subject);
$carbon = urldecode($carbon);
$postedby = urldecode($postedby);


echo "
$date
$subject
$postedby
Edit
";

}

echo "";

} else {

echo "No data.";

}

mysql_free_result($result);

include("links.y");

?>






editform02.php








Mode International e-Bulletin Board




M o d e  I n t e r n a
t i
o n a l  I n c.
e - B u l l
e t
i n  B o a r d



Date:

  
  
To:
">
  

Subject:
">
  

Cc:
">
  

 

  

Postedby:



 

  


   

">
">
">









editform03.php
---

mysql_connect(localhost, root, mypassword) or die ("Problem connecting to
DataBase");

$query = "UPDATE czz SET
idx='$idx',date='$date',too='$too',subject='$subject',carbon='$carbon',body=
'$body',postedby='$postedby' WHERE idx='$idx'";

$result = mysql_db_query("e-bulletin", $query);
$query = "SELECT * FROM czz";
$result = mysql_db_query("e-bulletin", $query);
mysql_free_result($result);

include("links.y");

?>




- Original Message -
From: "ds" <[EMAIL PROTECTED]>
To: "delz" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, March 12, 2002 4:02 AM
Subject: Re: Request-URI Too Large


> If all the data is in your database, why are you passing it in your
> query-string ?!?!?!!?
> Why don't you simply pass the idx like:
>
> 
> Then, in editform02.php you only need to do a
>
> $query = "select * from czz where idx=$idx";
>
> to get your data to edit.
> Also, one more note: you encode and after you decode... You must decide
> your self! ;-)  You can get the results from database, show them while
> they are decoded, then encode the data and put the url "Edit".
> Hope this helps!
>
>
> On Sat, 2002-03-09 at 02:52, delz wrote:
> > Hi,
> >
> > To give you all an idea, i have a script named editform01.php that first
> > displays the data in a table. ThenI have this link called "Edit" in
which it
> > goes to another script called editform02.php which is where the data is
> > displayed and then you can edit it there. My problem is I cannot proceed
to
> > the other script editform02.php because it gives me the error "Request
URI
> > Too Large", this only appears whenever I have a big amount of data in
one of
> > my textbox.
> >
> > Below is my script editform01.php for your reference.
> >
>
> --
--
> > ---
> > 
> > My Database
> > 
> >
> > 
> >
> >
> >  > mysql_connect(localhost, root, mypassword) or die ("Problem connecting
to
> > DataBase");
> > $query = "select * from czz";
> > $result = mysql_db_query("e-bulletin", $query);
> >
> > if ($result) {
> > echo "
> > D a t
> > e
> > S u b j
e c
> > t
> > P o s t
e d
> > b y
> > 
> >
> > ";
> >
> > while ($r = mysql_fetch_array($result)) {
> > $idx = $r["idx"];
> > $date = $r["date"];
> > $too = $r["too"];
> > $subject = $r["subject"];
> > $carbon = $r["carbon"];
> > $body = $r["body"];
> > $postedby = $r["postedby"];
> >
> > //URL Encode
> >
> > $idx = urlencode($idx);
> > $date = urlencode($date);
> > $too = urlencode($too);
> > $subject = urlencode($subject);
> > $carbon = urlencode($carbon);
> > $body = urlencode($body);
> > $postedby = urlencode($postedby);
> >
> >
> > //URL Decode
> >
> > $date = urldecode($date);
> > $subject = urldecode($subject);
> > $carbon = urldecode($carbon);
> > $postedby = urldecode($postedby);
> >
> >
> > echo "
> > $date
> > $subject
> > $postedby
> >  >
href=\"editform02.php?idx=$idx&date=$date&too=$too&subject=$subject&carbon=$
> > carbon&body=$body&postedby=$postedby\">Edit
> > ";
> >
> > }
> >
> > echo "";
> >
> > } else {
> >
> > echo "No data.";
> >
> > }
> >
> > mysql_free_result($result);
> > ?>
> > 
> > 
> >
> >
> > Thanks.
> >
> > Delz
> >
> > - Original Message -
> > From: "Andreas Frosting" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROT

Re: Why v3.23.49 does not build on RedHat 6.2 ?????

[Sommai Fongnamthip]

Hi,
 What's wrong with GNU-cc 2.96?  Why could we use 2.95 (and old 
2.91) or above 3.*?  Is this the junction of MySQL's user to choose which 
Linux version and review the suitable Hardware and Software?   I mentioned 
this statement because I have more MySQL Server for several purpose in my 
organization.  Of course, I still wait for the better feature from MySQL. 
How should we do; if the future version need more hardware, latest compiler 
or migration (3.xx --> 4.xx)?  Did we still have the strength feature from 
MySQL (easy setup, run fast, need low resource)?

Sommai,

At 14:22 9/3/2002 +0200, Sinisa Milivojevic wrote:
>Gabriele Carioli writes:
> > Hi!
> >
> > > Our (MySQL AB) recommendation is to NOT compile
> > > *mysql* with RedHat's 2.96 compiler. Instead,
> > > in the case of RedHat, you should use 2.91
> > > EGCS or 2.95 GCC compilers.
> >
> > Your (MySQL AB) source rpm does not build at all with
> > the egcs/gcc 2.91 compiler. In fact, it gives this error:
> >
> > [..snip...]
> > creating libmysqlclient.la
> > (cd .libs && rm -f libmysqlclient.la && ln -s ../libmysqlclient.la
> > libmysqlclient.la)
> > make[2]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.49/libmysql'
> > Making all in client
> > make[2]: Entering directory `/usr/src/redhat/BUILD/mysql-3.23.49/client'
> > gcc -DUNDEF_THREADS_HACK 
> -I./../include -I..
> > /include -I./.. -I.. -I..-O3 
> -DDBUG_OFF  -O3   -felide-const
> > ructors -fno-exceptions -fno-rtti -fno-implicit-templates 
> -fno-exception
> > s -fno-rtti -fpermissive -I/usr/local/mysql-glibc/include -c mysql.cc
> > In file included from mysql.cc:48:
> > /usr/include/curses.h:195: warning: `ERR' redefined
> > /usr/include/sys/ucontext.h:74: warning: this is the location of the
> > previous definition
> > cc1plus: Invalid option `-fpermissive'
> > In file included from client_priv.h:19,
> >  from mysql.cc:28:
> > ../include/global.h:685: abstract declarator used as declaration
> > make[2]: *** [mysql.o] Error 1
> > make[2]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.49/client'
> > make[1]: *** [all-recursive] Error 1
> > make[1]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.49'
> > make: *** [all-recursive-am] Error 2
> > error: Bad exit status from /var/tmp/rpm-tmp.61911 (%build)
> >
>
>Hi!
>
>I can only repeat what Matt Wagner said.
>
>If you are using GNU compiler, we recommend either 2.95.* or 3.*
>series.
>
>Better still, use our binaries. Noone knows better then us how to
>build proper MySQL binaries.
>
>--
>Regards,
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
>  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
>/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
><___/   www.mysql.com
>
>
>-
>Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

--
Please be informed that all e-mail which are addressing to
thaithanakit.co.th will need to be changed to
BTsecurities.com by March 1, 2002 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

Myisamchk question

[Fournier Jocelyn [Presence-PC]]

Hi,

I'm currently testing the BACKUP TABLE function, and to reconstruct the MYI
files, I'm performing the following action :

For exemple :

dd if=/home/mysql/Hardwarefr/cookie.MYI bs=16k count=1
of=/home/mirror/mysql/Hardwarefr
/cookie.MYI

(to restore the valid first 16 K block)

[root@forum] /home/mirror/mysql/Hardwarefr> ls -la cookie.MYI
-rw-r--r--1 root root16384 Mar 12 01:52 cookie.MYI

Then I execute :

myisamchk -r cookie.MYI

- recovering (with sort) MyISAM-table 'cookie'
Data records: 95290
- Fixing index 1
Data records: 95289

[root@forum] /home/mirror/mysql/Hardwarefr> ls -la cookie.MYI
-rw-r--r--1 root root   879616 Mar 12 01:55 cookie.MYI

[root@forum] /home/mirror/mysql/Hardwarefr> myisamchk -e cookie
Checking MyISAM file: cookie
Data records:   95289   Deleted blocks:   0
- check file-size
- check key delete-chain
- check record delete-chain
- check index reference
- check data record references index: 1
- check records and index references

Things seems to be perfect here, but :

myisamchk -o cookie
- recovering (with keycache) MyISAM-table 'cookie'
Data records: 95289

[root@forum] /home/mirror/mysql/Hardwarefr> ls -la cookie.MYI
-rw-r--r--1 root root  1577984 Mar 12 01:56 cookie.MYI

Why does the MYI is know nearly twice as big as the old cookie.MYI file ?

Thanks you !

Jocelyn Fournier
Presence-PC



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

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

Re: Mysql installation. Help!

[Andy Cheng]

Great, the uppercase in $sth->{NUM_OF_FIELDS} works.  Now I can start to 
learn perl.  Any advice on where could I find a good source for beginner on 
the web?  Thank you very much.


>From: ds <[EMAIL PROTECTED]>
>To: Andy Cheng <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: Mysql installation. Help!
>Date: 11 Mar 2002 19:41:08 +
>
>
>I don't understand the code. I copy it from a book. I am trying to print 
>out
>the records returned from a query.  I have a table named client in database
>andy. The table has 2 records.  When I run the above code, I have 2 blank
>lines return.  Could any one tell me what the problem is?  Where could I
>find better documentation on DBI::DBD::mysql stuff for beginner?  man
>DBD::mysql is difficult to understand.  Thanks again for the info.
>
>#!/usr/bin/perl
>
>use DBI;
>$dbh=DBI->connect('DBI:mysql:andy');
>my $query="select * from client";
>my $sth=$dbh->prepare($query) or die "cann't prepare".$dbh->errstr."\n";
>$sth->execute;
>my $rows;
>while(@row=$sth->fetchrow_array)
>{my $i;
>for $i (0..($sth->{num_of_fields}-1))
>{print "[".$row[$i]."]";}
>print("\n");
>}
>$sth->finish;
>$dbh->disconnect

>Hi,

>I'm not an expert in perl too, but i would correct your code to this:
>
>#!/usr/bin/perl
>
>use DBI;
>$dbh=DBI->connect('DBI:mysql:andy');
>my $query="select * from client";
>my $sth=$dbh->prepare($query) or die "cann't prepare".$dbh->errstr."\n";
>$sth->execute;
>my $rows;
>while(@row=$sth->fetchrow_array)
>{my $i;
>for $i (0..($sth->{NUM_OF_FIELDS}-1))
>{print "[".$row[$i]."]";}
>print("\n");
>}
>$sth->finish;
>$dbh->disconnect
>
>Note the uppercase in $sth->{NUM_OF_FIELDS}.
>Also remove the line "my $rows"... It's doing nothing there.



_
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

MySQL++ samples are not working?

[Radhakrishna Mohan Tadepalli]

Does anybody tried MySQL++ samples? I guess they are not working. Any help
is appreciated -Radha



_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


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

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

RE: Problem with locking i guess ...

[Patrick de Kievit]

Okay, i've build an application using the db a lot. Sometimes the db have
500-600 query per sec. avg. 400 concurrent connections.

On some scripts i do a select (where ready='Y'), update the records (set
ready='N')  in a way that a new select will not show the previous selected
records. (uhh..)

Sometimes this fails and records are selected 2/3 times. Will a simple LOCK
IN SHARE MODE solve this problem, or do i need to upgrade to InnoDB ? ( i
really dont want to do that right now)

I run 3.23.39-log using MyISAM on a 2*pIII 1 ghz 1 gig of ram / raid 5

Thanks in advance...







-
Before posting, please check:
   http://www.mysql.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

mysqldumpslow errors

[Steven Roussey]

>Description:
1. Handling of string simplification confused, crashes perl!
2. Format of slow log had changed a while back, so now the
timing information is broken in mysqldumpslow

>How-To-Repeat:
uploaded to mysql secret: n54-slow.log.gz
gunzip n54-slow.log.gz
mysqldumpslow n54-slow.log
>Fix:
1. Change:
   s/'([^\\\']|\\.|\'\')+'/'S'/g;
   s/"([^\\\"]|\\.|\"\")+"/"S"/g;

To:
s/''/'S'/g;
s/""/"S"/g;

s/(\\')//g;
s/(\\")//g;

s/'[^']+'/'S'/g;
s/"[^"]+"/"S"/g;

I'm not a perl wizzard, so there is likely a better way. But this
actually works. :)

2. Change:

s/^# Time: (\d+)  Lock_time: (\d+)  Rows_sent: (\d+).*\n//;

To:

s/^# Query_time: (\d+)  Lock_time: (\d+)  Rows_sent: (\d+).*\n//;

>Submitter-Id:  
>Originator:Steven Roussey
>Organization:
 Network54
>MySQL support: [none anymore :( ]
>Synopsis:  
>Severity:  < serious >
>Priority:  <[ low | medium | high ] (one line)>
>Category:  mysql
>Class: < sw-bug >
>Release:   mysql-3.23.47 (Official MySQL binary)
>Server: /usr/local/bin/mysqladmin  Ver 8.23 Distrib 3.23.47, 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.47-log
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 5 days 20 hours 57 min 33 sec

Threads: 81  Questions: 693745099  Slow queries: 2238  Opens: 967352
Flush tables: 1  Open tables: 1510 Queries per second avg: 1367.112
>Environment:

System: Linux trinity 2.4.16-0.13smp #1 SMP Fri Dec 14 05:10:37 EST 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-98)
Compilation info: CC='gcc'  CFLAGS='-O3 -mpentium '  CXX='gcc'
CXXFLAGS='-O3 -mpentium  -felide-constructors'  LDFLAGS='-static'
LIBC:
lrwxrwxrwx1 root root   13 11-16 13:02 /lib/libc.so.6 ->
libc-2.2.4.so
-rwxr-xr-x1 root root  1283580 10-03 11:10
/lib/libc-2.2.4.so
-rw-r--r--1 root root 27314604 10-03 10:52 /usr/lib/libc.a
-rw-r--r--1 root root  178 10-03 10:52 /usr/lib/libc.so
Configure command: ./configure  --prefix=/usr/local/mysql
'--with-comment=Official MySQL binary' --with-extra-charsets=complex
--with-server-suffix= --enable-thread-safe-client --enable-assembler
--with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static
--disable-shared

Sincerely,
Steven Roussey
http://Network54.com/?pp=e 




-
Before posting, please check:
   http://www.mysql.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

LEFT/RIGHT Join?

[Johnny Withers]

So, it's been a while since I've actaully needed to do this
and I can not for the life of me figure this out, maybe it's
because I've been working for nine hours w/o getting up.

Here it is:
I have two tables, one table holds Team information, the
other table holds top scorers. However, sometimes the top
scorers are a tie between players on different teams, so I need
a record returned with no team associated with it:

ie:

Top Scorers:
NameTeamPoints
John DoeTeam A  423
Jane DoeTeam B  233
Tie between 3 players   (no team)   100

This is the left join I'm using:
select t1.player,t1.game,t1.points,t1.ppg,t2.team as team_name
from sc_scoreleaders as t1,sc_seasonstanding as t2
left outer join sc_scoreleaders on t1.id=t2.team;

And I get these results:
*** 1. row ***
   player: Johnny Withers
 game: 2
   points: 200
  ppg: 100
team_name: Mindbender's Fake Team
*** 2. row ***
   player: No Team Asso
 game: 1
   points: 1
  ppg: 1
team_name: Mindbender's Fake Team


Table desc and data follows:

mysql> desc sc_seasonstanding; 
++--+--+-+-+
+
| Field  | Type | Null | Key | Default | Extra
|
++--+--+-+-+
+
| id | int(10) unsigned |  | PRI | NULL|
auto_increment |
| team   | varchar(255) |  | | |
|
| win| tinyint(1) unsigned  | YES  | | 0   |
|
| loss   | tinyint(1) unsigned  | YES  | | 0   |
|
| pts_scored | smallint(3) unsigned | YES  | | 0   |
|
| pts_versus | smallint(3) unsigned | YES  | | 0   |
|
| pts_diff   | smallint(3) unsigned | YES  | | 0   |
|
++--+--+-+-+
+
7 rows in set (0.01 sec)

mysql> desc sc_scoreleaders;
++--+--+-+-+
+
| Field  | Type | Null | Key | Default | Extra
|
++--+--+-+-+
+
| id | int(10) unsigned |  | PRI | NULL| auto_increment
|
| team   | int(10) unsigned | YES  | MUL | 0   |
|
| player | varchar(255) | YES  | | NULL|
|
| game   | varchar(255) | YES  | | 0   |
|
| points | smallint(6) unsigned | YES  | | 0   |
|
| ppg| smallint(6) unsigned | YES  | | 0   |
|
++--+--+-+-+
+


data:

mysql> select * from sc_seasonstanding\G
*** 1. row ***
id: 2
  team: Mindbender's Fake Team
   win: 32
  loss: 0
pts_scored: 4052
pts_versus: 12
  pts_diff: 4050
1 row in set (0.00 sec)

mysql> select * from sc_scoreleaders\G
*** 1. row ***
id: 1
  team: 2
player: Johnny Withers
  game: 2
points: 200
   ppg: 100
*** 2. row ***
id: 2
  team: 0
player: No Team Asso
  game: 1
points: 1
   ppg: 1
2 rows in set (0.00 sec)



Someone help me out please...
Server version: 3.23.44-Max

(mysql,query,table,sql,etc)

-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985

 


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

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

error logging

[Jerrad Pierce]

Why doesn't mysql have a --err-log option?
Are at the *very* least send it's output to STDERR instead of STDOUT?

-
Before posting, please check:
   http://www.mysql.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++ samples are not working?

[Radhakrishna Mohan Tadepalli]

Does anybody tried MySQL++ samples? I guess they are not working. Any help
is appreciated -Radha



-
Before posting, please check:
   http://www.mysql.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: Encrypted table

[Cengizhan Kaptan]

Anyone who ever used 'authlib' script? On my local Apache server it works
well however, it does not work on my domain... I would be very grateful to
the person who explains me how to setup this script... It always says:
connection to mysql failed...

thanks in advance...

- Original Message -
From: "Chris Becker" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, March 11, 2002 11:46 PM
Subject: Re: Encrypted table


> encrypted table, no.
>
> encrypted data - yes!  check out this AES algorithm, it can be used with
C,
> C++, and there is even a VB implementation.
>
> I highly recommend.
>
> Chris
>
> www.MyDBA2000.com
>
>
> >From: Tripp Scott <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: Encrypted table
> >Date: Tue, 12 Mar 2002 03:57:16 +0700
> >
> >The downside of putting users' data in a MySQL database is that
> >the sysadmin knows everything. Is there an implementation of an
> >encrypted table in MySQL?
> >
> >t
> >
> >
> >-
> >Before posting, please check:
> >   http://www.mysql.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
> >
>
>
> _
> Chat with friends online, try MSN Messenger: http://messenger.msn.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

What type of Unicode?

[David Ayliffe]

I hear MySQL 4.0.3 will support Unicode.  But what sort of Unicode do
you mean

UTF-8 encoding or UTF-16 or UCS or what?  Will the same sort be used
internally as externally (UI)  what is used at the moment - standard
ASCII?


Can anyone clarify?


Thanks lots
David Ayliffe

ICQ# 125646758


Query table database



-
Before posting, please check:
   http://www.mysql.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: Encrypted table

[Chris Becker]

encrypted table, no.

encrypted data - yes!  check out this AES algorithm, it can be used with C, 
C++, and there is even a VB implementation.

I highly recommend.

Chris

www.MyDBA2000.com


>From: Tripp Scott <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Encrypted table
>Date: Tue, 12 Mar 2002 03:57:16 +0700
>
>The downside of putting users' data in a MySQL database is that
>the sysadmin knows everything. Is there an implementation of an
>encrypted table in MySQL?
>
>t
>
>
>-
>Before posting, please check:
>   http://www.mysql.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
>


_
Chat with friends online, try MSN Messenger: http://messenger.msn.com


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

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

RE: How to pass mysql connections across exec()

[Rick Emery]

have you tried forking the process, then terminating the parent?  All open
file desciptors, including sockets, would be available to the child.  The
child would contain the code in try1.c.

-Original Message-
From: Manvendra Bhangui [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 11, 2002 5:22 AM
To: [EMAIL PROTECTED]
Subject: How to pass mysql connections across exec()


Hi,

I have a requirement where I should be able to open connection to mysql from
a server
which is running continuously and pass the connection to a child of this
server after it
does a exec to a totally different executable. This will enable me to reuse
a mysql connection
initiated by one process and used by another process - which though is a
child of the
first process but is a totally different executable. Thus, I will be able to
initiate
connection pooling for a daemon like smtp without keeping on initiating
mysql_real_connect()
on each and every mail.

I have done this by doing mysql_init() and mysql_real_connect() in the
parent.
In the exec'ed process, I do mysql_init() followed my vio_new() and
my_net_init().
The above logic works for me, But i am not sure if I am doing the right
thing. Also there is a difference
in the some of the values of the mysql structure in parent and the child.

Also enclosing two programs try.c and try1.c, which demonstrate the above.
try does a mysql_real_connect()
to open a mysql_connection with socket descriptor 3. The program try1 the
uses this same descriptor to
restablish the connection to the mysqld server without initiating a new
socket connection.

The output of the mysql structure by try is

hostlocalhost
uservpopmail
passssh-1.5-
sock/tmp/mysql.sock
vers4.0.0-alpha-log
Host Info   Localhost via UNIX socket
info(null)
db  vpopmail
Affected Rows   0
Insert id   0
extra_info  0
thread_id   103
packet_length   0
port3306
client_flag 8333
server_capabilities 44
Protocol version10
Field Count 0
Server Status   2
Server Language 8
Mysql Status0
Free me 0
Reconnect   1
Scramble0Q,$n~OR

The output of the mysql structure by try1 is

hostlocalhost
uservpopmail
passssh-1.5-
sock/tmp/mysql.sock
vers
Host Info   Localhost via UNIX socket
info(null)
db  (null)
Affected Rows   0
Insert id   0
extra_info  0
thread_id   0
packet_length   0
port3306
client_flag 8333
server_capabilities 0
Protocol version10
Field Count 0
Server Status   2
Server Language 0
Mysql Status0
Free me 0
Reconnect   1
Scramble   

As you can see the following variables are not getting set in the exec'ed
process.

mysql.server_version
mysql.thread_id
mysql.server_language
mysql.scramble_buff

Is there anyting i am missing? (However, the program works fine and the
query also works fine.
The mysql show process list also shows that the connection is being reused.
However I am not
sure, if this method could cause any problems).

The programs try.c and try1.c are below

/* try.c */
#include 
#include 
#include 
main()
{
MYSQL mysql;

mysql_init(&mysql);
if (!(mysql_real_connect(&mysql, "localhost", "vpopmail", "***",
"vpopmail", 3306, 0, 0)))
{
fprintf(stderr, "mysql_real_connect: %s\n",
mysql_error(&mysql));
return(1);
} 
printf("host%s\n", mysql.host);
printf("user%s\n", mysql.user);
printf("pass%s\n", mysql.passwd);
printf("sock%s\n", mysql.unix_socket);
printf("vers%s\n", mysql.server_version);
printf("Host Info   %s\n", mysql.host_info);
printf("info%s\n", mysql.info);
printf("db  %s\n", mysql.db);
printf("Affected Rows   %d\n", mysql.affected_rows);
printf("Insert id   %d\n", mysql.insert_id);
printf("extra_info  %d\n", mysql.extra_info);
printf("thread_id   %d\n", mysql.thread_id);
printf("packet_length   %d\n", mysql.packet_length);
printf("port%d\n", mysql.port);
printf("client_flag %d\n", mysql.client_flag);
printf("server_capabilities %d\n", mysql.server_capabilities);
printf("Protocol version%d\n", mysql.protocol_version);
printf("Field Count %d\n", mysql.field_count);
printf("Server Status   %d\n", mysql.server_status);
printf("Server Language %d\n", mysql.s

RE: xml

[Rutledge, Aaron]

I would think an add on to Apache Xerces would be perfect for this--and
not difficult. Has anyone from MySQL contacted members of the Apache XML
project about this?  It would be great if this was done in a high
profile open source environment.  An XML wrapper API for MySQL would fit
a huge whole in the open source community between the DB and open-source
application servers such as Tomcat and JBoss.  This is definitely an
area that companies like Oracle have a huge advantage right now for
developers.  Additionally, it could later be integrated into an open
source IDE module like NetBeans.  I hope to see it happen. --Aaron

 


-Original Message-
From: Matt Wagner [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 09, 2002 1:11 PM
To: James Cox
Cc: [EMAIL PROTECTED]
Subject: RE: xml


On Sat, 2002-03-09 at 13:13, James Cox wrote:
> Matt,
> 
> Are you suggesting development of a wrapper around MySQL to convert
XML to
> SQL and back, so that you would have a pseudo XML front end to mysqld?

James,

Well 'wrapper' and 'pseudo XML front end' are kind of nebulous terms and
phrases. :)

But yeah basically. Functionality can be added to the MySQL client
library (libmysqlclient) -- which is the library that holds all the C
API functions and whatnot. It is the library that your PHP, Perl DBI,
Java MySQL drivers link against in order to be able to talk to the MySQL
server.

  http://www.mysql.com/doc/C/_/C_API_function_overview.html

So for instance, for XML retrieval of your results it would be quite
trival to add additional API calls to libmysqlclient that return XML to
your application.

However, loading an XML file into your MySQL server (via the C API)
would be a more difficult and tricky task. DTDs would have to be
defined, some software would have to manage these DTDs so that the data
in the XML file could be correctly mapped into your database schema, etc
etc.

You can't just load any old XML file and expect MySQL to know how to
deal with it. There would have to be a DTD (the file that defines the
format of your XML file) submitted with the XML file so that things
could be interpretted correctly.

This means that this would involve an SGML parser (such as nsgmls) and
some way to validate the XML file (I think nsgmls can do this), etc etc.
This brings us to the point where if all of this was added to
libmysqlclient, we would start running into bloatware issues there also.

That's why I suggested that probably an external process (a daemon) that
provides a "bridge" (as Rob ([EMAIL PROTECTED]) suggested earlier in this
thread) would be better suited to *inputting* XML into MySQL.

Output is easy. Input is more difficult. :)

As you may be aware we are currently working diligently to add big
functionality to MySQL (sub-selects, store procedures, failsafe
replication, etc). That makes something like this XML stuff better
suited for sponsorship.

I'm not saying that with sponsorship, this XML stuff can pre-empt the
development of the above features. But instead, sponsorship would allow
us to hire another developer or two to develop this proposed XML
functionality. It allows us to develop features that are in demand in
parallel with our other priorities.

Again, if anyone is interested in this sponsorship, please contact
<[EMAIL PROTECTED]>.


Regards,

Matt

-- 
For technical support contracts, visit https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Coordinator of Development
/_/  /_/\_, /___/\___\_\___/   Hopkins, Minnesota  USA
   <___/   www.mysql.com   M: +1 952 250 5434


-
Before posting, please check:
   http://www.mysql.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

Encrypted table

[Tripp Scott]

The downside of putting users' data in a MySQL database is that 
the sysadmin knows everything. Is there an implementation of an 
encrypted table in MySQL?

t


-
Before posting, please check:
   http://www.mysql.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 database connect issue..............!

[Jani Tolonen]

Ashraf KAzmi writes:
 > Hi Jani,
 > That variable is already set to "max_allowed_packet=16M" in my.cnf file?
 > Any more clue..!
 > Ashraf

Hi,

First of all,

Please turn off HTML mode in your email client and use plain text mode
instead. HTML mode only increases the size of emails without providing
extra information.

Second, you have basic email support, so you can mail to
[EMAIL PROTECTED] or use SupportWizard at http://support.mysql.com

Third, error: "Got error reading communication packets" means that
there is a problem in communication between a client and the server. 
This can be:

a.) Due to bad connection. Are your clients connecting using TCP/IP?
If so, please check the line.

b.) Your MySQL server is failing, maybe crashing.

If you think the reason is the latter one, then please provide us
information about:

- Your MySQL server version number

- Include the last 50 lines in `hostname`.err file. If MySQL crashed,
  you should be able to see it in this file.

- Please check your tables with '[my]isamchk' for errors and fix if
  you find any.

- Please check section 'A.4.1 What To Do If MySQL Keeps Crashing'
  from the MySQL manual.

Regards,

- Jani

For technical support contracts, visit https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Jani Tolonen <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Full-Time Developer
/_/  /_/\_, /___/\___\_\___/   Helsinki, Finland
   <___/   www.mysql.com

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

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

Re: MySQL and MSAccess

[russo]

Hi Chris,
 Also interested in exploring how MS products can interact with MySQL
since I work in a diverse environment (PC's, some MACs, UNIX
clusters-Solaris 8).

I found this so far:


Also, to check which version of MDAC you have use:
Component Checker


That's all I have I'm fairly new to most of this...
I'm hoping other list members have more to say. ;)

Regards,
-Ryan

On Mon, 11 Mar 2002, Chris Becker wrote:

>
> Is anyone out there using MySQL on either Unix or NT, with MSAccess as the
> front-end?  Are you using odbc bound controls on your access forms?
>
> Any issues? Suggestions? In-sights?
>
> We are planning on migrating a SQLServer back-end to MySQL on Linux as a
> robust and affordable back office solution.
>
> Thanks in advance.
>
> Chris
>
> _
> Chat with friends online, try MSN Messenger: http://messenger.msn.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
>
>

||
| Ryan Russo |
| Academic Computing Web Group, (518) 442-4772   |
||



-
Before posting, please check:
   http://www.mysql.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 and MSAccess

[Chris Becker]

Anyone using MySQL on Linux/Unix with a MSAccess front end? Using odbc bound 
controls?

Any issues, insights, suggestions?  How's the interaction with the Jet 
engine?  Any performance issues?

Thanks in advance.

Chris

_
Send and receive Hotmail on your mobile device: http://mobile.msn.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: On the logging of BLOBS

[Dan Patnaude]

Hi-

I apologize for being unclear. It is messing with the text update log. I have 
both binary and text logging running right now while I try figure this out. 
However I have since learned that the database that is writing the blobs is 
related to Resin JSP session data, and so does not need to be logged. A simple

binlog-ignore-db=sessions will work for the binary logs. 

But, the text logs get all messed up... i.e. if you more the text log, the 
output gets garbled as soon as you encounter one of these blobs. Should I 
just not use text logging (I know its use is being discouraged)?

I hope this info helps.
-Dan

On Monday 11 March 2002 02:38, you wrote:
> On Mon, Mar 11, 2002 at 01:43:59PM -0500, Dan Patnaude wrote:
> > Is there SQL syntax to do selective logging. We have logging
> > turned on, but queries involving BLOBS tend to screw with the
> > logs. Any help would be useful
>
> Can you be more specific than "screw with the logs"?  If it's a bug,
> the MySQL folks will fix it.
>
> Oh, and which logs?  Binary logs?
>
> Jeremy

-
Before posting, please check:
   http://www.mysql.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: On the logging of BLOBS

[Dan Patnaude]

Hi-

I apologize for being unclear. It is messing with the text update log. I have 
both binary and text logging running right now while I try figure this out. 
However I have since learned that the database that is writing the blobs is 
related to Resin JSP session data, and so does not need to be logged. A simple

binlog-ignore-db=sessions will work for the binary logs. 

But, the text logs get all messed up... i.e. if you more the text log, the 
output gets garbled as soon as you encounter one of these blobs. Should I 
just not use text logging (I know its use is being discouraged)?

I hope this info helps.
-Dan

On Monday 11 March 2002 02:38, Jeremy Zawodny wrote:
> On Mon, Mar 11, 2002 at 01:43:59PM -0500, Dan Patnaude wrote:
> > Is there SQL syntax to do selective logging. We have logging
> > turned on, but queries involving BLOBS tend to screw with the
> > logs. Any help would be useful
>
> Can you be more specific than "screw with the logs"?  If it's a bug,
> the MySQL folks will fix it.
>
> Oh, and which logs?  Binary logs?
>
> Jeremy

-
Before posting, please check:
   http://www.mysql.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: On the logging of BLOBS

[Dan Patnaude]

Hi-

I apologize for being unclear. It is messing with the text update log. I have 
both binary and text logging running right now while I try figure this out. 
However I have since learned that the database that is writing the blobs is 
related to Resin JSP session data, and so does not need to be logged. A simple

binlog-ignore-db=sessions will work for the binary logs. 

But, the text logs get all messed up... i.e. if you more the text log, the 
output gets garbled as soon as you encounter one of these blobs. Should I 
just not use text logging (I know its use is being discouraged)?

I hope this info helps.
-Dan

On Monday 11 March 2002 02:38, Jeremy Zawodny wrote:
> On Mon, Mar 11, 2002 at 01:43:59PM -0500, Dan Patnaude wrote:
> > Is there SQL syntax to do selective logging. We have logging
> > turned on, but queries involving BLOBS tend to screw with the
> > logs. Any help would be useful
>
> Can you be more specific than "screw with the logs"?  If it's a bug,
> the MySQL folks will fix it.
>
> Oh, and which logs?  Binary logs?
>
> Jeremy

-
Before posting, please check:
   http://www.mysql.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 + ext3 + data=journal ?

[David yahoo]

I ve read an article tellinf that it s a plus.
But with no explanation.

With journal option you journaling the data too.

So it migth prevent from a myisamchk ?
It s my opinion.

But the best security u can add into this is transaction.

a+.


> On Mon, Mar 11, 2002 at 05:06:56PM +0100, Matthias Jaekle wrote:
> > Hello,
> >
> > I am running mysql with datafiles on a ext3 file system.  Is there
> > an security advantage for mysql, if I mount the ext3 file system
> > with the option data=journal ?
>
> I don't know a lot about ext3 yet.  Is that full journaling or
> metadata only?
> --
> 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 32 days, processed 1,042,867,093 queries (374/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


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


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

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

Re: Request-URI Too Large

[ds]

If all the data is in your database, why are you passing it in your
query-string ?!?!?!!?
Why don't you simply pass the idx like:

 Hi,
> 
> To give you all an idea, i have a script named editform01.php that first
> displays the data in a table. ThenI have this link called "Edit" in which it
> goes to another script called editform02.php which is where the data is
> displayed and then you can edit it there. My problem is I cannot proceed to
> the other script editform02.php because it gives me the error "Request URI
> Too Large", this only appears whenever I have a big amount of data in one of
> my textbox.
> 
> Below is my script editform01.php for your reference.
> 
> 
> ---
> 
> My Database
> 
> 
> 
> 
> 
>  mysql_connect(localhost, root, mypassword) or die ("Problem connecting to
> DataBase");
> $query = "select * from czz";
> $result = mysql_db_query("e-bulletin", $query);
> 
> if ($result) {
> echo "
> D a t
> e
> S u b j e c
> t
> P o s t e d
> b y
> 
> 
> ";
> 
> while ($r = mysql_fetch_array($result)) {
> $idx = $r["idx"];
> $date = $r["date"];
> $too = $r["too"];
> $subject = $r["subject"];
> $carbon = $r["carbon"];
> $body = $r["body"];
> $postedby = $r["postedby"];
> 
> //URL Encode
> 
> $idx = urlencode($idx);
> $date = urlencode($date);
> $too = urlencode($too);
> $subject = urlencode($subject);
> $carbon = urlencode($carbon);
> $body = urlencode($body);
> $postedby = urlencode($postedby);
> 
> 
> //URL Decode
> 
> $date = urldecode($date);
> $subject = urldecode($subject);
> $carbon = urldecode($carbon);
> $postedby = urldecode($postedby);
> 
> 
> echo "
> $date
> $subject
> $postedby
>  href=\"editform02.php?idx=$idx&date=$date&too=$too&subject=$subject&carbon=$
> carbon&body=$body&postedby=$postedby\">Edit
> ";
> 
> }
> 
> echo "";
> 
> } else {
> 
> echo "No data.";
> 
> }
> 
> mysql_free_result($result);
> ?>
> 
> 
> 
> 
> Thanks.
> 
> Delz
> 
> - Original Message -
> From: "Andreas Frosting" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, March 09, 2002 10:06 AM
> Subject: RE: Request-URI Too Large
> 
> 
> > > I'm using php and mysql as my server, when I'm updating a large
> > > page on my database using a browser I get
> > > "Request-URI Too Large
> > > the requested URL's length exceeds the capacity limit for this server.
> > > request failed: URI too long"
> > > Why is this so? Do I need to adjust something on mysql or my
> > > phpscript?
> >
> > Try putting method="post" in your 
> >
> > I.e:
> >
> >   
> >
> > :wq
> > //andreas
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.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
> 
-- 
dsoares
(sql)

-
Before posting, please check:
   http://www.mysql.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 and MSAccess

[Chris Becker]

Is anyone out there using MySQL on either Unix or NT, with MSAccess as the 
front-end?  Are you using odbc bound controls on your access forms?

Any issues? Suggestions? In-sights?

We are planning on migrating a SQLServer back-end to MySQL on Linux as a 
robust and affordable back office solution.

Thanks in advance.

Chris

_
Chat with friends online, try MSN Messenger: http://messenger.msn.com


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

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

Re: mysql + ext3 + data=journal ?

[Sinisa Milivojevic]

Jeremy Zawodny writes:
> On Mon, Mar 11, 2002 at 05:06:56PM +0100, Matthias Jaekle wrote:
> > Hello,
> > 
> > I am running mysql with datafiles on a ext3 file system.  Is there
> > an security advantage for mysql, if I mount the ext3 file system
> > with the option data=journal ?
> 
> I don't know a lot about ext3 yet.  Is that full journaling or
> metadata only?
> -- 
> 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 32 days, processed 1,042,867,093 queries (374/sec. avg)
> 

Both !!

But it is much slower for me then Reiser ...

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


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

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

Re: How to timestamp records across time zones? ##

[Keith C. Ivey]

Two more possibilities:

1. Set your MySQL server to use GMT for everything (that is, in the
   OS, not in MySQL).

2. Store all times as Unix time (seconds since 1970) -- the
   UNIX_TIMESTAMP() function can be useful for this.

Either solution still has the problem of converting to another format 
for display, but at least it's possible to do the inserts and updates 
with MySQL functions alone.

[Filter fodder: SQL, query]

-- 
Keith C. Ivey <[EMAIL PROTECTED]>
Washington, DC

-
Before posting, please check:
   http://www.mysql.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: On the logging of BLOBS

[Jeremy Zawodny]

On Mon, Mar 11, 2002 at 01:43:59PM -0500, Dan Patnaude wrote:

>   Is there SQL syntax to do selective logging. We have logging
> turned on, but queries involving BLOBS tend to screw with the
> logs. Any help would be useful

Can you be more specific than "screw with the logs"?  If it's a bug,
the MySQL folks will fix it.

Oh, and which logs?  Binary logs?

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 32 days, processed 1,042,867,859 queries (374/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 + ext3 + data=journal ?

[Jeremy Zawodny]

On Mon, Mar 11, 2002 at 05:06:56PM +0100, Matthias Jaekle wrote:
> Hello,
> 
> I am running mysql with datafiles on a ext3 file system.  Is there
> an security advantage for mysql, if I mount the ext3 file system
> with the option data=journal ?

I don't know a lot about ext3 yet.  Is that full journaling or
metadata only?
-- 
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 32 days, processed 1,042,867,093 queries (374/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 installation. Help!

[ds]

> 
> I don't understand the code. I copy it from a book. I am trying to print out 
> the records returned from a query.  I have a table named client in database 
> andy. The table has 2 records.  When I run the above code, I have 2 blank 
> lines return.  Could any one tell me what the problem is?  Where could I 
> find better documentation on DBI::DBD::mysql stuff for beginner?  man 
> DBD::mysql is difficult to understand.  Thanks again for the info.
>
> #!/usr/bin/perl
> 
> use DBI;
> $dbh=DBI->connect('DBI:mysql:andy');
> my $query="select * from client";
> my $sth=$dbh->prepare($query) or die "cann't prepare".$dbh->errstr."\n";
> $sth->execute;
> my $rows;
> while(@row=$sth->fetchrow_array)
> {my $i;
> for $i (0..($sth->{num_of_fields}-1))
> {print "[".$row[$i]."]";}
> print("\n");
> }
> $sth->finish;
> $dbh->disconnect

Hi, 

I'm not an expert in perl too, but i would correct your code to this:

> #!/usr/bin/perl
> 
> use DBI;
> $dbh=DBI->connect('DBI:mysql:andy');
> my $query="select * from client";
> my $sth=$dbh->prepare($query) or die "cann't prepare".$dbh->errstr."\n";
> $sth->execute;
> my $rows;
> while(@row=$sth->fetchrow_array)
> {my $i;
> for $i (0..($sth->{NUM_OF_FIELDS}-1))
> {print "[".$row[$i]."]";}
> print("\n");
> }
> $sth->finish;
> $dbh->disconnect

Note the uppercase in $sth->{NUM_OF_FIELDS}.
Also remove the line "my $rows"... It's doing nothing there.


> 
> >From: "Chuck \"PUP\" Payne" <[EMAIL PROTECTED]>
> >To: Doug Thompson <[EMAIL PROTECTED]>,   Andy Cheng 
> ><[EMAIL PROTECTED]>, Intrex <[EMAIL PROTECTED]>,   
> >"[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> >Subject: Re: Mysql installation.  Help!
> >Date: Sun, 10 Mar 2002 14:18:13 -0500
> >
> >Ok, if never run it then you have to start once, if I remember right undex
> >Red Hat, you have to go to /etc/rc.d/init.d and do this...
> >
> >./mysql start that will start it
> >
> >Then you will need to set it up so it will start later. SuSE you have to
> >start it once
> >
> >You will then need to set a password for mysql.
> >
> >I hope that helps.
> >
> >
> >  
> >  | Chuck Payne  |
> >  | Magi Design and Support  |
> >  | www.magidesign.com   |
> >  | [EMAIL PROTECTED]   |
> >  
> >
> >BeOS, Macintosh 68K, Classic, and OS X, Linux Support.
> >Web Design you can afford.
> >
> >Fortune for today --
> >
> >Q:  How many Zen masters does it take to screw in a light bulb?
> >A:  None.  The Universe spins the bulb, and the Zen master stays out
> > of the way.
> >
> >
> >
> > > If mysql.sock doesn't exist, that is because the server is not running.
> > >
> > > I fought the same battle as Mark and ultimately downloaded and installed 
> >the
> > > RPM for 3.23.49a from MySQL in place of
> > > the copy that came with RH.  The MySQL RPM installed and came up just 
> >like it
> > > says in the book.  Saves a lot of hair
> > > and dain bramage.
> > >
> > > If the server process _is_ running, it may be useful to go through the 
> >section
> > > on binary installation and check those
> > > items to see if your RPM set everything up correctly.  Don't bet on 
> >finding
> > > anything, but it doesn't take long to do
> > > these checks.
> > > http://www.mysql.com/doc/I/n/Installing_binary.html
> > >
> > > Regards,
> > > Doug
> > >
> > > "Perfection is finally attained not when there is no longer anything to 
> >add,
> > > but when there is no longer anything to
> > > take away." -- Antoine de Saint Exup?ry
> > >
> > > On Sun, 10 Mar 2002 10:11:05 -0500, Intrex wrote:
> > >
> > >> What I did was beat my brains out on the same exact problem.  In the 
> >end I
> > >> have no clue what I did to get it actually working.  I had re-installed 
> >the
> > >> mysql from the .tar.gz, I installed all the RPM's several times. 
> >Everytime,
> > >> I fully rebooted the system, and finally I have to run
> > >> safe_mysqld --user=root
> > >>
> > >> I think finaly I ran the tar -zxvf on the mysqlmax..tar.gz,
> > >> rebooted the system, then re-ran safe_mysqld --user=root.
> > >>
> > >> Mark
> > >>
> > >> - Original Message -
> > >> From: "Andy Cheng" <[EMAIL PROTECTED]>
> > >> To: <[EMAIL PROTECTED]>
> > >> Sent: Sunday, March 10, 2002 10:01 AM
> > >> Subject: Mysql installation. Help!
> > >>
> > >>
> > >>> Hi all,
> > >>> I got this error message when trying to connect to mysql at the shell
> > >>> command:
> > >>>
> > >>> Error 2002:Can't connect to local MySql server through socket
> > >>> '/var/lib/mysql/mysql.sock
> > >>>
> > >>>
> > >>> There is no mysql.sock in the /var/lib/mysql directory. Did I miss 
> >some
> > >>> thing in the mysql installation?  Where could I find the mysql.sock?  
> >I
> > >>> install mysql that came with redhat 7.2. Thank for the help.
> > >>>
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > -
> > > Before posting, please check:
> > >  http://www.mysql.com/manual.php   (the man

Re: How to sum only nest N values?

[Anzej Becan]

I think that answer is (because I group on user field):

create temporary table usertempcnt
 SELECT *,(@a:= IF(@b=user,@a+1,1)) as cnt , @b:=user from users order
by
user,points desc;

Thanks for advice on temporary table and great example!

Anzej

P.S. Sorry form misspelled subject: "nest" should be "best" :)

- Original Message -
From: "Richard Clarke" <[EMAIL PROTECTED]>
To: "Richard Clarke" <[EMAIL PROTECTED]>; "Anzej Becan"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, March 11, 2002 6:36 PM
Subject: Re: How to sum only nest N values?


> argh read your scheme wrong
> answer should be:
>
> create temporary table usertempcnt
>  SELECT *,(@a:= IF(@b=id,@a+1,1)) as cnt, @b:=id from user order by
> user,points desc;
>
>  select *,sum(points) from usertmpcnt where cnt<=2;
>
>  where 2 is your N
>
> Regards,
> Richard
>
> - Original Message -
> From: "Richard Clarke" <[EMAIL PROTECTED]>
> To: "Anzej Becan" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Monday, March 11, 2002 5:26 PM
> Subject: Re: How to sum only nest N values?
>
>
> > create temporary table usertempcnt
> > SELECT *,(@a:= IF(@b=id,@a+1,1)) as cnt, @b:=id from user order by
> > id,points desc;
> >
> > select *,sum(points) from usertmpcnt where cnt<=2;
> >
> > where 2 is your N
> >
> > Regards,
> > Richard
> >
> > - Original Message -
> > From: "Anzej Becan" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Monday, March 11, 2002 9:39 AM
> > Subject: Fw: How to sum only nest N values?
> >
> >
> > > I have table "users" with some results. Now I would like to sum up
> highest
> > > two points (not all!) for each user and sort by this sum.
> > > If I use this sql query...
> > >  SELECT user, SUM(points) total FROM users GROUP BY user ORDER BY
total
> > > desc;
> > > ... the result is sum of all points for each user.
> > > How to sum only highest two (or N) points?
> > >
> > > Thanks for any advice!
> > > Anzej
> > >
> > >
> > > Structure and data:
> > >
> > > CREATE TABLE users (
> > >   id tinyint(3) unsigned NOT NULL auto_increment,
> > >   user char(5) NOT NULL default '',
> > >   points tinyint(3) unsigned NOT NULL default '0',
> > >   PRIMARY KEY  (id),
> > >   UNIQUE KEY id (id)
> > > ) TYPE=MyISAM;
> > > INSERT INTO users VALUES (1, 'user1', 10);
> > > INSERT INTO users VALUES (2, 'user1', 20);
> > > INSERT INTO users VALUES (3, 'user1', 50);
> > > INSERT INTO users VALUES (4, 'user1', 40);
> > > INSERT INTO users VALUES (5, 'user2', 10);
> > > INSERT INTO users VALUES (6, 'user2', 20);
> > > INSERT INTO users VALUES (7, 'user2', 50);
> > >
> > >
> > >
> > >
> > > -
> > > Before posting, please check:
> > >http://www.mysql.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

On the logging of BLOBS

[Dan Patnaude]

Hi-
Is there SQL syntax to do selective logging. We have logging turned on, but 
queries involving BLOBS tend to screw with the logs. Any help would be useful

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

mysql@lists.mysql.com

[root]

>Description:

>How-To-Repeat:

>Fix:


>Submitter-Id:  
>Originator:root
>Organization:
 
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:  
>Severity:  
>Priority:  
>Category:  mysql
>Class: 
>Release:   mysql-3.23.41 (Source distribution)

>Environment:

System: Linux mweb.co.za 2.4.7-10enterprise #1 SMP Thu Sep 6 16:48:20 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-98)
Compilation info: CC='gcc'  CFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE 
-D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE'  CXX='c++'  CXXFLAGS='-O2 -march=i386 
-mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE'  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 Mar 10 03:28 /lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x1 root root  1282588 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
lrwxrwxrwx1 root root   10 Mar 10 04:06 /usr/lib/libc-client.a -> 
c-client.a
Configure command: ./configure  i386-redhat-linux --prefix=/usr --exec-prefix=/usr 
--bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share 
--includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec 
--localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man 
--infodir=/usr/share/info --without-debug --without-readline --enable-shared 
--with-extra-charsets=complex --with-bench --localstatedir=/var/lib/mysql 
--with-unix-socket-path=/var/lib/mysql/mysql.sock --with-mysqld-user=mysql 
--with-extra-charsets=all --disable-assember --with-berkeley-db 
--enable-large-files=yes --enable-largefile=yes --with-thread-safe-client 
--enable-assembler




















































-
Before posting, please check:
   http://www.mysql.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

Lost connection to MySQL server during query

[Mihail Manolov]

Greetings,

We use MySQL 3.23.47 running on 4 Pentium III processors machine with 16GB
of RAM.
The site is hosted on 6 web servers using Alteon for load balancing.


If someone had such problem and knows how to fix it, or any ideas are
welcome regarding the following...

Here's what we know about the two problems:

First Scenario: auction_list.pl
---

Problem can be duplicated with every run time

Approximate runtime is 20-40 minutes

Its a standard, non-mod_perl script that has no way of clobbering
a handle due to a memory leak, that can be experienced under
mod_perl.

Program is very database intensive with many multi-table joined
SELECT queries.

All SELECT/INSERT/UPDATE statements occur over one DB handle.

The two handles that fail are prepared at the beginning of
runtime:

my $sth_update = $LIQ::DB->prepare("

UPDATE auction_list SET
auction_count= ?,
auction_data = ?,
last_update_time = NOW()
WHERE
owner_id = ?
  AND language_code= ?
");

my $sth_insert = $LIQ::DB->prepare("

INSERT INTO auction_list (
auction_count,
auction_data,
owner_id,
language_code,
last_update_time
) VALUES (
?, ?, ?, ?, NOW()
)
");

mysql> desc auction_list;
+--+-+--+-+-+---
+

| Field| Type| Null | Key | Default | Extra
| |

+--+-+--+-+-+---
+

| owner_id | varchar(32) |  | PRI | |
| | language_code| char(2) |  | PRI | |
|  | auction_count| int(11) |  | | 0   |
|   | auction_data | mediumblob  |  | | |
|| last_update_time | datetime|  | | -00-00 00:00:00 |
| |

+--+-+--+-+-+---
+ 5 rows in set (0.00 sec)

Program runs for about 20 minutes, then breaks on both queries
sequentially (i.e., if an update fails, it performs an insert),
both fail.

Statement from handle is the following:

MySQL server has gone away

Loop continues and all other subsequent rows are written correctly.

This error occurs on one specific row update/insertion and then
continues. The row this breaks on _can_ change. I ran this script
again, commented out the lengthy part of the initial run time,
and half way through, it broke on a different row than usually
expected, and then merrily continued. However, during a run time,
usually the same row breaks from one run time to the next. I
managed to change the row it breaks on by cutting the amount of
SELECTS it initially does in half.

Neither database handle, nor prepared statement is clobbered,
because subsequent rows are written.

One of the datums inserted with each statement is always a blob.

I have included a Dumper of the bind variables passed to the
statement handles in error.txt.gz, please note it is rather large.

Second scenario: various CGIs, diff machines, same time
---

Run time breakage of following programs:

auction/bid
auction/list
auction/search

During normal execution. Software runs correctly for hours, then
the following message is seen in debug emails:

Lost connection to MySQL server during query

Usually this error is accompanied by multiple CGIs experiencing the
error at the same time (i.e., seconds, or concurrently between each
other). The error then simply goes away and processing returns to
normal.

This error can be seen with any type of query, UPDATE/INSERT/DELETE/
SELECT maybe once or twice a day, from various mod_perl CGIs, at the
same, or close time, for 2-5 separate requests, and goes away. I've
attached example debug output emails with this message.

This message can be encountered on any of our machines, and usually
occurs at the same time from various machines in the loop. It then
simply fixes itself.

My concern is that this behavior has occurring in our bid CGI. The
others are not as important. But I'm scared to see what kind of effect
this may be having on our data.

Thanks.



-
Before posting, please check:
   http://www.mysql.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

Foreign keys in mysqldump?

[Bob McLaughlin]

When I do a mysqldump and include table creation, it does not seem to
include the foreign key constraints in the create table statements of the
InnoDB tables.

Is there a command line switch or other way to make this happen?

Thanks,
-Bob


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

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

Problem entering data in Access, win2k default system locale differs from MySQL db locale

[Ness]

The problem is following:

MySQL 4.0.1 alfa on Win2k machine
MyODBC 3.51.01
Access XP

I need to migrate my clients database from Access to MySQL server and
use Access as a frontend to MySQL for adding data. BUT default system
locale is different from MySQL locale (cp1257). My database is in
latvian, but i use russian (cp1251) as a default system locale. If I set
latvian as default, everything works great. But not if I use russian. If
I try to enter latvian character (with dash over vowels) it shows
correctly in Access, but after reopening database (link using ODBC to
MySQL database) all latvian characters changed to english equivalents
(without dash over letters). Everything works if system locale is
latvian. But I need to use russian, because I use some speciffic
programs with russian interface.

Any help.

--
Ness


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

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

Problem entering data in Access, win2k default system locale differs from MySQL db locale

[Ness]

The problem is following:

MySQL 4.0.1 alfa on Win2k machine
MyODBC 3.51.01
Access XP

I need to migrate my clients database from Access to MySQL server and
use Access as a frontend to MySQL for adding data.
BUT default system locale is different from MySQL locale (cp1257). My
database is in latvian, but i use russian (cp1251) as a default system
locale.
If I set latvian as default, everything works great. But not if I use
russian. If I try to enter latvian character (with dash over vowels) it
shows correctly in Access, but after reopening database (link using ODBC
to MySQL database) all latvian characters changed to english equivalents
(without dash over letters). Everything works if system locale is
latvian. But I need to use russian, because I use some speciffic
programs with russian interface.

Any help.

--
Ness


-
Before posting, please check:
   http://www.mysql.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 sum only nest N values?

[Richard Clarke]

argh read your scheme wrong
answer should be:

create temporary table usertempcnt
 SELECT *,(@a:= IF(@b=id,@a+1,1)) as cnt, @b:=id from user order by
user,points desc;

 select *,sum(points) from usertmpcnt where cnt<=2;

 where 2 is your N

Regards,
Richard

- Original Message -
From: "Richard Clarke" <[EMAIL PROTECTED]>
To: "Anzej Becan" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, March 11, 2002 5:26 PM
Subject: Re: How to sum only nest N values?


> create temporary table usertempcnt
> SELECT *,(@a:= IF(@b=id,@a+1,1)) as cnt, @b:=id from user order by
> id,points desc;
>
> select *,sum(points) from usertmpcnt where cnt<=2;
>
> where 2 is your N
>
> Regards,
> Richard
>
> - Original Message -
> From: "Anzej Becan" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, March 11, 2002 9:39 AM
> Subject: Fw: How to sum only nest N values?
>
>
> > I have table "users" with some results. Now I would like to sum up
highest
> > two points (not all!) for each user and sort by this sum.
> > If I use this sql query...
> >  SELECT user, SUM(points) total FROM users GROUP BY user ORDER BY total
> > desc;
> > ... the result is sum of all points for each user.
> > How to sum only highest two (or N) points?
> >
> > Thanks for any advice!
> > Anzej
> >
> >
> > Structure and data:
> >
> > CREATE TABLE users (
> >   id tinyint(3) unsigned NOT NULL auto_increment,
> >   user char(5) NOT NULL default '',
> >   points tinyint(3) unsigned NOT NULL default '0',
> >   PRIMARY KEY  (id),
> >   UNIQUE KEY id (id)
> > ) TYPE=MyISAM;
> > INSERT INTO users VALUES (1, 'user1', 10);
> > INSERT INTO users VALUES (2, 'user1', 20);
> > INSERT INTO users VALUES (3, 'user1', 50);
> > INSERT INTO users VALUES (4, 'user1', 40);
> > INSERT INTO users VALUES (5, 'user2', 10);
> > INSERT INTO users VALUES (6, 'user2', 20);
> > INSERT INTO users VALUES (7, 'user2', 50);
> >
> >
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.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: How to timestamp records across time zones? ##

[DL Neil]

Brent,


> What's the best way to timestamp records if records are to be exported
and
> then re-imported to another web server in a different time zone? Data
will
> be exported as comma delimited data. All of the combined records
should
> reflect the same instant in time, and not have the web site in
California
> to be timestamping data 3 hours earlier than New York. If the data
were to
> be merged from both sites, then records added to CA and NY at the same
> instant should have the same time stamp.
>
> The data will originate from a PHP webpage form so I was thinking of
using
> PHP's gmdate function to get the GMT and store that in the table. So
all of
> the dates and times in the database are GMT. When the user displays
the
> data from the table I have to format the date to a single timezone
(like
> Eastern Time) when the user displays the data in the browser. I don't
> really care what timezone it gets displayed as, as long as sorting the
> records by date show NY and CA records together if they were inserted
at
> the same instant.
>
> I'd prefer to use a MySQL function to get the GMT because I don't want
to
> restrict data input to using just PHP. Does MySQL have a Now("GMT")
option?
> Or is there a better way to handle this?


AFAIK all datetime data stored in MySQL is inherently timezone agnostic.
However if the time is taken from the server running MySQL, eg
auto-UPDATE/INSERT into a timestamp field, then the time recorded will
be localised BUT will not be labeled as such!

To answer your last question first: there are no GMT options/time
functions (again AFAIK) in MySQL.

To solve exactly this problem, I do what you have outlined in paragraph
two - use PHP to pre-process all times, convert them to UTC, and
explicitly store those values into MySQL.

When it comes time to retrieve the data then you have a problem!
Obviously you can train your people to think in UTC - just as long as
they don't keep comparing that against their wrist-watches. You could
also keep one time in the db and yet endeavor to display two or even
three where appropriate (UTC, time at display location, and time at
location that stored data) If you interrogate the retrieving server it
will advise PHP in which timezone it has been located, and thus a simple
addition/subtraction will allow UTC datetimes to be 'adjusted' to the
local time (this breaks down big-time if the people in Denver are
accessing a server in California!*** Because all datetimes in the db are
UTC, there is no problem about maintaining comparative chronology around
the world!

Your other choice, of course, is to run everything as local time, and
then to post-process the transported .CSV files. I suspect that this
will involve more manual effort on an operational basis (in which case,
Murphy rules!), whereas the above can put all the thought/confusing
calculations (including Summer time issues) onto the computer's
shoulders!

*** for the benefit of enquiring minds: the two places are in separate
time zones!

Please call back if I haven't addressed/anticipated all of your issues,
=dn


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

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

Re: How to sum only nest N values?

[Richard Clarke]

create temporary table usertempcnt
SELECT *,(@a:= IF(@b=id,@a+1,1)) as cnt, @b:=id from user order by
id,points desc;

select *,sum(points) from usertmpcnt where cnt<=2;

where 2 is your N

Regards,
Richard

- Original Message -
From: "Anzej Becan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 11, 2002 9:39 AM
Subject: Fw: How to sum only nest N values?


> I have table "users" with some results. Now I would like to sum up highest
> two points (not all!) for each user and sort by this sum.
> If I use this sql query...
>  SELECT user, SUM(points) total FROM users GROUP BY user ORDER BY total
> desc;
> ... the result is sum of all points for each user.
> How to sum only highest two (or N) points?
>
> Thanks for any advice!
> Anzej
>
>
> Structure and data:
>
> CREATE TABLE users (
>   id tinyint(3) unsigned NOT NULL auto_increment,
>   user char(5) NOT NULL default '',
>   points tinyint(3) unsigned NOT NULL default '0',
>   PRIMARY KEY  (id),
>   UNIQUE KEY id (id)
> ) TYPE=MyISAM;
> INSERT INTO users VALUES (1, 'user1', 10);
> INSERT INTO users VALUES (2, 'user1', 20);
> INSERT INTO users VALUES (3, 'user1', 50);
> INSERT INTO users VALUES (4, 'user1', 40);
> INSERT INTO users VALUES (5, 'user2', 10);
> INSERT INTO users VALUES (6, 'user2', 20);
> INSERT INTO users VALUES (7, 'user2', 50);
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.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 under FreeBSD 4.5

[Ken Menzel]

I am now seeing this behavior as well.  I will work with the
developement group to help resolve this.
Ken
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 22, 2002 2:10 AM
Subject: mysql under FreeBSD 4.5


> Just recently installed FreeBSD 4.5-RELEASE and cvsup'd to latest
> 4-STABLE. Updated ports tree and did a make install in
> /usr/ports/databases/mysql323-server and received the following on
the
> mysql_install_db part:
>
> /usr/local/bin/mysql_install_db
> Preparing db table
> Preparing host table
> Preparing user table
> Preparing func table
> Preparing tables_priv table
> Preparing columns_priv table
> Installing all prepared tables
> Fatal error 'Can't create gc thread' at line ? in file
> /usr/src/lib/libc_r/uthread/uthread
> _create.c (errno = ?)
> Abort trap - core dumped
> Installation of grant tables failed!
>
> Examine the logs in /var/db/mysql for more information.
> You can also try to start the mysqld daemon with:
> /usr/local/libexec/mysqld --skip-grant &
> You can use the command line tool
> /usr/local/bin/mysql to connect to the mysql
> database and look at the grant tables:
>
> shell> /usr/local/bin/mysql -u root mysql
> mysql> show tables
>
> Try 'mysqld --help' if you have problems with paths. Using --log
> gives you a log in /var/db/mysql that may be helpful.
>
>
>
> I saw that one other person had ran into the same thing, but the
trail
> ends there as I can't find if she/he ever resolved it. The version
in the
> ports of FreeBSD is 3.23.49, btw. Please help? This is and will be
our
> future ACM local chapter website, hopefully running MySQL. If we can
ever
> get it to install properly.
>
> Thanks in advance.
>
>
> 
-
> Before posting, please check:
>http://www.mysql.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

Non odbc/jdbc connection

[Walker, Roy]

I am looking for different alternatives to getting data into a MySQL
database from an unattended command line output (a script) from a remote
machine. This is what I have so far: 

email: Parse the output from the command line and simply email it to the
MySQL database server, where a sendmail script can add it to the database

ftp: Parse the output into a csv text file and ftp it to the MySQL server
and then let a cron job pick it up and import the data into the database

htttp: (This is a little more difficult since I am trying to do everything
through a command line) I could use a custom php command script to do an
http insert into the database (the security on this method could be of
concern).

Any feedback would be GREATLY appreciated. If anyone has any experience
importing command-line output into a remote MySQL database please elaborate.


Thanx 
Roy

-
Before posting, please check:
   http://www.mysql.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: Unicode support for MySQL

[David Ayliffe]

When you say:

"Unicode will be supported in 4.0.3 version of MySQL." 

What do you mean - UTF-8 encoding or UTF-16 or what?

Can you clarify

-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] 
Sent: 11 March 2002 09:24
To: [EMAIL PROTECTED]
Subject: Unicode support for MySQL


Robin,
Monday, March 11, 2002, 6:55:51 AM, you wrote:

RT> I am just wondering if the latest stable build of MySQL has 
RT> support for Unicode character set so I can use it to store english, 
RT> chinese and korean characters. If so please let me know. And also if

RT> there is going to be any problems to perform SELECT statements to 
RT> search for a particular pattern. Much appreciated.

Unicode will be supported in 4.0.3 version of MySQL.

RT> Robin Tay




-- 
For technical support contracts, goto https://order.mysql.com/ 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 stops when it shouldn't

[Mike Wexler]

>Description:
Replication halts on drop of ignored, temporary table
>How-To-Repeat:
[mysqld]
replicate-ignore-table=curioscape.avstemp
replicate-ignore-table=tias.avtemp
replicate-ignore-table=inventory.availableQuantity
replicate-ignore-table=inventory.thisItem
replicate-ignore-table=inventory.auctionStatus
replicate-ignore-table=inventory.itemTable
replicate-ignore-table=orders.grossDemand
replicate-ignore-table=orders.netDemand
replicate-ignore-table=lionbrand.shippableOrders
replicate-ignore-table=orders.shippedItems
replicate-ignore-table=inventory.top_levels
replicate-ignore-table=inventory.systemCatList
replicate-ignore-table=inventory.itemTotals
replicate-wild-ignore-table=tums.%
replicate-wild-ignore-table=stats.%
master-host=db1.tias.com
master-user=slave
master-password=[removed]
log=db.log
# master-port=
server-id=2

mysql> show slave status;
+--+-+-+---+---+--+---+-+-++--+--+
| Master_Host  | Master_User | Master_Port | Connect_retry | Log_File
| Pos  | Slave_Running | Replicate_do_db | Replicate_ignore_db |
Last_errno | Last_error
| Skip_counter |
+--+-+-+---+---+--+---+-+-++--+--+
| db1.tias.com | slave   | 3306| 60|
spode-bin.259 | 53260121 | No| |
| 1158   | Slave: query 'drop table
lionbrand.shippableOrders,orders.netDemand,orders.grossDemand' partially
completed on the master and was aborted. There is a chance that your
master is inconsistent at this point. If you are sure that your master
is ok, run this query manually on the slave and then restart the slave
with SET SQL_SLAVE_SKIP_COUNTER=1; SLAVE START; | 0

I looked up error 1158 in docs/mysqld_error.txt and its: 

#define ER_NET_READ_ERROR 1158
"Got an error reading communication packets",

which doesn't look like an appropriateerror to ignore. But why is it
even worrying about this when the request is to drop 3 temporary tables
that are being ignored anyway?

>Fix:

>Submitter-Id:  
>Originator:Mike Wexler
>Organization:  TIAS.COM
 
>MySQL support: extended login support
>Synopsis:  replication stops when it shouldn't
>Severity:  serious
>Priority:  medium
>Category:  mysql
>Class: sw-bug | support
>Release:   mysql-3.23.49a (Official MySQL RPM)

>Environment:

System: Linux walker.tias.com 2.2.19-7.0.8enterprise #1 SMP Thu Jun 21 06:00:20 EDT 
2001 i686 unknown
Architecture: i686

Some paths:  /usr/bin/mh/perl /usr/bin/mh/make /usr/bin/mh/gmake /usr/bin/mh/gcc 
/usr/bin/mh/cc
GCC: Reading specs from /usr/bin/mh/../lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-85)
Compilation info: CC='gcc'  CFLAGS='-O6 -fno-omit-frame-pointer -mpentium'  CXX='gcc'  
CXXFLAGS='-O6 -fno-omit-frame-pointer  -felide-constructors 
-fno-exceptions -fno-rtti -mpentium'  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 Feb  8 21:18 /lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x1 root root  5808375 Dec  8 07:04 /lib/libc-2.2.4.so
-rw-r--r--1 root root 27315960 Dec  8 07:02 /usr/lib/libc.a
-rw-r--r--1 root root  178 Dec  8 07:02 /usr/lib/libc.so
lrwxrwxrwx1 root root   10 Sep 18 01:58 /usr/lib/libc-client.a -> 
c-client.a
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 My

Re: MYSQLGUI 1.7.5

[Sinisa Milivojevic]

Martin van Dijken writes:
> Dear MySQL,
> 
> I had quite a bit of contact with Sinisa a few months ago and suggested some 
>improvements and several bugs he might fix. A lot of time has passed, but no new 
>version of the program has been released. Can you give me a status-update?
> 
> grtz
> 
> Martin van Dijken
> 
> 

hi!

We have a new client, MyCC, please check it out ...

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


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

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

MYSQLGUI 1.7.5

[Martin van Dijken]

Dear MySQL,

I had quite a bit of contact with Sinisa a few months ago and suggested some 
improvements and several bugs he might fix. A lot of time has passed, but no new 
version of the program has been released. Can you give me a status-update?

grtz

Martin van Dijken

-
Before posting, please check:
   http://www.mysql.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/Solaris: can't run configure or mysql_install_db

[Kannan_R]

Hi..

I had faced a similar problem with mysql_install_db..but i had downloaded the
source and done a make ..

I had to change the path of sh in the first line of the script
mysql_install_db..the default path of sh is /bin/sh. I had to change it to
/usr/bin/sh and did a make intall again and lo behold it worked..

regards
kannan







"Ahmed S K Anis" <[EMAIL PROTECTED]> on 03/11/2002 08:28:31 PM
  
  
  
  To:  [EMAIL PROTECTED],
   [EMAIL PROTECTED], [EMAIL PROTECTED]  
  
  cc:  (bcc: Kannan R/Satyam) 
  
  
  
  Subject  RE: Mysql/Solaris: can't run configure or  
  :mysql_install_db   
  







Hi,
I too am stuck with mysql installaiton on solaris.
Please let me know if you can help me out.
I prefer downlaoding the binary and installing ot..rather then getting
the src and building.

thanks
Anis


>>> "Chuck Roberts" <[EMAIL PROTECTED]> 03/11/02 07:47PM >>>


> -Original Message-
> From: Egor Egorov [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, March 09, 2002 6:08 AM
> To: [EMAIL PROTECTED]
> Subject: Mysql/Solaris: can't run configure or mysql_install_db
>
>
> Chuck,
> Friday, March 08, 2002, 5:56:59 PM, you wrote:
>
> CR> Hi. We have Solaris 2.8 and just got Mysql 3.23.
> We installed the
> CR> files and are now trying to run the mysql/configure or
> CR> mysql/scripts/mysql_install_db scripts but I get an error
> CR> "Command not found." I logged in as "chuck", then
> did "su" and
> CR> logged in as superuser before running this
> command. I also logged
> CR> in as root and used this command. All the files in
> mysql/ are
> CR> owned by root and have a group of 'mysql'.
>
> CR> Anyone know what I can try to run the install script?
>
> Try to install script in the following way:
> 1. cd to where you have unzipped the binary ditribution.
> 2. Then cd to scripts
> 3. Then run ./mysql_install_db

I tried that. It did not work.



-
Before posting, please check:
   http://www.mysql.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

How to timestamp records across time zones? ##

[BD]

What's the best way to timestamp records if records are to be exported and 
then re-imported to another web server in a different time zone? Data will 
be exported as comma delimited data. All of the combined records should 
reflect the same instant in time, and not have the web site in California 
to be timestamping data 3 hours earlier than New York. If the data were to 
be merged from both sites, then records added to CA and NY at the same 
instant should have the same time stamp.

The data will originate from a PHP webpage form so I was thinking of using 
PHP's gmdate function to get the GMT and store that in the table. So all of 
the dates and times in the database are GMT. When the user displays the 
data from the table I have to format the date to a single timezone (like 
Eastern Time) when the user displays the data in the browser. I don't 
really care what timezone it gets displayed as, as long as sorting the 
records by date show NY and CA records together if they were inserted at 
the same instant.

I'd prefer to use a MySQL function to get the GMT because I don't want to 
restrict data input to using just PHP. Does MySQL have a Now("GMT") option? 
Or is there a better way to handle this?

TIA

Brent


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


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

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

Re: Changing datatypes "on the fly"?

[BD]

At 02:59 PM 3/9/2002, you wrote:
>I have a column defined as varchar(255) in my MySql-database. Now I 
>realized that there's not enough room for my inserts. Is there any chance 
>to change it's datatype to tinytext without making an entirely new 
>database and inserting data from the old one to it?
>
>-Jarkko
Jarkko,
 If you want something easier than ALTER TABLE, try MySQL Front, a 
MySQL GUI from http://www.anse.de/mysqlfront/. It's free and you're less 
likely to shoot yourself in the foot with it.

Brent


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


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

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

mysql + ext3 + data=journal ?

[Matthias Jaekle]

Hello,

I am running mysql with datafiles on a ext3 file system.
Is there an security advantage for mysql, if I mount the ext3 file 
system with the option data=journal ?

Many thanks

Matthias Jaekle



-
Before posting, please check:
   http://www.mysql.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: bug: segfaults with mysql_read_default_group!

[Sinisa Milivojevic]

Christian Hammers writes:
> On Mon, Mar 11, 2002 at 04:11:08PM +0200, Sinisa Milivojevic wrote:
> > > There is a problem with the myslq_read_default_group function!
> > > It's DBI 1.21, DBD::MySQL 1.2216 and mysql-3.23.49, compiled on the very
> > > latest Debian unstable (I'm the mysql maintainer of Debian).
> 
> > This is the only code that I found in latest version of this program
> > that has anything to do with options :
> > 
> > my $dbh = DBI->connect("dbi:mysql:$dsn;mysql_read_default_group=mysqlhotcopy",
> > $opt{user}, $opt{password},
> Yes, this line and every other perl script that uses the
> mysql_read_default_group option segfaults on its invocation. Maybe it's a 
> problem specific to our Debian library version but we should try to track
> it down nevertheless.
> 
> Can you tell me how to make a little C programm with this option then 
> we have a change to use gdb to track down the crashing function.
> 
> bye,
> 
> -christian-
> 
> 

Sure. 

You only need to have a program with following functions :

  MYSQL mysql,*sock;
  mysql_init(&mysql);
  load_defaults(...);   // set groups to "client" and "mysqlhotcopy"...
// take a look at mysql.cc on how to do that.
  if (!(sock = mysql_real_connect(&mysql,NULL,0,0,argv[1],0,NULL,0)))
exit(1);

Of course, you should set parameters correctly, but that is not
difficult, I hope.

Judging by the trace output, it looks like an error in your
libmysqlclient library.

Let us know, please how we can help you further, as we would also like
that Debian builds our binary properly.

Also, regarding other MySQL binaries, please follow instructions from
our manual. Also, please change glibc to contain our modifications, or
similar ones.

This is very important for installations under heavy load.

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


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

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

Re: Help w/ "join" syntax

[Benjamin Pflugmann]

Hi.

On Mon, Mar 11, 2002 at 09:42:01AM -0500, [EMAIL PROTECTED] wrote:
> 
> When I call the following PHP script, $qry_1 doesn't work (No query # 1!).
> 
>  $result_1=mysql_query($qry_1,$connection) or die ("No query # 1!");

At first glance, I don't see any error. But change the previous line
to something like

$result_1=mysql_query($qry_1,$connection)
or die("query #1: " . mysql_errno() . ": " . mysql_error() . "");

And you will get a more reasonable error message.

Bye,

Benjamin.

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

xBase (foxpro) conversion

[Neil Davies]

I tried sending this earlier and it seemed to get sent but an error came
back not long afterwards so I'm not sure it did. So, I'm sending it again to
ensure it is sent, if this was sent before successfully I apologise for
sending this twice:


Needing to convert some old foxpro tables into mysql. Have done this before
using a long winded xbase-text-mysql through access97, but it through out Dr
Watson errors with a couple of the tables, oddly enough a couple of
important ones that I need. I was wondering if anyone knew of any apps/perl
modules that would perform this for me? Btw. I use WindowsNT4 and don't have
easy access to a linux machine.

Thanks in advance,
Neil



-
Before posting, please check:
   http://www.mysql.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

Memory problem

[DPicek]

Hello,

we use mysql 3.23 on a redhat 7.0 system and myodbc 2.50 on a windows 2000
system. If we make
a insert, update or delete record from the windows system we have the
problem that the mysql
server on the redhat system takes memory. On each action the mysql server
takes memory until
the system memory is used and then the system crashes. Is it a bug?

Thank you!

Mit freundlichen Grüssen / with kind regards
Dominik Picek
--
ASAP (Schweiz) GmbH, Aescherstrasse 20, 5615 Fahrwangen, Switzerland
Phone +41 56 676 62 62, Fax +41 56 676 62 65


-
Before posting, please check:
   http://www.mysql.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 Windows accessed client on Solaris--gives problem

[Ahmed S K Anis]

hi,
Mysql is installed on Windows 95.
Client program runs on solarisConnection to DB fails
I used the mm driver for mysql.

see stack trace. please  help!!

*** panic: symbol "ioctl" undefinedSIGABRT   6*   abort (generated by
abort(3) routine)si_signo [6]: SIGABRT   6*   abort (generated by
abort(3) routine)si_errno [0]: Error 0si_code [-1]: SI_LWP [pid:
5778, uid: 0]stackpointer=FC03EFC8"Thread-1" (TID:0x8f53e4,
sys_thread_t:0x8f5328, state:R, thread_t: t@28, threadID:0xfc04,
stack_bottom:0xfc04, stack_size:0x2) prio=5 *current thread*[1]
java.net.PlainSocketImpl.socketAvailable(Native Method)[2]
java.net.PlainSocketImpl.available(PlainSocketImpl.java:429)[3]
java.net.SocketInputStream.available(SocketInputStream.java:141)[4]
org.gjt.mm.mysql.MysqlIO.clearAllReceive(MysqlIO.java:987)[5]
org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:548)[6]
org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635)[7]
org.gjt.mm.mysql.Connection.execSQL(Connection.java:882)[8]
org.gjt.mm.mysql.Connection.execSQL(Connection.java:815)[9]
org.gjt.mm.mysql.Statement.executeQuery(Statement.java:169)[10]
org.gjt.mm.mysql.jdbc2.Statement.executeQuery(Statement.java:78)[11]
org.gjt.mm.mysql.Connection.connectionInit(Connection.java:285)[12]
org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Connection.java:89)[13]
org.gjt.mm.mysql.Driver.connect(Driver.java:167)[14]
java.sql.DriverManager.getConnection(DriverManager.java:457)[15]
java.sql.DriverManager.getConnection(DriverManager.java:137)[16]
audit.server.SQLExecutor.connect(SQLExecutor.java:204)[17]
audit.server.SQLExecutor.(SQLExecutor.java:177)[18]
audit.server.DatabaseManager.(DatabaseManager.java:153)[19]
audit.server.DatabaseManager.getInstance(DatabaseManager.java:212)[20]
audit.server.ServerImplementation.(ServerImplementation.java:80)[21]
audit.server.EventHandler.run(SocketServer.java:831)

-
Before posting, please check:
   http://www.mysql.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 w/ "join" syntax

[Anthony Rodriguez]

When I call the following PHP script, $qry_1 doesn't work (No query # 1!).

DONE";
flush();
exit;
?>

Thank you!

Anthony F. Rodriguez
([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

Slow CONCAT on BLOBs

[Bill Clery]

I am appending blocks of binary data to an existing BLOB in a database.  The
blocks are coming at me in 1000 to 3000 bytes chunks and the BLOB can grow to
a few meg easily.  I am using the sql command (from PHP):

UPDATE MyTable SET MyBlobField=CONCAT(MyBlobField,"--escaped binary data
here--")

This update gets significantly slower as the BLOB grows in size.  I believe
the server may actually be reading the entire BLOB out of the database and
writing it back in.  Is there a smarted way to APPEND in instead of CONCAT?
I can't find it.

Thank You,
Bill Clery


-
Before posting, please check:
   http://www.mysql.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/Solaris: can't run configure or mysql_install_db

[Ahmed S K Anis]

Hi, 
I too am stuck with mysql installaiton on solaris.
Please let me know if you can help me out.
I prefer downlaoding the binary and installing ot..rather then getting
the src and building.

thanks
Anis


>>> "Chuck Roberts" <[EMAIL PROTECTED]> 03/11/02 07:47PM >>>


> -Original Message-
> From: Egor Egorov [mailto:[EMAIL PROTECTED]] 
> Sent: Saturday, March 09, 2002 6:08 AM
> To: [EMAIL PROTECTED] 
> Subject: Mysql/Solaris: can't run configure or mysql_install_db
>
>
> Chuck,
> Friday, March 08, 2002, 5:56:59 PM, you wrote:
>
> CR> Hi. We have Solaris 2.8 and just got Mysql 3.23.
> We installed the
> CR> files and are now trying to run the mysql/configure or
> CR> mysql/scripts/mysql_install_db scripts but I get an error
> CR> "Command not found." I logged in as "chuck", then
> did "su" and
> CR> logged in as superuser before running this
> command. I also logged
> CR> in as root and used this command. All the files in
> mysql/ are
> CR> owned by root and have a group of 'mysql'.
>
> CR> Anyone know what I can try to run the install script?
>
> Try to install script in the following way:
> 1. cd to where you have unzipped the binary ditribution.
> 2. Then cd to scripts
> 3. Then run ./mysql_install_db

I tried that. It did not work.



-
Before posting, please check:
   http://www.mysql.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

install on Red Hat Linux 7.2 with rpm

[Victoria Reznichenko]

Loftus,
Monday, March 11, 2002, 2:31:06 PM, you wrote:

Leoen> installing MySQL-Max-3.23.49-1.i386.rpm on Linux Red Hat 7.2 (server install
Leoen> option) kernel 2.4
Leoen> while logged in as root, from /usr/local/mysql on an old PC

Leoen> Hi. I am brand new to Linux, and I can't get MySQL installed. The client
Leoen> part goes fine, but when I do 
Leoen> rpm -ivh MySQL-Max-3.23.49-1.i386.rpm

Leoen> I get this

Leoen> Preparing...# [100%]
Leoen> 1:MySQL-Max # [100%]
Leoen> Giving mysqld a couple of seconds to restart
Leoen> /var/tmp/rpm-tmp.18185: /etc/rc.d/init.d/mysql: No such file or directory

Leoen> then if I do an rpm -qs on the same file, I get a message saying that
Leoen> package is not installed. 
Leoen> Yet Gnome rpm gives me an option to uninstall it. 
Leoen> And if I try to install it again, (rpm -ivh again) I get a message that it
Leoen> is already installed. 

Leoen> and neither I nor my machine can find scripts/mysql_install_db. So I guess
Leoen> the install didn't get that far.

Leoen> I keep wondering if I am missing some common utility because this is a fresh
Leoen> Linux install, and I haven't added much. But how would that result in a
Leoen> missing file? 

You should install standard MySQL RPM before installing MySQL-max RPM.

Leoen> Thanks in advance for your help,
Leoen> Annie




-- 
For technical support contracts, goto https://order.mysql.com/
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 
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: 4.0.2 Replication Bug...

[Michael Widenius]

Hi!

> "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes:

Sasha> On Thursday 07 March 2002 12:42 am, Jeremy Zawodny wrote:
>> My 4.0.2 slave has run through about 14 million queries and it's going
>> well.

Sasha> Good news

>> 
>> Do you have any feel for how much slower a debugging version of MySQL
>> is compared to a normal version? ?I ask because my replication
>> heartbeat monitor has noticed this particular slave falling behind on
>> replication a fair amount. ?It usually doesn't get too far behind, but
>> it's certainly farther behind that it's neighbor--which has a slower
>> CPU.

Sasha> Depends on the queries. I would say it could be from 3 to 10 times slower. To 
Sasha> know for sure, use BUILD/compile-pentium instead of 
Sasha> BUILD/compile-pentium-debug. This will compile a perfectly optimal binary.

If you are using --skip-safemalloc or just configure with --with-debug
instead of --with-debug=full, the speed difference should not be
larger than 15-35 % (This is from our manual).

If you start mysqld with the --debug option, then things will be 3-10
times slower.



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

Large table problems

[Dan Patnaude]

Hi-

We are running mysql version 3.23.33, along with resin. The tables we are 
using are large, but not overly so. We also, for reasons I cannot comprehend, 
but for which my manager thinks is a good idea, have index files that are as 
big as the data files themselves. So, here is the problem:

Every now and then (say once every two weeks), our table crashes, saying that 
there is an invalid key file. I can repair the table, but it is troubling 
that it happens so frequently. So, is the problem with the size of the table 
(900,000 records =~ 220 MB), or is it the overly large indexes my boss has 
set up. Also, could it be resin not closing its sessions nicely? I know that 
this is vague, but any help would be useful. Again the problem is: what 
causes a table to lose its keyfile.

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

Large table problems

[Dan Patnaude]

Hi-

We are running mysql version 3.23.33, along with resin. The tables we are 
using are large, but not overly so. We also, for reasons I cannot comprehend, 
but for which my manager thinks is a good idea, have index files that are as 
big as the data files themselves. So, here is the problem:

Every now and then (say once every two weeks), our table crashes, saying that 
there is an invalid key file. I can repair the table, but it is troubling 
that it happens so frequently. So, is the problem with the size of the table 
(900,000 records =~ 220 MB), or is it the overly large indexes my boss has 
set up. Also, could it be resin not closing its sessions nicely? I know that 
this is vague, but any help would be useful. Again the problem is: what 
causes a table to lose its keyfile.

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: bug: segfaults with mysql_read_default_group!

[Christian Hammers]

On Mon, Mar 11, 2002 at 04:11:08PM +0200, Sinisa Milivojevic wrote:
> > There is a problem with the myslq_read_default_group function!
> > It's DBI 1.21, DBD::MySQL 1.2216 and mysql-3.23.49, compiled on the very
> > latest Debian unstable (I'm the mysql maintainer of Debian).

> This is the only code that I found in latest version of this program
> that has anything to do with options :
> 
> my $dbh = DBI->connect("dbi:mysql:$dsn;mysql_read_default_group=mysqlhotcopy",
> $opt{user}, $opt{password},
Yes, this line and every other perl script that uses the
mysql_read_default_group option segfaults on its invocation. Maybe it's a 
problem specific to our Debian library version but we should try to track
it down nevertheless.

Can you tell me how to make a little C programm with this option then 
we have a change to use gdb to track down the crashing function.

bye,

-christian-


-
Before posting, please check:
   http://www.mysql.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/Solaris: can't run configure or mysql_install_db

[Chuck Roberts]

> -Original Message-
> From: Egor Egorov [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, March 09, 2002 6:08 AM
> To: [EMAIL PROTECTED]
> Subject: Mysql/Solaris: can't run configure or mysql_install_db
>
>
> Chuck,
> Friday, March 08, 2002, 5:56:59 PM, you wrote:
>
> CR> Hi. We have Solaris 2.8 and just got Mysql 3.23.
> We installed the
> CR> files and are now trying to run the mysql/configure or
> CR> mysql/scripts/mysql_install_db scripts but I get an error
> CR> "Command not found." I logged in as "chuck", then
> did "su" and
> CR> logged in as superuser before running this
> command. I also logged
> CR> in as root and used this command. All the files in
> mysql/ are
> CR> owned by root and have a group of 'mysql'.
>
> CR> Anyone know what I can try to run the install script?
>
> Try to install script in the following way:
> 1. cd to where you have unzipped the binary ditribution.
> 2. Then cd to scripts
> 3. Then run ./mysql_install_db

I tried that. It did not work.



-
Before posting, please check:
   http://www.mysql.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: bug: segfaults with mysql_read_default_group!

[Sinisa Milivojevic]

Christian Hammers writes:
> Hello 
> 
> There is a problem with the myslq_read_default_group function!
> It's DBI 1.21, DBD::MySQL 1.2216 and mysql-3.23.49, compiled on the very
> latest Debian unstable (I'm the mysql maintainer of Debian).
> 
> bye,
> 
> -christian-
> 
> There is no section "ch" in /etc/mysql/my.cnf and no ~ch/.my.cnf. The same
> problem also occurs in mysqlhotcopy which looks for a section of this name.
> 
> $ cat t.pl
> #!/usr/bin/perl
> use DBI;
> $dbh = DBI->connect("dbi:mysql:test:mysql_read_default_group=ch","ch","");
> 
> $ ./t.pl
> ...
> open("/etc/mysql/my.cnf", O_RDONLY|O_LARGEFILE) = 3
> fstat64(3, {st_mode=S_IFREG|0644, st_size=1892, ...}) = 0
> old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1,
> 0) = 0x40026000
> read(3, "# You can copy this to one of:\n#"..., 4096) = 1892
> read(3, "", 4096)   = 0
> close(3)= 0
> munmap(0x40026000, 4096)= 0
> open("/var/lib/mysql/my.cnf", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such
> file or directory)
> open("/home/ch/.my.cnf", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or
> directory)
> --- SIGSEGV (Segmentation fault) ---
> +++ killed by SIGSEGV +++
> 

Sorry, but, I could not trace the above code in mysqlhotcopy 

This is the only code that I found in latest version of this program
that has anything to do with options :

my $dbh = DBI->connect("dbi:mysql:$dsn;mysql_read_default_group=mysqlhotcopy",
$opt{user}, $opt{password},


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


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

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

Languages

[Dave]

Does MySQL support the below languages?  I can find info about character
sets but I can't find info to tell me what languages map to those character
sets.

> Korean
> Chinese ( Simplified and Traditional )
> Japanese
> Canadian French
> Latin Spanish
> Portuguese



Regards
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[2]: RH 7.2 connections problems w 16 web servers to 2 MySQL servers

[Peter Zaitsev]

Hello Michael,

Monday, March 11, 2002, 3:38:28 PM, you wrote:


I had a close problem once -  then having many active connections (and
so threads) mysql speed may degrade a lot because of scheduling and
convergency problem. This does not explain the mysql lock itself, but
may be the reason (i.e too many threads may make mysql to lock or
crush because of GLIBC limits)
  The good solution for this would be to put OOPS behind of apache.
This gives two positive issues:
  - your apache server will have much less children and so will require
  much less memory and will basically work faster. In my case the
  number of children have dropped from 150 to 16 and required memory
  from about 1G to 200M (I'm running very complicated PHP scripts)
  - you will need much less number of connections for mysql.  In my
  case the number have dropped from about 500 connections from web
  server to 50, and load average on mysql server fell from 3.0-4.0 to
  0.5-1.0.


P.S Are you using mysql binary or version compiled with patched GLIBC
if not the threads limit should be the cause.


MW> Hi!

Sam>> We have a very high volume site (3 million page views a day) that's run 
Sam>> on 16 Apache / PHP web servers & 2 MySQL servers. We are using PHP with 
Sam>> persistent connections. Each MySQL serves 8 web servers & is supposed to 
Sam>> act as a failover machine for the other group of 8 web servers.
Sam>> 
Sam>> The failover won't work now as if one MySQL goes down the cost of the 8 
Sam>> web servers switching over is so high the other MySQL locks up.
Sam>> 
Sam>> Each Apache / PHP server takes up hundreds of connections even when 
Sam>> they're idle so we ran into the Linux connection limit of 1000 & had to 
Sam>> recompile to get past that.
Sam>> 
Sam>> Our actual MySQL CPU useage is low but the goes when with the connection 
Sam>> overhead when starting up or failing over a bank of machines.
Sam>> 
Sam>> We get a mysterious MySQL lockup once a week at the same day & time.

MW> Could you please describe the lookup, exactly what happens ?

MW> What does 'mysqladmin var ext' show when this happens?
MW> What do you have in your log files ?

Sam>> Questions :
Sam>> 
Sam>> - Is our configuration of 2 sets of 8 Apache/PHP web servers & 1 MySQL 
Sam>> servers just not a good idea ?

MW> This should not be a problem.

Sam>> - Would we better off with FreeBSD ?

MW> If you are running a CMP machine, then Linux preforms normally better
MW> than FreeBSD.

MW> To be able to give some recommendations we need to know more about
MW> this setup.

Sam>> - Is there anyone doing any similar setups with lots of web servers & a 
Sam>> few MySQLs ?

MW> We have several hundred of paying support customers with this setup.

Sam>> - Is there any way to get Apache / PHP to use fewer connections ?

MW> Stevens Rousseys exellent answer should help you with this

Sam>> We pay for MySQL support but haven't had much help from them.

MW> I checked our support email archive, but couldn't find anything from
MW> you or your company in it.

MW> Could you please use our supportwizard interface to make a ticket of
MW> this problem so that we can help you with it?
MW> If you have already a ticket, please email me the ticket number so
MW> that we can check this up.

MW> Regards,
MW> Monty




-- 
Best regards,
 Petermailto:[EMAIL PROTECTED]


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

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

Re: MySQL GUI

[Sinisa Milivojevic]

Luque writes:
> Hello all,
> 
> After install XDarwin in Mac OSX and experimenting installing the GIMP 
> and some other xapps I have tried to compile MySQL GUI unsuccesfully. 
> Would somebody show me a link with some advice?
> 
> TIA,
> 
> Luque
> 


It should be possible to build MySQLGUI on OSX.

Download latest faltk 1.1 and build that one first. Then download
other necessary FLTK widgets (see our mysqlgui page) and proceed. 

After you finish that, building mysqlgui should be rather easy. 

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


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

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

MySql in Linux, Unable to connect from windows

[Ahmed S K Anis]

Hi,
i am using the standard Mysql  installation on  Redhat Linux.
I am trying to run a simple JDBC test pgm from windows machine and
connect to DB on linux.
I am not getting any error , but its hanging at this statment .

statement is
Connection connection  =
DriverManager.getConnection("jdbc:mysql://111.111.111.111./", "user",
"paas"); 


Please suggest

Thanks,
Anis
 

-
Before posting, please check:
   http://www.mysql.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: install on Red Hat Linux 7.2 with rpm

[Aleksandar Bradaric]

Hi,

> installing MySQL-Max-3.23.49-1.i386.rpm on Linux Red Hat 7.2 (server install
> option) kernel 2.4
> while logged in as root, from /usr/local/mysql on an old PC

> Hi. I am brand new to Linux, and I can't get MySQL installed. The client
> part goes fine, but when I do 
> rpm -ivh MySQL-Max-3.23.49-1.i386.rpm

> I get this

> Preparing...# [100%]
> 1:MySQL-Max # [100%]
> Giving mysqld a couple of seconds to restart
> /var/tmp/rpm-tmp.18185: /etc/rc.d/init.d/mysql: No such file or directory

> I keep wondering if I am missing some common utility because this is a fresh
> Linux install, and I haven't added much. But how would that result in a
> missing file? 

Did you install MySQL before trying to install MySQL-Max? If
I remeber right, these messages appear if you try to install
Max without installing MySQL first...


Regards,
Sasa



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

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

Cyrillic characters

[Jim Philips]

I am trying to understand how to store both Latin and Cyrillc characters
in a database. I built in support for koi-8 and win1251, but I don't
seem to be getting real support for Cyrillic. Cyrillic characters are
stored as ASCII and are echoed back on the Web page that way. Will MySQL
support storing both Latin and Cyrillic characters in the same database?




-
Before posting, please check:
   http://www.mysql.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: RH 7.2 connections problems w 16 web servers to 2 MySQL servers

[Michael Widenius]

Hi!

Sam> We have a very high volume site (3 million page views a day) that's run 
Sam> on 16 Apache / PHP web servers & 2 MySQL servers. We are using PHP with 
Sam> persistent connections. Each MySQL serves 8 web servers & is supposed to 
Sam> act as a failover machine for the other group of 8 web servers.
Sam> 
Sam> The failover won't work now as if one MySQL goes down the cost of the 8 
Sam> web servers switching over is so high the other MySQL locks up.
Sam> 
Sam> Each Apache / PHP server takes up hundreds of connections even when 
Sam> they're idle so we ran into the Linux connection limit of 1000 & had to 
Sam> recompile to get past that.
Sam> 
Sam> Our actual MySQL CPU useage is low but the goes when with the connection 
Sam> overhead when starting up or failing over a bank of machines.
Sam> 
Sam> We get a mysterious MySQL lockup once a week at the same day & time.

Could you please describe the lookup, exactly what happens ?

What does 'mysqladmin var ext' show when this happens?
What do you have in your log files ?

Sam> Questions :
Sam> 
Sam> - Is our configuration of 2 sets of 8 Apache/PHP web servers & 1 MySQL 
Sam> servers just not a good idea ?

This should not be a problem.

Sam> - Would we better off with FreeBSD ?

If you are running a CMP machine, then Linux preforms normally better
than FreeBSD.

To be able to give some recommendations we need to know more about
this setup.

Sam> - Is there anyone doing any similar setups with lots of web servers & a 
Sam> few MySQLs ?

We have several hundred of paying support customers with this setup.

Sam> - Is there any way to get Apache / PHP to use fewer connections ?

Stevens Rousseys exellent answer should help you with this

Sam> We pay for MySQL support but haven't had much help from them.

I checked our support email archive, but couldn't find anything from
you or your company in it.

Could you please use our supportwizard interface to make a ticket of
this problem so that we can help you with it?
If you have already a ticket, please email me the ticket number so
that we can check this up.

Regards,
Monty

-- 
For technical support contracts, goto https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, CTO
/_/  /_/\_, /___/\___\_\___/   Helsinki, Finland
   <___/   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

foxpro xbase conversion

[Neil Davies]

Needing to convert some old foxpro tables into mysql. Have done this before
using a long winded xbase-text-mysql through access97, but it through out Dr
Watson errors with a couple of the tables, oddly enough a couple of
important ones that I need. I was wondering if anyone knew of any apps/perl
modules that would perform this for me? Btw. I use WindowsNT4 and don't have
easy access to a linux machine.

Thanks in advance,
Neil


-
Before posting, please check:
   http://www.mysql.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

install on Red Hat Linux 7.2 with rpm

[Loftus, Annie]

installing MySQL-Max-3.23.49-1.i386.rpm on Linux Red Hat 7.2 (server install
option) kernel 2.4
while logged in as root, from /usr/local/mysql on an old PC

Hi. I am brand new to Linux, and I can't get MySQL installed. The client
part goes fine, but when I do 
rpm -ivh MySQL-Max-3.23.49-1.i386.rpm

I get this

Preparing...# [100%]
1:MySQL-Max # [100%]
Giving mysqld a couple of seconds to restart
/var/tmp/rpm-tmp.18185: /etc/rc.d/init.d/mysql: No such file or directory

then if I do an rpm -qs on the same file, I get a message saying that
package is not installed. 
Yet Gnome rpm gives me an option to uninstall it. 
And if I try to install it again, (rpm -ivh again) I get a message that it
is already installed. 

and neither I nor my machine can find scripts/mysql_install_db. So I guess
the install didn't get that far.

I keep wondering if I am missing some common utility because this is a fresh
Linux install, and I haven't added much. But how would that result in a
missing file? 
Thanks in advance for your help,
Annie


-
Before posting, please check:
   http://www.mysql.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