crash

2002-03-11 Thread Marcelo Stucky
Hi Guys ! : attached is the log report after crashing every time i send a sql query (see log file ) this query works fine with other keywords in the where match against-clause . its a bug its a feature? please help me LOG FILE SAYS: tonic:~ # mysqld got signal 11; This could be because you

Unicode support for MySQL

2002-03-11 Thread Victoria Reznichenko
Robin, Monday, March 11, 2002, 6:55:51 AM, you wrote: RT I am just wondering if the latest stable build of MySQL has support RT for Unicode character set so I can use it to store english, chinese and RT korean characters. If so please let me know. And also if there is going RT to be any

Fw: How to sum only nest N values?

2002-03-11 Thread Anzej Becan
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

Mysql error .

2002-03-11 Thread Egor Egorov
carlos, Saturday, March 09, 2002, 7:58:57 PM, you wrote: ca Can someone help and tell how can i fix this error . ca Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' ca (Using password: YES) Are you sure that your password was correct? You can find causes of access

Re: Mysql error .

2002-03-11 Thread George Pitcher
Also, make sure that you 'flush privileges' after storing your user details in MySQL. George - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 11, 2002 9:46 AM Subject: Mysql error . carlos, Saturday, March 09, 2002, 7:58:57 PM, you

passing Mysql handler to the exec'ed child

2002-03-11 Thread Murali P
Hi , My aim is to avoid mysql connects to the DB my application does not run as a daemon . But the parent of this program runs as a daemon , so can someone tell me how I would make use of the same Mysql handler in the execed child also assuming I connect to the Mysql Server in the parent ?

ISCII support for mysql

2002-03-11 Thread Uma Shankari T.
Hello, Can anyone tell to me which version of Mysql support ISCII.. Regards, Uma - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

RE: what's wrong with EXPLAIN?

2002-03-11 Thread savaidis
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

How to pass mysql connections across exec()

2002-03-11 Thread Manvendra Bhangui
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

RE: [PHP] Re: A stupid question...

2002-03-11 Thread Tim Ward
If you mean select by first letter then wild cards are what you want ... http://www.mysql.com/doc/S/t/String_comparison_functions.html http://www.mysql.com/doc/S/t/String_comparison_functions.html in your case SELECT ... WHERE lastname LIKE '$Letter%' ORDER BY lastname ... if you mean sort all

install on Red Hat Linux 7.2 with rpm

2002-03-11 Thread 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

foxpro xbase conversion

2002-03-11 Thread 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

Re: RH 7.2 connections problems w 16 web servers to 2 MySQL servers

2002-03-11 Thread 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

Cyrillic characters

2002-03-11 Thread 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

Re: install on Red Hat Linux 7.2 with rpm

2002-03-11 Thread 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 in Linux, Unable to connect from windows

2002-03-11 Thread 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 =

Re: MySQL GUI

2002-03-11 Thread 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.

Re[2]: RH 7.2 connections problems w 16 web servers to 2 MySQL servers

2002-03-11 Thread 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

Languages

2002-03-11 Thread 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

Re: bug: segfaults with mysql_read_default_group!

2002-03-11 Thread 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

RE: Mysql/Solaris: can't run configure or mysql_install_db

2002-03-11 Thread 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

Large table problems

2002-03-11 Thread 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:

Large table problems

2002-03-11 Thread 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:

Re: 4.0.2 Replication Bug...

2002-03-11 Thread 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

install on Red Hat Linux 7.2 with rpm

2002-03-11 Thread 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

RE: Mysql/Solaris: can't run configure or mysql_install_db

2002-03-11 Thread 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:

Slow CONCAT on BLOBs

2002-03-11 Thread 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--)

Help w/ join syntax

2002-03-11 Thread Anthony Rodriguez
When I call the following PHP script, $qry_1 doesn't work (No query # 1!). ?php set_time_limit(300); $connection=mysql_connect(localhost,wagner,???) or die (No connection!); $db=mysql_select_db(sbwresearch,$connection) or die (No database!); $qry_1=select first_name.con_inf, ... zip.con_inf,

Mysql on Windows accessed client on Solaris--gives problem

2002-03-11 Thread 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

Memory problem

2002-03-11 Thread 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

xBase (foxpro) conversion

2002-03-11 Thread 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.

Re: Help w/ join syntax

2002-03-11 Thread 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!). ?php [...] $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

Re: bug: segfaults with mysql_read_default_group!

2002-03-11 Thread 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

mysql + ext3 + data=journal ?

2002-03-11 Thread 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

Re: Changing datatypes on the fly?

2002-03-11 Thread 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?

How to timestamp records across time zones? ##

2002-03-11 Thread 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

RE: Mysql/Solaris: can't run configure or mysql_install_db

2002-03-11 Thread 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

MYSQLGUI 1.7.5

2002-03-11 Thread 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

Re: MYSQLGUI 1.7.5

2002-03-11 Thread 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

replication stops when it shouldn't

2002-03-11 Thread 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

RE: Unicode support for MySQL

2002-03-11 Thread 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

Non odbc/jdbc connection

2002-03-11 Thread 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

Re: mysql under FreeBSD 4.5

2002-03-11 Thread 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

Re: How to sum only nest N values?

2002-03-11 Thread 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

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

2002-03-11 Thread 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

Re: How to sum only nest N values?

2002-03-11 Thread 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 -

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

2002-03-11 Thread 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

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

2002-03-11 Thread 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

Foreign keys in mysqldump?

2002-03-11 Thread 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

Lost connection to MySQL server during query

2002-03-11 Thread 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

synopsis of the problem (one line)

2002-03-11 Thread root
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release:

On the logging of BLOBS

2002-03-11 Thread 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:

Re: How to sum only nest N values?

2002-03-11 Thread 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

Re: Mysql installation. Help!

2002-03-11 Thread 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?

Re: mysql + ext3 + data=journal ?

2002-03-11 Thread 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

Re: On the logging of BLOBS

2002-03-11 Thread 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

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

2002-03-11 Thread 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

Re: mysql + ext3 + data=journal ?

2002-03-11 Thread 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

MySQL and MSAccess

2002-03-11 Thread 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

Re: Request-URI Too Large

2002-03-11 Thread 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: a href=\editform02.php?idx=$idx\ 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

Re: mysql + ext3 + data=journal ?

2002-03-11 Thread 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

Re: On the logging of BLOBS

2002-03-11 Thread 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

Re: On the logging of BLOBS

2002-03-11 Thread 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

Re: On the logging of BLOBS

2002-03-11 Thread 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

MySQL and MSAccess

2002-03-11 Thread 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

Re: MySQL and MSAccess

2002-03-11 Thread 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: http://www.mysql.com/doc/M/y/MyODBC_clients.html Also, to check which version of MDAC you have use: Component

MySQL database connect issue..............!

2002-03-11 Thread 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

Encrypted table

2002-03-11 Thread 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

RE: xml

2002-03-11 Thread 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

RE: How to pass mysql connections across exec()

2002-03-11 Thread 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

Re: Encrypted table

2002-03-11 Thread 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

What type of Unicode?

2002-03-11 Thread 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

Re: Encrypted table

2002-03-11 Thread 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

MySQL++ samples are not working?

2002-03-11 Thread 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

error logging

2002-03-11 Thread 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/

LEFT/RIGHT Join?

2002-03-11 Thread 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,

mysqldumpslow errors

2002-03-11 Thread 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

RE: Problem with locking i guess ...

2002-03-11 Thread 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..)

Re: Mysql installation. Help!

2002-03-11 Thread 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.

Myisamchk question

2002-03-11 Thread 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]

Re: Request-URI Too Large

2002-03-11 Thread 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

Re: Request-URI Too Large

2002-03-11 Thread 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

MySQL / XP / some expletive

2002-03-11 Thread 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

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

2002-03-11 Thread 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

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

2002-03-11 Thread 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

Re: MyODBC and .NET (C#)

2002-03-11 Thread 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#.

Re: What type of Unicode?

2002-03-11 Thread 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

Re: Languages

2002-03-11 Thread 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

Re: MySQL / XP / some expletive

2002-03-11 Thread 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

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

2002-03-11 Thread 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

Order by list?

2002-03-11 Thread 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

Re: Order by list?

2002-03-11 Thread 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

Re: MySQL / XP / some expletive

2002-03-11 Thread 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

Multiple languages (was Re: Cyrillic characters)

2002-03-11 Thread 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,

site search

2002-03-11 Thread 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

mysql server can't work.

2002-03-11 Thread Äþº£½¢
The mysql server can't work.Anyone know what will I do? === ÊÖ»úºÅÂëÊǵçÓÊ£¬´Ó´Ë½»·Ñ²»ÓóһºÅÔÚÊÖ¡°ËæÉíÓÊ¡± ¡ª¡ª 163¡°ËæÉíÓÊ¡±ÊÖ»úÓÊÏä ¡ª¡ª ¡ò ÊÖ»úºÅÂë¾ÍÊǵç×ÓÓÊÏäµØÖ·£¬·½±ã¼ÇÒä ¡ò ²»ÓÃÉÏÍø£¬Í¸¹ýÊÖ»ú¶ÌÐÅ£¬ËæʱÕÆÎÕÓʼþµÄ½ÓÊÕÇé¿ö ¡ò

Re: mysql + ext3 + data=j

2002-03-11 Thread Äþº£½¢
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

mysql with java

2002-03-11 Thread 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

Re: mysql with java

2002-03-11 Thread 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

Re: How to pass mysql connections across exec()

2002-03-11 Thread 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

  1   2   >