Re: MySQL bug? - problems with character-set

2002-08-01 Thread Andis
Hi! It's just a simple example, because I don't want send latvian-specific symbols. This problem occurs with latvian-specific symbols only. Configuration file I cheked some 4-5 times. I'm confused now. Regards from Latvia! Andis Grasis - Original Message - From: "Victoria Reznichenko"

Exporting Multi-DataType Excel Worksheet to CSV for Import into MySQL

2002-08-01 Thread Jonathan Duncan
I have done a lot of looking and search through archives of mailing lists and newsgroups and I guess I haven't looked enough because "I still haven't found what I'm looking for." What I have is an Excel worksheet that had 26 fields and several hundred rows of data. The data types will be are INT

problems when a combination of join, select distinct and order by are used together.

2002-08-01 Thread hean
Description: When we join two or more tables, select distinct and order by on a column, we get problems. How-To-Repeat: mysql> select * from test; +--+--+ | a| b| +--+--+ |1 |1 | |2 |2 |

Setting the safe_show_database variable in my.cnf

2002-08-01 Thread Bill Leonard
Newbie alert here...! Making my first attempt at changing a variable... I am trying to add this line: set-variable= safe_show_database=ON To the my.cnf file... But when I do that and then attempt to restart MySQL, it doesn't... Give the can't connect to the mysql.sock error. This is on Red

Re: MySQL 4.0 on Debian

2002-08-01 Thread Jeremy Zawodny
On Thu, Aug 01, 2002 at 09:50:33PM -0400, Quinten Steenhuis wrote: > > Hello all, > > Has anyone successfully gotten MySQL 4.02 running on Debian? I'm running > into problems if I use alien to convert the RPMs. I could install from > source, but I want to avoid cruftiness and make it easy to upg

Re: Basic MySQL setup question

2002-08-01 Thread Jeremy Zawodny
On Fri, Aug 02, 2002 at 10:41:12AM +0800, Kenneth Gomez wrote: > Dear All, > > My web host provider says that he cannot allow me to have a MySQL account > on the server. However, he asks me to set up my tables offline and ftp them > across and asses them using Php. > > Can this be done? Yes.

Re: Basic MySQL setup question

2002-08-01 Thread Bhavin Vyas
Yes, Install mysql on a local box (same OS as your provider and preferably the same MySql version), create and populate your tables and then FTP the files that reside in the mysql data directory. There will be 3 files associated with each table .MYD (Data file) .MYI (Index file) .frm (schema/descr

Basic MySQL setup question

2002-08-01 Thread Kenneth Gomez
Dear All, My web host provider says that he cannot allow me to have a MySQL account on the server. However, he asks me to set up my tables offline and ftp them across and asses them using Php. Can this be done? Thank you. Kindest regards, Kenneth Gomez, Engineering Analyst, Compumod Sdn Bh

MySQL 4.0 on Debian

2002-08-01 Thread Quinten Steenhuis
Hello all, Has anyone successfully gotten MySQL 4.02 running on Debian? I'm running into problems if I use alien to convert the RPMs. I could install from source, but I want to avoid cruftiness and make it easy to upgrade. Basically, I run into conflicts with the package libmysqlclient10, but if

Failed on getting reply's on:: How to "download" a mssql db to mysql once a day

2002-08-01 Thread Lars Erik Petersen
Hello everybody! I just found out that something strange happend when I tried to subscribe to this list. I was able to send my question but something wrong happend when trying to subscribe. Therefor I was unable to see if I got any answers to my question. I would really appreciate if the people

Accessing new columns within the WHERE condition

2002-08-01 Thread Dean Householder
Okay, I thought I'd done this before but maybe not. I can't figure it out now. What I want to do is: SELECT column AS something FROM table WHERE something > 5 Basically I'm creating a new column called something and I want to use it to compare with in the WHERE condition. Is this possible? U

Re: ORDER BY question

2002-08-01 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: | I am performing a query along the lines of the following: | | SELECT DISTINCT property.Internal_ID | FROM property, owner_names | WHERE property.Internal_ID = owner_names.Internal_ID | AND [ other conditions ] | ORDER BY own

Re: Re: InnoDB: Looong pause when log file is full?

2002-08-01 Thread Pete Harlan
Thanks for your feedback (and your general untiring devotion to the cause...) On Thu, Aug 01, 2002 at 04:30:10PM -0700, Jeremy Zawodny wrote: > > about what we can do to alleviate this? Instead of having three 150mb > > log files, would we be better off with 30 15mb log files? > > It shouldn't

Re: InnoDB: Looong pause when log file is full?

2002-08-01 Thread Jeremy Zawodny
On Thu, Aug 01, 2002 at 04:37:05PM -0500, Pete Harlan wrote: > Hi, > > I've read the performance tuning tips for InnoDB > (http://www.innodb.com/ibman.html#InnoDB_tuning), but am getting bit > when the log files are full and the buffer pool is checkpointed. > > By 'geting bit', I mean for severa

ORDER BY question

2002-08-01 Thread speters
I am performing a query along the lines of the following: SELECT DISTINCT property.Internal_ID FROM property, owner_names WHERE property.Internal_ID = owner_names.Internal_ID AND [ other conditions ] ORDER BY owner_names.Name Without the order by clause this is a pretty quick query, but with it,

[Bug in UNION clause]

2002-08-01 Thread cliff
>Description: The UNION clause displays results 2 times even when not using the ALL keyword with it. example: (SELECT allusa.id,line,name,city,country,listcity,state,liststate,url,line,bookable,cost_range_low,cost_range_high,showlink,desc1,child,pets,wc,spec.id,spec.historic,spec.skiing,s

InnoDB enum and set datatypes

2002-08-01 Thread speters
I was wondering about the Enum and Set column types in InnoDB tables. I was able to create an InnoDB table with an enum column, but i get errors when trying to insert values into that column. I'm thinking that InnoDB doesnt support those data types, but the MySQL interface to InnoDB may have some

InnoDB: Looong pause when log file is full?

2002-08-01 Thread Pete Harlan
Hi, I've read the performance tuning tips for InnoDB (http://www.innodb.com/ibman.html#InnoDB_tuning), but am getting bit when the log files are full and the buffer pool is checkpointed. By 'geting bit', I mean for several minutes the db server basically stops, and our website stops serving page

Installation frustration....

2002-08-01 Thread Ben Turner
Not sure if this is the correct list to be sending to but I am having some very frustrating problems with mysql-3.23.51 on redhat 7.2 My problem is the db starts just fine using bin/safe_mysqld --user=root & although the crt seems to lock when I issue the command. After I hit ctl+c and get back

myodbc or server problem

2002-08-01 Thread Tomas Mas Esteve
Hello all, y send an SQL to server by VB & ADO. y traced from ODBC and I obtained this trace: GESTION fd28fee3-fd2805ff ENTER SQLExecDirectW HSTMT 02361D94 WCHAR * 0x01B46750 [ 211] "INSERT INTO macbase_totales.recibos

Re: maximum number of columns & max row size

2002-08-01 Thread Gerald Clark
Michael Zelina wrote: > This is an interesting idea... I thought about doing this, > but the variety of data types prohibited me from doing so. > Initially, I was going to make everything VARCHAR(80)... but > that seemed to be horrible for data storage purposes and would > prevent me from bei

Re: How to speed up slow query from OR

2002-08-01 Thread Jeremy Zawodny
On Thu, Aug 01, 2002 at 06:15:16PM +0200, Joseph Bueno wrote: > > According to MySQL documentation, indexes are not used with OR: > http://www.mysql.com/doc/M/y/MySQL_indexes.html > You can't speed up your query by adding indexes. > Running 2 separate queries is the best you can do if you want to

FreeBSD/MySQL 4.0.2 and UNION buggy?

2002-08-01 Thread Jeremy Zawodny
Is anyone else seeing odd problems with heavy use of UNIONs on a MySQL 4.0.x server on FreeBSD? I seem to be able to induce the problem on FreeBSD but not Linux. I have a lot more testing to do yet, but if someone else is seeing it that would really help to narrow the bug down. Thanks, Jeremy

Re: maximum number of columns & max row size

2002-08-01 Thread Michael Zelina
It's funny how terminology can be so confusing! When I say "dimension", I mean engineering-wise as in the distance from a to b. Also, my use of session probably wasn't a good word in this context. Our sessions are actually permanently stored, since they are associated with a particular engineer

RE: maximum number of columns & max row size

2002-08-01 Thread James Ching
The way you store session values, as you said, can be troublesome when new dimensions are added, or existing ones removed. Also it might be constrained by some column limit. I'd try something like this, +--++-+---+ | SESSIONID| UserID | DimensionID | Val

Re: max_connect_errors & wait_timeout problem?

2002-08-01 Thread Diana Soares
On Wed, 2002-07-31 at 19:09, Troy Hakala wrote: > I decreased wait_timeout (from 28,800 to 300) to kill off sleeping threads. > This morning, the server stopped accepting connections and gave me this > error: > > ERROR 1129: Host 'hostname' is blocked because of many connection errors. > Unbl

Re: How to speed up slow query from OR

2002-08-01 Thread Brent Baisley
If running two queries is running faster than perhaps the best way to do it is select the first query into a temporary table and then insert select the second to append to the temp table. Then you can select and sort however you want from the temporary table. create table tempname SELECT somet

Re: maximum number of columns & max row size

2002-08-01 Thread Brent Baisley
I thought you were coming from some other database. I haven't heard "dimension" since my FoxPro (on the Mac) days. Since session data is temporary, you should use temporary tables to store you session variables. Just use the "real" table to hold you default values. You want to do something like

Re: permissions questions...

2002-08-01 Thread Bill Leonard
on 8/1/02 11:32 AM, Victoria Reznichenko at [EMAIL PROTECTED] wrote: > C> Is there a way to create a user by giving access to only one database, > C> without giving him the permission to "mysqlshow --user=[thisuser] > C> --password=[thispassword]" and retrieve all database names? He should see >

Re: a newserver would be better than this mailing list , 1 more time

2002-08-01 Thread Pete French
> >p.s. PLEASE can you put a [mysql] tag on the list??? > Please not, it wastes space on the screen. not a lot of space - and does have the great advantage that we can then filter out the mysql stuff into a separate mailbox whihc (on standard UNIX mail) isnt possible without it. -pcf. ---

Re: maximum number of columns & max row size

2002-08-01 Thread Michael Zelina
Hi Brent, Thanks for the response. Currently, I have the variables listed out in a table with one variable per row... something similar to the following: ++--+- | ID | DimensionName| ++--+- | 1 | units_length | | 2 | units_temp | | 3 | d

Re: Error in using "source" command with PHP

2002-08-01 Thread Gerald Clark
That is because "source" is a mysql client command, not as sql command. It gets executed by the client 'mysql'. The 'mysql' client reads it line by line, and passes the lines to the server. The server never sees the scriptfile.sql. You will have to write a PHP modules that reads the file, and pa

Problem under high load

2002-08-01 Thread Matthew Kahn
Hi all-- I'm running a PHP/Apache/MySQL web app on a server. Specs are: Slackware Linux v8.0 Kernel 2.4.16 Dual Athlon MP 1.2 GHz processors on a Tyan S2460 Mobo 1 GB registered ecc ram I'm running MySQL 3.23.51-log, I believe, and it's the binary version for x86 supplied by MySQL. The proble

Re: a newserver would be better than this mailing list , 1 moretime

2002-08-01 Thread Joseph Bueno
David Wolf wrote: > Personally, I think one simple change would work wonders for the list: > adding a [mysql] ident at the beginning of each subject line. An EASY > change that would allow for MUCH easier sorting of the list into a > different folder. From there, you can thread it with (almost)

RE: RPM Installation Question

2002-08-01 Thread Luc Foisy
read the documentation in the my.cnf sections you can supply datadir=/usr/data/mysql (or whatever the data directory you choose) make sure mysql has permissions on the new directory a couple other things rely on this base directory too your socket file your pid file You can set these too in y

RE: permissions questions...

2002-08-01 Thread Caron, Christian
Yes, but when I create a user with any other grants, it generates automatically this "grant usage on *.*": mysql> use Liste_MP3; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> grant select

Re: a newserver would be better than this mailing list , 1 more time

2002-08-01 Thread Bernd Petrovitsch
David Wolf <[EMAIL PROTECTED]> wrote: >Personally, I think one simple change would work wonders for the list: >adding a [mysql] ident at the beginning of each subject line. An EASY You have already (in the header) List-id: Should be enough to filter the mails. >p.s. PLEASE can you put a [mysq

Re: How to speed up slow query from OR

2002-08-01 Thread Joseph Bueno
James MacLean wrote: >On Thu, 1 Aug 2002, Ralf Narozny wrote: > > > >>Hello! >> >>James MacLean wrote: >> >> >> >>>Hi Folks, >>>Have only known enough SQL to do what we needed. >>>Today on mysql-3.23.51 we found out that : >>>select something from table where index1 = 'value' or index2 = '

various questions about my.ini /or my.cnf

2002-08-01 Thread Jerry Arkema
As a newcomer to MySql, I have struggled through the install and am working my way through the tutorial. My environment: Win2000 MySql version 3.23.51-nt My.ini: [mysqld] # set basedir to installation path, e.g., c:/mysql basedir=c:/mysql # set datadir to location of data

Re: Running an SQL file from the command line

2002-08-01 Thread Francisco Reinaldo
mysqlsource sms.sql Bye and Good Luck! --- Scott Pippin <[EMAIL PROTECTED]> wrote: > I need to run a file called sms.sql from the command > line. Is this > possible and what is the syntax? > Thanks in advance. > > - > Before po

INSERT Question

2002-08-01 Thread Steven Kreuzer
Hello All, First, Let me start by saying this question has most likely been asked before, but I did a search in the archive and was unable to come up with any results. I think this is because I am not quite sure what this is called. So, I do apologize, but hopefully this can be answered quick

Re: permissions questions...

2002-08-01 Thread Victoria Reznichenko
Caron, Thursday, August 01, 2002, 5:34:16 PM, you wrote: C> mysql> show grants for nouveau@localhost; C> +--- C> + C> | Grants for nouveau@localhost| C> +---

Re: Please suggest some

2002-08-01 Thread Egor Egorov
Chai, Thursday, August 01, 2002, 3:52:59 PM, you wrote: CW> Very sorry for my childish question, I'm just starting to learn about MySQL CW> Following is my procedure in fixing the problem of installation on Intel PC, CW> and Linux RH7.3. CW> 1. RPM installation CW> 2. When execute mysql, there i

Re: a newserver would be better than this mailing list , 1 moretime

2002-08-01 Thread David Wolf
Personally, I think one simple change would work wonders for the list: adding a [mysql] ident at the beginning of each subject line. An EASY change that would allow for MUCH easier sorting of the list into a different folder. From there, you can thread it with (almost) any modern mailreader..

RPM Installation Question

2002-08-01 Thread Jason Frisvold
I was hoping to use the RPM distribution to install MySQL on my Linux machine.  However, I notice that it sets the data directory to /var/lib/mysql  ...  This is unacceptable for my purposes...  I know I can probably use a link to fix this, but I'd rather do it the "right" way...  How do I tell

NumberFormatException at ResultSet.getTimestamp()!

2002-08-01 Thread Ram Myneni
Hello: I am getting NumberFormatException when getting Timestamp using ResultSet class. This occurs only if I run simultaneous threads. This doesn't happen if the same select query is not fired several times. The application is currently using older version of JDBC driver (mysql_both_comp.jar).

Error in using "source" command with PHP

2002-08-01 Thread Stephen Wardlaw
When in MySQL in a terminal, if I enter the command "source scriptfile.sql", MySQL correctly executes the source file. However, if using PHP, I execute the following commands in a PHP file: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) T

Re: How to speed up slow query from OR

2002-08-01 Thread James MacLean
On Thu, 1 Aug 2002, Ralf Narozny wrote: > Hello! > > James MacLean wrote: > > >Hi Folks, > >Have only known enough SQL to do what we needed. > >Today on mysql-3.23.51 we found out that : > >select something from table where index1 = 'value' or index2 = 'value'; > >Runs considerably slower than

RE: dos trouble

2002-08-01 Thread Gerald Jensen
Home or Pro? I have no experience with WinXP Home, but with WinXP Pro you need to installed MySQL as a service, then start the service. After that, the console will start with c:\mysql\bin\mysql Instructions for installing as a service are in the MySQL Manual. -Original Message- From: S

Re: Linux Installation (make) problem

2002-08-01 Thread Ralf Narozny
Hello! Saravanan C wrote: >>To: [EMAIL PROTECTED] >>From: Saravanan C <[EMAIL PROTECTED]> >>Subject: From Saravanan, REC, INDIA >>Date: Thu, 1 Aug 2002 13:05:17 GMT >>- >>Hi Lists, >> >>I recently downloaded mysql-3.23.51-pc-linux-gnu-i686 from mysql.com for >> >> >linux > > >>platfo

various questions about my.ini /or my.cnf

2002-08-01 Thread Jerry Arkema
As a newcomer to MySql, I have struggled through the install and am working my way through the tutorial. My environment: Win2000 MySql version 3.23.51-nt My.ini: [mysqld] # set basedir to installation path, e.g., c:/mysql basedir=c:/mysql # set datadir to location of data

Re: Connecting to MySQL using OLEDB

2002-08-01 Thread Christoph Lütjen
Tell me what you do ADODB -> OLEDB driver for ODBC -> MyODBC -> MySQL ADODB -> MyOLEDB -> MySQL or anything else? first case: check "don't promt on connect" Did you create a data source? (First thing you don't need to do...) But whatever you do with VB, MS ADODB and MySQL - you will need

Re: How to speed up slow query from OR

2002-08-01 Thread Ralf Narozny
Hello! James MacLean wrote: >Hi Folks, > >Have only known enough SQL to do what we needed. > >Today on mysql-3.23.51 we found out that : > >select something from table where index1 = 'value' or index2 = 'value'; > >Runs considerably slower than: > >select something from table where index1 = 'va

RE: dos trouble

2002-08-01 Thread Benoit St-Jean
>I'm trying to start up mysql through dos prompt. When I enter a >command >like c:\mysql\bin\mysqld or anything similar (any command in the bin >directory), it just waits there. I can't Ctrl-C out of it. I can end >the >process to get out. What's happening? You just started the server. If

permissions questions...

2002-08-01 Thread Caron, Christian
mysql> show grants for nouveau@localhost; +--- + | Grants for nouveau@localhost| +--- + | GRANT USAGE ON *.* TO 'nouveau'@

Re: dos trouble

2002-08-01 Thread Shion D. Deysarkar
Win XP On Thu, 1 Aug 2002, Gerald R. Jensen wrote: > What O/S are you using ... Win2k, WinXP, etc.? > > > - Original Message - > From: "Shion D. Deysarkar" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Wednesday, July 31, 2002 11:15 PM > Subject: dos tro

Selectable results

2002-08-01 Thread Birgit Woods
Hello, In my web page I have MySQL retrieve information from a database, and display it in a table. I would like to make the results of the search selectable, as in, be able to click on a field in my table and have it preform a function. Here is the code for my table. I would like $myrow["FileNam

Re: A field named "change" can't be created

2002-08-01 Thread //mikezero/
you could always try dropping a 'd' on the end of 'change'... as in making the field 'changed' if it's a flag to see if the data has changed. Gerald Clark wrote: > It is not a good idea to use reserved words for field names. > If you must, then use back ticks ( below the ~ on my keyboard) . >

Re: problem on open a table

2002-08-01 Thread Egor Egorov
Florian, Thursday, August 01, 2002, 10:44:40 AM, you wrote: FL> I do not manage to open a table it puts me " Can' t open takes off: ' FL> pkf_as_events_log. MYD '. (Errno: 145) " is what anybody has already had FL> this error on mysql? Your table is corrupted. You shoulf repair it: http://

Re: enable-local-infile=1 or where can I found older version?

2002-08-01 Thread Egor Egorov
lana, Thursday, August 01, 2002, 2:24:15 PM, you wrote: ll> I installed mysql version 3.23.51 on redhat 7.2 ll> (but I had the same problem with version 3.23.49a) ll> I am not able to load data form text file ll> neather with the load command or with mysqlimport ll> The error message is ll> "The

Re: Problems When Upgrading to MySQL 4.02

2002-08-01 Thread Cliff
all of the files are chown -R mysql in that directory. Any other ideas? - Original Message - From: "Gerald Clark" <[EMAIL PROTECTED]> To: "Cliff" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, August 01, 2002 7:05 AM Subject: Re: Problems When Upgrading to MySQL 4.02 > Chec

Re: Problems When Upgrading to MySQL 4.02

2002-08-01 Thread Gerald Clark
Check the files in the directory. I bet they are not owned by mysql. Cliff wrote: >Hi, I am trying to upgrade to 4.02 from 3.23.47 on FreeBSD 4.6. The mysql >database does not want to work for some reason, when I move my old mysql >database over the new one, it does not start up, giving an error

Re: maximum number of columns & max row size

2002-08-01 Thread Brent Baisley
A rule of thumb I always follow is to design the DB so that you don't have to add columns (or modify the structure) unless something unforseen comes up (like a new feature). In your case, you are expecting to add "variables" in the future, so I would deign accordingly. Use rows instead of colum

Re: A field named "change" can't be created

2002-08-01 Thread Gerald Clark
It is not a good idea to use reserved words for field names. If you must, then use back ticks ( below the ~ on my keyboard) . CREATE TABLE test (`change` char(1) default NULL ) Taras Plakhotnichenko wrote: > A field named "change" can't be created. Any other name is OK. > >

Re: MySQL bug? - problems with character-set

2002-08-01 Thread Victoria Reznichenko
Andis, Thursday, August 01, 2002, 2:28:12 PM, you wrote: AG> I tested MySQL 3.23.51 under Windows and 3.23.49 under Linux RedHat 7.3 with AG> such SQL: AG> select lcase('HERE I TIPED IN SPECIFIC MY LANGUAGE CHARACTERS') AG> and recieved different results (of course, I used same config file with

Re: Connecting to MySQL using OLEDB

2002-08-01 Thread Francisco Reinaldo
Hi, Search if somebody has the OLEDB driver for MySQL, and then you will be able to do it. Bye and Good Luck! --- "Darrell A. Sullivan, II" <[EMAIL PROTECTED]> wrote: > Can anyone tell me if it is possible to connect to a > MySQL server running on > Linux from a Windows Visual Basic application

THIS IS NOT AN ADVERTISEMENT: Please suggest me some

2002-08-01 Thread Chai Wutiwiwatchai
Original-Message-ID: <[EMAIL PROTECTED]> Original-Sender: "Chai Wutiwiwatchai" <[EMAIL PROTECTED]> Original-Subject: Please suggest some Original-Date: Thu, 01 Aug 2002 19:52:59 +0700 --

Problems When Upgrading to MySQL 4.02

2002-08-01 Thread Cliff
Hi, I am trying to upgrade to 4.02 from 3.23.47 on FreeBSD 4.6. The mysql database does not want to work for some reason, when I move my old mysql database over the new one, it does not start up, giving an error about permissions even though the permissions of that directory are 770 mysql.mysql. I

A field named "change" can't be created

2002-08-01 Thread Taras Plakhotnichenko
A field named "change" can't be created. Any other name is OK. CREATE TABLE test ( change char(1) default NULL ) SQL-query : CREATE TABLE test ( change char(1) default NULL ) MySQL said: You have an error in your SQL syntax near 'change cha

Re: THIS IS NOT AN ADVERTISEMENT: Please suggest me some

2002-08-01 Thread David Ziggy Lubowa
well for one i think you need to make sure after doing mysql_install_db , you check the ownership of your diretory , is should be owned by mysql.deamon, after that try and start mysql i think it should work after, such errors are ususally due to ownership. hope this helps :) ma 2cents cheers D

Re: Linux Installation (make) problem

2002-08-01 Thread Francisco Reinaldo
Hi, I recomend you to use the pre-compiles binary distribution. You won't have to build it and it worked for me. This is the link for the Intel platform: http://www.mysql.com/downloads/download.php?file=Downloads/MySQL-3.23/mysql-3.23.51-pc-linux-gnu-i686.tar.gz Bye and Good Luck. --- Saravana

Please suggest some

2002-08-01 Thread Chai Wutiwiwatchai
Very sorry for my childish question, I'm just starting to learn about MySQL Following is my procedure in fixing the problem of installation on Intel PC, and Linux RH7.3. 1. RPM installation 2. When execute mysql, there is a message "ERROR 2002: Can't connect to local MySQL server through socket '

Re: repeated crashes (buffer overrun?)

2002-08-01 Thread Heikki Tuuri
Colin, what version of MySQL you are running and on what OS? The assertion means there is an attempt to reference a pointer which does not point to the buffer pool. It might be memory corruption or table corruption. If you have updated to new disk drives in Linux, best to check if there are new

Re: MySQL 3.23.51 compile problems with SuSE 8.0

2002-08-01 Thread A.J.Dawson
Blast! I _did_ ask Yast to install the file - for some reason it didnt go on during the installation. Ah well, you learn something new every day... Many thanks for your time in helping me solve this one. Regards Andy On Thu, 1 Aug 2002, Lenz Grimmer wrote: > -BEGIN PGP SIGNED MESSAGE

Re: dos trouble

2002-08-01 Thread Gerald R. Jensen
What O/S are you using ... Win2k, WinXP, etc.? - Original Message - From: "Shion D. Deysarkar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, July 31, 2002 11:15 PM Subject: dos trouble I'm trying to start up mysql through dos prompt. When I ente

MySQL bug? - problems with character-set

2002-08-01 Thread Andis Grasis
Hi! I tested MySQL 3.23.51 under Windows and 3.23.49 under Linux RedHat 7.3 with such SQL: select lcase('HERE I TIPED IN SPECIFIC MY LANGUAGE CHARACTERS') and recieved different results (of course, I used same config file with case-sensitive configuration). Result under Linux looks better, unde

enable-local-infile=1 or where can I found older version?

2002-08-01 Thread lana lana
I installed mysql version 3.23.51 on redhat 7.2 (but I had the same problem with version 3.23.49a) I am not able to load data form text file neather with the load command or with mysqlimport The error message is "The used command is not allowed with this Mysql version" I found some mail telling

Linux Installation (make) problem

2002-08-01 Thread Saravanan C
> To: [EMAIL PROTECTED] > From: Saravanan C <[EMAIL PROTECTED]> > Subject: From Saravanan, REC, INDIA > Date: Thu, 1 Aug 2002 13:05:17 GMT > - > Hi Lists, > > I recently downloaded mysql-3.23.51-pc-linux-gnu-i686 from mysql.com for linux > platform. > > I did the following. > > Created gr

From Saravanan, REC, INDIA

2002-08-01 Thread Saravanan C
Hi Lists, I recently downloaded mysql-3.23.51-pc-linux-gnu-i686 from mysql.com for linux platform. I did the following. Created group mysql Created user mysql Extracted the zip using gunzip to /usr/local/mysql-VERSION-OS/ cd /usr/local/mysql-VERSION-OS/ /configre --prefix=/usr/loca/mysql

mysql@lists.mysql.com

2002-08-01 Thread Thomas Raabe
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:Thomas Raabe >Organization: Thomas Raabe E-Mail: [EMAIL PROTECTED] UNI-Kassel - HRZ-ABT II Tel: 0561-804-2285 Moenchebergstr. 11 - 34125 Kassel Fax:

Large File support on linux 2.2

2002-08-01 Thread Martin Waite
Mysql, SQL, etc. Hi, Does anyone have experience of compiling in large file support for Linux ? I just want to know what is the scope of the change: do I have to recompile the kernel and every single library and application ? thanks, Martin --

Re: MySQL 3.23.51 compile problems with SuSE 8.0

2002-08-01 Thread A.J.Dawson
I get a slightly different result in my config.h file: $ grep GETHOSTBY config.h /* #undef HAVE_GETHOSTBYNAME_R_GLIBC2_STYLE */ /* #undef HAVE_GETHOSTBYNAME_R_RETURN_INT */ #define HAVE_GETHOSTBYADDR_R 1 #define HAVE_GETHOSTBYNAME_R 1 Sorry to say that I have no real idea what this means! I ha

MySql on Linux Clustering..?

2002-08-01 Thread
I want to run MySql on Linux Clustering Sever. But I can't find about that. Would you tell me , Where can I get MySql Clustering HOW-TO Docs? - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Chinese charset

2002-08-01 Thread Pete French
> Is it possible to use MySQL with a chinese charset (utf8) ? You need to use BLOB or TEXT types and do a little bit of work yourself to manage them, but basically it does work fine. mySQL just treats it as binary data. -pcf. -

Re: "assertion failed" "invalid signature" in file "details.php"

2002-08-01 Thread Bart Burkhardt
- Original Message - From: "Bart Burkhardt" <[EMAIL PROTECTED]> > i get this error in mysql 3.23.51 with snortreport > (http://www.circuitsmaximus.com/download.html) > is this an mysql error or snortreport error ? problem solved, i had to enable global environment=on in php.ini so, no

Re: Answer: how to get 64 indexes

2002-08-01 Thread Jeremy Zawodny
On Mon, Jul 29, 2002 at 12:15:50PM -0700, [EMAIL PROTECTED] wrote: > After many headaches, rantings, and emails, i have FINALLY figured out how > to get 64 indexes out > of MySQL tables. [snip] > I think its a sad situation that i could find numerous references to using > 64 keys, none > more sp

AW: Installing MySQL 3.23.51 on AIX 4.3.3

2002-08-01 Thread R . Sommer
Hi Scott, you have to set the PATH variable. PATH=/usr/local/bin:$PATH in your profile. Then the mysql_install_db runs. -Ursprüngliche Nachricht- Von: Scott Pippin [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 31. Juli 2002 21:17 An: [EMAIL PROTECTED] Betreff: Installing MySQL 3.23.51

problem on open a table

2002-08-01 Thread Florian Litot
HI, I do not manage to open a table it puts me " Can' t open takes off: ' pkf_as_events_log. MYD '. (Errno: 145) " is what anybody has already had this error on mysql? Cordially Florian - Before posting, please check: http

Re[2]: Bug or feature fulltext search?

2002-08-01 Thread Artem V. Ryabov
Hello Sergei, Tuesday, July 23, 2002, 10:17:06 PM, you wrote: SG> Hi! SG> On Jul 23, Artem V. Ryabov wrote: >> Hello mysql, >> >> see this 2 queries: >> why they not equal? >> why first skip many records? >> >> mysql> select left(ftText,20) from Txt_index where match(ftText) >against('+(wùd2