RE: forget root password

2002-02-12 Thread Andrew Schmidt 

http://www.mysql.com/doc/R/e/Resetting_permissions.html

after starting mysql with the --skip-grant-tables,  you'll have to execute a grant 
statement 

http://www.mysql.com/doc/G/R/GRANT.html

GRANT ALL PRIVILEGES ON *.* TO root@localhost INDENTIFIED BY 'somepassword' WITH GRANT 
OPTION;

then restart mysql without the --skip-grant-tables.

thanks,

-- Andrew

 -Original Message-
 From: dick idod [mailto:[EMAIL PROTECTED]]
 Sent: Monday, February 11, 2002 3:23 AM
 To: [EMAIL PROTECTED]
 Subject: forget root password
 
 
 Hi,
 
 I have installed mysql-3.22.22 on Linux RedHat, but
 now I have problem because I forget the root password.
 How do I solve this problem ?
 
 TIA,
 
 dick#
 
 __
 Do You Yahoo!?
 Send FREE Valentine eCards with Yahoo! Greetings!
 http://greetings.yahoo.com
 
 -
 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 PROTECTED]
 To unsubscribe, e-mail 
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 
 -
 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 PROTECTED]
 To unsubscribe, e-mail 
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: I deleted my root user!

2002-01-24 Thread Andrew Schmidt 

http://www.mysql.com/doc/R/e/Resetting_permissions.html

after starting mysql with the --skip-grant-tables,  you'll have to
execute a grant statement 

http://www.mysql.com/doc/G/R/GRANT.html

GRANT ALL PRIVILEGES ON *.* TO root@localhost INDENTIFIED BY
'somepassword' WITH GRANT OPTION;

then restart mysql without the --skip-grant-tables.

thanks,

-- Andrew

-Original Message-
From: Lisa Williams [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 24, 2002 10:59 AM
To: [EMAIL PROTECTED]
Subject: I deleted my root user!


Please help.  I accidentally deleted the root user and now I can't do
anything.  How can I recreate this user with super user privileges?  I'm
new to MySQL so please be detailed.

Thanks in advance 

Lisa


-
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 PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Slow updates with two keys in where.

2002-01-24 Thread Andrew Schmidt 

MySQL can only use 1 index per query.  So take your first query for example:

update forum set approved='N' where id=644122 or thread=644122

it can only use the id key OR the thread key,  not both.   and since you have an 'or' 
in your query MySQL must scan the entire table for either id being 644122 or thread 
being 644122.

thanks,

-- Andrew


-Original Message-
From: Brian Moon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 24, 2002 3:03 PM
To: [EMAIL PROTECTED]
Subject: Slow updates with two keys in where.


I have pasted below some queries and a table structure that I am finding to
be very slow.

As you can see, if I or the two keyed fields, the query takes ~7 seconds.
If I just run them by themselves, it takes no measurable time.

Is this something we just have to live with?  Or, is there something wrong?

Brian.

=

mysql update forum set approved='N' where id=644122 or thread=644122;
Query OK, 0 rows affected (6.79 sec)
Rows matched: 1  Changed: 0  Warnings: 0

mysql update forum set approved='N' where id=644122;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

mysql update forum set approved='N' where thread=644122;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

mysql select count(*) from forum;
+--+
| count(*) |
+--+
|   547989 |
+--+
1 row in set (0.00 sec)


CREATE TABLE `forum` (
  `id` int(10) unsigned NOT NULL default '0',
  `datestamp` datetime NOT NULL default '-00-00 00:00:00',
  `thread` int(10) unsigned NOT NULL default '0',
  `parent` int(10) unsigned NOT NULL default '0',
  `author` char(37) NOT NULL default '',
  `subject` char(255) NOT NULL default '',
  `email` char(200) NOT NULL default '',
  `host` char(50) NOT NULL default '',
  `email_reply` char(1) NOT NULL default 'N',
  `approved` char(1) NOT NULL default 'N',
  `msgid` char(100) NOT NULL default '',
  `modifystamp` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `author` (`author`),
  KEY `userid` (`userid`),
  KEY `datestamp` (`datestamp`),
  KEY `subject` (`subject`),
  KEY `thread` (`thread`),
  KEY `parent` (`parent`),
  KEY `approved` (`approved`),
  KEY `msgid` (`msgid`),
  KEY `modifystamp` (`modifystamp`)
)

Brian Moon
-
Phorum Dev Team - http://phorum.org
Making better forums with PHP
-



-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: User Defined Functions.

2001-11-27 Thread Andrew Schmidt 

http://www.mysql.com/doc/A/d/Adding_UDF.html

thanks,

-- Andrew

- Original Message -
From: Julio Faerman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 27, 2001 3:11 PM
Subject: User Defined Functions.


 Can i create my own functions with 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 PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Connection limit per user

2001-11-27 Thread Andrew Schmidt 

In the changes to 3.23.34  http://www.mysql.com/doc/N/e/News-3.23.34.html

o Added option max_user_connections to mysqld.

and in the show variables doc
http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html

o max_user_connections The maximum number of active connections for a single
user (0 = no limit).

so this feature is readily available depending on which version of mysql you
are using.

thanks,

-- Andrew


- Original Message -
From: Roman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 27, 2001 1:43 PM
Subject: Connection limit per user


 Hi All.

 Does anybody know how can I limit maximun connections number to mysqd for
 individual user, not for all users in sum, as it done by the variable
 max_connection ?
 I suppose it is nonstandard feature, and may be a patch for mysql is
available ?

 --
 regards
 Roman.

 -
 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 PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: undelete records ?

2001-11-19 Thread Andrew Schmidt 

the deleted rows will get re-used by inserts.

however,  you can always run OPTIMIZE TABLE XXX  and that will clear the
deleted rows

thanks,

-- Andrew

- Original Message -
From: Steve Wright [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, November 19, 2001 12:03 PM
Subject: undelete records ?



 I've had a dig around the mysql website / google  can't find an answer so
 maybe someone here can help...

 we've noticed data/records deleted from mysql databases still appear to
exist
 in the /var/lib/mysql/database/ files ?

 I presume they are flagged for deletion at a later date, if this is true
can
 anyone tell me when they are really deleted and if until then they can be
 recovered?

 A point in the right direction / website would be great.

 Thanks
 Steve.

 -
 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 PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

TCP_NODELAY: what systems?

2001-11-14 Thread Andrew Schmidt 

Hi guys,

In the latest MySQL release (3.23.44) it was noted:

o TCP_NODELAY was not used on some systems

Which systems would this affect?  and is this client side or server side?

thanks,

-- Andrew




-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Inner selects

2001-08-27 Thread Andrew Schmidt 

no mysql right now (3.23) does not support inner selects.

however,  it looks like you could join the 2 tables to get the result you
want

I'm assuming there are 2 tables inside the emp database ?  or is emp the
table ?

anyway here is an idea:

select d1.ename, d1.deptno FROM emp.table1 d1, emp.table2 d2 WHERE d1.deptno
= d2.deptno AND d2.ename = 'SCOTT'


-- Andrew


- Original Message -
From: Michael Beaucourt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 27, 2001 11:27 AM
Subject: Inner selects


 Hi all,

 I was wondering if it is possible to perform an inner select in MySQL.
 I have a database called EMP and when i enter the following query, I
 keep getting error 1064:

 select ename,deptno from emp where deptno in (select deptno from emp
 where ename = 'SCOTT')


 The error message reads as follows:
 ERROR 1064: You have an error in your SQL syntax near 'select deptno
 from emp where ename='scott')' at line 1


 Does MySQL support inner select this way or is there another way to
 achieve the same?

 Thanks for your help.

 Best Regards,
 Michael Beaucourt
 --

 -
 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 PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: auto_increment vs. heap tables

2001-08-16 Thread Andrew Schmidt 

good point.  the only real way to duplicate auto increment logic is to
create a new table with 1 row and 1 field. and lock, select, and update that
row.

thanks,

-- Andrew

- Original Message -
From: Johnny Withers [EMAIL PROTECTED]
To: 'Andrew Schmidt' [EMAIL PROTECTED]
Sent: Thursday, August 16, 2001 1:02 PM
Subject: RE: auto_increment vs. heap tables


 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1

 Except, if you have a table like so:

 ++-+
 | id | num |
 ++-+
 |  1 |   1 |
 |  2 |   2 |
 |  3 |   3 |
 |  4 |   4 |
 |  5 |   5 |
 ++-+

 And remove record 5..
 mysql delete from aitest where id=5;
 Query OK, 1 row affected (0.02 sec)

 mysql select max(id)+1 as nextid from aitest;

 ++
 | nextid |
 ++
 |  5 |
 ++


 You will see that you get nextid as being 5, again..
 this is wrong, nextid will be 6.

 mysql insert into aitest(num) values(6);
 Query OK, 1 row affected (0.00 sec)

 mysql select * from aitest;
 ++-+
 | id | num |
 ++-+
 |  1 |   1 |
 |  2 |   2 |
 |  3 |   3 |
 |  4 |   4 |
 |  6 |   6 |
 ++-+


 - -
 Johnny Withers
 [EMAIL PROTECTED]
 p. 601.853.0211
 c. 601.209.4985


 - -Original Message-
 From: Andrew Schmidt [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, August 16, 2001 10:18 AM
 To: Leos Bitto; [EMAIL PROTECTED]
 Subject: Re: auto_increment vs. heap tables


 auto increment is really just a nice way of doing the following
 (really nice
 way actually):

 lock table x
 select max(id) + 1 from table x
 insert into table x values (newid)
 unlock table x

 this is under the assumption table x as 1 field called id which has a
 primary key on it.  and newid is the id recieved from the select.

 so doing it manually with heap tables seems quite feasable just a
 little
 extra work.

 thanks,

 - -- Andrew

 - - Original Message -
 From: Leos Bitto [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Tuesday, August 14, 2001 6:05 AM
 Subject: auto_increment vs. heap tables


  Hello,
 
  I am currently changing a simple PHP4-based application from
  PostgreSQL 7.1 to MySQL 3.23. I have some tables in the database
  which I would like to create as TYPE=HEAP in MySQL. Because I have
  read the MySQL manual (applause here, please!) I know that
  auto_increment cannot be used there. This hurts me a lot, and given
  that MySQL doesn't support sequences, it nearly prohibits the usage
  of heap tables in my application.
 
  However, I am still not giving up, so here's the question: how
  difficult would it be to get rid  of that restriction for
  auto_increment in heap tables? The ideal answer I am hoping for is
  'yeah, that's easy - wait for 3.23.42' or 'try this patch and let
  us know if it works for you'.
 
  Thanks in advance for any response.
 
 
  Leos Bitto
 
 
 
  
  - 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 PROTECTED]
  To unsubscribe, e-mail
 [EMAIL PROTECTED]
  Trouble unsubscribing? Try:
  http://lists.mysql.com/php/unsubscribe.php
 
 


 - -
 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 PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try:
 http://lists.mysql.com/php/unsubscribe.php


 -BEGIN PGP SIGNATURE-
 Version: PGPfreeware 6.5.3 for non-commercial use http://www.pgp.com

 iQA/AwUBO3v8qbFNxPoD98ryEQLTugCgoEEhzKz/VraPLlDS4+VTuQBTeosAoKrD
 1RgfMXrbh3jf6EFdWPFpn9cW
 =I63n
 -END PGP SIGNATURE-




-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Looks like any user can read the mysql db!

2001-08-15 Thread Andrew Schmidt 

I'm not sure how you were able to do that.  Especially since you didn't
provide exactly what you did.

But here's what I get as ROOT (all privileges):

mysql load data infile '/usr/local/var/db/mysql/mysql/user.MYD' into table
t;
ERROR 1085: The file '/usr/local/var/db/mysql/mysql/user.MYD' must be in the
database directory or be readable by all
mysql

since all mysql datafiles are 660  (not readable by all) and do not sit in
the database directory I'm not sure how you would read in those tables.

The only thing I was able to read in was the .err file

perhaps you can explain in more detail what you did?

thanks,

-- Andrew

- Original Message -
From: Jose de Leon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 16, 2001 5:03 AM
Subject: Looks like any user can read the mysql db!


 MySQL 3.23.36

 Using the LOAD DATA command, I was able to read the first field of
user.MYD.  I think I should
 be able to load the rest of the table with a little bit of playing
around...

 I think with a little bit of ingenious delimeter specification, etc,
anybody should be able to
 load any table they want provided they know the path.

 -
 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 PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Looks like any user can read the mysql db!

2001-08-15 Thread Andrew Schmidt 

What are the permission in your /var/lib/mysql/mysql directory?

here's what I get:

mysql load data local infile '/usr/local/var/db/mysql/mysql/user.MYD' into
table t;
ERROR:
File '/usr/local/var/db/mysql/mysql/user.MYD' not found (Errcode: 13)
mysql


and here is the file

[dev-405:andrew] ...var/db/mysql (8) # ll
/usr/local/var/db/mysql/mysql/user.MYD
-rw-rw  1 mysql  mysql  1498 Jun 29 14:29
/usr/local/var/db/mysql/mysql/user.MYD
[dev-405:andrew] ...var/db/mysql (9) #

thanks,

-- Andrew

- Original Message -
From: Jose de Leon [EMAIL PROTECTED]
To: Andrew Schmidt [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, August 16, 2001 6:01 AM
Subject: Re: Looks like any user can read the mysql db!


 This is what I did:

 load data local infile '/var/lib/mysql/mysql/user.MYD' into table data;

 At first I did it without the 'local' keyword.  But with 'local' keyword
it works.



 ==
 On Wed, 15 Aug 2001 14:51:44 -0400
 Andrew Schmidt [EMAIL PROTECTED] wrote:

  I'm not sure how you were able to do that.  Especially since you didn't
  provide exactly what you did.
 
  But here's what I get as ROOT (all privileges):
 
  mysql load data infile '/usr/local/var/db/mysql/mysql/user.MYD' into
table
  t;
  ERROR 1085: The file '/usr/local/var/db/mysql/mysql/user.MYD' must be in
the
  database directory or be readable by all
  mysql
 
  since all mysql datafiles are 660  (not readable by all) and do not sit
in
  the database directory I'm not sure how you would read in those tables.
 
  The only thing I was able to read in was the .err file
 
  perhaps you can explain in more detail what you did?
 
  thanks,
 
  -- Andrew
 
  - Original Message -
  From: Jose de Leon [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Thursday, August 16, 2001 5:03 AM
  Subject: Looks like any user can read the mysql db!
 
 
   MySQL 3.23.36
  
   Using the LOAD DATA command, I was able to read the first field of
  user.MYD.  I think I should
   be able to load the rest of the table with a little bit of playing
  around...
  
   I think with a little bit of ingenious delimeter specification, etc,
  anybody should be able to
   load any table they want provided they know the path.
  
   -
   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 PROTECTED]
   To unsubscribe, e-mail
  [EMAIL PROTECTED]
   Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
  
  



-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: UPDATE which changes nothing gets duplicate error - bug?

2001-07-12 Thread Andrew Schmidt 

In the change log for 3.23.29:

Fixed a bug in UPDATE involving multi-part keys where one specified all key
parts both in the update and the WHERE part. In this case MySQL could try to
update a record that didn't match the whole WHERE part.

I think that was fixed.  Try upgrading your mysql server to the latest
3.23.39 and try testing that bug.

thanks,

-- Andrew

- Original Message -
From: John Nagle [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 12, 2001 1:07 PM
Subject: UPDATE which changes nothing gets duplicate error - bug?


 We have a table ticker with five primary keys.  Sometimes we
 do an UPDATE but don't change any values.  This produces the
 error ERROR 1062: Duplicate entry.  The manual indicates that
 a no-change UPDATE is allowed.  (ref page 583)  Is this a bug,
 or a documentation error?

 There are no auto-increment fields involved.

 Server 3.23.28-gamma, running on Win2K, SP1.

 John Nagle
 Downside.com

 mysql describe ticker;

++---+--
+-++---+-+
 | Field  | Type  |
 Null | Key | Default| Extra | Privileges  |

++---+--
+-++---+-+
 | symbol | varchar(5)
 |  | PRI ||   | select,insert,update,references |
 | exchange_section   | char(3)
 |  | PRI ||   | select,insert,update,references |
 | exchange   | varchar(6)
 |  | PRI ||   | select,insert,update,references |
 | cik| bigint(10)
 |  | MUL | 0  |   | select,insert,update,references |
 | company_conformed_name | varchar(120)
 |  | MUL ||   | select,insert,update,references |
 | security_name  | varchar(120)
 |  | PRI ||   | select,insert,update,references |
 | valid_from | date
 |  | PRI | -00-00 |   | select,insert,update,references |
 | valid_to   | date
 |  | | -00-00 |   | select,insert,update,references |
 | data_source| varchar(6)
 |  | ||   | select,insert,update,references |
 | cik_confidence | smallint(1)
 |  | | 9  |   | select,insert,update,references |
 | security_class | enum('normal','bank','foreign','unknown') |
 YES  | | unknown|   | select,insert,update,references |
 | errors | text  |
 YES  | | NULL   |   | select,insert,update,references |

++---+--
+-++---+-+
 12 rows in set (0.00 sec)

 mysql SELECT * FROM ticker WHERE symbol='ACSEF'
 - AND exchange='NASDAQ'
 - AND exchange_section='SCM'
 - AND security_name='ACS-Tech80 Limited - Common Stock'
 - AND valid_from='2001-05-24';

++--+--+-++-
--+++-+-
---++-+
 | symbol | exchange_section | exchange | cik | company_conformed_name |
 security_name | valid_from | valid_to   |
 data_source | cik_confidence | security_class |
 errors  |

++--+--+-++-
--+++-+-
---++-+
 | ACSEF  | SCM  | NASDAQ   |   0 ||
 ACS-Tech80 Limited - Common Stock | 2001-05-24 | 2001-07-11 |
 EDGAR   |  7 | unknown| Company name ACS TECH80
 LTD not found |

++--+--+-++-
--+++-+-
---++-+
 1 row in set (0.00 sec)

 mysql UPDATE ticker SET
 symbol='ACSEF',exchange_section='SCM',exchange='NASDAQ',
 - cik='0',company_conformed_name='',security_name='ACS-Tech80
 Limited - Common Stock',
 -
 security_class='unknown',valid_from='2001-05-24',valid_to='2001-07-11',
 - data_source='EDGAR',errors='Company name ACS TECH80 LTD not
 found',cik_confidence='7'
 - WHERE symbol='ACSEF'
 - AND exchange='NASDAQ'
 - AND exchange_section='SCM'
 - AND security_name='ACS-Tech80 Limited - Common Stock'
 - AND valid_from='2001-05-24';
 ERROR 1062: Duplicate entry 'ACSEF-NASDAQ-SCM-ACS-Tech80 Limited -
 Common Stock-2001-05-24' for key 4

Re: UPDATE which changes nothing gets duplicate error - bug?

2001-07-12 Thread Andrew Schmidt 

Be careful using REPLACE instead of UPDATE as it will destroy any fields in
the existing record that aren't in the update field set.  Unless of course
you always plan on setting all the fields on every REPLACE.

REPLACE is basicly an INSERT which upon finding a duplicate will replace it.
So treat REPLACE as INSERT.

thanks,

-- Andrew

- Original Message -
From: John Nagle [EMAIL PROTECTED]
To: Andrew Schmidt [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, July 12, 2001 2:58 PM
Subject: Re: UPDATE which changes nothing gets duplicate error - bug?


  That sounds like the bug.  In my example, I specified all
 five primary keys in both the update and the WHERE part, so that
 matches the situation reported in the bug.   Thanks.

  I changed my program to use a REPLACE instead of an UPDATE,
 which seems to have worked around the problem.  Does that bug ever
 affect REPLACE?

 John Nagle
 Animats

 Andrew Schmidt wrote:
 
  In the change log for 3.23.29:
 
  Fixed a bug in UPDATE involving multi-part keys where one specified all
key
  parts both in the update and the WHERE part. In this case MySQL could
try to
  update a record that didn't match the whole WHERE part.
 
  I think that was fixed.  Try upgrading your mysql server to the latest
  3.23.39 and try testing that bug.
 
  thanks,
 
  -- Andrew
 
  - Original Message -
  From: John Nagle [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Thursday, July 12, 2001 1:07 PM
  Subject: UPDATE which changes nothing gets duplicate error - bug?
 
   We have a table ticker with five primary keys.  Sometimes we
   do an UPDATE but don't change any values.  This produces the
   error ERROR 1062: Duplicate entry.  The manual indicates that
   a no-change UPDATE is allowed.  (ref page 583)  Is this a bug,
   or a documentation error?
  
   There are no auto-increment fields involved.
  
   Server 3.23.28-gamma, running on Win2K, SP1.
  
   John Nagle
   Downside.com
  
   mysql describe ticker;
  
 
++---+--
  +-++---+-+
   | Field  | Type  |
   Null | Key | Default| Extra | Privileges  |
  
 
++---+--
  +-++---+-+
   | symbol | varchar(5)
   |  | PRI ||   | select,insert,update,references |
   | exchange_section   | char(3)
   |  | PRI ||   | select,insert,update,references |
   | exchange   | varchar(6)
   |  | PRI ||   | select,insert,update,references |
   | cik| bigint(10)
   |  | MUL | 0  |   | select,insert,update,references |
   | company_conformed_name | varchar(120)
   |  | MUL ||   | select,insert,update,references |
   | security_name  | varchar(120)
   |  | PRI ||   | select,insert,update,references |
   | valid_from | date
   |  | PRI | -00-00 |   | select,insert,update,references |
   | valid_to   | date
   |  | | -00-00 |   | select,insert,update,references |
   | data_source| varchar(6)
   |  | ||   | select,insert,update,references |
   | cik_confidence | smallint(1)
   |  | | 9  |   | select,insert,update,references |
   | security_class | enum('normal','bank','foreign','unknown') |
   YES  | | unknown|   | select,insert,update,references |
   | errors | text  |
   YES  | | NULL   |   | select,insert,update,references |
  
 
++---+--
  +-++---+-+
   12 rows in set (0.00 sec)
  
   mysql SELECT * FROM ticker WHERE symbol='ACSEF'
   - AND exchange='NASDAQ'
   - AND exchange_section='SCM'
   - AND security_name='ACS-Tech80 Limited - Common Stock'
   - AND valid_from='2001-05-24';
  
 
++--+--+-++-

 --+++-+---
--
  ---++-+
   | symbol | exchange_section | exchange | cik | company_conformed_name
|
   security_name | valid_from | valid_to   |
   data_source | cik_confidence | security_class |
   errors  |
  
 
++--+--+-++-

 --+++-+---
--
  ---++-+
   | ACSEF  | SCM

Re: mysqldump bug during regenerate enum field.

2001-06-18 Thread Andrew Schmidt 

but mysqldump generates an invalid statement.

mysql CREATE TABLE TESTBADDUMP (
- e_test enum('0','1') NOT NULL default ''
- );
ERROR 1067: Invalid default value for 'e_test'
mysql

I think that's what the orignator is trying to show.  That mysqldump is
generating an invalid statement.

thanks,

-- Andrew

- Original Message -
From: Thomas Karcher [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 18, 2001 9:08 AM
Subject: Re: mysqldump bug during regenerate enum field.


 Hi,

  mysqldump regenerates a bad sql statement from a bad initial create
table.
 
  When you create this table for example (ok it's not a really nice
definition):
 
  CREATE TABLE TESTBADDUMP (
  e_test enum('0','1') NOT NULL default 0
  );
 
  desc TESTBADDUMP;
  ++---+--+-+-+---+
  | Field  | Type  | Null | Key | Default | Extra |
  ++---+--+-+-+---+
  | e_test | enum('0','1') |  | | |   |
  ++---+--+-+-+---+
 
  and use mysqldump to regenerate the sql statement, you obtain:
 
  CREATE TABLE TESTBADDUMP (
  e_test enum('0','1') NOT NULL default ''
  );

 If you use default 0, 0 is an integer. But ENUM only accept strings,
 so try to use default '0' when you create the table.

 Have a nice day,
 Thomas Karcher

 -
 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 PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: What is the for in ' safe_mysqld --log '

2001-06-06 Thread Andrew Schmidt 

that's a unix shell command that basicly puts the process in the background.

if you type that command at your console you'll notice you get a prompt
right away.

This allows safe_mysqld to run in the background (somewhat like a daemon)

thanks,

-- Andrew

- Original Message -
From: mysql list [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 06, 2001 11:29 AM
Subject: What is the  for in ' safe_mysqld --log  '


 I lost track of the tutorial where I saw the command
 safe_mysqld --log 
 What is the  for?

 __
 Do You Yahoo!?
 Get personalized email addresses from Yahoo! Mail - only $35
 a year!  http://personal.mail.yahoo.com/

 -
 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 PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: does show create table work?

2001-06-06 Thread Andrew Schmidt 

I believe show ceate table was added in mysql 3.23 and subsequently 3.22
will not have it.

thanks,

-- Andrew

- Original Message -
From: Rob Agar [EMAIL PROTECTED]
To: Mailinglist MySQL COM [EMAIL PROTECTED]
Sent: Wednesday, June 06, 2001 11:48 AM
Subject: does show create table work?


 hi!

 Does SHOW CREATE TABLE x actually work?   When I try it I just get error
 1064 (you have an error in your sql syntax near 'CREATE TABLE x')

 (version 3.22.32 on linux)

 ta,
 Rob Agar


 -
 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 PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

missing doc: identified by password

2001-05-02 Thread Andrew Schmidt 

Doing a :
mysql show grants for root@localhost;  
+---+
| Grants for root@localhost
| |
+---+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD 
|'6ffc60a31940f7bd' WITH GRANT OPTION |
+---+
1 row in set (0.00 sec)


However I can't find anywhere in the docs about IDENTIFIED BY PASSWORD 
(the PASSWORD part in particular)

I looked here:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#GRANT
and
http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.html#Adding_users

thanks,

-- Andrew

Re: missing doc: identified by password

2001-05-02 Thread Andrew Schmidt 

I guess I didn't phrase my point properly due to the emails I have been
recieving =).

I'm just stating that this feature isn't documented in the manual though it
probably should be.

sorry for the confusion.

thanks,

-- Andrew

- Original Message -
From: Andrew Schmidt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 02, 2001 11:01 AM
Subject: missing doc: identified by password


Doing a :
mysql show grants for root@localhost;
+---
+
| Grants for root@localhost
|
+---
+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD
'6ffc60a31940f7bd' WITH GRANT OPTION |
+---
+
1 row in set (0.00 sec)


However I can't find anywhere in the docs about IDENTIFIED BY PASSWORD
(the PASSWORD part in particular)

I looked here:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#GRA
NT
and
http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.h
tml#Adding_users

thanks,

-- Andrew




-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL 3.23.36 STILL Having Major Problems

2001-04-25 Thread Andrew Schmidt 

taken from the manual:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SHO
W_PROCESSLIST


SHOW PROCESSLIST shows you which threads are running. You can also get this
information using the mysqladmin processlist command. If you have the
process privilege, you can see all threads. Otherwise, you can see only your
own threads. See section 7.27 KILL Syntax. If you don't use the FULL option,
then only the first 100 characters of each query will be shown.

This command is very useful if you get the 'too many connections' error
message and want to find out what's going on. MySQL reserves one extra
connection for a client with the Process_priv privilege to ensure that you
should always be able to login and check the system (assuming you are not
giving this privilege to all your users).


I believe you will want to do the second paragraph.

regards,

-- Andrew

- Original Message -
From: Hunter Hillegas [EMAIL PROTECTED]
To: mySQL List [EMAIL PROTECTED]
Sent: Wednesday, April 25, 2001 11:21 AM
Subject: MySQL 3.23.36 STILL Having Major Problems


 OS: Red Hat Linux 6.0 / Intel
 1GB RAM

 MySQL 3.23.36
 PHP4.0.4PL1
 Linux kernel 2.4.3
 Using the my.cnf for medium sized sites

 mySQL starts with safe_mysqld and there are three threads running. Queries
 come in and out and it's quite fast. Using mysqladmin proc status shows no
 queries running.

 After about 12 hours, the number of mySQL threads visible in ps have shot
to
 about 75. At this point the server reports No More Connections, both
 through PHP and from mysqladmin.

 What's going on here? I can't figure it out. I can't even get in to
diagnose
 the problem, since the server is out of connections. 99% of my queries are
 SELECT's.

 It sounds like something is hanging on to connections and not returning
 them... I'm using mysql_connect() in the PHP scripts.

 Any ideas? This has taken my Web site out about 5 or 6 times in the last
two
 weeks. It's no fun. Anything anyone could do to help would be great.

 Hunter


 -
 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 PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL 3.23.36 STILL Having Major Problems

2001-04-25 Thread Andrew Schmidt 

Who are web users logging in as?   Take away their process_priv if they have
it (unless they need it).

Also,  what version of php are you running?  As old versions contained leaks
in connections

In the change log for php 4.0.4
cut
Fixed mysql_close(), pg_close(), msql_close() and sybase_close() - they
weren't properly closing the SQL connections (Zeev)
cut

regards,

-- Andrew

- Original Message -
From: Hunter Hillegas [EMAIL PROTECTED]
To: Andrew Schmidt [EMAIL PROTECTED]; mySQL List
[EMAIL PROTECTED]
Sent: Wednesday, April 25, 2001 3:04 PM
Subject: Re: MySQL 3.23.36 STILL Having Major Problems


 Running mysqladmin -p proc reports:

 too many connections...

 That's why I can't diagnose it.

 I'm logging in as root. How else would I get process_priv? I haven't
changed
 any parameters so I should be able to get in but I cannot.

 What am I doing wrong?

 Hunter

  From: Andrew Schmidt [EMAIL PROTECTED]
  Date: Wed, 25 Apr 2001 14:46:48 -0400
  To: Hunter Hillegas [EMAIL PROTECTED], mySQL List
  [EMAIL PROTECTED]
  Subject: Re: MySQL 3.23.36 STILL Having Major Problems
 
  taken from the manual:
 
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SHO
  W_PROCESSLIST
 
  
  SHOW PROCESSLIST shows you which threads are running. You can also get
this
  information using the mysqladmin processlist command. If you have the
  process privilege, you can see all threads. Otherwise, you can see only
your
  own threads. See section 7.27 KILL Syntax. If you don't use the FULL
option,
  then only the first 100 characters of each query will be shown.
 
  This command is very useful if you get the 'too many connections' error
  message and want to find out what's going on. MySQL reserves one extra
  connection for a client with the Process_priv privilege to ensure that
you
  should always be able to login and check the system (assuming you are
not
  giving this privilege to all your users).
  
 
  I believe you will want to do the second paragraph.
 
  regards,
 
  -- Andrew
 
  - Original Message -
  From: Hunter Hillegas [EMAIL PROTECTED]
  To: mySQL List [EMAIL PROTECTED]
  Sent: Wednesday, April 25, 2001 11:21 AM
  Subject: MySQL 3.23.36 STILL Having Major Problems
 
 
  OS: Red Hat Linux 6.0 / Intel
  1GB RAM
 
  MySQL 3.23.36
  PHP4.0.4PL1
  Linux kernel 2.4.3
  Using the my.cnf for medium sized sites
 
  mySQL starts with safe_mysqld and there are three threads running.
Queries
  come in and out and it's quite fast. Using mysqladmin proc status shows
no
  queries running.
 
  After about 12 hours, the number of mySQL threads visible in ps have
shot
  to
  about 75. At this point the server reports No More Connections, both
  through PHP and from mysqladmin.
 
  What's going on here? I can't figure it out. I can't even get in to
  diagnose
  the problem, since the server is out of connections. 99% of my queries
are
  SELECT's.
 
  It sounds like something is hanging on to connections and not returning
  them... I'm using mysql_connect() in the PHP scripts.
 
  Any ideas? This has taken my Web site out about 5 or 6 times in the
last
  two
  weeks. It's no fun. Anything anyone could do to help would be great.
 
  Hunter
 
 
  -
  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 PROTECTED]
  To unsubscribe, e-mail
  [EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 
 




-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

bug report

2001-04-20 Thread Andrew Schmidt 

Description:
tough one to describe.   the step by step example shows all
basicly once a table gets more than 1 row and doing a select with no
result will yield a blank date... gah please see the example =)

How-To-Repeat:
create database tmpdb;
use tmpdb;
create table test (foo int);
insert into test values (1);
select NOW(), count(*) from test where foo in (2);
+-+--+
| NOW()   | count(*) |
+-+--+
| 2001-04-20 17:21:29 |0 |
+-+--+

insert into test values (1);
select NOW(), count(*) from test where foo in (2);
+---+--+
| NOW() | count(*) |
+---+--+
|   |0 |
+---+--+

notice the date field is blank.

Fix:
how to correct or work around the problem, if known (multiple lines)
Submitter-Id:  submitter ID
Originator:Andrew Schmidt
Organization:
 organization of PR author (multiple lines)
MySQL support: [none | licence | email support | extended email support ]
Synopsis:  synopsis of the problem (one line)
Severity:  [ non-critical | serious | critical ] (one line)
Priority:  [ low | medium | high ] (one line)
Category:  mysql
Class: [ sw-bug | doc-bug | change-request | support ] (one line)
Release:   mysql-3.23.37 (Source distribution)
Environment:
machine, os, target, libraries (multiple lines)
System: FreeBSD wrk-112.tor1.targetnet.pvt 4.2-STABLE-20010112-JPSNAP
FreeBSD 4.
2-STABLE-20010112-JPSNAP #0: Thu Jan 11 20:06:54 GMT 2001
[EMAIL PROTECTED]
reebsd.org:/usr/src/sys/compile/GENERIC  i386
Some paths:  /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc
/usr/
bin/cc
GCC: Using builtin specs.
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''  LDFLAGS=''
LIBC:
-r--r--r--  1 root  wheel  1169222 Jan 11 14:28 /usr/lib/libc.a
lrwxrwxrwx  1 root  wheel  9 Jan 19 13:01 /usr/lib/libc.so - libc.so.4
-r--r--r--  1 root  wheel  559420 Jan 11 14:28 /usr/lib/libc.so.4
Configure command:
./configure  --localstatedir=/usr/local/var/db/mysql --withou
t-perl --without-debug --without-readline --without-bench --enable-assembler
 --e
nable-thread-safe-client
Perl: This is perl, version 5.005_03 built for i386-freebsd


-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysql uses 99% cpu under freebsd 4.3

2001-04-09 Thread Andrew Schmidt 

Have you tried this under a 'stable' version of freebsd?

In FreeBSD 4.2 beta, mysql would crash with user locks.  Not mysql's fault.

now, I understand RC's are generally stable; but I would still make sure
that this bug doesn't show up in a stable os.

regards,

-- Andrew

- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 09, 2001 3:34 PM
Subject: mysql uses 99% cpu under freebsd 4.3


 Description:
 mysql uses 99% cpu and becomes extremely unresponsive under high load

 How-To-Repeat:
 send about 300 simultaneous visitors to www.chicagobusiness.com and tell
them to click around.


 Fix:
 restart mysql.  this usally helps, at least for a few minutes.  sometimes
it climbs back to 99% though.

 Submitter-Id: submitter ID
 Originator: Jon Nathan
 Organization:
 Chaffee Interactive
 MySQL support: extended email support
 Synopsis: mysql uses 99% cpu and becomes unresponsive
 Severity: serious
 Priority: high
 Category: mysql
 Class: support
 Release: mysql-3.23.36 (Source distribution) from freebsd ports

 Environment:
 System: FreeBSD d1.crain.com 4.3-RC FreeBSD 4.3-RC #1: Tue Apr  3 16:17:52
GMT 2001 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/CHAFFEE  i386


 Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
 GCC: Using builtin specs.
 gcc version 2.95.2 19991024 (release)
 Compilation info: CC='cc'  CFLAGS='-O2 -pipe -mpentiumpro '  CXX='c++'
CXXFLAGS='-O2 -pipe -mpentiumpro  -felide-constructors -fno-rtti -fno-except
ions'  LDFLAGS=''
 LIBC:
 -r--r--r--  1 root  wheel  1170734 Apr  3 12:24 /usr/lib/libc.a
 lrwxr-xr-x  1 root  wheel  9 Apr  3 12:24 /usr/lib/libc.so - libc.so.4
 -r--r--r--  1 root  wheel  559764 Apr  3 12:24 /usr/lib/libc.so.4
 Configure command:
./configure  --localstatedir=/data/db --without-perl --without-debug --witho
ut-readline --without-bench --with-mit-threads=no --with-libwrap --with-low-
memory --enable-assembler --with-berkeley-db --with-charset=latin1 --prefix=
/usr/local i386--freebsd4.3
 Perl: This is perl, version 5.005_03 built for i386-freebsd

 -
 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 PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: history file

2001-04-03 Thread Andrew Schmidt 

it matters what you run the mysql client as

if I'm root

root: # mysql -u foo -p

the program mysql is running as root and hense writes the history file to
root's home dir.

if I'm me

andrew: $ mysql -u foo -p

it'll write it to ~andrew/.mysql_history

regards,

-- Andrew

- Original Message -
From: "Scott Meesseman" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 03, 2001 4:25 PM
Subject: history file


 Hi

 Does anyone know why no matter what user I log into my database undr, the
 only history file that is being written to is root's :

 /root/.mysql_history

 Why is a history file not created in the users home directory?

 Thank You so much to anyone who has the time to help.

 Scott


 -
 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 PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: problems with linking

2001-03-19 Thread Andrew Schmidt 

make sure you have -L/usr/local/mysql/lib/mysql/ in your compile

and make sure that /usr/local/mysql/lib/mysql/ is in your shared object
cache.

ldconfig -r  will list your current cache entries.
 if /usr/local/mysql/lib/mysql/libmysqlclient.so.10 is not in there then add
the path:

/sbin/ldconfig -m /usr/local/mysql/lib/mysql/ to add the directory to the
cache.

regards,

-- Andrew

- Original Message -
From: "Alonso Guarisma" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: "Keith Rambo" [EMAIL PROTECTED]
Sent: Monday, March 19, 2001 5:26 PM
Subject: problems with linking


 Dear MySQL Sirs,
 I have been trying to run a simple client program using the C API and
 unfortunatelly I am still getting the same error over and over again:
 ./client1: error in loading shared libraries: libmysqlclient.so.10:
 cannot open shared object file: No such file or directory

 Attached is the output of the libraries directory when I execute ls -l
 I cannot understand why the program does not find the library, I would
 really appreciate any help from you regarding this matter, because I
 already tried the options you provide in the MySQL manual (Section 20.3
 Problems when linking the MySQL client library).

 I also think the problems related to this library is causing me failures
 when I try to install the GUI for MySQL.

 I hope to hear from you as soon as possible, sincerely

 Alonso Guarisma







 alonso@linux:~  ls -l /usr/local/mysql/lib/mysql/
 total 972
 -rw-r--r--   1 mysqladm mysqlgrp11822 Feb 11 16:02 libdbug.a
 -rw-r--r--   1 mysqladm mysqlgrp34846 Feb 11 16:02 libheap.a
 -rw-r--r--   1 mysqladm mysqlgrp15246 Feb 11 16:02 libmerge.a
 -rw-r--r--   1 mysqladm mysqlgrp   230180 Feb 11 16:02 libmyisam.a
 -rw-r--r--   1 mysqladm mysqlgrp23312 Feb 11 16:02 libmyisammrg.a
 -rw-r--r--   1 mysqladm mysqlgrp   182284 Feb 11 16:02 libmysqlclient.a
 -rwxr-xr-x   1 mysqladm mysqlgrp  721 Feb 11 16:02 libmysqlclient.la
 lrwxrwxrwx   1 mysqladm root   24 Feb 11 16:02
libmysqlclient.so - libmysqlclient.so.10.0.0
 lrwxrwxrwx   1 mysqladm root   24 Feb 11 16:02
libmysqlclient.so.10 - libmysqlclient.so.10.0.0
 -rwxr-xr-x   1 mysqladm mysqlgrp   134367 Feb 11 16:02
libmysqlclient.so.10.0.0
 -rw-r--r--   1 mysqladm mysqlgrp31540 Feb 11 16:02 libmystrings.a
 -rw-r--r--   1 mysqladm mysqlgrp   190742 Feb 11 16:02 libmysys.a
 -rw-r--r--   1 mysqladm mysqlgrp   102344 Feb 11 16:02 libnisam.a







 -
 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 PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php