Re: Can someone help explain this

2001-03-14 Thread Fred van Engen
On Tue, Mar 13, 2001 at 08:03:09PM -0800, Bob Silva wrote: Heres the query Im trying to run: takes about 2 minutes...both userid and usernum columns have indexes...usernum is unique. Show keys follows. mysql explain SELECT usernum FROM client WHERE userid='Salty3' OR usernum = 4158774796;

Hi, a question about mysql and servlets

2001-03-14 Thread Cyrano_
Hello everyboy, nice to post you. I hope this question not to be very frequent but i'm new in this list. I'd like to know if anybody knows how to connect a servlet with MySQL. It doesn't matter if it is by a ODBC:JDBC bridge o a 100% JDBC Driver. I can download the drivers. I want to know the

Very (excruciatingly) slow select

2001-03-14 Thread Hannes Wyss
Hi List, I'm new to the list and I have a BrainTeaser for all of you. I have yet lots to learn about sql and mySQL so any suggestions are very welcome! Thanx in advance Hannes I have following select over a Database that I cannot setup myself, but have to take on as is: SELECT

Re: apostrophe ....

2001-03-14 Thread René Tegel
tx Rolf! Yes, indeed. by default, on the newest releases of the php.ini file, magic_quotes_gpc is turned off. Of course one can switch it on/off running single scripts. The ini file in fact mentions in the introduction that is has changed. but.. why does php change default parameters,

Communication Errors

2001-03-14 Thread Marvin Wright
Hi ! I've just upgraded to the new mysql server 3.23.32 and in the log I now see 'Aborted connection ... (Got an error reading communication packets)'. I have found information about this problem such as using the binary release instead of the source release. I have now done this and it

Erratic behaviour of binary varchar fields

2001-03-14 Thread Voskuil, Jan
Description. The bug is about selecting binary varchar fields and consists in erratic behaviour of these fields in combination with OR. When executing a SELECT statement with an ORed WHERE-clause such that the two basic clauses each select a differently cased variant of one (binary varchar)

Re[2]: Innobase in MySQL

2001-03-14 Thread Peter Zaitsev
Hello Dan, Tuesday, March 13, 2001, 6:37:16 PM, you wrote: DN In the last episode (Mar 13), Peter Zaitsev said: Well guys mysqldump have one serious problem - the speed. The backup speed is quite upsetting and loads system much, but the worst thing is recovery speed. In my case the data

connection lost on long-distance connection

2001-03-14 Thread René Tegel
I've ran into some problems when connecting to a mysql server over a long-distance connection (i.e.: the internet). The first time a client reconnects from a idle connection this reconnect fails, only the second time it succeeds. The main problem is that i've written a win32 app that connects to

setting simple mysqld options in /etc/my.cnf

2001-03-14 Thread Bill Marrs
Hi, I like to run mysqld with these 3 options: --log-slow-queries --delay-key-write-for-all-tables --skip-networking But, so far, I've been unable to get mysqld to read them out of /etc/my.cnf. Here's what's inside my /etc/my.cnf: [mysql.server] log-slow-queries delay-key-write-for-all-tables

Re: setting simple mysqld options in /etc/my.cnf

2001-03-14 Thread René Tegel
you chowned mysql.cnf to owner/group mysql ? - Original Message - From: "Bill Marrs" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 1:16 PM Subject: setting simple mysqld options in /etc/my.cnf Hi, I like to run mysqld with these 3 options:

Re: setting simple mysqld options in /etc/my.cnf

2001-03-14 Thread Bill Marrs
At 01:23 PM 3/14/2001 +0100, Ren Tegel wrote: you chowned mysql.cnf to owner/group mysql ? I hadn't, but mysql is reading some other options properly from my /etc/my.cnf file. Actually, I did some more searching and I found this command: /usr/libexec/mysqld --print-defaults It seems to show

Importing ACCESS into MYSQL

2001-03-14 Thread Javier Garcia
Hi Does anybody know how to import MDB's into MYSql. Thanks Javier

use one database or many databases

2001-03-14 Thread abdelhamid bettache
Hello, I have to design a huge database for all the universities , is it better to consider a database for each university or one for all universities .. If I consider one database so I'll have one table for all students wich contain about 30 rows . thank you

RE: Importing ACCESS into MYSQL

2001-03-14 Thread Vankeerberghen, Pieter
Dear Colleague, Easily, install myODBC on your Windows PC, then export table to the ODBC source. To do this, in the Access DB window, select the table you want to export, right-click on it, select save/export, choose the ODBC source. Table is created automatically in mysql, values are exported.

Re: Membership management

2001-03-14 Thread Javier Garcia
Hi I'm newbie but see a PHP GuestBook in PHPBuilder.com Bye javier Dear All, Can someone recommend a PHP/MySQL script for managing membership forms using PHP and MySQL? I need something like a dbmanager which was available by Selena, but it was in perl with flat text database.

use one database or many databases

2001-03-14 Thread abdelhamid bettache
Hello, I have to design a huge database for all the universities , is it better to consider a database for each university or one for all universities .. If I consider one database so I'll have one table for all students wich contain about 30 rows . thank you

AW: Importing ACCESS into MYSQL

2001-03-14 Thread Patrick Schäfer
Hi, you have to create an exportfile with ACCESS separated with colons for example. Then import this textfile in your mysql-database. It looks like this: LOAD DATA LOCAL INFILE "C:\\name_of_your_file.txt" INTO TABLE name_of_your_table FIELDS TERMINATED BY 'your_separator for example ,'

RE: BDB table corruption when inserting/retrieving a BLOB into a BDB table

2001-03-14 Thread Cedric Sims
We had similar problems with version 3.23.33. For us, the fix was to move the errant tables to MyISAM. We did not need transaction support for those tables. We have since moved the tables back to BDB with MySQL version 3.23.34a. The problem seems to have been resolved in this latest update.

Compile failing

2001-03-14 Thread Martyn Perring
Hi, Can anyone shed any light on this? I'm trying to build mySQL V3.23.34a on Tru64 V4.0G using gcc2.95.2 and GNU Make version 3.79.1. The makefiles were created using ./configure --prefix=/nipweb/mysql. No other configure paramaters were used. The compile keeps failing with the following

RE: use one database or many databases

2001-03-14 Thread Cal Evans
If all the data will be used by the same application then I would suggest that you stick with a single database. Cal http://www.calevans.com -Original Message- From: abdelhamid bettache [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 8:11 AM To: [EMAIL PROTECTED] Subject:

Trouble automating backup

2001-03-14 Thread Duncan Hudson
Hi, I'm trying to write a Perl script that will automate the backing up of the tables in my database. I'm building an array of the tables in the database, using show tables, and then I step through the array with a foreach loop. I've setup the SQL statement (to do the backup) as follows:

Re: error 127

2001-03-14 Thread Gerald L. Clark
Run isamchk on your tables. mohamed Abd El-Samei Mohamed wrote: Dear all i need help i have mysql-3.22.26a over unix solairs 7 when i try to apply query from the console to retrieve some information i got that error ERROR 1030: Got error 127 from table handler please help .. Thanks

Antwort: Re: Configure problems

2001-03-14 Thread alexander . skwar
On 13.03.2001 23:37:20 Kevin Price-Ward wrote: You can NOT use gcc-2.96. Why not? Compiling works fine, without a problem - anything else that I'm missing? - Before posting, please check:

Re: 2 Problems, Shutdown and BDB (data loss)

2001-03-14 Thread goEbusiness.com Mail Lists
Enabled the binary log seems to have helped fix the data loss somewhat...I definetly don't loss it all, but I still get those restarts when I shutdown and sometimes, but now less often, I find the last few rows gone. /etc/my.cnf [mysqld] user=sql datadir=/usr/local/mysql/data

Re: help-urgent

2001-03-14 Thread Gerald L. Clark
You have provided absolutely no useful information for anyone who may wish to help you. ramamurthy rajeshkumar wrote: hi, We are using mysql as back end in our server.We are getting an problem with Mysql .the problem is mysqld is going down wiht out any error messages.in the log file it

Re: Trouble automating backup

2001-03-14 Thread Jochen Wiedmann
Duncan Hudson wrote: $sth_backup = $dbh-prepare("BACKUP table ? TO ?"); You cannot embed table names or column names with the placeholder. If you do, that will not be mapped to BACKUP table foo but to BACKUP table 'foo' which will most probably fail. Use

How many rows does a table can hold?

2001-03-14 Thread abdelhamid bettache
I want to ask you : 1- How many rows does a mysql table can hold? 2- I have to design a database for all universities of my country , Is it better to consider one database for each university or one database for all universities . Note that a query on a table "student" would be more quick if I

synopsis of the problem (one line)

2001-03-14 Thread root
Description: How-To-Repeat: Fix: Submitter-Id: [EMAIL PROTECTED] Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release:

How many rows does a table can hold?

2001-03-14 Thread abdelhamid bettache
I want to ask you : 1- How many rows does a mysql table can hold? 2- I have to design a database for all universities of my country , Is it better to consider one database for each university or one database for all universities . Note that a query on a table "student" would be more quick if I

[#Deleted] records in Access

2001-03-14 Thread Christopher Lewis
Is anybody aware of a problem when connecting Microsoft Access to MySQL 3.23 where records with AutoIncrement fields claim to be deleted after entry? Here's what I have: MySQL 3.23.32 MyODBC 2.50.36 Microsoft Access 2000 Some of my tables have an AutoIncrement Integer field as the primary

Re: Transactions

2001-03-14 Thread Heikki Tuuri
Ryan, How exactly does the BEGIN/COMMIT/ROLLBACK transaction process work? The examples I have seen are like: BEGIN; statement 1; statement 2; statement n; COMMIT; Does this imply that if any of the statements fail then a ROLLBACK will be called, otherwise it will COMMIT? you have to code

Upgrading RPM 3.23.33 to 3.23.34

2001-03-14 Thread varin
Sorry for the basic-ness of my questions, but... What's the best way to upgrade an RPM installation of MySQL? Can I just run rpm -U 3.23.34-1.i386 and it will take care of the upgrade or is there another way? Also, should I bring down the server before attempting an upgrade? Is it likely I'll

FULLTEXT indexes

2001-03-14 Thread john r. durand
i have a table with a FULLTEXT index that correctly matches certain words: mysql select title from movie where title like 'little%'; ++ | title | ++ | Little Fugitive| | Little Kidnappers, The | | Little Mermaid, The| |

In some circumstances it can be beneficial to split into two a table that is scanned very often

2001-03-14 Thread abdelhamid bettache
"In some circumstances it can be beneficial to split into two a table that is scanned very often" I found these sentence in the mysql manual , section 12.3:Get your Data as small as possible Does every body know what are these circumstances? __

Re: Upgrading RPM 3.23.33 to 3.23.34

2001-03-14 Thread Charles L Hagen
rpm -Uhv ... Yes bring it down or it will not upgrade properly. You may need to upgrade Apache etc too. Need to check with your OS vendor on this. Charles Hagen On Thu, 15 Mar 2001 [EMAIL PROTECTED] wrote: Sorry for the basic-ness of my questions, but... What's the best way to

Re[2]: Innobase in MySQL

2001-03-14 Thread Michael Widenius
hi! "Peter" == Peter Zaitsev [EMAIL PROTECTED] writes: Peter Hello Dan, Peter Tuesday, March 13, 2001, 6:37:16 PM, you wrote: DN In the last episode (Mar 13), Peter Zaitsev said: Well guys mysqldump have one serious problem - the speed. The backup speed is quite upsetting and loads system

Symbolic links to tables

2001-03-14 Thread David Patton
In section 12.2.2.1 of the manual it states that MySQL will allow one to move a table and symbolically link it. Then MySQL uses realpath() to find the absolute path. I have done this and all is fine until someone does a DELETE FROM or a ALTER TABLE . When these are done the symbolic links are

Failover and Replication

2001-03-14 Thread Bryan Coon
Hi, We are implementing a linux cluster, and rather than get gouged by oracle (in performance and licensing) would much rather use MySQL. I searched through the archives and found several references to failover and replication but still have some questions. If I understand correctly,

CVS anonymous access for 4.0 ??

2001-03-14 Thread Martin Rode
What am I missing? cvs login had succeded. [martin@bart work]$ cvs -d :pserver:[EMAIL PROTECTED]:/cvsroot/mysql co mysql-4.0 cvs server: Updating mysql-4.0 cvs [server aborted]: cannot stat /home/cvs/locks-master: No such file or directory cvs [server aborted]: cannot stat

Working with UltraDev

2001-03-14 Thread Wilmar Pérez
Hello guys Does anyone ever work with Macromedia Dreamweaver Ultradev 4.0 and MySQL? I've just started a project and would like to work with MySQL on a RH6.2 box. The goal is to have UltraDev easily working on a Windows PC but managing the data bases store on the RH box. I guess I must start

HOWTO: Get column types enum values using perl

2001-03-14 Thread Mark Worsdall
Hi, I posted before but the help did not yield any success, sorry but thanks. Any one else help? In message [EMAIL PROTECTED], Mark Worsdall [EMAIL PROTECTED] writes Hi, I am trying to read the field types (as well as 1 row of data and the field names), but I cannot seem to manage it. Any

Re: help-urgent

2001-03-14 Thread Roberto Meyer
Hello ramamurthy, rr hi, rr We are using mysql as back end in our server.We are getting an problem with Mysql .the problem is mysqld is going down wiht out any error messages.in the log file it has writted as mysql deamon rr ended no other messages is thr.but we are getting problmem recently

Installation Problem

2001-03-14 Thread Chris Lu
Hi: I am upgrading MySql from 3.22 to 3.23 on Sun solaris box. After download, unzip (GNU), and untar (GNUtar), I tried to configure and run it. It failed. Below is the message from error log. 010314 11:14:16 mysqld started ld.so.1:

INFO

2001-03-14 Thread GB Net
can I manage mysql server 3.23 on red hat linux 6.1 using a win32 client on win nt ? thank you in advance. regards. Andrea GIGLIOTTI GB Net S.n.c. Via Bagni Caldi, 11 55021 Bagni di Lucca (LU) Tel. 0583-805533 Fax 0583-807912 http://www.g-bnet.com

Re: In some circumstances it can be beneficial to split into two a table that is scanned very often

2001-03-14 Thread Dan Nelson
In the last episode (Mar 14), abdelhamid bettache said: "In some circumstances it can be beneficial to split into two a table that is scanned very often" I found these sentence in the mysql manual , section 12.3:Get your Data as small as possible Does every body know what are these

RE: use one database or many databases

2001-03-14 Thread James Blackwell
I have a similiar situation where I've got a huge database that maintains data for quite a few clients. Queries have gotten extremely sluggish. What I'm working on right now is to have a control database with a single table that contains a unique identifier for each client and a database

urgent reply expected!

2001-03-14 Thread DR. GNANASAMABANDAM
Dear Ruby, Thank you very much for your earlier response! We have downloaded the mm.mysql.jdbc driver as you have specified and placed it in the lib directory of Tomcat server! We tried placing the same in jdk and mysql lib directories too! Still we are not able to connect it! We are not clear as

RE: Full tables...

2001-03-14 Thread Quentin Bennett
Hi, The output from mysqladmin variables would be useful. Quentin -Original Message- From: Dave Camarillo [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 March 2001 7:42 a.m. To: [EMAIL PROTECTED] Subject: Full tables... Hello all, I've run into a minor problem with my schema/mysql.

RE: Full tables...w/ show variables

2001-03-14 Thread Dave Camarillo
Wow...thanks for the quick response... The mysql variables are: +-+---+ | Variable_name | Value | +-+---+ | ansi_mode |

Mysql.sock Question

2001-03-14 Thread Marcus Ouimet
I hate to ask this question but I have tried everything. I am installed mysql on a new server and everything seems to be OK except it never created mysql.sock? Here is how I installed it: cd mysql-3.23.29a-gamma/ groupadd mysql useradd -g mysql mysql ./configure

Re: use one database or many databases

2001-03-14 Thread Gerald L. Clark
Or, you could use one database, and lookup the clients table names, and use a merge table for reports. James Blackwell wrote: I have a similiar situation where I've got a huge database that maintains data for quite a few clients. Queries have gotten extremely sluggish. What I'm working

Re: In some circumstances it can be beneficial to split into two a table that is scanned very often

2001-03-14 Thread Bill Marrs
In the last episode (Mar 14), abdelhamid bettache said: "In some circumstances it can be beneficial to split into two a table that is scanned very often" I found these sentence in the mysql manual , section 12.3:Get your Data as small as possible Does every body know what are these

RE: Full tables...w/ show variables

2001-03-14 Thread Quentin Bennett
Hello again. A few thoughts - nothing certain, and all derived from the fine manual, which you have already read, I'm afraid: Are you issuing the SQL_BIG_TABLES=1 in the same connected session as the query? Is there enough space in '/var/tmp'? However, if that was filling up, mysqld would wait

Re: HOWTO: Get column types enum values using perl

2001-03-14 Thread Mark Worsdall
In message [EMAIL PROTECTED], [EMAIL PROTECTED] writes $sth-{TYPE} returns a reference to an array of types. $types = $sth-{TYPE} if ($$type[0] = Mysql::FIELD_TYPE_STRING) (I don't know about the Mysql::FIELD_TYPE_STRING, but $$type[0] is the type of the first field.) When I do this:- my

mysqldump Error

2001-03-14 Thread Joel Caturia
I'm trying to use mysqldump to dump a database (obviously). Here's the commandline I'm using: [root@fugu work]# mysqldump --tab=. wonderdesk mysqldump: Got error: 1: Can't create/write to file '/root/work/Calls.txt' (Errcode: 13) The interesting thing, is that is IS creating Calls.sql, but it

win to linux

2001-03-14 Thread rozakdemir
Hello, I am using MySQL on windows platform. How can I port mt datas from MySQL server on windows to MySQl server on Linux? Thanks for all.

Webmin

2001-03-14 Thread Charles L Hagen
Has anyone found a GUI for MySQL on a Linux box? I found Webmin, but it seems limited. Is there an HTML GUI for MySQL? -- Charles L. Hagen - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: setting simple mysqld options in /etc/my.cnf

2001-03-14 Thread Kyle Hayes
I've found that past versions of MySQL ship with a version of safe_mysqld that reads the config file itself and only passes on a few of the parameters. We had to rewrite our own version to allow mysqld to actually parse the stuff on its own. Note that the my.cnf file that ships often seems

Re: HOWTO: Get column types enum values using perl

2001-03-14 Thread Vivek Khera
"MW" == Mark Worsdall [EMAIL PROTECTED] writes: MW When I do this:- MW my $types = $sth-{TYPE}; MW # MW if ($$types[0] = Mysql::FIELD_TYPE_STRING) { MW print "Type is a SRINGBR"; MW } Perhaps you mean if ($$types[0] == Mysql::FIELD_TYPE_STRING) you are doing an assignment, not a

Re: win to linux

2001-03-14 Thread Steve Ruby
rozakdemir wrote: Hello, I am using MySQL on windows platform. How can I port mt datas from MySQL server on windows to MySQl server on Linux? Thanks for all. You should search the sarchives and manual, this is a very FAQ... tables extension is like .MY* you can just copy them, if not

Re: mysqldump Error

2001-03-14 Thread Joel Caturia
ah but I do.. Allow me to prove it.. drwxr-xr-x 4 root wheel 512 Mar 14 12:50 work [root@fugu work]# touch this_works [root@fugu work]# ls -la -rw-r--r-- 1 root wheel0 Mar 14 13:42 this_works And, as I stated before, the Calls.sql file IS being created in this same directory.

Re: Webmin

2001-03-14 Thread Adam Stein
Has anyone found a GUI for MySQL on a Linux box? I found Webmin, but it seems limited. Is there an HTML GUI for MySQL? You could try "MysqlTool". It's a Perl program. Haven't really used it yet, but it looks good. Adam -- Adam Stein @

Re: Webmin

2001-03-14 Thread Ray Zimmerman
Has anyone found a GUI for MySQL on a Linux box? I found Webmin, but it seems limited. Is there an HTML GUI for MySQL? Check out MysqlTool at ... http://dajoba.com/projects/mysqltool/ ... it's a web-based interface implemented in Perl. If you prefer one written in PHP, have a look

RE: mysqldump Error

2001-03-14 Thread Quentin Bennett
Hi, Error 13 is permissions. Your server has to have permission to write to the directory, and over-write any existing file of the same name. Regards Quentin -Original Message- From: Joel Caturia [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 March 2001 10:07 a.m. To: [EMAIL PROTECTED]

Re: win to linux

2001-03-14 Thread René Tegel
use ftp to copy your database/table files :) - Original Message - From: "rozakdemir" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 10:05 PM Subject: win to linux Hello, I am using MySQL on windows platform. How can I port mt datas from MySQL server on windows

RE: mysqldump Error

2001-03-14 Thread Quentin Bennett
Hi, But is your mysql server run by root, or, as advised, by 'mysql'? Quentin -Original Message- From: Joel Caturia [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 March 2001 10:56 a.m. To: Gerald L. Clark Cc: [EMAIL PROTECTED] Subject: Re: mysqldump Error ah but I do.. Allow me to

Re: use one database or many databases

2001-03-14 Thread Dave Hewlett
I've run into a situation where i need to split an enormous database (only say a million rows but oh so long possibly many K) Using JDBC and prepared statements this could be facilitated if we could have the driver implement a setSQL(int x, "--text--") function which could replace a '?'

C with embedded mysql

2001-03-14 Thread Ryan D'Souza
Hi, I am a newbie... so please excuse me if the question is a bit wacky ;-) I was trying to write a database system using C with embedded mysql.. could you please help me by providing me with any links to anysites where I can get help in the form of 1. Sample code. 2. Tutorial on how to do the

Re: mysqldump Error

2001-03-14 Thread Joel Caturia
ahhh.. ok, I understand.. So the moral of the story is the mysql process itself touches the local filesystem. It's NOT the UID of the person running the command that matters, it's who the daemon is running as. Hence the reason the help page says "this only works when running on the same machine

MySql connection failed in browser

2001-03-14 Thread Tim Czerlinsky
Hey everyone, I just went through a new setup of Information Resource Manager scripts under PHP 4.0.1p12-9 that work with MySql 3.23.22-6 under Apache 1.3.125-25, all of this stuff except the Resource Manager come standard with RedHat 7.0. After creating the database for the set of php

Re: How many rows does a table can hold?

2001-03-14 Thread Jeremy D. Zawodny
On Wed, Mar 14, 2001 at 07:19:24AM -0800, abdelhamid bettache wrote: I want to ask you : 1- How many rows does a mysql table can hold? Millions. Probably billions. I've heard of someone putting 2 billion rows in a table before (if memory serves). 2- I have to design a database for all

RE: win to linux

2001-03-14 Thread Brian Kaney
I don't think that works across platformsits better to use the mysqldump command. Brian -Original Message- From: René Tegel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 5:09 PM To: rozakdemir; [EMAIL PROTECTED] Subject: Re: win to linux use ftp to copy your

connection lost on long-distance connection

2001-03-14 Thread René Tegel
I've ran into some problems when connecting to a mysql server over a long-distance connection (i.e.: the internet). The first time a client reconnects from a idle connection this reconnect fails, only the second time it succeeds. The main problem is that i've written a win32 app that connects to

Re: apostrophe ....

2001-03-14 Thread Rolf Hopkins
- Original Message - From: "Ren Tegel" [EMAIL PROTECTED] To: "Rolf Hopkins" [EMAIL PROTECTED]; "Eric Fitzgerald" [EMAIL PROTECTED]; "Randy Johnson" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 18:48 Subject: Re: apostrophe tx Rolf! Yes, indeed. by

Re: Mysql.sock Question

2001-03-14 Thread Rolf Hopkins
- Original Message - From: "Marcus Ouimet" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 4:05 Subject: Mysql.sock Question I hate to ask this question but I have tried everything. I am installed mysql on a new server and everything seems to be OK except it

Re: apostrophe ....

2001-03-14 Thread René Tegel
Rolf, i asked my college "did you use the original ini" ? "yes, i did." he said, " i only changed some layout". for myself i changed some parameters on this .ini file like max execution time and max upload time, nothing more. excuse me for not verifying further but as far as i see this php.ini

Re: MySql connection failed in browser

2001-03-14 Thread Rolf Hopkins
Since you say you're new to this stuff, let's start with the very basics. RH7.0, I thought, was done poorly with many bugs. You can download their latest RPM patches from their ftp server which will fix up a lot of these bugs. With MySQL, my advice is to download the latest and greatest RPM

Re: am I alone? (scale)

2001-03-14 Thread Pete Harlan
We've had fairly bad luck with Linux 2.2.X and SMP for any kind of high-end system. The DAC 960 SCSI controllers proved to be fairly problematic in this environment. Sometimes updating the drivers helps. We have a couple of systems that run much better when we do not use one of the

Re: connection lost on long-distance connection

2001-03-14 Thread Boulat Khakimov
Hi, Here is the way I would fix that problem (assuming you're a programmer) write a simple function check_connection(MYSQL **conn) for example. that will issue a query "SELECT NOW()" to mysql, if that query fails that means connection to mySQL has gone away and the function has to reconnects

hunting down duplicate entries

2001-03-14 Thread Josh Burroughs
We recently moved our hardware inventory database off of access (yay!) over to mysql. During it's days as an access database it aquired a numbered of duplicate entries. In every case (or at least the ones I'm working on) the serial numbers will be the same but likely all other info will be

RE: hunting down duplicate entries

2001-03-14 Thread Cal Evans
Select serialNo, count(serialNo) serNoCount from table group by serialNo order by 2 desc This will give you a list of all the unique serial numbers in your table. The ones with serNoCount1 are your duplicates. Without the capability to do subselects (yes, we all know...it's coming in the

Re: hunting down duplicate entries

2001-03-14 Thread harm
On Wed, Mar 14, 2001 at 03:48:28PM -0900, Josh Burroughs wrote: We recently moved our hardware inventory database off of access (yay!) over to mysql. During it's days as an access database it aquired a numbered of duplicate entries. In every case (or at least the ones I'm working on) the

Re: connection lost on long-distance connection

2001-03-14 Thread René Tegel
well, i use mysql_query as ported from libmysql.dll function mysql_query(_mysql:pmysql;const query: pchar):integer;stdcall;external 'libmysql.dll'; this function is supposed to return non-zero on failure and zero on succeed ( includes select/update/delete/insert/show etc.etc). This function

Re: MySql connection failed in browser

2001-03-14 Thread Bill Marrs
I've been running Redhat 7.0 for 5 months now on my production server, haven't had any trouble with it. I had trouble with the rpms for 3.23.34 that were on mysql.com's download page. The server was getting intermittent signal 11's with blown stacks. I assume a shared library mismatch. My

Example DAO (not ADO)

2001-03-14 Thread Darlan Oliveira
Please example DAO!! ADO When you are coding with the ADO API and MyODBC you need to put attention in some default properties that aren't supported by the MySQL server. For example, using the CursorLocation Property as adUseServer will return for the RecordCount Property a result of -1. To

Data tool

2001-03-14 Thread WANG_KING
I want to load data to mysql. Does mysql has any tools like sqlload in oracle? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

RE: Very (excruciatingly) slow select

2001-03-14 Thread Tony Shiu
Hi Hannes Several approaches to achieve your work. One is upgrade your resource i.e. CPU, memory... I do not take this. Another is check all columns used inside WHERE clause whether they are indexed. If not, pls create indexes for them. it will definitely smooth better. Programmatically, I

RE: Very (excruciatingly) slow select

2001-03-14 Thread Tony Shiu
One more suggestion is, using LIKE to search (whatever your column is indexed or not) is definitely slow than using "=". I try it in 0.38 M records before. -Original Message- From: Tony Shiu [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 15, 2001 11:21 AM To: [EMAIL

connecting Microsoft Access to MySQL

2001-03-14 Thread Charles Cotton
The "trick" is that while an autoincrement field is a nice thing to have as a primary key, is to put a timestamp field in each MySQL table (in addition to the primary key). - Before posting, please check:

Re: Failover and Replication

2001-03-14 Thread Jeremy D. Zawodny
On Wed, Mar 14, 2001 at 09:10:42AM -0800, Bryan Coon wrote: We are implementing a linux cluster, and rather than get gouged by oracle (in performance and licensing) would much rather use MySQL. A common solution to a common problem, I suspect. If I understand correctly, replication

Re: MySQL takes too much memory

2001-03-14 Thread Jeremy D. Zawodny
On Wed, Mar 14, 2001 at 03:44:34PM +0700, Mohamad Ilhami wrote: Hi, after a few days, mysql take too much memory and sometimes causing swap memory exhausts. I'm sure that only one client accessing mysql server, but I see too many threads. So I shutdown MySQL periodically. I use

limiting, sql question

2001-03-14 Thread Maxim Maletsky
Hello, I have one SQL question: I do: SELECT geo_continents.name, geo_countries.name from geo_continents, geo_countries WHERE geo_continents.id=geo_countries.continent; what gives me: +---++ | name | name |

MySQL make install problem.

2001-03-14 Thread Eric Morgan
I configured and compiled mysql-3.23.34a without even a warning: ./configure --prefix=/usr/local/mysql-3.23.34a make but when I do a make install I get errors listed below. I included the mysqlbug output if needed below that. I dont know what the install is trying to do here (newbie :). I have

koi8_ru question

2001-03-14 Thread Serhiy Kuzhanov
Hello list! The question should be simple. Does koi8_ru stands for koi8 RUssian or is it koi8 Russian/Ukrainian. The reason I am asking is that I remember the days when RU was used for letter. But it does not seem to support Ukrainian characters. I could use koi8_ukr but I do not know if it will

Re: MySQL make install problem.

2001-03-14 Thread Eric Morgan
Yes, The prefix path I used below is the path to the source distribution. Should it not be? Eric Mohamad Ilhami wrote: On Wed, 14 Mar 2001, Eric Morgan wrote: I configured and compiled mysql-3.23.34a without even a warning: ./configure --prefix=/usr/local/mysql-3.23.34a Is Mysql