7241 Indexes on columns that are declared differently?

The MySQL online manual says that MySQL cannot use indexes efficiently unless the columns have the same type and the same length. I can see no release notes that this problem has been fixed. My question: Is this still a problem? Here is the extract from the latest manual: 7.29 EXPLAIN Syntax (G

Re: mixed up variables || solution found

Hi, A better solution would be to simply use the fetchrow_hashref() method. i.e.: while(my $ref = $sth->fetchrow_hashref()){ print "$ref->{my_column}\n"; } Much cleaner and easier to manage. etc. I've found this way much easier to manage than a huge list of variables. Sven Bentl

Replication problem

Hi, I have short question ... my mysql daemon sometimes restarted ... and the error message like this : 020429 11:19:36 Slave: connected to master '[EMAIL PROTECTED]:3306', replica tion started in log 'austria_replication.048' at position 95670800 mysqld got signal 11; This could be because

Re: mixed up variables || solution found

Hi guys, just found a way that works, though it's not very elegant. (see below) and I do not know why it didn't work... Although it's working now, I'd still appreciate your comments. Regards, Sven code: while ( my ( $u_id, $u_surname, $u_name, $u_rank, $u_cname, $u_caddress, $u

Re: MySQL database files

they r the binary log files... Ritu On Tue, 14 May 2002, Augey Mikus wrote: > what are the -bin.001 002 003 etc.. files in the /var > directory? On my system they range in size from bytes to gigs. What > are they and can they be cleaned? > > > Augey > > > > ---

Re: MySQL database files

On Tue, 14 May 2002 18:49:48 -0400 Augey Mikus <[EMAIL PROTECTED]> wrote: > what are the -bin.001 002 003 etc.. files in the /var > directory? On my system they range in size from bytes to gigs. What > are they and can they be cleaned? it's mysql binary log file ... if you don't need the fil

Re: SQL root deleted.. ;-(

On Wed, 15 May 2002 01:33:47 +0200 "Schoenland, Daniel \(intern\) im Auftrag von Schoenland, Daniel \(extern\)" <[EMAIL PROTECTED]> wrote: > Hi, > > Well, I am new to the list.. so if i ask something stupid, just slap me > on the back of my head, k? =) > > I was playing a little with my phpmy

mixed up variables

Hi! I'm using the code below to fetch data from mysql, but when I print iit out, several variables are always mixed up. For example $u_course has the value of membership_paid, membership has the values of pcont. Can anybody help me figure out how to correct that? Thank you for your help. sve

Re: Making UPDATE return the no. of rows matched [from Perl]

- Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "rory oconnor" <[EMAIL PROTECTED]> Cc: "Rune Steinseth" <[EMAIL PROTECTED]>; "mysql list (choose midget)" <[EMAIL PROTECTED]> Sent: Tuesday, May 14, 2002 11:45 AM Subject: Re: Making UPDATE return the no. of rows matched [fr

Yikes :)

FYI, I just added "skip-bdb" to /etc/my.inf, and restarted mysqld. It went from occupying a whopping permanent 28 MB, to a mere 12 MB! :) - Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Performance Tuning?

Devon Harding - GTHLA wrote: >Where can I find some info on mysql performance tuning? > > http://www.mysql.com/doc/M/y/MySQL_Optimisation.html -myk - Before posting, please check: http://www.mysql.com/manual.php (the m

gcc for newer mysql versions - what's needed exactly ?

Hi all: Can someone (who knows this sort of thing) give a layman's introduction to the interplay between various gcc versions and various mysql versions (3.49, 3.50, 4.01 etc) ? I have some linux boxes and don't really want to have to install/use gcc 3.x (because then I have the hassle of multi

Re: query for search on mysql database

Thanks for the "thinking through this" exercise. I solved my problem (and a couple of others) with your help and some additional sweat. Mike - Original Message - From: "Nick Stuart" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 14, 2002 5:37 PM Subject: Re: query for s

SQL root deleted.. ;-(

Hi, Well, I am new to the list.. so if i ask something stupid, just slap me on the back of my head, k? =) I was playing a little with my phpmyadmin and deleted user root. Now I don't get access anymore.. Is there any command like mysqladmin add user root again -f -and -shut up? (root is not a

Re: Massive Research Data

The file size limits are imposed by the operating system, so one thing you might consider is some of the linux filesystems that do not have that limitation, (IIRC, XFS doesn't have that limit), or the use of a solaris machine, which (again, IIRC :)) doesn't have that limitation, either. Others

MS ADO (VB6.0) Problem with Updates

Hi all, I use MS VB6 and ADO to access my MySQL-Server. dim rs as new adodb.recordset rs.activeconnection = ConnectionObject rs.curserlocation = aduseclient rs.cursertype = adopenkeyset rs.source = "select * from TABLE where ID = " & id rs.open rs!FIELD1 = "VALUE" ... rs.update ... ERROR: Row ca

Massive Research Data

Some background... We have Objects r1, r2 ... r1600 Which each have (~1600) regions d1, d2 ... d500 Which each have (~500) datapoints So, roughly we have around 786,000 datapoints on a given object. Typically, we might take 15 or so regions and take data from each of their d

Re: MySQL load problems - gcc-2.96?

[EMAIL PROTECTED] (Trond Eivind Glomsrød) writes: > FWIW, reproducible testcases are good... all complex software products > have bugs (MySQL, gcc 2.95.x, gcc 2.96RH, gcc 3.0.x, egcs), often in > interaction with oneanother (e.g. timing/locking issues), so > reproducible testcases are a necessity

MySQL database files

what are the -bin.001 002 003 etc.. files in the /var directory? On my system they range in size from bytes to gigs. What are they and can they be cleaned? Augey - Before posting, please check: http://www.mysql.com/man

Large tables on FreeBSD

Hello, I need to create a table that is around 15 GB on a FreeBSD 4.5RELEASE system. I compiled mysql-3.23.49 without any extraneous flags such as (--disable-largefile) I use mysqlimport to import the table from a flatfile which is about 9GB. I watch the .MYD file grow to about 4.2 GB and stop

builidng mysql-4.0.1-alpha

Hi all, I am attempting to build mysql-4.0.1-alpha on an HP-UX 11.00 box because the binary I installed worked, but I couldnet connect to the database by typing in a password at the prompt, I had to actually pass it on the command line. I figured there might be a few other odd behaviors that wo

LINK2001, I need help

I desperately need to find a solution to this problem: Winnt 4,0, service pack 6.0; Visual C++;mysql-max-3.23.49-win binary. my.ini File: [mysqld] basedir=D:/mysql datadir=D:/mysql/data 1.-On prompt: D:\mysql\bin>mysqld-nt --install the current server installed: ...

Performance Tuning?

Where can I find some info on mysql performance tuning? _ Devon Harding System Administrator Gilat Latin America 954-858-1600 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manua

LINK2001, I need help

I desperately need to find a solution to this problem: Winnt 4,0, service pack 6.0; Visual C++;mysql-max-3.23.49-win binary. my.ini File: [mysqld] basedir=D:/mysql datadir=D:/mysql/data 1.-On prompt: D:\mysql\bin>mysqld-nt --install the current server installed: ...

Re: Best book on MySQL

Hi Mike, What did you think of Firebird vs. MySQL? I haven't seen any comparisons by people who have used both. Thanks, --jeff - Original Message - From: "Michael Grover" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, May 11, 2002 7:25 PM Subject: Re: Best book on MySQL >

Re: Problem with DDL

I don't think quoted identifiers are supported in 3.22.x. --jeff - Original Message - From: "Steve Edberg" <[EMAIL PROTECTED]> To: "Elliot L. Tobin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, May 13, 2002 3:42 PM Subject: Re: Problem with DDL > 'when' is a reserved word: >

Re: MySQL load problems - gcc-2.96?

"Mike Robinson" <[EMAIL PROTECTED]> writes: > Thanks for your note. > > You wrote: > > > > > There are known problems with gcc-2.96 which comes with RH 7.2 > > distribution. There is disclaimer about it at > > www.mysql.com/downloads/mysql-3.23.html as you noticed. > > There is much reading

RE: query for search on mysql database

* MikeParton > I guess what might help is to explain that the form fields are on a page > with method="POST" action=results.php > The sql I provided originally is in results.php and I use the superglobal > $_POST to pull the variables from the form field. > > I want the query results to be based

RE: A table setup question.

* "al butler" <[EMAIL PROTECTED]> > I have the MySQL book and I am trying to come to terms on how > to setup a column that is based on another one. > > Let me try and explain. > > Each row has a string (unique) and indexed. > This string is catergorized by anothe column defined as a SET , > le

Re: query for search on mysql database

I guess what might help is to explain that the form fields are on a page with method="POST" action=results.php The sql I provided originally is in results.php and I use the superglobal $_POST to pull the variables from the form field. I want the query results to be based on the variables which, i

RE: Error 1114

Found it, it was INNODB running out of space. (Can we get better error messages here?) =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 3:24 PM To: [EMAIL PROTEC

RE: RAND and MySQL version!

You can't do "ORDER BY RAND()" prior to version 3.23... On your 3.22.32 version do something like: SELECT column_name*0+RAND() AS rnd FROM table_name WHERE IsActive=1 ORDER BY rnd LIMIT 1; Gurhan -Original Message- From: Soheil Shaghaghi [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 1

Re: RAND and MySQL version!

At 13:26 -0700 5/14/02, Soheil Shaghaghi wrote: >Hello All, >I am running 2 MySQL servers, one on Linux, and the other on FreeBSD. >Linux, MySQL version: 3.23.49 >FreeBSD, MySQL version: 3.22.32 > >Problem: > >The following code runs on the newer version of MySQL, and Linux, but when I >run it on

Re: query for search on mysql database

I want an OR test. If someone searches on last name and enters nothing in the other fields, I want to find the record(s). Similarly, if they enter a first name and no other data, I want to find the record(s). The part I realize I am missing is to first test to see which fields have been filled

Error 1114

I'm trying to create an index on a large-ish table. It runs for about 10 minutes and then I get: ERROR 1114: The table '#sql-3584_4' is full I've started mysqld with --big-tables and even set SQL_BIG_TABLES=1; for good luck but it still keeps erroring out. Anybody got any ideas? =C= * * Cal

RAND and MySQL version!

Hello All, I am running 2 MySQL servers, one on Linux, and the other on FreeBSD. Linux, MySQL version: 3.23.49 FreeBSD, MySQL version: 3.22.32 Problem: The following code runs on the newer version of MySQL, and Linux, but when I run it on the other server, I get sql error. SELECT ID,Headlines,I

A table setup question.

Subject: A table setup question. From: "al butler" <[EMAIL PROTECTED]> === I have the MySQL book and I am trying to come to terms on how to setup a column that is based on another one. Let me try and explain. Each row has a string (unique) and indexed. This string is catergorized by anothe

Re: Help with UPDATE and SET with two tables

On Tuesday 14 May 2002 06:10 am, Egor Egorov wrote: > If not, can I write the Query results of the SELECT statement out to a > new table and delete the original table? > >       Yes, you can use CREATE ... SELECT statement. Thank you for the reply, Egor. Here is what I have tried since your rep

Re: Query slow (again)

Hi, Try this... Do an "alter" and create indexes on the following fields of your tables: -wmkt_email_sent.fkemail -wmkt_client.fkemail -wmkt_maillist_client.fkclient ... and i think it's a good idea if you create indexes on the primary keys of each table.It's redundant but have some "effect". Reg

RE: query for search on mysql database

* MikeParton > I have a similar query in a PHP script. I want to allow users to > use fields > in a page to search for the records. BUT, I want them to be able to enter > the first few characters. I would think my query, below, would do it (the > entire search works when the WHERE statement has

Re: query for search on mysql database

I have a similar query in a PHP script. I want to allow users to use fields in a page to search for the records. BUT, I want them to be able to enter the first few characters. I would think my query, below, would do it (the entire search works when the WHERE statement has first='$first' OR last

query for search on mysql database

Hi All I am making a search program. I am looking for a query. I want to allow the user to search "Any" or "All". Anyhow, suppose the database contains the following Author | Rim Torus | | Jerry Pal Deprado | | Roan P. Classy | --- If the user

Re: Emebedded MySQL Engine & Client Server Engine

Hi Nirmal, If i understand well you make reference at MySQL files.In this case the client application cannot access this file directly , only by MySQL daemon using the libmysql library and not by "embedded library".In my opinion i find that is VERY DANGEROUS It seems is not to be very sophisticate

RE: query for search on mysql database

* Aman Raheja > I am making a search program. I am looking for a query. > I want to allow the user to search "Any" or "All". > Anyhow, suppose the database contains the following > > Author > > | Rim Torus | > | Jerry Pal Deprado | > | Roan P. Classy | > --

Mysql 4.0

Has anyone installed the mysql 4.0 HP-UX binary (10.20) on an 11.00 box? If so did it work okay...? What about builing from the source on 11.00? Any big issues I should be aware of? Thanks, Taylor Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 "Help Wanted. Seeking Te

RE: shutting down mysql

mysqladmin [...] shutdown http://www.mysql.com/doc/m/y/mysqladmin.html Gurhan -Original Message- From: Taylor Lewick [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 12:51 PM To: [EMAIL PROTECTED] Subject: shutting down mysql I looked through the documentation, and I see how to

Re: source code

yes, http://www.mysql.com/downloads Amy Zediak wrote: > > Can i download the source code for MySQL? > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/

Query slow (again)

Hi, I have changed my query but it is so slow :( Please, help me! Thank u very much! Edilson. - Query -> SELECT a.idemail, a.fklastresp FROM wmkt_email a, wmkt_client b, wmkt_maillist_client c LEFT JOIN

Re: Emebedded MySQL Engine & Client Server Engine

Hi Nirmal, Now i am a little confused from you. We discuss about how some devices(not Personal Computers) is possible to have a communication with MySQL? ... or... ...replication,data redundancy it's a different kind of items than we talk about. >You can run two different servers pointing to the s

foreign key constraint to itself

Hi, I am just wondering can I create foreign key constraint to itself in mySQL innodb (the mySQL 3.23.50 release)? Let's say we have a table: test_table_01 (id integer, pid integer) type = innodb. Can I create a foreign key on pid and reference to test_table_01 (id)? Thanks, Lisa

shutting down mysql

I looked through the documentation, and I see how to start the dbase/server, but how do I stop it.. Just kill the mysql daemon? Thanks Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 "Help Wanted. Seeking Telepath..." "You Know where to apply." **

source code

Can i download the source code for MySQL? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECT

Re: Making UPDATE return the no. of rows matched [from Perl]

At 11:35 -0500 5/14/02, rory oconnor wrote: >I'm having some trouble with this issue...I'm using perl DBI and mysql >for a customer addressbook. I know MySQL won't needlessly update a row >if nothing's changed, but since I'm using $rc = $sth->rows; as an >indicator of success, customers will get

BDB wrapped transaction id's

Hi! > "Robert" == Robert Cross <[EMAIL PROTECTED]> writes: Robert> Anyone seen a message like: Robert> 020509 0:05:30 bdb: txn_begin: transaction ID wrapped. Exit the database environment Robert> and restart the application as if application failure had occurred Robert> Now for the i

Re: Making UPDATE return the no. of rows matched

I'm having some trouble with this issue...I'm using perl DBI and mysql for a customer addressbook. I know MySQL won't needlessly update a row if nothing's changed, but since I'm using $rc = $sth->rows; as an indicator of success, customers will get stuck if they decide they don't want to change a

Re: Emebedded MySQL Engine & Client Server Engine

Hi Nirmal, Now i understand what you wish to do. MySQL daemon don't use libmysql.This library is for client. I think you have at least 2 option : 1.Devices work off line with RDBMS and half duplex communication (from devices to DataBase). - but this devices must do an output into ASCII file,

RE: RE: MySQL Locales

Yes you can.. http://www.phpmyadmin.net/documentation/#intro Gurhan -Original Message- From: Lekeas GK [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 11:51 AM To: Gurhan Ozen Cc: [EMAIL PROTECTED] Subject: Re: RE: MySQL Locales That's a good idea, but if you have something li

Re: RE: MySQL Locales

That's a good idea, but if you have something like 2000 entries it can be a lifetime typing one by one...that's why I would like to do it through a script...Does phpmyadmin supports scripts? George - Original Message - From: "Gurhan Ozen" <[EMAIL PROTECTED]> To: "Lekeas GK" <[EMAIL PROTEC

RE: limitation in mysql

Actually there is a maximum table limit , for MyISAM tables .. and that is 8 million terabytes, if you can ever reach that : The limitations in MySQL is limited by the OS limits... See: http://www.mysql.com/doc/T/a/Table_size.html Gurhan -Original Message- From: Inbal Ovadia [mail

Re: NOW()

You may SELECT the current value and write it back explicitely when UPDATEing the table. Then it stays as it was. Thomas On Mon, 13 May 2002, Jeff Kilbride wrote: > The first timestamp field in any table is always updated when the row > changes: > > http://www.mysql.com/doc/D/A/DATETIME.html

RE: RE: MySQL Locales

You mean inserting the entries in Greek?? I would say install phpMyAdmin, and insert the entries thru your browser when the browser encoding is Greek ... Gurhan -Original Message- From: Lekeas GK [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 10:46 AM To: [EMAIL PROTECTED] Cc: [E

Re: How do i add an attachment

On Sat, 11 May 2002, yimdjo francis wrote: > I have a mailing list in Mysql database working very > well; How do I add an ATTACHMENT(files of any type) to > emails going to the addresses in the mailing list > stored in the database? Hi, adding an attachment means changing the header and adding

Re: Error in mysqldump when using numeric table names

Ronald, Tuesday, May 14, 2002, 3:11:16 PM, you wrote: RL> When testing some of our Perl/DBI code, we made a couple of tables with RL> numeric names (e.g. test.1 test.2 etc), because the code we're making has to RL> be able to handle them correctly. It does, w/o any problem, but mysqldump RL> does

Re: Encrypting with PASSWORD() function

Walter, Tuesday, May 14, 2002, 4:59:15 PM, you wrote: WDF> I am trying Mysql Password() function, to encrypt password in a a WDF> user/password WDF> table, WDF> it works fine both ways; it is to say, when I submit a login WDF> (user/password) WDF> combination it fetches the pair ok. WDF> My qu

Re: RE: MySQL Locales

> > Yes, > > > > Just add default-character-set=greek line in your > > /etc/my.cnf (or whereever > > the global server specificationa are read) . > > > > Gurhan Thanks a lot for your prompt reply...Could you please advice me as well how am I going to insert them given that the default language f

RE: limitation in mysql

* Inbal Ovadia > Is there any limitation about the number of rows in a table > and about the number of tables that i can put in mysql? The number of rows in a table is normally limited by the type of the primary key. A TINYINT can only hold 256 values, thus you can only have 256 rows in a table w

Re: limitation in mysql

Hey, > Hi, > Is there any limitation about the number of rows in a table > and about the number of tables that i can put in mysql? Question has been asked many times. Check the lists. Answer : no, only limited by drive space. EG --

Re: diffrent amount of datasets with "mysql" man perl

Hi, thanks for the fast replies, It was a database problem. I compared two tables wich were not syncronised and therefor didnt have the same amount of datasets. Thanks sake.

RE: Encrypting with PASSWORD() function

* Walter D. Funk > I am trying Mysql Password() function, to encrypt password in a a > user/password table, > it works fine both ways; it is to say, when I submit a login > (user/password) combination it fetches the pair ok. > My question is, as I read in the documentation, that the process is

RE: limitation in mysql

[snip] Is there any limitation about the number of rows in a table and about the number of tables that i can put in mysql? [/snip] You are limited by disk space, RAM, and processing power. There are no AFIAK "physical" limitations to MySQL itself. Jay -

Re: Stupid - I just can't get it (NOT IN or NOT EXISTS)

On Monday 13 May 2002 17:49, John Doe wrote: > Simle query request: I want to display the ID for everyone in a table who > is NOT in a second table. > > so this is what I have come up with > > SELECT student.SID, student.firstName > FROM student > WHERE student.SID NOT IN > (SELECT msoccerros

Re: Encrypting with PASSWORD() function

At 10:59 -0300 5/14/02, Walter D. Funk wrote: >Hi, > > I am trying Mysql Password() function, to encrypt password in a a >user/password >table, > it works fine both ways; it is to say, when I submit a login >(user/password) >combination it fetches the pair ok. > My question is, as I read in the

Re: Encrypting with PASSWORD() function

Hi Walter, Walter D. Funk wrote: >Hi, > > I am trying Mysql Password() function, to encrypt password in a a >user/password >table, > it works fine both ways; it is to say, when I submit a login >(user/password) >combination it fetches the pair ok. > My question is, as I read in the documentation

Re: Encrypting with PASSWORD() function

Hi Walter > My question is, as I read in the documentation, that the process is > irreversible, how can I deal with the fact > that a user can forget his password, if I will not be able to retrieve the > original string, because what i can see is the encrypted data The purpose of the encryp

Re: Error in mysqldump when using numeric table names

At 14:11 +0200 5/14/02, Ronald Landheer wrote: >Hello all, > >When testing some of our Perl/DBI code, we made a couple of tables with >numeric names (e.g. test.1 test.2 etc), because the code we're making has to >be able to handle them correctly. It does, w/o any problem, but mysqldump >doesn't: I

Re: how to put passwords for different dbs

At 4:14 -0700 5/14/02, naveed abdul wrote: >Dear sir, > >Iam created mysql databases with : >mysqladmin create database. I was successfull. > >I created different databases now I want give >different password for each database.Is it possible.If >so how it was? >Waiting for your replay, Passwo

limitation in mysql

Hi, Is there any limitation about the number of rows in a table and about the number of tables that i can put in mysql? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.co

Re: SQL Sorting

support, Tuesday, May 14, 2002, 2:41:35 PM, you wrote: s> I work with cyrillic alphabet (Russian) and found that SQL query ORDER BY towns s> with Russian entries doesn't work properly. Is there an easy way to resolve s> this and sort rows by Russian alphabet? Set up default-character-set=koi8

Re: error while start mysql service

Priyesh, Tuesday, May 14, 2002, 3:20:45 PM, you wrote: PP> I get the follwoing error while starting myssql service. PP> If anybody can help that would be great. PP> D:\mysql\bin>net start mysql PP> The MySql service is starting. PP> The MySql service could not be started. PP> A system error ha

Re: how to put passwords for different dbs

naveed, Tuesday, May 14, 2002, 2:14:48 PM, you wrote: na> Iam created mysql databases with : na> mysqladmin create database. I was successfull. na> I created different databases now I want give na> different password for each database.Is it possible.If na> so how it was? na> Waiting for your re

diffrent amount of datasets with "mysql" man perl

Hello, im using mysql 3.23.41-log perl 5.6 This might be a perl question but I have to start somewhere:-) to get the data out of the DB im using: --- perl snip --- while (my @fields = $sth->fetchrow_array()) { print join (";", @fields), "\n"; } --- perl snip --- so each data set is presen

Encrypting with PASSWORD() function

Hi, I am trying Mysql Password() function, to encrypt password in a a user/password table, it works fine both ways; it is to say, when I submit a login (user/password) combination it fetches the pair ok. My question is, as I read in the documentation, that the process is irreversible, how can

RE: Row Locking issue in 3.23.x

use InnoDB which does support row-locking (MySQL-Max) -Original Message- From: Sherzod B. Ruzmetov [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 9:23 AM To: [EMAIL PROTECTED]; MySQL Maling list Subject: Row Locking issue in 3.23.x Hi. As far as I know, MySQL doesn't suport ro

Row Locking issue in 3.23.x

Hi. As far as I know, MySQL doesn't suport row-locking, only table locking is available. But I figured table locking for sessions table of CGI::Session::MySQL would be quite inefficient, for there might be millions of rows and hundreds of them could be active at any time. So what do you guys

Re: error while start mysql service

Have you considered using perror? Try perror 10 67. - Original Message - From: "Priyesh Panchmatia" <[EMAIL PROTECTED]> Date: Tue, 14 May 2002 20:20:45 +0800 To: <[EMAIL PROTECTED]> Subject: error while start mysql service > Hi, > > I get the follwoing error while starting myssql servi

Re: Is InnoDB 64bit clean?

Ralph, InnoDB works on 64-bit Linux Compaq-Alpha when compiled with gcc. Some suggestions: - have you set the FILE_OFFSET_BITS etc. CFLAGS required for 64-bit file offset addressing? - try to run inside a debugger and look where InnoDB gets stuck. - try compiling with gcc-2.95. Best regards,

FW: RE: Project Time

[snip] Do you know if freshmeat is only online certain times of the day/week? I have tried from several different servers of ours to get to it, but it always gives me the "Cannot find server" message. [/snip] Ooops, my mistake. http://www.freshmeat.net ...typing without thinking again! Jay sql,

error while start mysql service

Hi, I get the follwoing error while starting myssql service. If anybody can help that would be great. Thanks in Advance. Priyesh -- D:\mysql\bin>net start mysql The MySql service is starting. The MySql service could not be started. A system error has occ

Error in mysqldump when using numeric table names

Hello all, When testing some of our Perl/DBI code, we made a couple of tables with numeric names (e.g. test.1 test.2 etc), because the code we're making has to be able to handle them correctly. It does, w/o any problem, but mysqldump doesn't: I get a message "mysqldump: Got error: 1064: You have

MySQL AIX RS6000 installation problem

Sending again, don't know why cannot send, sorry if duplicated > Hi, > > I am having a problem running the binary installation for RS6000. > I am installing MySQL in AIX 4.3.3 on RS6000 machine. > (I had successfully installed MySQL in Linux PC using binary installation, > and having C applicati

mysql-test-run errors

all passed up to rpl01: At line 6: query 'slave stop' failed: 1199: This operation requires a running slave, configure slave and do SLAVE START home/mysql/bin/mysqltest: At line 6: query 'load data infile' ../../std_data/words.dat' into table t1' filed: 1085: The file ../../std_data/words.

AIX RS6000 installation problem

Hi, I am having a problem running the binary installation for RS6000. I am installing MySQL in AIX 4.3.3 on RS6000 machine. (I had successfully installed MySQL in Linux PC using binary installation, and having C applications running without problem.) I tar everything in /mysql directory then und

SQL Sorting

Hi, I work with cyrillic alphabet (Russian) and found that SQL query ORDER BY towns with Russian entries doesn't work properly. Is there an easy way to resolve this and sort rows by Russian alphabet? Vyacheslav - Befor

Re: --- InnoDB for Win

maxim wrote: > Hi? all > >Can i use InnoDB tables in MySQL Max for Win9x ? > >Thanks... > > > Hi Maxim, Yes, if you use the -max version, you can. -- -- \|/ __\|/ `@" / o . \ "@' Microsoft? Por acaso é alguma nova /___| \

how to put passwords for different dbs

Dear sir, Iam created mysql databases with : mysqladmin create database. I was successfull. I created different databases now I want give different password for each database.Is it possible.If so how it was? Waiting for your replay, regards = naveed abdul Software Engineer I

Re: reg installation

radhika, Tuesday, May 14, 2002, 11:41:04 AM, you wrote: rg> i have a problem in accessing the MySQL. it denies rg> access when i try to change to the mysql database. rg> it tells "Access denied for user:'@localhost' to rg> database 'mysql'. rg> I didnt setup any user or password .the server is r

Re: RE: Password=password('mypassword')

Tewfic, Monday, May 13, 2002, 4:55:35 PM, you wrote: TK> Hello, thanks for the suggestions so far but... TK> mysql> select * from access where UserID='myusername' and Password = TK> password('mypassword'); TK> Empty set (0.00 sec) Check if your data is correct. It should work. TK> mysql> selec

Re: RE: Backing up/Creating new database

PR, Monday, May 13, 2002, 8:28:20 PM, you wrote: P> Thnaks . I tried several variation and they are giving me sql syntax P> error: :) mysqldump is not an SQL command, it's a program for database backup. So, you should run it from DOS prompt, f.e. if MySQL is located in C:\mysql, it would be:

Re: Help with UPDATE and SET with two tables

Andrew, Tuesday, May 14, 2002, 12:43:31 AM, you wrote: AL> I have a database with several tables. I want to update a field in that AL> table with a field contained in another table. I have a unique key to use AL> for a WHERE clause. AL> This is easy to do with various procedural languages

Re: SQL syntax question

Graham, Monday, May 13, 2002, 8:45:09 PM, you wrote: GN> I have a directory of professional magicians, consisting of a MySQL table GN> like GN> this: GN> +-++-+ GN> | artist | area| magic | GN> +-++--

  1   2   >