Re: mysql highload

2002-10-01 Thread David Bordas
MR> We run MySQL on a 2xP3 1Ghz (Coppermine), 1 GB RAM, 1 software RAID1 (2 x MR> SCSI), Linux 2.4.9-31 (RedHat patched kernel). We have run a older version MR> of MySQL (we run only binary releases) for a long time (6 months) with MR> great success. We had uptimes like 100 days and almost 200 que

mysql highload

2002-10-01 Thread Mihai RUSU
Hi We run MySQL on a 2xP3 1Ghz (Coppermine), 1 GB RAM, 1 software RAID1 (2 x SCSI), Linux 2.4.9-31 (RedHat patched kernel). We have run a older version of MySQL (we run only binary releases) for a long time (6 months) with great success. We had uptimes like 100 days and almost 200 queries / secon

Re: Please Help!

2002-10-01 Thread Iikka Meriläinen
On Tue, 1 Oct 2002, DeNewbie wrote: > > I am a newbie and I am having a chronic problem getting mysql started up and >running. I got so frustrated that I uninstalled the mysql rpms and started over again >but its hasn't helped my situation. My whole problem revolves around mysql_install_db >se

Access denied for user

2002-10-01 Thread luoya li
Hi, I have Mysql 3.23.52-max-nt on Win2K. I¡¯d like to set a password for root so I use the following commands: mysql> use mysql Database changed mysql> update user set password=password('l05m') -> where host='localhost' and user='root'; Query OK, 1 row affected (0.00 sec) Mysql prompt

Using Install shield, how to do ODBC DSN setting ?

2002-10-01 Thread Alice Tan
Hi, i am doing a project and it is almost nearing release version. i planned to do the installation by using install shield to one short doing the mysql, myodbc installation and also the ODBC DSN setting. is anyone have any idea to do the ODBC DSN setting through install shield ? or writing any p

Re: InnoDB AUTO-INC lock timeouts / deadlocks on inserts (using

2002-10-01 Thread iod iod
Tuuri, Thank you for the follow-up. It's great that our efforts were not in vain and I could contribute towards resolving the issue. I will be looking forward to the next release of InnoDB/MySQL-Max. - regards, Afroze H. Zubairi (IOD) - - Origina

Re: Cannot install mysql on OS X 10.2

2002-10-01 Thread Joel Rees
Philip Lavine scrawled > To all, > > I can not configure mysql on OS X, using the latest build for that OS. Oh? > Thanks Sure. (I'm not telepathic. What error messages and/or misbehavior are you getting during the install?) -- Joel Rees <[EMAIL PROTECTED]>

Re: install mysql on osx 10.2

2002-10-01 Thread Joel Rees
Stephane Pinel wrote > Le 1/10/02 19:51, $B%)(B webmaster ; <[EMAIL PROTECTED]> a $BqD(Brit : > > > Hi, I am looking for some help installing mysql > > I have downloaded a copy and have it on my > > desktop , and well I am sorta wondering where to > > go from here. Because the instructi

Startup script for Solaris 7?

2002-10-01 Thread Bin Zhang
If you are running MySQL on a Solaris 7 machine, would you mind sharing your startup script with the list? Thanks. bz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Please Help!

2002-10-01 Thread DeNewbie
I am a newbie and I am having a chronic problem getting mysql started up and running. I got so frustrated that I uninstalled the mysql rpms and started over again but its hasn't helped my situation. My whole problem revolves around mysql_install_db setup. This is what I am doing and its simply

Re: Please Help!

2002-10-01 Thread Clayburn W. Juniel, III
On Tuesday, Oct 1, 2002, at 16:39 America/Phoenix, DeNewbie wrote: > > I am a newbie and I am having a chronic problem getting mysql started > up and running. I got so frustrated that I uninstalled the mysql rpms > and started over again but its hasn't helped my situation. My whole > problem

Re: Get the total of a feild

2002-10-01 Thread nellA hciR
sounds like you need SUM() - hcir > Hi, > > I wanting to know what the sql statement is that will let me get the > total > of database. The feild is amount. I have tried a couple of sql > statement and > have even looked at mysql 6.3.3.1 Arithmetic Operations. But I am lost.

Re: How many days out...

2002-10-01 Thread Paul DuBois
At 15:41 -0400 10/1/02, Chuck Payne wrote: >Hi, > >I am having problems get how many days out an invoice is from mysql. I have >try this. > >SELECT NOW()-summitted_date FROM table; > >But it not working as usually. So please guys a little help. What do you mean "not working as usually"? A query

How to get the number of days an invoice was submitted.

2002-10-01 Thread Chuck Payne
Hi, I am having problems get how many days out an invoice is. I have try this sql statement. SELECT NOW()-submmitted_date FROM table; But it not working as usually. So please guys a little help. So If an invoice was submmitted on 9-26-02 then I should be able to see that 5 days. Chuck Payne M

Re: Table says it is read only but it is not from file system level

2002-10-01 Thread Mark
- Original Message - From: "Rochester, Dean" <[EMAIL PROTECTED]> To: "MySQL (E-mail) (E-mail)" <[EMAIL PROTECTED]> Sent: Tuesday, October 01, 2002 8:22 PM Subject: Table says it is read only but it is not from file system level > I am running an sql insert against a mysql table > version

RE: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB?

2002-10-01 Thread Chris Couture
Thanks for the info. Let me see if I have this right. (I am asking these question on behalf of my UNIX programmer who will be doing all of the programming so sorry if I am asking simple questions.) To make this simple, let's label the computers. The MySQL database server will be labeled "B"

Re: MySQl 4.03

2002-10-01 Thread gerald_clark
What do you mean 'still' ? Version 4 just went beta a short time ago, and is only at 03 or 04. DonPro wrote: >Hi, > >The web site states that MySQL 4.03 is still officially beta. Does anyone >have any experience or feedback using it on a production system? I really >require some of the new feat

Re: Help on SQLyog

2002-10-01 Thread gerald_clark
Check out the GRANT syntax in the manual. I don't see where you granted any privileges. Kevin Tsay wrote: >Nestor: > >I've set the password for root and granted privileges to it. > >see below: > >mysql> select * from user where user='root'; >+---+--+--+-+

Re: Table says it is read only but it is not from file system level

2002-10-01 Thread gerald_clark
You are connecting th the server, not the table. The server must have read and write permissions on the files. They must be owned by mysql, as must their directories. Rochester, Dean wrote: >I am running an sql insert against a mysql table version 3.23.52 > >When from the file system level the t

Re: Exporting and overwriting file

2002-10-01 Thread gerald_clark
No. How would the server know if you had used the previous output file? As a matgter of fact, since it is still there, I guess you didn't. Have your cgi script move it. Carter, Steve wrote: >Hi, > >I am trying to export a query into a .CSV file using SELECT ... OUTFILE at >the command prompt. >

Re: Store pictures in DB (load_file() revisited)

2002-10-01 Thread gerald_clark
mysql probably does not have search permission on /home/alex. copy the file to /tmp and see what happens. Alex Safonov wrote: >Greetings, > >just saw a message with an example of inserting a BLOB >value using load_file(). Can't get load_file() to >work: > >mysql> select load_file('/home/alex/pos

RE: Help on SQLyog

2002-10-01 Thread Nestor Florez
Check the db table in mysql database. See what that says also, I notice the error was that kevin.smith.com not allowed sould that be [EMAIL PROTECTED] not allowed? Generally you will get kevin@localhost not allowed. Grant priviledges to that user on that machine as [EMAIL PROTECTED] Nestor :-)

Re: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB?

2002-10-01 Thread gerald_clark
You need the client 'mysql' on the unix machine to talk to the server 'mysqld' on whatever machine. This will allow you to write shell scripts that call mysql. If you want to program in PHP or perl, then you need their mysql drivers which talk to the server. Chris Couture wrote: >Hi, > >I'm a

Re: Drop Index - Error 28

2002-10-01 Thread gerald_clark
Yes, it builds a new index file before deleteing the old. Oswaldo Castro wrote: >Hi List > >I have a table with 90 Millions records and 8 indexes (75GB). I am >trying to drop one of them but I get an errorcode 28 (no space left on >device). df- v gives me an extra 27% of free space. > >My questi

How many days out...

2002-10-01 Thread Chuck Payne
Hi, I am having problems get how many days out an invoice is from mysql. I have try this. SELECT NOW()-summitted_date FROM table; But it not working as usually. So please guys a little help. So If an invoice was summitted on 9-26-02 then I should be able to see that 5 days. Chuck Payne Magi D

Please confirm (conf#3609bdcf19fdd5aadddc58b8665f2e25)

2002-10-01 Thread Chuck Payne
<< IMPORTANT INFORMATION! >> This is an automated message. The message you sent (attached below) requires confirmation before it can be delivered. To confirm that you sent the message below, just hit the "R"eply button and send this message back (you don't need to edit anything). Once this is d

FULLTEXT search and ORDER BY

2002-10-01 Thread Grzegorz Paszka
Hi. I've such problem. Is "ORDER BY" works with MATCH AGAINST ? i.e. create table test ( id_test int11, message text ); SELECT id_test, message FROM test WHERE WHERE MATCH (message) AGAINST ('example' IN BOOLEAN MODE) ORDER BY id_test For me in mysql 4.0.3beta this select doesn't work as I want

Cannot install mysql on OS X 10.2

2002-10-01 Thread Philip Lavine
To all,   I can not configure mysql on OS X, using the latest build for that OS.   Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

Re: Table says it is read only but it is not from file system level

2002-10-01 Thread Iikka Meriläinen
On Tue, 1 Oct 2002, Rochester, Dean wrote: > I am running an sql insert against a mysql table version 3.23.52 > > When from the file system level the table has the following permissions. > > rw-rw-r-- table.frm > rw-rw-r-- table.MYD > rw-rw-r-- table.MYI > Hi, Please verify that the user

Re: install mysql on osx 10.2

2002-10-01 Thread Stéphane Pinel
Le 1/10/02 19:51, « webmaster » <[EMAIL PROTECTED]> a écrit : > Hi, I am looking for some help installing mysql > I have downloaded a copy and have it on my > desktop , and well I am sorta wondering where to > go from here. Because the instructions are too vague > > for me, as a newbie to mysql

MySQl 4.03

2002-10-01 Thread DonPro
Hi, The web site states that MySQL 4.03 is still officially beta. Does anyone have any experience or feedback using it on a production system? I really require some of the new features in version 4. - Before posting, please c

RE: Help on SQLyog

2002-10-01 Thread Kevin Tsay
Nestor: I've set the password for root and granted privileges to it. see below: mysql> select * from user where user='root'; +---+--+--+-+-+- +-+-+---+-+---+- -+--

Re: install mysql on osx 10.2

2002-10-01 Thread Kelly
Check out the excellent package/instructions at http://www.entropy.ch/software/macosx/mysql/ At 01:51 PM 10/1/2002 -0400, webmaster wrote: >Hi, I am looking for some help installing mysql >I have downloaded a copy and have it on my >desktop , and well I am sorta wondering where to >go from here.

MySQL 4 choosing wrong index for merge table

2002-10-01 Thread Keith C. Ivey
A query that took less than a second under 3.23.44 started taking minutes when we upgraded to 4.0.3. The original query involved multiple tables including one merge table containing 10 subtables and millions of rows, but I've trimmed it down to a manageable test case where the merge table has

Re: install mysql on osx 10.2

2002-10-01 Thread Clayburn W. Juniel, III
On Tuesday, October 1, 2002, at 10:51 24h, webmaster wrote: > Hi, I am looking for some help installing mysql > I have downloaded a copy and have it on my > desktop , and well I am sorta wondering where to > go from here. Because the instructions are too vague > Try the Mac OS version 10.2 fro

MS Exchange Email?

2002-10-01 Thread Patrick Fowler
Hello, Is there a way to have email from an email account on a MS Exchage Server be populated into MySQL. I can to this by connecting to the exchange server with MS Access and then push the data from access into the MySQL table. I would like not to have to use MS Access. Thanks for any help.

RE: RedHat 8.0 and MySQL

2002-10-01 Thread Luc Foisy
Has anyone rushed out and tried them out with each other yet?=20 Maybe some things to be concerned about: gcc 3.2=20 glibc 2.2.93=20 kernel 2.4.18=20 Luc Foisy sql - Before posting, please check: http://www.mysql.com

MySQL Error 1030: Got error -30996 from table handler

2002-10-01 Thread Sridhar Peddireddy
List, I would appreciate if somebody has any ideas on the above error. We are getting this error "Error 1030: Got error -30996 from table handler" with BDB tables on a Linux Server (Red Hat 7.3), the version of MySQL is 3.23.42 Thanks Sridhar ---

Re: Help on SQLyog

2002-10-01 Thread Robert Tam
Kevin, It sounds like you don't have your MySQL access setup correctly. I am also a newbie to MySQL. I recently experienced the same problem with MyCC, which is similar software to SQLyog. I have both, MyCC and SQLyog, installed and currently comparing and contrasting to see which one I like t

Question about FULLTEXT indexes

2002-10-01 Thread DonPro
Hi, I'm using MySQl 3.23.52 on RedHat Linux 6.2 I have a table that is indexed on the description column as FULLTEXT. I allow the user to enter text in an input field and I return matching rows. I've noticed that writing a query such as: SELECT EDescript FROM HSCodes WHERE MATCH(EDescript) AGAI

Re: Help on SQLyog

2002-10-01 Thread Iikka Meriläinen
On Tue, 1 Oct 2002, Kevin Tsay wrote: > Dear Listers: > > I've installed MySQL over my Linux (RedHat 7.3) and SQLyog over my laptop. > When I start SQLyog and type in the > > mySQLHostAddress: 10.0.5.210 > User Name: root > Password: > Port: 3306 > > Itis giving me the error: Host 'kevin

Table says it is read only but it is not from file system level

2002-10-01 Thread Rochester, Dean
I am running an sql insert against a mysql table version 3.23.52 When from the file system level the table has the following permissions. rw-rw-r-- table.frm rw-rw-r-- table.MYD rw-rw-r-- table.MYI When the sql runs it says the table is read only. I am connecting to the table as root an

Exporting and overwriting file

2002-10-01 Thread Carter, Steve
Hi, I am trying to export a query into a .CSV file using SELECT ... OUTFILE at the command prompt. It works ok the first time but all subsequent runs give a 1086 error - "File already exists". I have to use the command prompt vs. a GUI as I am running this in a .cgi script. Is there any way

Re: FileMaker Pro Schema Export?

2002-10-01 Thread Clayburn W. Juniel, III
On Tuesday, October 1, 2002, at 10:25 24h, Jan Steinman wrote: >> From: "Chuck Payne" <[EMAIL PROTECTED]> >> >> Question are you want to take your data from Filemaker to Excel? > > No, I want to just go from FileMaker to MySQL, period. Forever. End of > story. If you export a FileMaker databa

MYSQL_OPT_CONNECT_TIMEOUT

2002-10-01 Thread Steven Roussey
If MYSQL_OPT_CONNECT_TIMEOUT is set before mysql_connect() or mysql_real_connect() and the value is set to zero, what is the expected behavior? (Reason: PHP now does this as the default.) Sincerely, Steven Roussey http://Network54.com/?pp=e

install mysql on osx 10.2

2002-10-01 Thread webmaster
Hi, I am looking for some help installing mysql I have downloaded a copy and have it on my desktop , and well I am sorta wondering where to go from here. Because the instructions are too vague for me, as a newbie to mysql please assist james --

Help on SQLyog

2002-10-01 Thread Kevin Tsay
Dear Listers: I've installed MySQL over my Linux (RedHat 7.3) and SQLyog over my laptop. When I start SQLyog and type in the mySQLHostAddress: 10.0.5.210 User Name: root Password: Port: 3306 Itis giving me the error: Host 'kevin.sitesmith.com' is not allowed to connect to this MySQL se

Store pictures in DB (load_file() revisited)

2002-10-01 Thread Alex Safonov
Greetings, just saw a message with an example of inserting a BLOB value using load_file(). Can't get load_file() to work: mysql> select load_file('/home/alex/post.html') from test; +---+ | load_file('/home/alex/post.html') | +---+ |

RE: FileMaker Pro Schema Export?

2002-10-01 Thread Jan Steinman
>From: "Chuck Payne" <[EMAIL PROTECTED]> > >Question are you want to take your data from Filemaker to Excel? No, I want to just go from FileMaker to MySQL, period. Forever. End of story. I'm tired of paying "FileMaker Tax" every year. (The version upgrade went from $149 to $199 this year.) I'm

Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB?

2002-10-01 Thread Chris Couture
Hi, I'm a MySQL Newbie and am working on my first real project. The project involves removing the Access database off of our system and using MySQL in its place. Here is what happens now with this database The Unix machine writes information to the end of a text file every time an invoice

Re: Japanese Charset

2002-10-01 Thread gerald_clark
It is already quoted. That's the point. Michael T. Babcock wrote: > gerald_clark wrote: > >> $qtext=$dbh->quote($text); >> $dbh->execute("insert into mytable set myvariable = $qtext"); >> >> The above quote() function will put a \ in fronnt of all the special >> characters listed in the manual

Drop Index - Error 28

2002-10-01 Thread Oswaldo Castro
Hi List I have a table with 90 Millions records and 8 indexes (75GB). I am trying to drop one of them but I get an errorcode 28 (no space left on device). df- v gives me an extra 27% of free space. My questions: Does MySQL use temporary areas to drop indexes and for what ? Is there a way to te

re: re: re: granting FILE privileges

2002-10-01 Thread Victoria Reznichenko
Mark, Tuesday, October 01, 2002, 5:50:15 PM, you wrote: MH> But root user is able to perform the write to file w/o issue. MH> I wonder what the problem could be. MH> I will upgrade to 3.23.52 but I don't think it will fix the problem. MH> Is there anything else it could be? As far as I remember

re: Re: How to find whether a key is fulltext

2002-10-01 Thread Egor Egorov
Insanely, Tuesday, October 01, 2002, 6:22:47 PM, you wrote: IG> When I am doing IG> show index from db.tablename, the columns I am gettings are - IG> Table IG> Non_unique IG> Key_name IG> Seq_in_index IG> Column_name IG> Collation IG> Cardinality IG> Sub_part IG> Packed IG> Comment IG> Which o

Re: select problem with "not equal" syntax

2002-10-01 Thread Clayburn W. Juniel, III
On Monday, September 30, 2002, at 08:44 24h, Gebhardt, Karsten wrote: > I have two tables > > CREATE TABLE pid_segment ( > id INT NOT NULL UNIQUE PRIMARY KEY, > msg TEXT) > TYPE=INNODB > > CREATE TABLE hl7incom( > id INT NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY REFERENCES > pid_segment > (id

Privileges for CREATE TEMPORARY TABLE?

2002-10-01 Thread Alec . Cawley
What privileges do I need for creating a TEMPORARY table? I seem to have locked myself out of this - and yet I can create permanent tables, which seems the wrong way round. N:\>mysql -ualec Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1121 to server versio

Re: Get the total of a feild

2002-10-01 Thread nellA hciR
sounds like you need SUM() - hcir > Hi, > > I wanting to know what the sql statement is that will let me get the > total > of database. The feild is amount. I have tried a couple of sql > statement and > have even looked at mysql 6.3.3.1 Arithmetic Operations. But I am lost.

Re: Japanese Charset

2002-10-01 Thread Michael T. Babcock
gerald_clark wrote: > $qtext=$dbh->quote($text); > $dbh->execute("insert into mytable set myvariable = $qtext"); > > The above quote() function will put a \ in fronnt of all the special > characters listed in the manual. > These in clude "'\ and the hex 00 character. FWIW, before anyone copies

Re: How to find whether a key is fulltext

2002-10-01 Thread Insanely Great
Greetinsg... When I am doing show index from db.tablename, the columns I am gettings are - Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment Which one of these will tell me whether a key is fulltext or not. Rgds Ritesh SQLyog ( http://www.webyog

re: re: granting FILE privileges

2002-10-01 Thread Mark Hennessy
But root user is able to perform the write to file w/o issue. I wonder what the problem could be. I will upgrade to 3.23.52 but I don't think it will fix the problem. Is there anything else it could be? -- Mark P. Hennessy [EMAIL PROTECTED] On Tue, 1

"Corrupted" Table (?)

2002-10-01 Thread Philip Daggett
All, I have a table which was accessible for the last couple years but is now inaccessible after performing a simple alter table command. There are approx. 10 tables in this database on which the same alter table command was given ("alter table table_name add glperiod varchar (3) null first;"

Get the total of a feild

2002-10-01 Thread Chuck Payne
Hi, I wanting to know what the sql statement is that will let me get the total of database. The feild is amount. I have tried a couple of sql statement and have even looked at mysql 6.3.3.1 Arithmetic Operations. But I am lost. Chuck Payne Magi Design -

Re: MYSQL

2002-10-01 Thread Michael T. Babcock
gerald_clark wrote: > What do the logs say? > > Stella Chipfupa wrote: > >> What are the advantages of Mysql over sql or microsoft access. > Pet peave: the product being refered to is "Microsoft SQL Server", not "SQL". -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~m

Lost Connection to MySQL Server During Query

2002-10-01 Thread Graphfixz
Hi, I am getting the following error: [TCX][MyODBC] Lost Connection to MySQL Server During Query My code is simply dumping an IP Address to the database... at the most 10 lines of code. Any ideas what is causing this error? I have searched on line and have not found much help. Thanks in ad

Re: MYSQL

2002-10-01 Thread gerald_clark
Please respond to the list. It sounds like the server does not like one of the options in your my.cnf file, and is printing a syntax/options list. Stella Chipfupa wrote: >The logs are listing the features of mysql but there is no comparison. > > > >-Original Message- >From: gerald_clar

Re: Japanese Charset

2002-10-01 Thread gerald_clark
I was not aware that you were running VB. In perl and PHP we have a function do do this for us. in perl: $qtext=$dbh->quote($text); $dbh->execute("insert into mytable set myvariable = $qtext"); The above quote() function will put a \ in fronnt of all the special characters listed in the manual.

Re: A FAQ type question, but not in the FAQ - How to change my hostname, but not make replication puke

2002-10-01 Thread Eric Frazier
Hi, The mysql master wasn't restricting the slave by ip. But thanks, Eric At 10:28 AM 9/30/02 -0500, gerald_clark wrote: >You need to grant privileges on the master to the new slave machine. > http://www.kwinternet.com/eric (250) 655 - 9513 (PST Time Zone) "Inquiry is fatal to certainty." --

Re: How to find whether a key is fulltext

2002-10-01 Thread Paul DuBois
At 18:19 +0530 10/1/02, Insanely Great wrote: >Greetings.. > >I am doing show keys from db.tablename but how can I know whether the key if >fulltext or not. I get to know the key is unique or not by checking >Not_Unique column in the returned resultset. SHOW KEYS shows this information in the Ind

re: mysql dies at startup after upgrade form 3.23 to 4.0.3

2002-10-01 Thread Victoria Reznichenko
jschleigh, Tuesday, October 01, 2002, 4:06:15 PM, you wrote: jahdc> I had a working install of mysql 3.23 in /usr/bin and /var/lib/mysql. I installed 4.0.3 to /usr/local/mysql and can't get it to run. I followed the installation instructions to the jahdc> T. When I run '/usr/local/my

Re: MYSQL

2002-10-01 Thread gerald_clark
What do the logs say? Stella Chipfupa wrote: >What are the advantages of Mysql over sql or microsoft access. > >Thanks > >Stella > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://

re: How to find whether a key is fulltext

2002-10-01 Thread Victoria Reznichenko
Insanely, Tuesday, October 01, 2002, 3:49:10 PM, you wrote: IG> I am doing show keys from db.tablename but how can I know whether the key if IG> fulltext or not. I get to know the key is unique or not by checking IG> Not_Unique column in the returned resultset. IG> How to find a key is fulltext.

re: LOAD command

2002-10-01 Thread Egor Egorov
Jim, Tuesday, October 01, 2002, 4:01:18 PM, you wrote: JB> I am trying to use the LOAD command and not having much success. My host JB> company is using version mysql 3.23.51. I am sshing into server, JB> starting mysql and getting a mysql prompt. I have a database called JB> login, and have mad

re: RE: RE: date column

2002-10-01 Thread Egor Egorov
Tewfic, Tuesday, October 01, 2002, 12:21:09 AM, you wrote: TK> Hello, I have a table that keeps track of people and their office visits. TK> This table will have duplicates since people will visit the office more than TK> once... TK> How can I get a list of people and the most recent time they'

Re: LOAD command

2002-10-01 Thread gerald_clark
The SERVER needs to be able to read the file, and I doubt very much that mysql has read permissions here. Jim Bahr wrote: >Hello >I am trying to use the LOAD command and not having much success. My host >company is using version mysql 3.23.51. I am sshing into server, >starting mysql and gettin

Trapping error thru eval is not working?

2002-10-01 Thread Ben Goswami
Anyone has any experience of trapping error using DBI-mySQL. The following code is not trapping the error. it is producing system generated error. $memberId='2a'; my($memberId)=@_; my($sql)= " select member_id from members where member_id != " . $memberId; my $sth = $dbh

mysql dies at startup after upgrade form 3.23 to 4.0.3

2002-10-01 Thread jschleigh
>Description: I had a working install of mysql 3.23 in /usr/bin and /var/lib/mysql. I installed 4.0.3 to /usr/local/mysql and can't get it to run. I followed the installation instructions to the T. When I run '/usr/local/mysql/bin/mysqld_safe&' I get: Starting mysqld daemon

MYSQL

2002-10-01 Thread Stella Chipfupa
What are the advantages of Mysql over sql or microsoft access. Thanks Stella - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

How to find whether a key is fulltext

2002-10-01 Thread Insanely Great
Greetings.. I am doing show keys from db.tablename but how can I know whether the key if fulltext or not. I get to know the key is unique or not by checking Not_Unique column in the returned resultset. How to find a key is fulltext. Thx Insane sql,query,mysql ---

Re: InnoDB AUTO-INC lock timeouts / deadlocks on inserts (using

2002-10-01 Thread Heikki Tuuri
IOD, thank you for the bug report. I was able to repeat the problem with you scripts. The bug was that InnoDB failed to release at an SQL statement end such AUTO-INC locks which were only granted after a lock wait. They were only released at the transaction commit. Since AUTO-INC locks normally

Re: Security vulnerability

2002-10-01 Thread Sergei Golubchik
Hi! On Oct 01, Plesk Support wrote: > Any user in mysql can create as many databases as he wants. > Create a user with 1 database, and let him create database with name > "my_data_base". Log into mysql console as user and run command: > > CREATE DATABASE "my?data?base"; > > New databas

re: re: granting FILE privileges

2002-10-01 Thread Victoria Reznichenko
Mark, Monday, September 30, 2002, 5:48:59 PM, you wrote: MH> +-+ MH> | Grants for [EMAIL PROTECTED] | MH> +

security vulnerability

2002-10-01 Thread kmv
Description: Any user in mysql can create as many databases as he wants. Create a user with 1 database, and let him create database with name "my_data_base". Log into mysql console as user and run command: CREATE DATABASE "my?data?base"; New database will be created and user can create

re: Testing New Install

2002-10-01 Thread Egor Egorov
DeNewbie, Monday, September 30, 2002, 9:36:03 PM, you wrote: D> I am a MySQL newbie and i am somewhat confused. Firstly did I make a mistake running mysql_install_db and afterwards running the commands; D> /usr/bin/mysqladmin -u root password 'new-password' D> mysqladmin -u pazin1 sqlpass D>

re: ERROR 1064 ...

2002-10-01 Thread Egor Egorov
hans, Tuesday, October 01, 2002, 1:02:02 PM, you wrote: hp> got a little problem during learning mysql : hp> have made a file called create_member.sql, looks like this here : hp> CREATE TABLE member hp> { hp> last_name VARCHAR(20) NOT NULL, hp> first_name VARCHAR(20) NOT NULL, hp

ERROR 1064 ...

2002-10-01 Thread hans privat
hi, got a little problem during learning mysql : have made a file called create_member.sql, looks like this here : CREATE TABLE member { last_name VARCHAR(20) NOT NULL, first_name VARCHAR(20) NOT NULL, suffix VARCHAR(5) NULL, expiration DATE NULL DEFAULT '-00-0

re: MySQLGUI: Win32 zipped binary seems corrupted

2002-10-01 Thread Victoria Reznichenko
Pavel, Monday, September 30, 2002, 9:04:32 PM, you wrote: PH> I've just tried to download the Win32 binaries of the MySQLGUI tool. PH> I recieved about 50kB. When I tried to unpack the archive, PH> WinCommander told me, that the zip archive is corrupted. I've just downloaded MySQLGUI and unzippe

re: Re: Re: Re: Replication

2002-10-01 Thread Victoria Reznichenko
CP, Tuesday, October 01, 2002, 11:29:30 AM, you wrote: C> I stopped both mysql in master and slave. Then I put in the server id for C> both master and slave, start the master then the slave. Is it okay? Yes. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This ema

re: MySQL 4.03 and merge tables: bug with BETWEEN

2002-10-01 Thread Egor Egorov
Tac, Friday, September 27, 2002, 10:34:46 PM, you wrote: T> We're having a problem with a huge merge table and BETWEEN. The same query T> in MySQL 3, using an identical (binary) copy of the database, takes a T> fraction of a second, in MySQL 4.03 it runs without stopping. T> The query is a simp

Archives are where (was Re: Filemaker database to MYSQL)

2002-10-01 Thread Joel Rees
Chuck Amadi asked > >>Has anyone created a plugin or script that will allow me to > >>convert my filemaker database to MYSQL > >> > > > >Check the archives. There has been some discussion of this in the past. > > > Has anyone got a link to this archive as I have a Filemaker Pro 5 Works > Databas

Compilation options of rpm packages

2002-10-01 Thread Iago Sineiro
Hi all. Any of MySQL AB team could explain the options used in the compilation of rpm packages for Linux? Thanks in advance. Iago. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://l

[Q] Replication & temporary tables (fwd)

2002-10-01 Thread Andrey Kotrekhov
sql,query Hello, All! Why is temporary tables replecated? Is it true? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 --

Re: Re: Re: Replication

2002-10-01 Thread CP
hi Victoria, I stopped both mysql in master and slave. Then I put in the server id for both master and slave, start the master then the slave. Is it okay? Thanks, Chee Peng - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, Septemb

mysql++ optimize 4 gcc3.2

2002-10-01 Thread Markus Schnelle
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi .. I have a question about mysql++. give it a version of mysql++ that is optimize for the gcc 3.2 Version or have someone a tip to compile that with the gcc 3.2 ?? Thanks a lot - -- Markus Schnelle - Email: [EMAIL PROTE

Re: InnoDB AUTO-INC lock timeouts / deadlocks on inserts (using

2002-10-01 Thread iod iod
Thank you for your response. We tried your example here on shell and it looks like InnoDB locks the table only for the first transaction after db startup and this lock is held for the whole transaction (like you observed). But, contrary to this scenario we have experienced some strange behav