Support request from Progetto 2000 ID support 4300

2001-02-05 Thread Progetto 2000
Hi, I installed PHPMyAdmin to manage MySQL but when I try to run the script, after insert user and password, the error message below displayed: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /home/sites/site2/web/phpadmin/lib.inc.ph

Adding the offset to mysqlbinlog

2001-02-05 Thread smurf
>Description: Sometimes, when you get a resync error, you need to skip a particular update and restart with the next bit. >How-To-Repeat: Insert conflicting records and try to re-sync without deleting one. >Fix: Apply this patch. Index: noris.38/sql/mysqlbinlog.cc

Re: why mysql eat my memory over 1G?

2001-02-05 Thread Van
olivefan wrote: > > why mysql eat my memory over 1G?Please help me!Thank you!!! > > server1:DELL6300,4cpu,4G memory.solaris5.7 for X86 . > mysql start command:nohup /usr/local/bin/safe_mysqld -O key_buffer=128M -O >

WEB to remote MySql server

2001-02-05 Thread Jonor Lacuesta
Hello, I would just like to ask the list's members of this setup: We have rented a Win2000 web server in the US with a 50GB transfer/month in the internet. The server currently holds our site's asp web files, SMTP/POP server and MS Access database files. The Access files holds the list of us

Re: System Requirements...

2001-02-05 Thread Rolf Hopkins
It will run on most computers of today. Question is what system have you got/want, what are you going to use it for and what is the expected volume of information? - Original Message - From: "Vangipuram, Anand" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 06, 2001

Re: Insert into blob

2001-02-05 Thread Rolf Hopkins
There's a function in php that allows you to escape strings before it is submitted to mysql. Check it out in the PHP manual. - Original Message - From: "Rus" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, February 06, 2001 7:48 Subject: Re: Insert into bl

Re: mysql -u root WITHOUT password !

2001-02-05 Thread Rolf Hopkins
No! Check out skip grants in the manual. - Original Message - From: "Nicolas GREGOIRE" <[EMAIL PROTECTED]> To: "RENAULT Laurent" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 19:19 Subject: Re: mysql -u root WITHOUT password ! > > > RENAULT Laurent a écrit : >

Get 'yes', 'no', or 'either' query ?

2001-02-05 Thread Floyd Baker
Hi. Hey I have been using a query in a search with prioritized criteria. In five different qualification fields, the first one filled in would produce the specific search. Name, City, Zip, (C)enter or (I)ndividual... If name & city empty and zip filled in, all that zip would appear. No

slow queries with BLOBS

2001-02-05 Thread ai
>Description: Queries to a table with BLOBs are very slow. I query select id,name,lator,lonor,latpp,lonpp,width,height from segments order by name The table is defined as: create table segments ( id int not null auto_increment primary key, name char(100) unique, scale int not null, dp

why mysql eat my memory over 1G?

2001-02-05 Thread olivefan
why mysql eat my memory over 1G?Please help me!Thank you!!! server1:DELL6300,4cpu,4G memory.solaris5.7 for X86 . mysql start command:nohup /usr/local/bin/safe_mysqld -O key_buffer=128M -O table_cache=512 -O sort_b

Is it a bug???

2001-02-05 Thread Michael's Sasquatch
I have been using MySQL for ecommerce work for quite some time. One problem that just recently arose was a duplicate key error during db restoration. The culprit lies in a table which has an auto_incremented, not null defined integer field called "id". There is an entry which was adjusted,

any recommendations

2001-02-05 Thread Daniel Kirk
any recommendations for jdbc drivers running red hat? which version of red hat should i install - 6.2 or 7? thx for advice dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.

Replication info in master.info corrupted in database startup

2001-02-05 Thread Michael . Dean
>Description: Replication master info seems to get corrupted when the database is restarted after a shutdown master.info after shutdown master-bin.001 25699 master username password 3306 60 master.info after startup - note the blank line -

Re: Insert into blob

2001-02-05 Thread Rus
Check text for special symbols and use " in your query (f.e. ... blobfield="text") - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 06, 2001 2:14 AM Subject: Insert into blob > Hi, > > I am having some problems inserting data into a blob fie

Re: Simple question

2001-02-05 Thread kentj
A gui that works on the linux box is kmysql. Joel Holtzman wrote: > Hello, I always wanted a gui interface to use on my win 98 pc to connect > to mysql, and create/edit tables. However, i always get an access denied > error, saying I'm not allowed to connect to the mysql server. > > However,

Re: Re[2]: Serious MySQL internal deadlock

2001-02-05 Thread Andreas Steinmetz
Hi, unfortunately I can't set up a scenario that easily reproduces the problem. The last lockups happened on saturday and today (monday). What I can confirm is: 1. It doesn't seem to be a slave related problem. During the last two lockups I checked the master as well as the slave statuses, all we

Re: 16 Index Table Limit

2001-02-05 Thread Jim Ginn
Thanks! Jim Dan Nelson wrote: > > In the last episode (Feb 05), Jim Ginn said: > > Is there a way to define more than 16 btrees per table? Can this > > index limit be increased to 32 or more? It's a static database that > > is massively updated once or twice a year so update performance is > >

Insert into blob

2001-02-05 Thread Website4S
Hi, I am having some problems inserting data into a blob field, everything works fine but if I use any HTML and try to insert it, it doesn`t work. So in short is there something I should be doing to allow HTML to go into a text blob? I am using PHP if that helps. TIA Ade --

Re: 16 Index Table Limit

2001-02-05 Thread Dan Nelson
In the last episode (Feb 05), Jim Ginn said: > Is there a way to define more than 16 btrees per table? Can this > index limit be increased to 32 or more? It's a static database that > is massively updated once or twice a year so update performance is > not the issue, rather speed of queries. Th

update logs and locking

2001-02-05 Thread Hardy Merrill
Redhat 6.1 Linux MySQL 1.2215 I'm doing a mysqldump with --flush-logs, and mysql is getting the update logs confused - I tested this when there *were* updates going on at the time of the dump. The docs said that on Linux the default is --skip-locking - what can I do to solve this update log co

Re: query over CD-ROMs?

2001-02-05 Thread Steve Ruby
Kuokai Shyu wrote: > > Hi, > > Can MySQL do the queries on the databases stored in the CD-ROM? > For example, when switching data CD-ROMs, is it necessary to shutdown > mysql server, and restarting server after mounting another CD-ROM? > Thanks in advance. > > Sincerely, > > Kuokai I

query over CD-ROMs?

2001-02-05 Thread Kuokai Shyu
Hi, Can MySQL do the queries on the databases stored in the CD-ROM? For example, when switching data CD-ROMs, is it necessary to shutdown mysql server, and restarting server after mounting another CD-ROM? Thanks in advance. Sincerely, Kuokai

Query Help

2001-02-05 Thread twilight
Hello, I have a table of 26 million rows that I need to query. The table is a keywords database with the keyword and a pointer to what page it came off of. (pageid|keyword) The problem is that when I use the following query is the group by make the query take about 14 seconds to do. However, if I

Re: Simple question

2001-02-05 Thread Tõnu Samuel
Joel Holtzman wrote: > > Hello, I always wanted a gui interface to use on my win 98 pc to connect to mysql, >and create/edit tables. However, i always get an access denied error, saying I'm not >allowed to connect to the mysql server. > > However, via telnet, I am fine. By default MySQL serve

Re: Arabic character set

2001-02-05 Thread Eran Boudjnah
Hi, am having the exact same problem with Hebrew... Best regards, -Eran medianova wrote: > Hi, > > we are setting up an Arabic web site using PHP with MySQL 3.23.22. > Our problem is that we can not sort data correctly when retreiving it > from Arabic text fields. This seems to be a character

Re: need some help here...

2001-02-05 Thread Hardy Merrill
Just my opinion, but I prefer numeric keys that the users *can't* see, to alpha keys that the users can see: 1. numeric keys are faster 2. using numeric keys that the user can't see allows you to open up(for UPDATE) ALL the fields that the user can see including a field like School N

16 Index Table Limit

2001-02-05 Thread Jim Ginn
Is there a way to define more than 16 btrees per table? Can this index limit be increased to 32 or more? It's a static database that is massively updated once or twice a year so update performance is not the issue, rather speed of queries. Please respond to [EMAIL PROTECTED] because I am not su

Re: Newbit: ADO and MySQL/MyODBC

2001-02-05 Thread Tim Bunce
On Mon, Feb 05, 2001 at 01:36:50PM -0700, Steve Ruby wrote: > Henrik Lebtien Mohr wrote: > > > > Hi there > > > > I use ASP and ADO 2.5 to access the data in my MySQL RDBMS. > > I get an error "Multiple-step error" when I try to update a recordset like > > the following: > > > > with rs > >

Problem with update logging under Solaris

2001-02-05 Thread Kent Hoover
That log rotation script smells like the culprit to me. Exactly what is it doing? If it is clipping the file in a way that doesn't let MySQL reset the file pointer when you do the flush logs command, you could be max-ing the file out to its ulimit. Cheers, Kent

Re: Port 3306

2001-02-05 Thread Eran Boudjnah
Would be easier to play with the grant tables and allow access from localhost only... Best regards, -Eran "johnny p." wrote: > Anyone know a good ipchains rule to close this port to the outside > world?  I haven't dabbled in forewalling yet... > > i use Immunix, a RedHat 6.2 derivative.  I reco

Re: Multiple AND on many-many-table.

2001-02-05 Thread Steve Ruby
Steve Ruby wrote: > > Does anybody know what is the fastest way to run a large multiple > AND type query on a many-many table and the least memory hungry. > > For example if I have > create table test (id int, value int); > > which has many-to-many on id, and value > > I want to do a selec

Simple question

2001-02-05 Thread Joel Holtzman
Hello, I always wanted a gui interface to use on my win 98 pc to connect to mysql, and create/edit tables. However, i always get an access denied error, saying I'm not allowed to connect to the mysql server. However, via telnet, I am fine. The support for the software sucks, and all the other

update log sequence

2001-02-05 Thread Hardy Merrill
I'm running mysql with --log-update=update_log with no extension, so every time I flush the logs I get the next sequential number appended as an extension to the new update_log file. If I flush the logs regularly every day, that sequence number will continue to grow - is there any way to reset t

SV: query questions

2001-02-05 Thread Jarmo Paavilainen
Hi, ... > 1. COUNT(*) Is there anything wrong with using > SELECT COUNT(*) > FROM bleah > or should I be using > SELECT COUNT(someField) > FROM bleah COUNT(*) might be faster. Its possible that it reads the count from internal table while COUNT(someField) needs to make a real que

Re: Port 3306

2001-02-05 Thread btjones
Add --skip-networking to your my.cnf file or pass it on the command line to safe_mysqld. This will stop ALL TCP connections to mySQL, so you'll have to use the server name "localhost" in your connection strings to force use of the unix socket. If your installation requires MIT-threads, this is

RE: Suggestion for new linux box

2001-02-05 Thread johnny p.
If you can wait a few more days, SuSE 7.1 with the new kernel will be out, Feb 12 on their site. This is a pretty good ditro. I like Immunix, a red hat distro with stackguard protection. there is a 650 MB ISO file available for download. www.immunix.org. I believe you can order the CD, too.

RE: Port 3306

2001-02-05 Thread johnny p.
Anyone know a good ipchains rule to close this port to the outside world? I haven't dabbled in forewalling yet... i use Immunix, a RedHat 6.2 derivative. I recommend it if you like RedHat: www.immunix.org. Has stack overflow protection so those pesky overflow bugs in wu-ftp no longer affect yo

Re: need some help here...

2001-02-05 Thread John Jensen
Think of the tables in your database as linked sets. I have a college database where school description as info associated in three other tables, allowing one school description, one or more contacts, requirements for one or more programs, and each program has one or more degrees associated, i

Re: Port 3306

2001-02-05 Thread Mikel King
fwcmd=/sbin/ipfw<... on BSD usage like so ${FWCMD} add deny all from any to any via ${oif} Have to make a new kernel to support ipfw though cheers, mikel [EMAIL PROTECTED] wrote: > What OS? If Linux or *BSD, they have firewall software (ipchains on linux, > don't recall what i

query questions

2001-02-05 Thread Anna
Hi all, I have a few questions about query structure. 1. COUNT(*) Is there anything wrong with using SELECT COUNT(*) FROM bleah or should I be using SELECT COUNT(someField) FROM bleah 2. Is two queries a lot less efficient than one? Background: I have a table with about 20 f

UPDATE using other table

2001-02-05 Thread Laurent Oget
Is there a way to update a column of a table using values from other tables something like update table1 set table1.column1=table2.column1 where table1.column2=table2.column1 -- Laurent Oget, Ph.D. [EMAIL PROTECTED] Senior Engineer Zvolve Systems Inc http://zvolve.com Cherche

Re: One connection between Mod_Perl & Mysql

2001-02-05 Thread Eran Boudjnah
Thanks for the reply... That's exactly what I want to do... I may have not made myself clear, though... I couldn't pull the Apache::DBI thingie off... Best regards, -Eran Harald Fuchs wrote: > > Hi, > > am running Apache 1.3.14 on RedHat 6.2. I've also installed the most > > recent Mod_Perl an

Re: Port 3306

2001-02-05 Thread Kevin . Brown
What OS? If Linux or *BSD, they have firewall software (ipchains on linux, don't recall what it is on BSD) > I'm new to MySQL, this may be a simple question; > > How do I turn off listen on port 3306?, I don't want to serve MySQL on the > net, I only need it for local > (server side) access. >

Port 3306

2001-02-05 Thread Gus Constan
I'm new to MySQL, this may be a simple question; How do I turn off listen on port 3306?, I don't want to serve MySQL on the net, I only need it for local (server side) access. Can someone point to docs or notes dealing with this issue. thanks, Gus Constan -

Re: how to install mysql on Linux(debian) (fwd)

2001-02-05 Thread William R. Mussatto
this came up on the lists a while ago. Asked our sysadmin to answer it so it took a while sorry. Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 -- Forwarded message -- Date: Mon, 5 Feb 2001 11:26:57 -0800 From: Michael J. Mic

Re: Newbit: ADO and MySQL/MyODBC

2001-02-05 Thread Steve Ruby
Henrik Lebtien Mohr wrote: > > Hi there > > I use ASP and ADO 2.5 to access the data in my MySQL RDBMS. > I get an error "Multiple-step error" when I try to update a recordset like > the following: > > with rs > .fields("date") = null 'timestamp datatype > .fields("nOnline") = .

Restarting a slave didn't work

2001-02-05 Thread smurf
>Description: Restarting doesn't connect to the master. >How-To-Repeat: mysql restart. show slave status. Read server log. >Fix: The master's file name still had a newline. Index: noris.38/sql/slave.cc --- noris.38/sql/slave.cc Thu, 25 Jan 2001 07:35:47 +0100 smurf (datab

[What is the password for standard/gerneric install]

2001-02-05 Thread dlewis
>Description: Trying to determine the default password(s) for user=> root and user -> mysql this is a generic install i.e. following the instructions in the mysql/INSTALL-BINARY...it states to be certain to change the root password using the commands ./bin/mysqladmin -u root -p pass

Re: Suggestion for new linux box

2001-02-05 Thread John Hinsley
Chuck Carson <[EMAIL PROTECTED]> wrote: > > > > Without a doubt SuSE linux. I'd second that. 7.1 is either out or due out any day now with a choice of kernels (I'd be inclined to put 2.4 on a development box). I've found that the (free for 90 days) support simply gets better, as does the

Re: newbie: problem with "select in (select)"

2001-02-05 Thread René Tegel
go to www.codecity.com mysql just does not support in :((( it's good, but far for 'sql compliant'... gl rene - Original Message - From: "Henrik Lebtien Mohr" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 7:46 PM Subject: newbie: problem with "

Re: Setting up data model

2001-02-05 Thread Kevin O
>If you mean you link table techadress to table domains, and then billing & >admin adress to techadress, then i think you'r odd.. >You should learn some about 'normalization', look for it on the web or in a >book. > No, I did not mean to link the tables like that. I simply wanted the Domain t

mysqld (3.23.30/Solaris) in a loop while loading/indexing LARGE dataset

2001-02-05 Thread Suresh Srinivasan
Hi all, The problem is I am loading and indexing a fairly large dataset (~2GB) and the mysqld process seems to go into a seemingly infinite loop after loading and indexing a good bit of the data. Unfortunately I don't know enough about MySQL to be able to debug the situation better, or provide y

RE: Can anyone do this ?

2001-02-05 Thread Jeff Sorenson
Ooops, I forgot to notice that you required consequetive days. This query works for me: select T1.*, T2.*, count(T2.id) as c, concat(T2.id,T2.d) as x from table1 as T1, table2 as T2, table 2 as T3 where T1.id=T2.id and T2.id=T3.id and T2.d>='2001-02-04' and T2.d<='2001-02-06' and T3.d>='2001-0

newbie: problem with "select in (select)"

2001-02-05 Thread Henrik Lebtien Mohr
Hi again If I try the following on my MySQL DB, I get an error: select user_id from tblUser where user_id in (select user_id from tblUserLink where group_id = xx) xx is an integer defining which group_id we want info on (mediumint(9)) user_id in tblUser and tblUserLink is also defined as medium

Install of mysql on AIX fails due to missing member shr.o in module libz.a

2001-02-05 Thread NELSON, GLEN
> -Original Message- > From: NELSON, GLEN > Sent: Tuesday, January 30, 2001 2:10 PM > To: '[EMAIL PROTECTED]' > Subject: Install of mysql on AIX fails due to missing member shr.o in > module libz.a > > From: t199k01 > To: [EMAIL PROTECTED] > Subject: Install of mysql o

Re: Problem with reinstalling

2001-02-05 Thread Miguel Angel Solórzano
At 23:15 04/02/2001, Lars-Olof Albertson wrote: Hi! The scenario of your problem is: - When you remove the installation of MySQL using the Control Panel Add/Remove, the uninstall program doesn't remove the Service. When you try to install the service again you receive the error message because a

Re: Setting up data model

2001-02-05 Thread René Tegel
If you mean you link table techadress to table domains, and then billing & admin adress to techadress, then i think you'r odd.. You should learn some about 'normalization', look for it on the web or in a book. I'd suggest something like this: Customer client_id clientaddr_id ..details... D

Newbit: ADO and MySQL/MyODBC

2001-02-05 Thread Henrik Lebtien Mohr
Hi there I use ASP and ADO 2.5 to access the data in my MySQL RDBMS. I get an error "Multiple-step error" when I try to update a recordset like the following: with rs .fields("date") = null 'timestamp datatype .fields("nOnline") = .fields("nOnline") + 1 'int datatype .upd

[ new install via script can not creat interrupt-thread]

2001-02-05 Thread Scott C Strecker
>Description: When I try to run the install-db script I get an error stating that the script Can't create interrupt-thread. I can get the script to run as root. We are installing into /usr/local/mysql as per the instructions. The script suggest the

Re: blob and replication questions

2001-02-05 Thread Jeremy D. Zawodny
On Mon, Feb 05, 2001 at 03:58:37PM +0100, Lukas Gruber wrote: > > > chapter 11: "replication" doesnt mention any way of scheduling > replication. it says after one configured and restarted the slave > server it will connect to the master and then start replication. is > there a way to schedule

Installing binary distributions in non- standard locations.

2001-02-05 Thread Summanen,Jack
I have been trying to install 1.3.23.29-solaris 2.6 binary distribution. But as a neophyte to MySQL I cannot seem to start the client software. I have varied from the standard procedure (By necessity) to install it to a non-standard directory (/ss/mysql) so I have had to add the --defaults-file

Re: need some help here...

2001-02-05 Thread Atle Veka
Hello, I tend to do either what Hardy suggested depending on the needs of your database. If the trouble ticket table is to be associated with both faculty and staff, and that fac/staff can have more than one trouble ticket I like to create a relational table. To do this you create a separate ta

RE: GROUPing question

2001-02-05 Thread Ung, Seng
Bob: In case if you don't know this just want you to know... Out of all the messages that I received, I only read your and saved it for the future. thank you.. seng - Before posting, please check: http://www.mysql.com/m

Setting up data model

2001-02-05 Thread Kevin O
Hello all, I've got a few questions about setting up a data model for a database I'm creating. I want to set it up to be most efficient and would like input from anyone that has the time. I'm setting up your basic customer database, except I'd like to allow for a customer within a customer o

MyODBC and SQL_BIT type

2001-02-05 Thread Eric Fitzgerald
Let's try this one more time, just in case it got scimmed over :) Hello everyone. I'm hoping the developer of MyODBC hangs out on this list, but here goes. I browsed through the sources a bit, and I noticed several places where you are mapping SQL_BIT type to TinyINT. It appears this is only a

Re: Asking help about SQL(Select)

2001-02-05 Thread Rus
select name,(Cashincome+transaction_income) as Income from TableA; - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 5:04 PM Subject: Asking help about SQL(Select) Dear All, Sorry for bothering everyone. I am just working with MyS

Re: Increasing queries speed?

2001-02-05 Thread scott
Yeah, Try adding an index to idtxt, that should speed the query in your example. Just keep adding indexes to columns commonly used in your where clause. > Hi, > > I'm handling a database which has about 2 million records. > > When I execute a query such as: "select * from megasize where > id

Re: One connection between Mod_Perl & Mysql

2001-02-05 Thread Harald Fuchs
> Hi, > am running Apache 1.3.14 on RedHat 6.2. I've also installed the most > recent Mod_Perl and I'm wokring on MySQL 3.23.29a. > For some reason, I can't create one stable connection between the Perl > session and the MySQL. I read it is possible, and tried following > instructions, but alas, n

Re: need some help here...

2001-02-05 Thread Hardy Merrill
Try going to www.mysql.com and search for "foreign key" in the search box - I found 28 matches - here are the 1st 3 matches: 1. MySQL Manual | 5.4.5 Foreign Keys [4] 2. MySQL Manual | 5.4.5.1 Reasons NOT to Use Foreign Keys constraints [4] 3. MySQL Manual | 9.3.6 Using Foreign Keys [4]

System Requirements...

2001-02-05 Thread Vangipuram, Anand
> What are the system requirements for installing mysql? > > Anand Vangipuram > 414-566-6701 > This message has been scanned for viruses with Trend Micro's Interscan VirusWall. -

character sets error

2001-02-05 Thread TM Safar Tibor Leo
Hi, I work under WinNT with MySQLODBC cilent, and the mySQL server is installed to the linux server. I receive an error message: 'can't initialize character set 21 (path: c:\mysql\\share\charsets)'. I use the hungarian character set, and I try to put in the showed location the hungarian.conf fi

Re: Can anyone do this ?

2001-02-05 Thread Rus
Hi. Ok, i get it. Here is one method, but i'm afraid it may not work in mysql. select t1.name,count(*) as nb from Table1 t1, Table2 t2 WHERE t2.date BETWEEN "2001-02-04" AND "2001-02-06" AND t1.id=t2.table1_id AND t2.no_of_Items >=1 AND nb = (DAYOFYEAR("2001-02-06")-DAYOFYEAR("2001-02-04")) GROU

Re: usage of "distinct" in a table join query?

2001-02-05 Thread Rus
Have you try GROUP BY? - Original Message - From: Marc Swanson <[EMAIL PROTECTED]> To: mysql list <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 9:32 AM Subject: usage of "distinct" in a table join query? > Hello, > > I am trying to craft a query that will allow me to retrieve trul

RE: need some help here...

2001-02-05 Thread Cal Evans
MySQl does not support FK relationship constraints. meaning that if you put a value in a FK, it won't automatically check to make sure it's a valid value in the related table. You can, however use FK's. That is how you should related your tables. It is up to you, the developer, to make sure that n

Multiple AND on many-many-table.

2001-02-05 Thread Steve Ruby
Does anybody know what is the fastest way to run a large multiple AND type query on a many-many table and the least memory hungry. For example if I have create table test (id int, value int); which has many-to-many on id, and value I want to do a select like select id from test where id

RE: Update: Status of MySQL 4.0/Innobase/trx & row level locks

2001-02-05 Thread Heikki Tuuri
Hi Robin! Innobase and Gemini are not linked, except that both will run under MySQL. MySQL already offers transaction support in the form of Berkeley DB tables. Berkeley DB has only page level locking, while Gemini and Innobase provide row level locks. In addition, Innobase has a consistent non-

character sets error

2001-02-05 Thread TM Safar Tibor Leo
I work under WinNT with MySQLODBC cilent, and the mySQL server is installed to the linux server. I receive an error message: 'can't initialize character set 21 (path: c:\mysql\\share\charsets)'. I use the hungarian character set, and I try to put in the showed location the hungarian.conf file bu

One connection between Mod_Perl & Mysql

2001-02-05 Thread Eran Boudjnah
Hi, am running Apache 1.3.14 on RedHat 6.2. I've also installed the most recent Mod_Perl and I'm wokring on MySQL 3.23.29a. For some reason, I can't create one stable connection between the Perl session and the MySQL. I read it is possible, and tried following instructions, but alas, nothing seem

need some help here...

2001-02-05 Thread Chris Toth
I'm having a extremely hard time grasping the concept of multiple tables. So far, I've been using just one table when designing a database. But now I have to design a database for a trouble-ticket system for our department. I've written out the design of the tables, but the part I don't understa

Re: How do I Move Directories

2001-02-05 Thread Gerald L. Clark
You should have run install_db --user=mysql Is the mysql directory in /dbshare owned by mysql ? Are the permissions 775 ? Does mysql own the files in /dbshare/mysql ? kentj wrote: > > dbshare is owned by mysql with group deamon > and I have run install_db > > "Gerald L. Clark" wrote: > > > ken

RE: [OFF] URL of e-business websites that use MySQL/PHP4/Apache

2001-02-05 Thread Cal Evans
I can't give you a URL but I can give you a testimonial. I spent 5 years doing ASP development against a M$/$QL server. I've been doing PHP/MySQL now for 6 months and hope I never have to go back. My main client has a small site with about 2,000 catalog items in the MS/SQL database and another 1

Re: download 3.23.32

2001-02-05 Thread Sinisa Milivojevic
Alan Ronald writes: > Hi > > we are having problem downloading MySQL 3.23.32 from your site. the error that we >constantly get when trying to open the file is unable to unzip does not appear to be >a valid archive. any suggestions. > > Kind regards > > Alan Ronald > ---

Re: How do I Move Directories

2001-02-05 Thread kentj
dbshare is owned by mysql with group deamon and I have run install_db Jody Williams wrote: > Did you run the script, mysql_install_db? > > kentj wrote: > > > > Platform Suse 7.0, > > AMD 450 KIII+, > > 128MB Ram > > > > Linux on 10 Gig system harddrive > > with 45 Gig additional drive mounted a

Re: How do I Move Directories

2001-02-05 Thread kentj
dbshare is owned by mysql with group deamon and I have run install_db "Gerald L. Clark" wrote: > kentj wrote: > > > > Platform Suse 7.0, > > AMD 450 KIII+, > > 128MB Ram > > > > Linux on 10 Gig system harddrive > > with 45 Gig additional drive mounted as /dbshare. > > > > I have created a symbo

Re: a user feedback about WinMySQLadmin 1.0

2001-02-05 Thread Sinisa Milivojevic
bozo writes: > > To whom it mat concern, > > Because the address ([EMAIL PROTECTED]) has a problem, i had to send > this mail > to you. The message turning back to me with my mail is; > > Subject: > Returned mail: Service unavailable >Date: > Tue, 30 Jan 2001

Re: How do I Move Directories

2001-02-05 Thread kentj
dbshare is owned by mysql with group deamon and I have run install_db "Gerald L. Clark" wrote: > kentj wrote: > > > > Platform Suse 7.0, > > AMD 450 KIII+, > > 128MB Ram > > > > Linux on 10 Gig system harddrive > > with 45 Gig additional drive mounted as /dbshare. > > > > I have created a symbol

a user feedback about WinMySQLadmin 1.0

2001-02-05 Thread bozo
To whom it mat concern, Because the address ([EMAIL PROTECTED]) has a problem, i had to send this mail to you. The message turning back to me with my mail is; Subject: Returned mail: Service unavailable Date: Tue, 30 Jan 2001 23:36:27 +0100 From: Mail Delivery

Re: [OFF] URL of e-business websites that use MySQL/PHP4/Apache

2001-02-05 Thread Billy Harvey
> I've some troubles with a competitor that says to my client that an > Apache/PHP4/MySQL solution on > Linux is unable to produce an e-commerce website. This person > proposal is ASP/M$ SQLServer on an NT 4 Server... > > Can you send me some URLs that illustrate the ability to an > Apa

RE: Suggestion for new linux box

2001-02-05 Thread Chuck Carson
Without a doubt SuSE linux. It is quickly becoming the most stable linux platform and has been blessed by Oracle as the most stable linux distrubtion. I have used all distributions and starting using linux back in the day when you had to compile your first kernel out of the box (like 0.97 I think

Re: About reserved words: mySQL's dirty little secret

2001-02-05 Thread Paul DuBois
At 9:25 AM -0500 2/5/01, Ken Menzel wrote: >Hi Paul, >Will we see a new version of your VERY excellent book with MySQL >4.0? >Ken I hope so, but I need to finish the projects I'm working on now, and I'm also waiting until 4.0 becomes more mature. Right now it's still in the very early stages

Re: [OFF] URL of e-business websites that use MySQL/PHP4/Apache

2001-02-05 Thread Verle Harrison
Dear Stephane Pinel: We have been using Apache/PHP3-PHP4/MySQL/FreeBSD for more than two years selling batteries for American Power Conversion UPS's and other batteries. The box, Apache and MySQL have now been up for more than 275 days and works really well. See it at http://batterywholesale.

Re: About reserved words: mySQL's dirty little secret

2001-02-05 Thread Paul DuBois
At 7:39 PM -0700 2/4/01, Colin Faber wrote: >Paul I expect to see documentation append to the copy of your book I bought 8 >months ago ;-) Do you prefer tape or staples? >Paul DuBois wrote: > >> On Sun, Feb 04, 2001 at 11:32:42PM -0200, Fábio Ottolini wrote: >> > Paul, >> > >> > Tomorrow th

download 3.23.32

2001-02-05 Thread Alan Ronald
Hi we are having problem downloading MySQL 3.23.32 from your site. the error that we constantly get when trying to open the file is unable to unzip does not appear to be a valid archive. any suggestions. Kind regards Alan Ronald ---

blob and replication questions

2001-02-05 Thread Lukas Gruber
hi list, i am new to mysql. i have read through the reference-manual but still there are some things i could not answer myself. please help, many thanks in advance. --- mysql-reference-manual describes longblob as a blob column with a maximum length of 4294967295 characters but also says that o

Re: Problem using COUNT & DISTINCT together

2001-02-05 Thread Gerald L. Clark
Check the docs to see when count distinct() was added. It is not in my 3.22.24, but is in my 3.23 Web Depressed wrote: > > Hi, > Woh ! This is very strange. Any ideas ? > > mysql> SELECT * FROM Table2; > ++-+---+ > | date | no_of_items | table1_id | > +---

[OFF] URL of e-business websites that use MySQL/PHP4/Apache

2001-02-05 Thread Stephane Pinel
I've some troubles with a competitor that says to my client that an Apache/PHP4/MySQL solution on Linux is unable to produce an e-commerce website. This person proposal is ASP/M$ SQLServer on an NT 4 Server... Can you send me some URLs that illustrate the ability to an Apache/PHP4/MySQL platfo

Re: BIG! bug in replication

2001-02-05 Thread Gerald L. Clark
Well, your version is 5 versions old. A lot of replication fixes have been applied since then. Try compiling the current version. root wrote: > > >Description: > As i wrote before, there's a bug with the replication in mysql. If the server is >once stopped, it will not read properly the informa

Re: About reserved words: mySQL's dirty little secret

2001-02-05 Thread Ken Menzel
Hi Paul, Will we see a new version of your VERY excellent book with MySQL 4.0? Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Rick Pasotto" <[EMAIL PROT

Re: MySQL constantly crash on BLOB insertions...

2001-02-05 Thread Jani Tolonen
Huang-Ming writes: Hi! I just saw this question un-answered, so in case you already got a private answer, please just ignore. > hi Tim, > > thanks for the prompt response which is hard to be seen with Oracle > and Microsoft. > > sorry, i should have had studied hard the manual a year >

Re: How do I Move Directories

2001-02-05 Thread Gerald L. Clark
kentj wrote: > > Platform Suse 7.0, > AMD 450 KIII+, > 128MB Ram > > Linux on 10 Gig system harddrive > with 45 Gig additional drive mounted as /dbshare. > > I have created a symbolic link in /var/lib of mysql-> /dbshare. > > then > > RPM -Uhv --force MySQL*-3.23.32-1.i386.rpm to install the

  1   2   >