RE: Generic questions

[Braxton Robbason]

Andrzej,

As I understand it,

MySQL does not have the concept of tablespaces like in Oracle. Databases are
subdirectories underneath the /var/lib/mysql directory and files are tables
within those subdirectories, so you can put an entire database or individual
files on a different disk by creating a folder on the other disk with the
proper permissions and then linking to that folder from /var/lib/mysql as
detailed in the manual:
http://www.mysql.com/doc/S/y/Symbolic_links.html

The InnoDB table type has the concept of tablespaces:
'InnoDB stores its tables and indexes in a tablespace, which may consist of
several files. ' from http://www.mysql.com/doc/I/n/InnoDB_overview.html

for MyISAM tables, in terms of limits, each table consists of three files:
one for the table definition, one for the data, and one for the indexes.
Thus neither the data file nor the index can be larger than your OS
supports, which is 2GB on linux AFAIK.

In my experience working with mysql and oracle, the same table in mysql is
much smaller than it would be on oracle, often by a factor of five or more.
I'm not sure that others see this ratio of table sizes.

braxton

-Original Message-
From: Andrzej Janczyszyn [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 22, 2001 11:46 PM
To: [EMAIL PROTECTED]
Subject: Generic questions


Where may I find more detail information about MySQL DBA?

How MySQL handle very large table (10,000,000 records)?
How can I give direction where store data files?
 example:
/var/lib/mysql
|
MYDATABASE
|
 SPACE1
(/dev/sda3)
|
 SPACE2
(/dev/sdb1)
|
--- SPACE3
(/dev/sdc2)

Is it possible specify size and location of designated data files for a
specific tables (like
in Oracle create a table space and give a location of datafiles)?
What are MySQL limits?

All the questions relate to MySQL on Linux.

Thanks,
AMJ



-
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: 64MB Limit on MyISAM indexes?

[Ole Gjerde]

Hi,
I'm having that same problem, but I only have about 1.3 million rows in my
table, and the size is only about 190MB or so.

This started with 3.23.21 (Which had this problem, look in the changelog),
but it is also continuing after upgrading to 3.23.36.

I have a 3.23.36 slave that is replication off of the one above, and that
one now has a index that is well over 100MB.  Weird thing is that the db
files are 100% the same(ie, they are both from the same tar'ed mysql
directory/files), so this could suggest it has to do with glibc or somesuch.
The working on is a RH7(glibc 2.2) box and the non-working is an old
slackware 4.0(libc 5.4.46) box with some upgrades.

However, from the manual:
MySQL requires libc Version 5.4.12 or newer.  It's known to work with libc
5.4.46.

So that shouldn't be a problem either.

Both are running 2.2.19 on i386.

Thanks,
Ole Gjerde
Mimer AS

- Original Message -
From: ryc [EMAIL PROTECTED]
To: Jeff Brewer [EMAIL PROTECTED]; MySQL Mail List
[EMAIL PROTECTED]
Sent: Saturday, April 21, 2001 2:59 AM
Subject: Re: 64MB Limit on MyISAM indexes?


 You need to change the maxrows on the table. It is in the documentation,
I
 dont remember the exact syntax something like alter table tablename set
 maxrows=1 for tables larger than 2gigs.

 ryan

  I've got tables in ISAM format whose indexes are way over 64 MB.
However,
  when I try to create a MyISAM table with an index that big I get errors
 and
  confirming that with myisamchk I get:
 
  myisamchk: warning: Keyfile is almost full,   67107839 of   67107839
used
 
  Which is essentially 64MB.  Are MyISAM tables able to handle large
 indexes?
  I hope I don't have to go back to ISAM tables...



-
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

Problem in connecting to mysql using perl

[Harish H N]

Dear Sir,
I have downloaded DBI-1.15. I tried installing it. The tests failed.
I am using PMAKE to prepare an install program.

The error is as follows:

can't locate loadable object for module DBI in @INC.

I am also providing you with the procedure i adopted to install DBI

  step 1: I checked my perl version. It is active-state perl 5.6.0

  step 2: I gave the command pmake makefile.pl

err:can't 'MAKE', - no target makefile.pl at Make.pm line 1164.

  step 3: On command pmake

pro: Reading Make.pm
   Reading /..makefile
   ...
err:  The name specified is not recognized as an internal or an external
   command, operable program or batch file. 

 step 4: On command pmake test

pro: Reading Make.pm
   Reading /..makefile
   ...
err:  The name specified is not recognized as an internal or an external
   command, operable program or batch file. 


Please tell me where I am wrong. Is there any setup kit, so that I can install
the DBI module easily.

With this, I also request you to give a suggession to connect to mySQL
without using DBI. Can I connect to mySQL database using win32::ODBC.
If yes, please give me code details on how to connect using this.

waiting for a positive response,
-harish



  

Re: complicated query

[Milo Stefani]

try
ORDER BY (Category = 'Other'), Category, Subcategory
It should work, (I hope ^_-;;;)

- Original Message -
From: Jeff Shipman - SysProg [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 20, 2001 8:38 PM
Subject: complicated query


 I would like to do something similar to an ORDER BY
 in one of my select statements, but I'mt not sure
 how to do something as complicated as this:

 I have two columns, category and subcategory, that
 I am retrieving. I would like category and subcategory
 to be sorted alphabetically. This is easy with an
 'ORDER BY 1 2', but I would like categories that
 are named 'other' to be put off until the end. So,
 I'd get something like this:

 abcd
 ghikj
 z
 other

 Is there a way to do this type of query? Thanks in
 advance.

 Jeff Shipman   E-Mail: [EMAIL PROTECTED]
 Systems Programmer Phone: (505) 835-5748
 NMIMT Computer Center  http://www.nmt.edu/~jeff



 -
 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: Every host is localhost

[Freaked Personality]

I don't exactly understand your problem but I think you want to secure
access to a certain part of your webserver instead of our your MySQL
server. If you are running apache you can secure complete directories with
.htaccess files.




On Wed, 18 Apr 2001, Sam Yenge wrote:

 Hi
 
 (Re: mysql 3.23.33 )
 
 I have got mysql running fine with the only problem that every connections
 made to it through a web browser (using cgi scripts) are considered as
 coming from localhost. In this way, I cannot limit the machines that
 should be allowed access. I read the manual pages, cleaned up user and
 host tables to remove all the default settings but the problem persists.
 
 The name of the server is being picked up from my scripts in the
 my ($dbh) = DBI-connect(.:localhost/machine's name,...)...
 
 All other machines for which permission was granted are being ignored and
 granting users permission to connect from localhost/its real name allows
 access from any host which is not what I wanted.
 
 Wherever the connection comes from, the log file shows:
   Connect username@localhost dbname
   Query ...
 
  or
 
   Connect username@machinename dbname
   Query ...
 
 
 Any idea??
 
 Thanks
 
 Sam
 
 
 
 
 
 -
 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

MySQL On Unix

[Janos Borbely]

Dear Gents,

I would like to access MySQL database running on Unix from a Windows
workstation through ODBC. IS it possible? Can you give me a tip how to
do that?

Thanks a lot for your help! Regards

Janos Borbely


-
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

Need help with 23.36

[New Style MySQL Personnel]

I copied my database files made with 23.29 to 23.26 and now I get this. I
chowned mysql.mysql and chmoded 660. What's wrong?

mysql use lumina;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Didn't find any fields in table 'absences'
Didn't find any fields in table 'admins'
Didn't find any fields in table 'classes'
Didn't find any fields in table 'marks'
Didn't find any fields in table 'students'
Didn't find any fields in table 'teachers'
Didn't find any fields in table 'users'
Didn't find any fields in table 'vars'
Database changed

It's urgent! Thanx!


-
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 On Unix

[Javier Armendáriz]

Hi,

You must install MyODBC in your Unix system, and the MyODBC module for
windows.

Once it is done, make a new connection trought this module whit de ODBC
default fort, the machine name, user, pass and database.

It was all I did and it worked correctly


Javier Armendáriz
[EMAIL PROTECTED]

 -Mensaje original-
 De: Janos Borbely [mailto:[EMAIL PROTECTED]]
 Enviado el: lunes, 23 de abril de 2001 9:12
 Para: [EMAIL PROTECTED]
 Asunto: MySQL On Unix


 Dear Gents,

 I would like to access MySQL database running on Unix from a Windows
 workstation through ODBC. IS it possible? Can you give me a tip how to
 do that?

 Thanks a lot for your help! Regards

 Janos Borbely


 -
 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

Selection bug in 3.23.37

[Nicola Sabbi]

 HI,
 I have the following table:


 desc keywords_news;
 ++--+--+-+-+---+
 | Field  | Type | Null | Key | Default | Extra |
 ++--+--+-+-+---+
 | id_keyword | int(11)  |  | PRI | 0   |   |
 | id_news| char(32) |  | PRI | |   |
 ++--+--+-+-+---+

with primary key on the couple (id_keyword, id_news).

When I launch:

 select distinct kn.id_keyword, k.keywords  from news n, keywords_news kn, keywords k
 where (kn.id_news=n.id_news)
and (n.id_news='news-965409279-1907') and
 kn.id_keyword=k.id_keyword;


 I obtain

++--+
 | id_keyword | keywords |
 ++--+
 | 13 | la   |
 |107 | in   |
 |194 | ragazzi  |
 |195 | h|
 |196 | arrivo   |
 |197 | pop-music! |
 ++--+


 and when I remove 'DISTINCT' from the query  the result is:

 Empty set (0.00 sec)

 It seems a bug, I should obtain duplicated couples without DISTINCT, right?

 Thanks
   Nico



-
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

Need help with 23.36

[New Style MySQL Personnel]

I copied my database files made with 23.29 to 23.26 and now I get this. I
chowned mysql.mysql and chmoded 660. What's wrong?

mysql use lumina;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Didn't find any fields in table 'absences'
Didn't find any fields in table 'admins'
Didn't find any fields in table 'classes'
Didn't find any fields in table 'marks'
Didn't find any fields in table 'students'
Didn't find any fields in table 'teachers'
Didn't find any fields in table 'users'
Didn't find any fields in table 'vars'
Database changed

It's urgent! Thanx!



-
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: Connecting to mysql as root

[B. van Ouwerkerk]

  For connecting I have given the user as root and no password in the PERL 
 scipt.

You NEED to provide the password otherwise you can't get any data out of 
the database.. If you didn't entered a password for the mysql root user you 
need to do it ASAP..

Is there any way to connect to the database in the normal way, I 
 mean from the shell ?

mysql -u root -p
then you're asked to enter your password
use name_of_database

Bye,


B.


-
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: Need help with 23.36

[B. van Ouwerkerk]

I copied my database files made with 23.29 to 23.26 and now I get this. I
chowned mysql.mysql and chmoded 660. What's wrong?

Perhaps or.. the location of your database is different.. or.. you 
didn't copy everything.. including subdirectories.

Solution: check the location and if you copied all files..

Bye,


B.


-
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

Berkely DB

[Warren van der Merwe]

Hi there

I am trying to find out how the Berkely DB stuff works when running MYSQL on
windows. How do I create a transactional table?

Regards
Warren


~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Cell (083) 262-9163
Office (031) 767-0249



-
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: Src distribution of MySQL takes up a lot of space

[B. van Ouwerkerk]

I'm new to MySQL and I've recently installed MySQL
(MySQL-3.23.36-1.src.rpm) and it's running ok. But, I noticed that it
seems to be consuming so much of my hard disk space. Is this normal? I'm
wondering if anyone encountered this problem before or can advise wat I
can do abt it?

I don't know what gets installed with the .rpm I never use them. If you 
think stuff gets installed which you don't need you could compile from source.

I don't consider it a problem if mysql uses a lot of space.. large drives 
aren't very expensive anymore..

Bye,


B.


-
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

Complicated Query...

[$B$U(B]

Hi there,
I'm having a problem on my complicated query.
My question is similar to the question in a couple of emails earlier in
this mailing list which subject's is complicated query.

I got 3 tables below.

test1 table
++--+
| id | name |
++--+
|  1 | fumi |
|  2 | ali  |
|  3 | ton  |
++--+

test2 table
+++---+
| id | maker  | price |
+++---+
|  1 | fum111 |   102 |
|  3 | ton222 |   150 |
+++---+

test3 table
++--+
| id | location |
++--+
|  3 | LA   |
++--+

when I commit my query select test1.*,test2.*,test3.* from test1 left join test2 on 
test1.id = test2.id left join te
st3 on test1.id = test3.id;,I get this table below.
++--+--++---+--+--+
| id | name | id   | maker  | price | id   | location |
++--+--++---+--+--+
|  1 | fumi |1 | fum111 |   102 | NULL | NULL |
|  2 | ali  | NULL | NULL   |  NULL | NULL | NULL |
|  3 | ton  |3 | ton222 |   150 |3 | LA   |
++--+--++---+--+--+

Now I wanna sort this table by smaller price. (I want NULL to be at the last)
so I made a new query  select test1.*,test2.*,test3.* from test1 left join test2 on 
test1.id = test2.id left join te
st3 on test1.id = test3.id  order by (price is null); according to a couple
of email earlier in this mailing list.

I get the table below.
++--+--++---+--+--+
| id | name | id   | maker  | price | id   | location |
++--+--++---+--+--+
|  3 | ton  |3 | ton222 |   150 |3 | LA   |
|  1 | fumi |1 | fum111 |   102 | NULL | NULL |
|  2 | ali  | NULL | NULL   |  NULL | NULL | NULL |
++--+--++---+--+--+

In a price column, NULL is at the last, so it's okay, BUT !!
150 is upper than 102 !! I want smaller price to show up upper and
finally NULL.

I've tried many queries , but couldn't find out...
anybody can give me a hint or answer ?

Thank you for reading till here.

Fumitada.

-
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

I need help to instal mysql

[Lana Conan]

First of all sorry for my English, I hope it would be good enougth to be 
understood.

I am trying to instal mysql on a digital unix os.

First I had problem   with the ./configure
it prompted this message

checking for cc++... no
checking for cl... no
checking whether the C++ compiler (gcc   ) works... no
configure: error: installation or configuration problem: C++ compiler
cannot create executables.

so I installed gcc-2.95.3

and the ./configure seemed to work.

then gave the command make
and I had this error message


bash# make
No suffix list.
make  all-recursive
No suffix list.
Making all in include
No suffix list.
Make: % rule can only use a single ':'.  Stop.
*** Exit 1
Stop.
*** Exit 1
Stop.
bash#

Can you please give me some information on what happen and what I did wrong.


Thank you for your attention
best regards
Sandra



_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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

Strange output from EXPLAIN SELECT - explanation needed!

[Basil Hussain]

Hi all,

I was just fiddling around with some indexes on a table and decided to do an
EXPLAIN for a query I was trying to optimize. I got a peculiar message
output, and I'm not sure what it's trying to tell me!

This is what I got:

mysql explain select min(impression), max(impression) from eventlog_81;
+--+
| Comment  |
+--+
| Select tables optimized away |
+--+
1 row in set (0.00 sec)

As you can see, it contains none of the usual information I was expecting. I
tried looking up that message in the manual, but it isn't covered in the
info on EXPLAIN.

I reckon it might be saying that it figured out the answer to the query
without having to look at the table (i.e. only consulting the index on the
'impression' column), but I'm not sure. Can anyone tell me what this message
means?

Regards,


Basil Hussain ([EMAIL PROTECTED])


-
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: Offtopic: Anybody from London?

[Pjotr Nyikolajevics Szekszardi]

[EMAIL PROTECTED] wrote:
 
 Your message cannot be posted because it appears to be either spam or
 simply off topic to our filter. To bypass the filter you must include
 one of the following words in your message:
 
 database,sql,query
 
 If you just reply to this message, and include the entire text of it in the
 reply, your reply will go through. However, you should
 first review the text of the message to make sure it has something to do
 with MySQL. You have written the following:
 
 offtopic
 Hi,
 
 Could anybody please help me? I have been offered a job in London, but I
 do not have enough information about average salaries, average costs,...
 Sorry to disturb you with this, but I need some help.
 (Please e-mail me privately.)
 
 Regards,
 
 Peter
 /offtopic

-
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

Criteria in the GRANT command

[Mark van Brenk]

Greetings, and I'm sorry if this is a topic that's already been covered, but I've read 
over about 100 of the past mails and can't find something similar.

How do I GRANT UPDATE to specific columns in specific records?

Example:

I've got a table u which covers complete data on each user for the group I 
administer the database for. I want to grant users the ability to update certain items 
in their rows, however, want their user/password to ONLY update that row.

I've got GRANT UPDATE (fname, lname, email, etc.) ON tsf.u etc. However, I want to 
issue the criteria similar to.. GRANT UPDATE (fname, lname, email WHERE u.uID=10) - 10 
being that user's ID number.

The WHERE clause doesn't work (or maybe I've using the wrong syntax).. any help?

Re: compress problem when using MySQL++

[Sinisa Milivojevic]

William Dan Terry writes:
 
 When you say the bug is in the linker, do you mean in the linker app
 itself or how I'm using it? In terms of the static zlib, don't I have that
 covered with 
 
 gcc -static metamgrd.o sock.o cfgfile.o cfgitem.o err.o -o ./metamgrd \
 -lstdc++ -L/usr/lib/mysql -lz -lmysqlclient -lsqlplus
 
 or am I missing something else?
 


I mean in the linker app itself, although you have put -static and it
is possible that you have only dynamic version of zlib library. That
is a definite possibility.

Also, follow other instructions too ..


Regards,

Sinisa

    __ _   _  ___ ==  MySQL AB
 /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
  /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
  /*/^^^\*\^^^
 /*/ \*\Developers Team

-
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 dissapearing

[Sinisa Milivojevic]

ryc writes:
 I have a auto increment field in a table and after doing a few operations
 the flag has gone away. This is using mysql 3.23.36 on OpenBSD. Here is how
 it happened:
 
 I am using perl with DBI to interface with mysql. I have been inserting
 NULL into this field to allow mysql to fill in the auto_increment value
 for me. Eventually I started using mysqlimport to put records into this same
 table. When the text file had NULL for the auto_increment field,
 mysqlimport would count that as a warning. Wanting to get mysqlimport to run
 warning free I tried changing the values from NULL to 0 for the
 auto_increment field. This worked great.
 
 Sometime a week later, and many many imports, I changed the perl code to
 insert with 0 instead of NULL. Instead of working as advertised, the
 insert resulted in a row with id set to 0 rather than the next
 auto_increment value. I deleted the row with id 0, and tried running
 mysqlimport again only to find it will not insert anything because of
 duplicate key entry 0 (even though it has been deleted). I ran myisamchk
 and it said the table was fine. After running myisamchk I noticed the extra
 column does not list auto_increment when doing a describe table. It just
 went away.
 
 When I try to do select * from table where id = 0 I get error 127,
 record-file is crashed.
 
 Does anyone know how I can fix this without loosing any data or changing the
 values in the auto_increment field? Did I do something wrong to screw up the
 table? How can this be avoided in the future?
 
 Thanks in advance.
 ryan


Hi!

The only solution for your problem in this moment is to omit
auto_increment column add list of columns in mysqlimport.

We plan to make a more flexible import in 4.* .


Regards,

Sinisa

    __ _   _  ___ ==  MySQL AB
 /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
  /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
  /*/^^^\*\^^^
 /*/ \*\Developers Team

-
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: Selection bug in 3.23.37

[Sinisa Milivojevic]

Nicola Sabbi writes:
  HI,
  I have the following table:
 
 
  desc keywords_news;
  ++--+--+-+-+---+
  | Field  | Type | Null | Key | Default | Extra |
  ++--+--+-+-+---+
  | id_keyword | int(11)  |  | PRI | 0   |   |
  | id_news| char(32) |  | PRI | |   |
  ++--+--+-+-+---+
 
 with primary key on the couple (id_keyword, id_news).
 
 When I launch:
 
  select distinct kn.id_keyword, k.keywords  from news n, keywords_news kn, keywords k
  where (kn.id_news=n.id_news)
 and (n.id_news='news-965409279-1907') and
  kn.id_keyword=k.id_keyword;
 
 
  I obtain
 
 ++--+
  | id_keyword | keywords |
  ++--+
  | 13 | la   |
  |107 | in   |
  |194 | ragazzi  |
  |195 | h|
  |196 | arrivo   |
  |197 | pop-music! |
  ++--+
 
 
  and when I remove 'DISTINCT' from the query  the result is:
 
  Empty set (0.00 sec)
 
  It seems a bug, I should obtain duplicated couples without DISTINCT, right?
 
  Thanks
Nico
 
 


The above definitely does not look right !

First of all check your table, and if any inconsistency is reported,
REPAIR it and try again.

If you obtain the same result then we would like to have your table
and query for testing.


Regards,

Sinisa

    __ _   _  ___ ==  MySQL AB
 /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
  /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
  /*/^^^\*\^^^
 /*/ \*\Developers Team

-
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

Query problems

[Wix,Christian XCW]

Hi
I have two similar tables. (table1  table2). They contain the columns
name, distance and date. Table1 is year 2000 and Table2 year 2001.

I need to get the total distance for each name.
For year 2000 I would do this:
select name, SUM(distance) from table1 group by name;

How do I do it for both years? (one query)

Thanks,

// Chris - Copenhagen


-
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

Any low budget database access available ???

[me]

Hi,
I am hoping to find somebody who provides low budget mysql and php access.

Thank you very much for any suggestion
Andonny

-
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

Random string for each row in a table

[Prasad Mhatre]

Dear All,

How do I create random string for each row in a mysql table? and mail the
same each recepient in the respective row.

Thanks
Love and regards
Prasad


-
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

how can i make it?

[Z_da_eXTaZie]

For example i have 3 tables (really i have to make it with 6 tables, but...)
So 3 tables:

Table1
uid| name
1user1
2user2
3user3

Table2
iduidc
1150
2123
3142
4223
52303

Table3
idctxt
123'twenty-three'
242'the reason of life'
350'50'
4303'303 rulz'

how can i get a recordset constains all records (or records matching a where
exp.) from the Table1 with the c values from the Table2, like this:

uidnamecs
-
1user1'50 - twenty-three - the reason of life'
2user2'twenty-three - 303 rulz'
3user3''

I can make heavy things with mysql, but i'm too small for this :)

thanx: Z



-
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: Query problems

[meyer]

Create a merge table of the year 2000 and year 2001 tables as follows. 
Then run your select on the merged table.
You can then drop the merge table if you don't need it anymore.


CREATE TABLE table3 (name, distance, date) TYPE=MERGE UNION=(table1,table2);
SELECT name, SUM(distance) FROM table3 GROUP BY name;
DROP table3;

HTH 
Edward


4/23/2001 5:01:48 PM, Wix,Christian XCW [EMAIL PROTECTED] wrote:

Hi
I have two similar tables. (table1  table2). They contain the columns
name, distance and date. Table1 is year 2000 and Table2 year 2001.

I need to get the total distance for each name.
For year 2000 I would do this:
select name, SUM(distance) from table1 group by name;

How do I do it for both years? (one query)

Thanks,

// Chris - Copenhagen


-
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: Need help with 23.36

[New Style MySQL Personnel]

The location is good because I have some other databases created with 36
and they work fine. I copied ALL the database's files to /var/lib/mysql
where the others are and I get this error. Any idea?

On Mon, 23 Apr 2001, B. van Ouwerkerk wrote:


 I copied my database files made with 23.29 to 23.26 and now I get this. I
 chowned mysql.mysql and chmoded 660. What's wrong?

 Perhaps or.. the location of your database is different.. or.. you
 didn't copy everything.. including subdirectories.

 Solution: check the location and if you copied all files..

 Bye,


 B.


 -
 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

mysql_install_db problems

[Pete Mattison]

Hi folks,

Thought I'd see if I have a common problem before I do a bug report. I am 
trying to install the binary file for HP/UX 10.20 on a HP/UX 10.20 785 
series computer. As the error message is about memory problems the following 
info may be of interest. The tar file is on a volume with 30,000 bytes free 
space. I unpack the file into the /usr/local/mysql-OS-version directory onto 
the volume /usr which has 300,000+ bytes free space. Okay, the result of 
running the install script is:

# scripts/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
010423 11:09:07  Warning: setrlimit couldn't increase number of open files 
to more than 200
010423 11:09:07  Warning: Changed limits: max_connections: 100  table_cache: 
64
scripts/mysql_install_db[284]: 15102 Memory fault(coredump)
Installation of grant tables failed!

Examine the logs in ./data for more information.
You can also try to start the mysqld demon with:
./bin/mysqld --skip-grant 
You can use the command line tool
./bin/mysql to connect to the mysql
database and look at the grant tables:

shell ./bin/mysql -u root mysql
mysql show tables


There are no logs in the ./data directory just a core dump. When I try 
./bin/mysqld --skip-grant I get the following message:

# ./bin/mysqld --skip-grant
010423 15:07:48  Warning: setrlimit couldn't increase number of open files 
to more than 200
010423 15:07:48  Warning: Changed limits: max_connections: 100  table_cache: 
64
./bin/mysqld: Can't change dir to 
'/usr/local/mysql-3.23.37-hp-hpux10.20-hppa1.1/var/' (Errcode: 2)
010423 15:07:48  Aborting

010423 15:07:48  ./bin/mysqld: Shutdown Complete

Why does mysqld even try to change to ../var ? This is a binary distribution 
and this directory does not exist!

Can someone help me or is this a case for bug fixing?

Thanks a lot in advance,

Pete
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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

MySQL 3.23.37 Compile Problem

[scott.Dukes]

I'm having trouble building the mysql323-server port (3.23.36/7). I am
running Freebsd 3.5 on an i386.
The build breaks during the sql/share/Makefile with the following error:

/bin/sh ../libtool --mode=link c++  -DDBUG_OFF -O -pipe
-felide-constructors -fno-rtti  -fno-implicit-templates
-DMYSQLD_NET_RETRY_COUNT=100  -o mysqld  sql_lex.o item.o item_sum.o
item_buff.o item_func.o  item_cmpfunc.o item_strfunc.o item_timefunc.o
thr_malloc.o  item_create.o field.o key.o sql_class.o sql_list.o
net_serv.o violite.o  net_pkg.o lock.o my_lock.o sql_string.o
sql_manager.o sql_map.o  mysqld.o password.o hash_filo.o hostname.o
convert.o sql_parse.o  sql_yacc.o sql_base.o table.o sql_select.o
sql_insert.o sql_update.o  sql_delete.o procedure.o item_uniq.o
sql_test.o log.o init.o derror.o  sql_acl.o unireg.o time.o opt_range.o
opt_sum.o opt_ft.o records.o  filesort.o handler.o ha_isam.o
ha_isammrg.o ha_heap.o ha_myisam.o  ha_myisammrg.o ha_berkeley.o
ha_innobase.o ha_gemini.o sql_db.o  sql_table.o sql_rename.o sql_crypt.o
sql_load.o mf_iocache.o  field_conv.o sql_show.o sql_udf.o sql_analyse.o
sql_cache.o slave.o  sql_repl.o md5.o log_event.o mini_client.o
mini_client_errors.o -L../bdb/build_unix -ldb
../isam/libnisam.a   ../merge/libmerge.a
../myisam/libmyisam.a   ../myisammrg/libmyisammrg.a
../heap/libheap.a   ../mysys/libmysys.a
../dbug/libdbug.a   ../regex/libregex.a
../strings/libmystrings.a   -Lyes/lib -lwrap -lz -lcrypt -lm  -pthread
cd: can't cd to yes/lib
libtool: link: warning: cannot determine absolute directory name of
`yes/lib'
libtool: link: passing it literally to the linker, although it might
fail
c++ -DDBUG_OFF -O -pipe -felide-constructors -fno-rtti
-fno-implicit-templates -DMYSQLD_NET_RETRY_COUNT=100 -o mysqld
sql_lex.o item.o item_sum.o item_buff.o item_func.o item_cmpfunc.o
item_strfunc.o item_timefunc.o thr_malloc.o item_create.o field.o key.o
sql_class.o sql_list.o net_serv.o violite.o net_pkg.o lock.o my_lock.o
sql_string.o sql_manager.o sql_map.o mysqld.o password.o hash_filo.o
hostname.o convert.o sql_parse.o sql_yacc.o sql_base.o table.o
sql_select.o sql_insert.o sql_update.o sql_delete.o procedure.o
item_uniq.o sql_test.o log.o init.o derror.o sql_acl.o unireg.o time.o
opt_range.o opt_sum.o opt_ft.o records.o filesort.o handler.o ha_isam.o
ha_isammrg.o ha_heap.o ha_myisam.o ha_myisammrg.o ha_berkeley.o
ha_innobase.o ha_gemini.o sql_db.o sql_table.o sql_rename.o sql_crypt.o
sql_load.o mf_iocache.o field_conv.o sql_show.o sql_udf.o sql_analyse.o
sql_cache.o slave.o sql_repl.o md5.o log_event.o mini_client.o
mini_client_errors.o -L../bdb/build_unix -ldb ../isam/libnisam.a
../merge/libmerge.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a
../heap/libheap.a ../mysys/libmysys.a ../dbug/libdbug.a
../regex/libregex.a ../strings/libmystrings.a -Lyes/lib -lwrap -lz
-lcrypt -lm -pthread
hostname.o: In function `ip_to_hostname(in_addr *, unsigned int *)':
hostname.o(.text+0x52b): undefined reference to `my_gethostbyname_r'
*** Error code 1

Stop.

I managed to fix the 'yes/lib' error? (which relates to the wrapping
using tcp wrappers):

cd: can't cd to yes/lib

by adding --with-libwrap=/usr to the CONFIGURE_ARGS of the port, but the
build still breaks with the hostname error:
hostname.o: In function `ip_to_hostname(in_addr *, unsigned int *)':
hostname.o(.text+0x52b): undefined reference to `my_gethostbyname_r'

Have you experienced this, and if so, do you know how to fix it?

Any help you could give me would be HUGELY appreciated.

.hasta luego

scott.Dukes [[EMAIL PROTECTED]]
blue.Kryptonite [http://blue.Kryptonite.co.za/]
:s 161 Tenth Ave, Morningside, Durban
:a Postnet Suite 399, Private Bag X10, Musgrave, 4062, South Africa
:p +27 31 312 1122
:f +27 31 303 8722
:c +27 83 661 3880




-
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: Query problems

[Warren van der Merwe]

Hi

In my opinion I would imagine Merged tables would do what you wanting. Refer
to the MYSQL manual.

Thanks


~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Cell (083) 262-9163
Office (031) 767-0249


 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]
 ]On Behalf
 Of Wix,Christian XCW
 Sent: 23 April 2001 02:02
 To: '[EMAIL PROTECTED]'
 Subject: Query problems


 Hi
 I have two similar tables. (table1  table2). They contain the columns
 name, distance and date. Table1 is year 2000 and Table2
 year 2001.

 I need to get the total distance for each name.
 For year 2000 I would do this:
 select name, SUM(distance) from table1 group by name;

 How do I do it for both years? (one query)

 Thanks,

 // Chris - Copenhagen


 -
 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: how can i make it?

[B. van Ouwerkerk]

how can i get a recordset constains all records (or records matching a where
exp.) from the Table1 with the c values from the Table2, like this:

uidnamecs
-
1user1'50 - twenty-three - the reason of life'
2user2'twenty-three - 303 rulz'
3user3''

I can make heavy things with mysql, but i'm too small for this :)

Think what you want is left join. Check your favorite SQL manual for syntax.

Bye,


B.


-
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: Information Technique

[Ken Menzel]

Bonjour,
  J'utile le 'characterset default' de MySQL et je n'ai acune probléme
avec mysql.  Si'l te plait, donne ça un coup,  D'abord on a besoin
d'un ligne de commande de mysql liée à le serveur en question.  (comme
mysql -uusername -pmotdepasse -hhôte.domaine )

You should not need to escape french characters.  Try this test
script:
Just use 'cut and paste' to paste eash line into the command line
interface and you will see it works fine.


use test;
create table français (
id int unsigned auto_increment primary key,
text char(60)
);
insert français (text) values ('crée français');
select * from français;

Voila le résultat!

++---+
| id | text  |
++---+
|  1 | crée français |
++---+
1 row in set (0.10 sec)

mysql

Ceci est de mes variables:
show variables;
coupé
character_sets  | latin1 dec8 dos german1 hp8 koi8_ru latin2
swe7 usa7
 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr
greek win125
0 croat cp1257 latin5 |

Bonne chance,
Ken
-
Ken Menzel  ICQ# 9325188
www.icarz.com  [EMAIL PROTECTED]
- Original Message -
From: hassan el forkani [EMAIL PROTECTED]
To: Samir Baghdadi [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, April 22, 2001 6:21 AM
Subject: Re: Information Technique


 j'ai eu le meme probleme mais en environnement de développement, ce
que je
 sait c'est que ca dépend du characterset de votre base de donnée
faut
 demander à votre hebergeur le characterset (dans les environnement
 variables) du serveur mysql ou votre base est hebergée




 At 23:33 21/04/01 +0200, you wrote:
 Salut Mr/Mme,
 
 J'ai une question précise : Comment coder les
 caractères spéciaux (de type à, é,..) dans une BDD
 MySql
 
 Le problème c'est que j'ai developpé avec JSP un site
 en utilisant le Système d'exploitation Windows (les
 essais étaient positifs).
 Lors de l'hébergement, (Sur adgraphix) les caractères
 spéciaux ne sont pas insérés correctement dans la BDD
 Par exemple à devient ?
 
 J'espère avoir une réponse, même si négative
 
 Merci
 
 ___
 Do You Yahoo!? -- Pour faire vos courses sur le Net,
 Yahoo! Shopping : http://fr.shopping.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

Any low budget database access available ???

[William Goedicke]

Dear me - 

me writes:

  I am hoping to find somebody who provides low budget mysql and php access.

Buy yourself a copy of Web Techniques magazine and browse the
advertisements.

Yours - Billy

-
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_install_db problems

[B. van Ouwerkerk]

This sounds more like a OS problem then a MySQL problem.

I don't know much about HPUX.

Bye,


B.


Hi folks,

Thought I'd see if I have a common problem before I do a bug report. I am 
trying to install the binary file for HP/UX 10.20 on a HP/UX 10.20 785 
series computer. As the error message is about memory problems the 
following info may be of interest. The tar file is on a volume with 30,000 
bytes free space. I unpack the file into the /usr/local/mysql-OS-version 
directory onto the volume /usr which has 300,000+ bytes free space. Okay, 
the result of running the install script is:

# scripts/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
010423 11:09:07  Warning: setrlimit couldn't increase number of open files 
to more than 200
010423 11:09:07  Warning: Changed limits: max_connections: 
100  table_cache: 64
scripts/mysql_install_db[284]: 15102 Memory fault(coredump)
Installation of grant tables failed!

Examine the logs in ./data for more information.
You can also try to start the mysqld demon with:
./bin/mysqld --skip-grant 
You can use the command line tool
./bin/mysql to connect to the mysql
database and look at the grant tables:

shell ./bin/mysql -u root mysql
mysql show tables


There are no logs in the ./data directory just a core dump. When I try 
./bin/mysqld --skip-grant I get the following message:

# ./bin/mysqld --skip-grant
010423 15:07:48  Warning: setrlimit couldn't increase number of open files 
to more than 200
010423 15:07:48  Warning: Changed limits: max_connections: 
100  table_cache: 64
./bin/mysqld: Can't change dir to 
'/usr/local/mysql-3.23.37-hp-hpux10.20-hppa1.1/var/' (Errcode: 2)
010423 15:07:48  Aborting

010423 15:07:48  ./bin/mysqld: Shutdown Complete

Why does mysqld even try to change to ../var ? This is a binary 
distribution and this directory does not exist!

Can someone help me or is this a case for bug fixing?

Thanks a lot in advance,

Pete


-
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

Maximum number of columns in a table

[Antoine Delaunay]

Hello,

Does any of you know how much columns a MySQl table can handle? Is it
fixed or does it depends of some parameters (fields' datatypes, RAM, total
table size...)?

Thanks

DELAUNAY Antoine


-
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: wildcard in tablesearch

[Robert Vetter]

Sven Heising wrote:
 
 Hi list,
 
 I'am new in this php and mysql-stuff so i need al lil bit support...
 
 this is my problem:
 $result = mysql_query(select * from $dbtable where $wonach like
 '%$first_name%' );
 
 $wonach is a var which is set in a html form if i want to search one row
 it is no problemselecting works!
 But how to search in all rows? What is the wildcard command?

Hello,

It seems to me you are mixing up the terms row and column. But I
might be wrong.

Anyway, to search all _columns_ in a database you have make a query like
this:

$result = mysql_query(select * from $dbtable where column1 like
'%$first_name%' OR column2 like '%$first_name%' OR column3 ...);

Robert

-
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

mysql+bdb

[Eugene Reuter]

I installed mysql 3.23.36 binary version for OpenServer 5.0.5. According to
MySql documentation this version supposes to support BDB-tables. But if I
try to create Type=BDB tables I get MyIsam. If I look into my variables I
see have_bdb = No.
How can I get it work?
Eugene


-
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: Convert varchar to number field

[Gerald Clark]

Steve Werby wrote:
 
 Martin E. Koss [EMAIL PROTECTED] wrote:
  I started a table with a varchar filed of 11 characters for a column that
  would hold data such as 0.27; 11; 0.6; 1; 5; 7.5; 11.2; etc
  I wasn't sure if a 'number' field would work. Now I want to list the
 values
  in this column and they do not list numerically, for example: if we had
  0.27; 0.6; 1; 5; 7.5; 11; then 11 would come before 5 and 7.5
  (alphanumerically).
 
  What I need is them to list numerically, so they would list like:
  0.27
  0.6
  1
  5
  7.5
  11
  11.2
 
  Any advice on what to change the field type to or how to convert it at the
  time of querying via PHP would be great. Thanks.
 
 Use an ALTER TABLE statement.  Something like the following:
 
 ALTER TABLE table_name MODIFY field_name DECIMAL(4,1) UNSIGNED




ALTER TABLE table_name MODIFY old_field_name new_field_name DECIMAL(4,1)
UNSIGNED

Old_field_name and new_field_name can be the same.


 
 Make sure you choose a numeric type that is appropriate.  See the online
 manual for options.  If you're worried you might ruin your data with this
 conversion first create a copy of the table and experiment on it instead.
 
 CREATE TABLE my_copy SELECT * FROM original_table
 
 Note that it won't copy the indexes, but it will create a copy of the table.
 
 --
 Steve Werby
 President, Befriend Internet Services LLC
 http://www.befriend.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: how can i make it?

[Z_da_eXTaZie]

Of course left join. And group by moreover. But how?
For the group by i need a sum-like function, which joins the strings.

 how can i get a recordset constains all records (or records matching a
where
 exp.) from the Table1 with the c values from the Table2, like this:
 
 uidnamecs
 -
 1user1'50 - twenty-three - the reason of life'
 2user2'twenty-three - 303 rulz'
 3user3''
 
 I can make heavy things with mysql, but i'm too small for this :)

 Think what you want is left join. Check your favorite SQL manual for
syntax.




-
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

Deleted user

[jessica]

I've made a stupid error.  While logged in as root I was deleting
records from the user table.  Someone was talking to me while I was
entering a command and I didn't realize what I entered until it was too
late.  I entered:
delete from user where user='root';

I immediately used an insert statement to re-insert the root entry, but
it's not working.  I can still log in as root but appear to have lost
access to the mysql database.

Is there any way to recover?

Thanks,
Bob





-
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

Probably a bug report

[Alexey Morozov]

Hi! It looks like I found a strange behaviour of the MySQL (3.23.36 on 
windows and linux). Probably it's due to my own mistake but I really 
can't catch what's up.

Look:

I have two tables linked w/ the 'one-to-many' relation. They look like 
follows:

mysql describe MessageType;
+--+--+--+-+-++
| Field| Type | Null | Key | Default | Extra  |
+--+--+--+-+-++
| Id   | int(11)  |  | PRI | NULL| auto_increment |
| Owner| int(11)  |  | | 0   ||
| Name | varchar(30)  |  | | ||

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

mysql describe Message;
+++--+-+-++
| Field  | Type   | Null | Key | Default | Extra
  |
+++--+-+-++
| Id | int(11)|  | PRI | NULL| 
auto_increment |
| Type   | int(11)|  | | 0   |  
  |
...
+++--+-+-++
4 rows in set (0.01 sec)

So each message has a type, each message type has an owner (described 
elsewhere). Now I try to get a list w/ all message types for a 
particular owner w/ currently selected MessageType 'highlighted' for 
given owner and message (Message 8 does have type 3 and this type 3 has 
owner 3, believe me :-)):

mysql SELECT T.Id, T.Owner, M.Id, M.Type FROM MessageType T LEFT JOIN Message M on 
T.Id = M.Type and M.Id=8 where T.Owner=3;
++---+--+--+
| id | owner | Id   | Type |
++---+--+--+
|  1 | 3 | NULL | NULL |
|  3 | 3 | NULL | NULL |
++---+--+--+
2 rows in set (0.00 sec)

Quite strange, right? But if I narrow the filter I get reasonable result:

mysql SELECT T.Id, T.Owner, M.Id, M.Type FROM MessageType T LEFT JOIN Message M on 
T.Id = M.Type and M.Id=8 where T.Owner=3 _*AND T.Id = 3*;_
++---++--+
| Id | Owner | Id | Type |
++---++--+
|  3 | 3 |  8 |3 |
++---++--+
1 row in set (0.01 sec)

That's it. I can't explain such behaviour.

Yours respectfully,
   Alexey Morozov.

P.S. When replying please CC to me directly 'cause I'm not yet a member 
of the list. Thank you.

copying datatbase?

[John Ranaudo]

I have MYSQL 3.23 and php on a Win2k box running on IIS5.  I must copy the
database to a Solaris machine that uses php running on Apache.  Can you help
me on how to handle this issue.
Your help would be greatly appreciated,
John

Re: multiproz in mysql on FreeBSD?

[Ken Menzel]

Hi Tim, and everyone,   I am moving this discussion to the main list
(since I have questions others might be able to answer.  I copied the
entire (short) thread so people can catch up.

1)  Is there anyone currently running multiple mysqld's on FreeBSD
with success?
2) How much is this 'overhead' for locking that I hear about, has
anyone measured this?  Don't we by default run with locking on anyway?
(unless --skip-locking is used).
3) To start a second or third process is it just
safe_mysqld --pid-file=/usr/local/var/mysql2.pid --user=mysqlwhatever
?

Hmmm sounds like fun,  I am going to try it on our test server.  I am
not sure how I might go about measuring this 'overhead' of locking
though,  and if it is really that signifigant.

Ken
-
Ken Menzel  ICQ# 9325188
www.icarz.com  [EMAIL PROTECTED]
- Original Message -
From: Timothy Smith [EMAIL PROTECTED]
To: Karl Prinz [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, April 20, 2001 2:11 PM
Subject: Re: multiproz in mysql


 On 2001 Apr 20, Karl Prinz [EMAIL PROTECTED] wrote:
 
  we are running mysql on a 4 prozessor machine under Free BSD and
we
  recognized, that mysql is using different prozessors, but only one
at a
  time. So one processor is always under heavy load, the remaining
three stay
  idle.
 
  Are there any possibilities to implement multithreading and
multiprozessing
  for Free BDS, by recompiling the kernel etc. or is this a problem
for mysql
  under Free BSD??

 Thanks for your interest in MySQL.  This particular list is
 meant for discussing changes to the MySQL code itself.  You
 can find out which list to use on our web site:

 http://www.mysql.com/documentation/lists.html

 When in doubt, write [EMAIL PROTECTED]  You don't have
 to subscribe in order to write the list.


 The problem is that FreeBSD's current threads implementation
 doesn't utilize more than one processor for a single process.
 You can get around this by running multiple mysqld's on one
 machine.  There is locking overhead when doing this, and it
 might not be worth it for you, but it probably is worth
 running some tests to see if it helps.

 I've heard that you can link MySQL against the LinuxThreads
 library (install ports/devel/linuxthreads, and then use the
 --with-named-thread-libs='-llthread' argument when configuring
 MySQL), but I've never tried it and I don't know how well it
 works.  Note that the LinuxThreads is NOT running under Linux
 emulation; it's a native library that treats threads like
 processes, just the way they are treated under Linux.

 The FreeBSD team is working on a new implementation of threads.
 It's dependent on some pretty complicated changes to the kernel,
 and it doesn't look like it will be stable any time soon.  (For
 some interesting reading on the topic, check the freebsd-current
 archives for the past week.)  I have high hopes for it, and
 think it will be great for running MySQL when it materializes,
 but I'm not holding my breath for that day.  So, while it pains
 me to say it, another good option for many people is to run
 mysqld on Linux.

 Tim

 --
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Tim Smith [EMAIL PROTECTED]
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Development Team
 /_/  /_/\_, /___/\___\_\___/   Boone, NC  USA
___/   www.mysql.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]




-
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: how can i make it?

[B. van Ouwerkerk]

It's a bad habbit to cc to a list.

Of course left join. And group by moreover. But how?
For the group by i need a sum-like function, which joins the strings.

Hmmm, something like concat() you mean?

Bye


B.


mysql, query


-
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+bdb

[Ken Menzel]

Hi Eugene,
   The binary version do not yet have BDB or Innodb support yet.  You
will need to compile your own version using --with-berkeley-db in
order to use those features.  I believe there are notes in the manual
on how to compile this for SCO,  but I don't know if BDB has been
ported to SCO yet.  Give it a try if you have some experience with
compiling otherwise I would wait for the new binaries with the support
built-in.

Good luck,
Hope I helped,
Ken
-
Ken Menzel  ICQ# 9325188
www.icarz.com  [EMAIL PROTECTED]
- Original Message -
From: Eugene Reuter [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 23, 2001 9:56 AM
Subject: mysql+bdb


 I installed mysql 3.23.36 binary version for OpenServer 5.0.5.
According to
 MySql documentation this version supposes to support BDB-tables. But
if I
 try to create Type=BDB tables I get MyIsam. If I look into my
variables I
 see have_bdb = No.
 How can I get it work?
 Eugene


 
-
 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: how can i make it? concat?

[Z_da_eXTaZie]

 It's a bad habbit to cc to a list.
Ooops. Sorry.

 Of course left join. And group by moreover. But how?
 For the group by i need a sum-like function, which joins the strings.

 Hmmm, something like concat() you mean?


I tried it. Doesn't works.
Without group by i have this set:

idnamec
1user1'50'
2user1'twenty-three'
3user1'the reason of life'
4user2'twenty-three'
5user2'303 rulz'
6user3NULL

I would like to get this:

1user1'50 - twenty-three - the reason of life'
2user2'twenty-three - 303 rulz'
3user3''

If there is a function to sum values, why there isn't one to sum strings
i.e. concat strings. Or how should i use it?
I tried:

SQLSELECT Table1.name, CONCAT(Table3.txt)  FROM Table1 left join Table2 on
Table1.uid=Table2.uid left join Table3 on Table2.c=Table3.c group by
Table1.name;
1user1'50'
2user2'twenty-three'
3user3NULL
3 rows in set (0.00 sec)

server version is 3.22.32

Z


-
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

Need help with 23.36

[New Style MySQL Personnel]

Please anyone. I really need some ideas.
I copied my database files made with 23.29 to 23.26 and now I get this. I
chowned mysql.mysql and chmoded 660.
The location of the databases is good because I have some other databases
created with 36 and they work fine. I copied ALL the database's files to
/var/lib/mysql where the others are and I get this error. Any idea?

 mysql use lumina;
 Reading table information for completion of table and column names
 You can turn off this feature to get a quicker startup with -A

 Didn't find any fields in table 'absences'
 Didn't find any fields in table 'admins'
 Didn't find any fields in table 'classes'
 Didn't find any fields in table 'marks'
 Didn't find any fields in table 'students'
 Didn't find any fields in table 'teachers'
 Didn't find any fields in table 'users'
 Didn't find any fields in table 'vars'
 Database changed
mysql select * from users;
ERROR 1017: Can't find file: './lum/users.frm' (errno: 13)

It's funny; that file exists!

It's urgent! Thanx!


-
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

Problem with corrupted System (internal error 1030:Got error 127 from table handler)

[Dave Millen]

Hi,

A client has had some sort of disk failure and several files from one of
my projects disappeared or were corrupted along with some system
files I have replaced the files from my own backups and have the
web/php based interface working again, but I get the following when
trying to access mysql:

internal error 1030:Got error 127 from table handler

This occurs whether using the web/php based interface, mysqladmin or
direct in mysql.

A system of elimination shows that one particular table is corrupt. All
records up to a certain 'id' can be retrieved, beyond this, the above
error occurs. It obviously doesn't allow any sort of wild card or
camparison select to work.

Is there any way to restore this table short of dropping and
re-creating?

Please CC me as I am not subscribed to the list.

TIA
Dave

--
Don't hit me!!  I'm in the Twilight Zone!!!

email: [EMAIL PROTECTED]
web: www.largesalad.co.uk/DJMsoft




-
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: Deleted user

[Ken Menzel]

From the very fine manual:

http://www.mysql.com/documentation/mysql/bychapter/manual_Problems.htm
l#Resetting_permissions
-
Ken Menzel  ICQ# 9325188
www.icarz.com  [EMAIL PROTECTED]
- Original Message -
From: jessica [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 23, 2001 10:09 AM
Subject: Deleted user


 I've made a stupid error.  While logged in as root I was deleting
 records from the user table.  Someone was talking to me while I was
 entering a command and I didn't realize what I entered until it was
too
 late.  I entered:
 delete from user where user='root';

 I immediately used an insert statement to re-insert the root entry,
but
 it's not working.  I can still log in as root but appear to have
lost
 access to the mysql database.

 Is there any way to recover?

 Thanks,
 Bob






--
--


 
-
 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: Need help with 23.36

[Gerald Clark]

chown -R mysql /var/lib/mysql


New Style MySQL Personnel wrote:
 
 The location is good because I have some other databases created with 36
 and they work fine. I copied ALL the database's files to /var/lib/mysql
 where the others are and I get this error. Any idea?
 
 On Mon, 23 Apr 2001, B. van Ouwerkerk wrote:
 
 
  I copied my database files made with 23.29 to 23.26 and now I get this. I
  chowned mysql.mysql and chmoded 660. What's wrong?
 
  Perhaps or.. the location of your database is different.. or.. you
  didn't copy everything.. including subdirectories.
 
  Solution: check the location and if you copied all files..
 
  Bye,
 
 
  B.
 
 
  -
  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: Need help with 23.36

[indrek siitan]

Hi,

  mysql use lumina;
  Reading table information for completion of table and column names
  You can turn off this feature to get a quicker startup with -A
 
  Didn't find any fields in table 'absences'
  Didn't find any fields in table 'admins'
  Didn't find any fields in table 'classes'
  Didn't find any fields in table 'marks'
  Didn't find any fields in table 'students'
  Didn't find any fields in table 'teachers'
  Didn't find any fields in table 'users'
  Didn't find any fields in table 'vars'
  Database changed
 mysql select * from users;
 ERROR 1017: Can't find file: './lum/users.frm' (errno: 13)

errno 13 stands for Permission denied - check your mysql data directory
permissions.


Rgds,
  Tfr

 --== [EMAIL PROTECTED] == MySQL development team == Tallinn / Estonia ==--  

-
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 need help to instal mysql

[Gerald Clark]

Install gmake.

Lana Conan wrote:
 
 First of all sorry for my English, I hope it would be good enougth to be
 understood.
 
 I am trying to instal mysql on a digital unix os.
 
 First I had problem   with the ./configure
 it prompted this message
 
 checking for cc++... no
 checking for cl... no
 checking whether the C++ compiler (gcc   ) works... no
 configure: error: installation or configuration problem: C++ compiler
 cannot create executables.
 
 so I installed gcc-2.95.3
 
 and the ./configure seemed to work.
 
 then gave the command make
 and I had this error message
 
 bash# make
 No suffix list.
 make  all-recursive
 No suffix list.
 Making all in include
 No suffix list.
 Make: % rule can only use a single ':'.  Stop.
 *** Exit 1
 Stop.
 *** Exit 1
 Stop.
 bash#
 
 Can you please give me some information on what happen and what I did wrong.
 
 Thank you for your attention
 best regards
 Sandra
 
 _
 Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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: Criteria in the GRANT command

[Gerald Clark]

You don't.
Privileges can be set for a column in a table, but not by record.

Mark van Brenk wrote:
 
 Greetings, and I'm sorry if this is a topic that's already been covered, but I've 
read over about 100 of the past mails and can't find something similar.
 
 How do I GRANT UPDATE to specific columns in specific records?
 
 Example:
 
 I've got a table u which covers complete data on each user for the group I 
administer the database for. I want to grant users the ability to update certain 
items in their rows, however, want their user/password to ONLY update that row.
 
 I've got GRANT UPDATE (fname, lname, email, etc.) ON tsf.u etc. However, I want to 
issue the criteria similar to.. GRANT UPDATE (fname, lname, email WHERE u.uID=10) - 
10 being that user's ID number.
 
 The WHERE clause doesn't work (or maybe I've using the wrong syntax).. any help?

-
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: Query problems

[Gerald Clark]

Use merge tables, or two separate queries.

Wix,Christian XCW wrote:
 
 Hi
 I have two similar tables. (table1  table2). They contain the columns
 name, distance and date. Table1 is year 2000 and Table2 year 2001.
 
 I need to get the total distance for each name.
 For year 2000 I would do this:
 select name, SUM(distance) from table1 group by name;
 
 How do I do it for both years? (one query)
 
 Thanks,
 
 // Chris - Copenhagen
 
 -
 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

how do i create mysql-logon.sock?

[Andy]

I was told that i need to create mysql-logon.sock so that mysql will start
running



-
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

nested set trees.

[Tobias Nix]

hello lists,

i want to use the nested set model to store a tree structure in a database.

the normal way i do this looks like this:

My table looks something like this:
ID LEFT RIGHT   NAME
11   14  Root
22   7Thema 1
33   4Thema 1.1
48   13  Thema 2
55   6Thema 1.2
61112   Thema 2.2
79  10   Thema 2.1

Now I get a sorted tree Structure with the following select:

SELECT *, count(*) AS level 
FROM tree AS a, tree AS b 
WHERE b.l BETWEEN a.l AND a.r AND 
  b.r BETWEEN a.l AND a.r
GROUP BY b.id ORDER BY b.l

The result looks like this:
IDLEFT   RIGHTLEVELNAME
1  1  141 Root
2  2  7  2 Thema 1
3  3  4  3 Thema 1.1
5  5  6  3 Thema 1.2
4  8  132  Thema 2
...

But know i want to use more than one tree in a table. This looks like this:

ID LEFT RIGHT  TREENAME
11   6   1Thema 1
22   3   1Thema 1.1
32   5   4Thema 2.1
41   6   4Thema 2
53   4   4Thema 2.1.1
64   5   1Thema 1.2

Now i use the following select:
SELECT *, count(*) AS level
FROM tree AS a, tree AS b
WHERE b.l BETWEEN a.l AND a.r AND
  b.r BETWEEN a.l AND a.r AND
  a.id = b.tree
GROUP BY b.id ORDER BY b.tree,b.l

The Output looks like the output above. The problem ist, that 
the level wouldnt be counted. the result of level is alway 1.
what can i do to count the right level of each tree ?

can anybody help ?

regards,
tobias.


-
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: Deleted user

[Samuel]

Hi!

Not sure if this will be useful as well.  Searched the MySQL manual and
found this page.  It mentions a bit about restarting MySQL and resetting the
root password.

http://www.mysql.com/doc/A/c/Access_denied.html

Hope it helps!


Sam.



- Original Message -
From: Ken Menzel [EMAIL PROTECTED]
To: jessica [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, April 23, 2001 4:24 PM
Subject: Re: Deleted user


 From the very fine manual:

 http://www.mysql.com/documentation/mysql/bychapter/manual_Problems.htm
 l#Resetting_permissions
 -
 Ken Menzel  ICQ# 9325188
 www.icarz.com  [EMAIL PROTECTED]
 - Original Message -
 From: jessica [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Monday, April 23, 2001 10:09 AM
 Subject: Deleted user


  I've made a stupid error.  While logged in as root I was deleting
  records from the user table.  Someone was talking to me while I was
  entering a command and I didn't realize what I entered until it was
 too
  late.  I entered:
  delete from user where user='root';
 
  I immediately used an insert statement to re-insert the root entry,
 but
  it's not working.  I can still log in as root but appear to have
 lost
  access to the mysql database.
 
  Is there any way to recover?
 
  Thanks,
  Bob
 
 
 
 


 --
 --


  
 -
  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 mysql-unsubscribe-sam=fast
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


 ===
 This message has been virus scanned by Messagelabs.
 ===


==
This message has been checked for all known viruses by MessageLabs. 
This message is intended for the stated recipients only and may be confidential. 
Opinions expressed in this email do not necessarily reflect the opinions of GlobePost 
Travel or Travelselect.com. If you are not the intended recipient of this message, 
please notify the sender immediately.  
==

-
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

Copy part of a table to a temporary table

[Jonathan Pelletier]

I'm looking for a way to create a temporary table containing a sub part of
the master table...

I know that I can use :

CREATE TEMPORARY TABLE tbl_name [(create_definition,...)]
[select_statement]


but i'm working on a script that must create tables with the same
create_definition that the master table (and the script must be
independent from the create_definition, I cannot Hardcode it in the CREATE
TABLE statement)...


For now, the only way i finded to do this is to copy the files associated to
the master table to another tablename and, after that, i'm deleting all the
rows that I don't need from the newly created table : It is not very
efficient :-)

I'll be glad if someone could tell me a SQL way to solve this tricky
problem...


/ Jonathan Pelletier \
\  /
/  Matrox Electronic Systems Ltd.  \
\   MIS / Département des systèmes -- Groupe Unix  /
/  \
\   1055 Blv. St-Regis   Tel: (514) 822-6000 x.7589/
/   Dorval (Quebec)  Fax: (514) 822-6262   \
\   H9P 2T4  Email: [EMAIL PROTECTED]/
/   http://www.matrox.com  \
\  /
/Home: [EMAIL PROTECTED] \
\/
  _
   ASCII ribbon campaign ( )
- against HTML email  X
 vcards / \


-
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: Random string for each row in a table

[Thalis A. Kalfigopoulos]

Not understanding excactly why you'd need a random string, I'd suggest doing a simple 
password() call on each row's recipient

ALTER TABLE ADD COLUMN rand_string char(16) NOT NULL;
UPDATE my_table SET rand_string=password(email);

This gives you a 16 char long (I think) random string.
Sending this rand_string to the coresponding email, is beyond SQL.
Export in a file the email and corresponding rand_string and from there beat the file 
to death with bash or perl or whatever scripting lang uage you want.

regards,
thalis


On Mon, 23 Apr 2001, Prasad Mhatre wrote:

 Dear All,
 
 How do I create random string for each row in a mysql table? and mail the
 same each recepient in the respective row.
 
 Thanks
 Love and regards
 Prasad
 
 
 -
 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: multiproz in mysql on FreeBSD?

[Jeremy Zawodny]

On Mon, Apr 23, 2001 at 10:33:48AM -0400, Ken Menzel wrote:

 Hi Tim, and everyone, I am moving this discussion to the main list
 (since I have questions others might be able to answer.  I copied
 the entire (short) thread so people can catch up.

[snip]

 Hmmm sounds like fun, I am going to try it on our test server.  I am
 not sure how I might go about measuring this 'overhead' of locking
 though, and if it is really that signifigant.

Another thing to consider is that you'll need to invent some sort of
load balancing system to spread the queries among the multiple MySQL
servers you'll be runnnig. You ability to do that well will also
impact the effectiveness of this solution.

Jeremy
-- 
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878Fax: (408) 530-5454
Cell: (408) 439-9951

-
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

[mysql@lists.mysql.com: Re: Re: Copy part of a table to a temporary table]

[harm]

 taxt/plain

Re: Java Example for connection

[Tommaso Nolli]

Hi,
I use this code to connect to a mySQL 3.23.36:

Connection cnn = null;
try {
Class.forName(org.gjt.mm.mysql.Driver);
cnn =
DriverManager.getConnection(jdbc:mysql://server/database, user, 
password);
cnn.setAutoCommit(false); // doesn't support autocommit!
}
catch (SQLException ex) {
}

 Hello all,

 I wonder if someone could send me a java code showing how to access a mysql 
 databse. I will appreciate very much, actually my job is counting on that.

 Thanks in advance

 Siomara

 _
 Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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

Tricky SQL query

[Andrei Zmievski]

Hi,

I have a table that keeps track of when certain articles go up on the
site. It has a field called featureStart, which is a unix timestamp. The
features stay on the site until the next feature replaces them, so there
is no featureEnd. If one feature started on Apr 23 and another one is
scheduled for Apr 25, the first one will keep going until Apr 25 and
then the second one will come on.

So far I've been using something like this to figure out the current
feature:

select * from features where featureStart  unix_timestamp() order by
featureStart desc limit 1

But now I find myself with the need to figure out which features are
active on a certain date, from beginning of day, until the end. In the
above example, both features would be the answer for Apr 25. I've been
trying to figure out a query that would give me back the list of
features if I specify the range those features should be active for, but
no luck so far. Any ideas?

-Andrei
* Non-volatile, random-access, analog memory store... a book. *

-
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: changing data directory

[Steve Brazill]

Marc S. Bragg wrote:

 How does one redirect mysql to a data directory location different than
 the default. . . . and if possible, only for a particular database.



You can find the 'official' notes on how to relocate tables or entire
databases at:
http://www.mysql.com/doc/S/y/Symbolic_links.html

But,  here's my few notes on it

Since MySQL 'presents' actual directories as databases and the files that
make up each Isam (or MyIsam) structure as a 'table',  you can 'fool' MySQL as
to their name or location via symbolic links (assuming you're using a
Unix/Linux setup,  though I think there's a method for Windoze systems as
well.  see:  http://www.mysql.com/doc/W/i/Windows_symbolic_links.html ).

You can have your entire MySQL data 'instance' (including the mysql control
tables and you're own databases) in another location by using a 'symbolic'
link to point at the real physical location of the var subdirectory,   or
have each of your own databases located on different devices,  or individual
files (tables).

THOUGH,  as of version 3.23.35 (and especially 3.23.36,  but not tested by
myself for version 3.23.37 yet) I can't seem to have the 'index' portion
(*.MYI) of the files (tables) located (via symbolic links) somewhere different
than the 'data' portion (*.MYD).   If I attempt to do this (so that accesses
to the index and data portions can occur simultaneously from separate disk
devices) I get the error  cannot access record info for table 'blah blah
blah'.

My setup looks like this (I removed some of the stuff 'ls' displays, like the
date/time of each file/directory):

ls -l /usr/local/mysql/var

drwxrws---mysqlmysqlmysql
lrwxrwxrwxmysqlmysqlmy_database-
/array/mysqldata/my_database
lrwxrwxrwxmysqlmysqlschmengies_stuff-
/dev/mysqldata/crappy_tables
drwxrws---mysqlmysqlproduction

Where the 'control' database mysql is within the normal mysql installation
directory 'tree',  but the user databases my_database and schmengies_stuff
are in different locations (the more important my_database is on a drive
'array' for performance,  while schmengies_stuff is just in another
directory which is actually named crappy_tables.
The database production appears to reside in the normal mysql directory
'tree',  but the file contents of the directory look like this:

lrwxrwxrwxmysqlmysqlyubby.myd -
/array/mysqldata/production/yubby.myd
lrwxrwxrwxmysqlmysqlyubby.myi   -
/array/mysqlindex/production/yubby.myi
lrwxrwxrwxmysqlmysqldubby.myd   -
/array/mysqldata/production/dubby.myd
lrwxrwxrwxmysqlmysqldubby.myi-
/array/mysqlindex/production/dubby.myi

As you can see,  the data portions of the tables yubby and dubby are in a
different location than the indexes... (though again, this hasn't worked for
me since upgrading above version 3.23.33)

P.S.  Be sure to read the official docs on the effects of 'dropping' and
'creating' databases and tables located via symbolic links...

Re: Information Technique

[hassan el forkani]

At 01:56 23/04/01 -0700, Van wrote:
hassan el forkani wrote:
 
  j'ai eu le meme probleme mais en environnement de développement, ce que je
  sait c'est que ca dépend du characterset de votre base de donnée faut
  demander à votre hebergeur le characterset (dans les environnement
  variables) du serveur mysql ou votre base est hebergée
 

Hassan:

Il est malheureux je doivent demander ceci, mais, posez s'il vous plaît votre
question en anglais, puisque vous obtiendrez une
meilleure réponse si vous ainsi. C'est pourquoi j'ai traduit la conversation
initiale et pensé lui soyez utile pour passer le temps
faisant ainsi.

Je suis américain et mon français n'est pas grand, mais, je le comprends, mais
mon DBA est meilleur et j'offre cela qui utilise
un langage commun pourrais vous obtenir une meilleure réponse qui pourrait 
vous
aider à résoudre votre problème plus vite. Je nous
offre devrais converser en anglais. Si vous avez besoin d'une traduction 
allez à
http://world.altavista.com/tr et vous pouvez
obtenir une jolie traduction décente du feedback que vous obtenez de la 
liste.

Le problème de jeu de caractères a pu avoir beaucoup d'origines. L'affiche
initiale utilisait des Windows, qui jette ce
dialogue entier dans une direction totalement différente.


Personnellement, je voudrais fournir de l'aide, mais, si nous parlons 
différents
langages, cela est aller juste de prendre beaucoup plus longtemps.

Je parle du français et puis écrire meilleur français, mais, au cours des
discussions techniques, vous obtiendrez une
meilleure exposition si vous utilisez l'anglais.

Désolé. Ce n'est pas une chose de bigoterie, il est juste dirigeant l'affiche
initiale dans une direction qui obtiendra à him/her une réponse plus
efficacement. Je puis converser avec vous en français, mais, si vous 
essayez de
résoudre un problème, vous pourriez vouloir essayer mon dialecte indigène, par
lequel je puis parler plus efficacement aux solutions potentielles.

Salut,
Van

hassan el forkani wrote: **time-out**
 
  I have have the same problem but in environment of development, ce which I
  know it be that Ca depend on characterset of your base of data be 
 necessary
  require with your hebergeur the characterset (in the  environment
  variable ) of server mysql or your base be hebergée
 

Hassan:

It's unfortunate I have to ask this, but, please ask your question in English,
since you'll get a better response if you do so.  That's why I translated the
original conversation and thought it would be useful to spend time doing so.

I'm American and my French isn't great, but, I understand it, but my DBA is
better and I offer that using a common language might get you a better 
response
that might help you solve your problem quicker.  I offer we should converse in
English.  If you need a translation go to http://world.altavista.com/tr 
and you
can get a  pretty decent translation of the feedback you get from the list.

The character set problem could have many origins.  The original poster was
using Windows, which throws this entire dialogue in a totally different
direction.

Personally, I'd like to provide some help, but, if we're speaking different
languages, it's just going to take a lot longer.

I do speak some French and can write French better, but, in technical
discussions, you'll get better exposure if you use English.

Sorry.  It's not a bigotry thing, it's just pointing the original poster in a
direction that will get him/her an answer more efficiently.  I can 
converse with
you in French, but, if you're trying to solve a problem, you might want to try
my native dialect, through which I can speak more efficiently to potential
solutions.

Best Regards,
Van
--
=
Linux rocks!!!   http://www.dedserius.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

Re: multiproz in mysql on FreeBSD?

[Ken Menzel]

Load balancing,  because I can't run two servers on the same port
either!  I have to use say 3307, 3308, 3309  and then do at least DNS
round robin,  what do you think Jeremey?  Anybody on your end have a
better idea?  Doesn't sound to me like the best solution.  I have
heard of people trying to make the linuxthreads work on FreeBSD but I
have not heard of anyone having success.  I wonder how far off the new
threads from freebsd-current are from being brought to -stable,  and
then it scares me as to what problems we will go through from there!
I love the stability of freebsd-stable and cvsup is great,  but
lately I have been thinking of running a server on -current to see the
new stuff go and what kind of problems I might have.   If -current now
is using the new threads maybe I should just try that.

Ummm ideas?
Thanks!
Ken

-
Ken Menzel  ICQ# 9325188
www.icarz.com  [EMAIL PROTECTED]

snip

 Another thing to consider is that you'll need to invent some sort of
 load balancing system to spread the queries among the multiple MySQL
 servers you'll be runnnig. You ability to do that well will also
 impact the effectiveness of this solution.

 Jeremy
 --
 Jeremy D. Zawodny, [EMAIL PROTECTED]
 Technical Yahoo - Yahoo Finance
 Desk: (408) 328-7878Fax: (408) 530-5454
 Cell: (408) 439-9951

 
-
 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: Information Technique

[Ken Menzel]

Bonjour Hassan,
  Il y a une liste français du MySQL que je viens de trouver.
Peut-être ça t'aide.
[EMAIL PROTECTED]

En Plus, il y a php-france,
envoyez un mail à [EMAIL PROTECTED]

Je suis un participant tous les deux.  J'espère que je t'y verra!

Amicalement,

Ken
-
Ken Menzel  ICQ# 9325188
www.icarz.com  [EMAIL PROTECTED]
- Original Message -
From: hassan el forkani [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Samir Baghdadi [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, April 23, 2001 10:52 AM
Subject: Re: Information Technique


 At 01:56 23/04/01 -0700, Van wrote:
 hassan el forkani wrote:
  
   j'ai eu le meme probleme mais en environnement de développement,
ce que je
   sait c'est que ca dépend du characterset de votre base de donnée
faut
   demander à votre hebergeur le characterset (dans les
environnement
   variables) du serveur mysql ou votre base est hebergée
  
 
 Hassan:
 
 Il est malheureux je doivent demander ceci, mais, posez s'il vous
plaît votre
 question en anglais, puisque vous obtiendrez une
 meilleure réponse si vous ainsi. C'est pourquoi j'ai traduit la
conversation
 initiale et pensé lui soyez utile pour passer le temps
 faisant ainsi.
 
 Je suis américain et mon français n'est pas grand, mais, je le
comprends, mais
 mon DBA est meilleur et j'offre cela qui utilise
 un langage commun pourrais vous obtenir une meilleure réponse qui
pourrait
 vous
 aider à résoudre votre problème plus vite. Je nous
 offre devrais converser en anglais. Si vous avez besoin d'une
traduction
 allez à
 http://world.altavista.com/tr et vous pouvez
 obtenir une jolie traduction décente du feedback que vous obtenez
de la
 liste.
 
 Le problème de jeu de caractères a pu avoir beaucoup d'origines.
L'affiche
 initiale utilisait des Windows, qui jette ce
 dialogue entier dans une direction totalement différente.
 
 
 Personnellement, je voudrais fournir de l'aide, mais, si nous
parlons
 différents
 langages, cela est aller juste de prendre beaucoup plus longtemps.
 
 Je parle du français et puis écrire meilleur français, mais, au
cours des
 discussions techniques, vous obtiendrez une
 meilleure exposition si vous utilisez l'anglais.
 
 Désolé. Ce n'est pas une chose de bigoterie, il est juste dirigeant
l'affiche
 initiale dans une direction qui obtiendra à him/her une réponse
plus
 efficacement. Je puis converser avec vous en français, mais, si
vous
 essayez de
 résoudre un problème, vous pourriez vouloir essayer mon dialecte
indigène, par
 lequel je puis parler plus efficacement aux solutions potentielles.
 
 Salut,
 Van
 
 hassan el forkani wrote: **time-out**
  
   I have have the same problem but in environment of development,
ce which I
   know it be that Ca depend on characterset of your base of data
be
  necessary
   require with your hebergeur the characterset (in the 
environment
   variable ) of server mysql or your base be hebergée
  
 
 Hassan:
 
 It's unfortunate I have to ask this, but, please ask your question
in English,
 since you'll get a better response if you do so.  That's why I
translated the
 original conversation and thought it would be useful to spend time
doing so.
 
 I'm American and my French isn't great, but, I understand it, but
my DBA is
 better and I offer that using a common language might get you a
better
 response
 that might help you solve your problem quicker.  I offer we should
converse in
 English.  If you need a translation go to
http://world.altavista.com/tr
 and you
 can get a  pretty decent translation of the feedback you get from
the list.
 
 The character set problem could have many origins.  The original
poster was
 using Windows, which throws this entire dialogue in a totally
different
 direction.
 
 Personally, I'd like to provide some help, but, if we're speaking
different
 languages, it's just going to take a lot longer.
 
 I do speak some French and can write French better, but, in
technical
 discussions, you'll get better exposure if you use English.
 
 Sorry.  It's not a bigotry thing, it's just pointing the original
poster in a
 direction that will get him/her an answer more efficiently.  I can
 converse with
 you in French, but, if you're trying to solve a problem, you might
want to try
 my native dialect, through which I can speak more efficiently to
potential
 solutions.
 
 Best Regards,
 Van
 --

=

 Linux rocks!!!   http://www.dedserius.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

Re: Error codes

[Steve Leibel]

Hello,

A few days ago I asked if anyone knows the numeric values of the 
Mysql error codes.  Nobody responded, so I looked through the source 
code to find the answer.  This info would be valuable if, for 
example, you wanted to programmatically handle certain types of 
errors.

In the source distribution I found the file Docs/mysqld_error.txt, 
which I'm including here just in case anybody else had the same 
question.

=


/* Copyright Abandoned 1997 TCX DataKonsult AB  Monty Program KB  Detron HB
This file is public domain and comes with NO WARRANTY of any kind */

#define ER_HASHCHK 1000
hashchk,
#define ER_NISAMCHK 1001
isamchk,
#define ER_NO 1002
NO,
#define ER_YES 1003
YES,
#define ER_CANT_CREATE_FILE 1004
Can't create file '%-.64s' (errno: %d),
#define ER_CANT_CREATE_TABLE 1005
Can't create table '%-.64s' (errno: %d),
#define ER_CANT_CREATE_DB 1006
Can't create database '%-.64s'. (errno: %d),
#define ER_DB_CREATE_EXISTS 1007
Can't create database '%-.64s'. Database exists,
#define ER_DB_DROP_EXISTS 1008
Can't drop database '%-.64s'. Database doesn't exist,
#define ER_DB_DROP_DELETE 1009
Error dropping database (can't delete '%-.64s', errno: %d),
#define ER_DB_DROP_RMDIR 1010
Error dropping database (can't rmdir '%-.64s', errno: %d),
#define ER_CANT_DELETE_FILE 1011
Error on delete of '%-.64s' (errno: %d),
#define ER_CANT_FIND_SYSTEM_REC 1012
Can't read record in system table,
#define ER_CANT_GET_STAT 1013
Can't get status of '%-.64s' (errno: %d),
#define ER_CANT_GET_WD 1014
Can't get working directory (errno: %d),
#define ER_CANT_LOCK 1015
Can't lock file (errno: %d),
#define ER_CANT_OPEN_FILE 1016
Can't open file: '%-.64s'. (errno: %d),
#define ER_FILE_NOT_FOUND 1017
Can't find file: '%-.64s' (errno: %d),
#define ER_CANT_READ_DIR 1018
Can't read dir of '%-.64s' (errno: %d),
#define ER_CANT_SET_WD 1019
Can't change dir to '%-.64s' (errno: %d),
#define ER_CHECKREAD 1020
Record has changed since last read in table '%-.64s',
#define ER_DISK_FULL 1021
Disk full (%s). Waiting for someone to free some space,
#define ER_DUP_KEY 1022
Can't write, duplicate key in table '%-.64s',
#define ER_ERROR_ON_CLOSE 1023
Error on close of '%-.64s' (errno: %d),
#define ER_ERROR_ON_READ 1024
Error reading file '%-.64s' (errno: %d),
#define ER_ERROR_ON_RENAME 1025
Error on rename of '%-.64s' to '%-.64s' (errno: %d),
#define ER_ERROR_ON_WRITE 1026
Error writing file '%-.64s' (errno: %d),
#define ER_FILE_USED 1027
'%-.64s' is locked against change,
#define ER_FILSORT_ABORT 1028
Sort aborted,
#define ER_FORM_NOT_FOUND 1029
View '%-.64s' doesn't exist for '%-.64s',
#define ER_GET_ERRNO 1030
Got error %d from table handler,
#define ER_ILLEGAL_HA 1031
Table handler for '%-.64s' doesn't have this option,
#define ER_KEY_NOT_FOUND 1032
Can't find record in '%-.64s',
#define ER_NOT_FORM_FILE 1033
Incorrect information in file: '%-.64s',
#define ER_NOT_KEYFILE 1034
Incorrect key file for table: '%-.64s'. Try to repair it,
#define ER_OLD_KEYFILE 1035
Old key file for table '%-.64s'; Repair it!,
#define ER_OPEN_AS_READONLY 1036
Table '%-.64s' is read only,
#define ER_OUTOFMEMORY 1037
Out of memory. Restart daemon and try again (needed %d bytes),
#define ER_OUT_OF_SORTMEMORY 1038
Out of sort memory. Increase daemon sort buffer size,
#define ER_UNEXPECTED_EOF 1039
Unexpected eof found when reading file '%-.64s' (errno: %d),
#define ER_CON_COUNT_ERROR 1040
Too many connections,
#define ER_OUT_OF_RESOURCES 1041
Out of memory;  Check if mysqld or some other process uses all 
available memory. If not you may have to use 'ulimit' to allow mysqld 
to use more memory or you can add more swap space,
#define ER_BAD_HOST_ERROR 1042
Can't get hostname for your address,
#define ER_HANDSHAKE_ERROR 1043
Bad handshake,
#define ER_DBACCESS_DENIED_ERROR 1044
Access denied for user: '%-.32s@%-.64s' to database '%-.64s',
#define ER_ACCESS_DENIED_ERROR 1045
Access denied for user: '%-.32s@%-.64s' (Using password: %s),
#define ER_NO_DB_ERROR 1046
No Database Selected,
#define ER_UNKNOWN_COM_ERROR 1047
Unknown command,
#define ER_BAD_NULL_ERROR 1048
Column '%-.64s' cannot be null,
#define ER_BAD_DB_ERROR 1049
Unknown database '%-.64s',
#define ER_TABLE_EXISTS_ERROR 1050
Table '%-.64s' already exists,
#define ER_BAD_TABLE_ERROR 1051
Unknown table '%-.64s',
#define ER_NON_UNIQ_ERROR 1052
Column: '%-.64s' in %-.64s is ambiguous,
#define ER_SERVER_SHUTDOWN 1053
Server shutdown in progress,
#define ER_BAD_FIELD_ERROR 1054
Unknown column '%-.64s' in '%-.64s',
#define ER_WRONG_FIELD_WITH_GROUP 1055
'%-.64s' isn't in GROUP BY,
#define ER_WRONG_GROUP_FIELD 1056
Can't group on '%-.64s',
#define ER_WRONG_SUM_SELECT 1057
Statement has sum functions and columns in same statement,
#define ER_WRONG_VALUE_COUNT 1058
Column count doesn't match value count,
#define ER_TOO_LONG_IDENT 1059
Identifier name '%-.100s' is too long,
#define ER_DUP_FIELDNAME 1060
Duplicate column name '%-.64s',
#define ER_DUP_KEYNAME 1061
Duplicate key 

Berkelely MYSQL

[Warren van der Merwe]

Hi there

I have managed to download the Berkeley for Windows installation, however
I have noted that MYSQL will not run without a patched version of
berkeley's. Where can I obtain such a installation to run on Windows?

Kind Regards
Warren


~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Cell (083) 262-9163
Office (031) 767-0249



-
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

Reg. determining version

[Aigars Grins]

Hi,

When using mysql.h there is defined a:

MYSQL_VERSION_ID

It's defined as something like:

32235

I guess this is representing version 3.33.35.

Is this the 'right' way of determining version? I want to do something like
an ifdef to incorporate support in my code for different versions of MySQL.

--
Aigars




-
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+bdb

[Boyd Lynn Gerber]

On Mon, 23 Apr 2001, Eugene Reuter wrote:
 I installed mysql 3.23.36 binary version for OpenServer 5.0.5. According to
 MySql documentation this version supposes to support BDB-tables. But if I
 try to create Type=BDB tables I get MyIsam. If I look into my variables I
 see have_bdb = No.
 How can I get it work?

It did but it, but it has been removed because maxsql is where it should
be.  A version should be out soon.

--
Boyd Gerber [EMAIL PROTECTED]
ZENEZ   3748 Valley Forge Road, Magna Utah  84044
Office 801-250-0795 FAX 801-250-7975



-
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: Reg. determining version

[Paul DuBois]

On Mon, Apr 23, 2001 at 08:37:31PM +0100, Aigars Grins wrote:
 When using mysql.h there is defined a:
 
 MYSQL_VERSION_ID
 
 It's defined as something like:
 
 32235
 
 I guess this is representing version 3.33.35.
 
 Is this the 'right' way of determining version? I want to do something like
 an ifdef to incorporate support in my code for different versions of MySQL.

Yes, although 32235 represents 3.22.35, not 3.33.35.
 
 --
 Aigars

-
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: multiproz in mysql on FreeBSD?

[Jeremy Zawodny]

On Mon, Apr 23, 2001 at 02:29:00PM -0400, Ken Menzel wrote:

 Load balancing, because I can't run two servers on the same port
 either!

Right.

 I have to use say 3307, 3308, 3309 and then do at least DNS round
 robin, what do you think Jeremey?

DNS round robin on affects hostnames, not port numbers.

 Anybody on your end have a better idea?  Doesn't sound to me like
 the best solution.

If you have a nice abstraction library in place in your code, it
shouldn't be to hard to implement something.

How about this. You have N MySQL daemons running and they are
listening on ports numbered:

  3306 + (N - (N-0))
  3306 + (N - (N-1))
  3306 + (N - (N-2))
  ...
  3306 + (N - (N-N))

In your database library, you take the PID of the client divide by N
and use the remanider to decide which port to connect to. It's not a
perfect scheme, but it's realtively simple, easy, and likely to work
reasonably well.

 I have heard of people trying to make the linuxthreads work on
 FreeBSD but I have not heard of anyone having success.

You could be the first. :-)

Now you know why, despite the fact that we're a FreeBSD shop, the most
critical MySQL servers I deal with are on Linux instead of
FreeBSD. :-(

Jeremy
-- 
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878Fax: (408) 530-5454
Cell: (408) 439-9951

-
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: Information Technique

[Van]

Ken Menzel wrote:
 
 Bonjour Hassan,
   Il y a une liste français du MySQL que je viens de trouver.
 Peut-être ça t'aide.
 [EMAIL PROTECTED]
 
 En Plus, il y a php-france,
 envoyez un mail à [EMAIL PROTECTED]
 
 Je suis un participant tous les deux.  J'espère que je t'y verra!
 
 Amicalement,
 
 Ken

Salutations Ken: 

Peut-être c'est overkill, mais, un des downsides d'écarter ces conversations à
travers de diverses listes de languir est vous détruisent l'avantage des
discussions non partagées avec les autres. Pourrait être gentil si quelqu'un
exécutait un Babel-serveur pour traduire les diverses listes ainsi tout pourrait
bénéficier. Juste une suggestion. 

En particulier, puisque le poteau initial a dû faire avec Windows-MySQL et le
jeu de caractères français. 

Salut,
Van

Greetings Ken:

Perhaps this is overkill, but, one of the downsides of spreading these
conversations across various language lists is you lose the benefit of
discussions not shared with the others.  Might be nice if someone ran a
babel-server to translate the various lists so all could benefit.

Just a suggestion.  Especially, since the original post had to do with
Windows-MySQL and the French character-set.

Regards,
Van
-- 
=
Linux rocks!!!   http://www.dedserius.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

Re: Berkelely MYSQL

[Miguel Angel Solórzano]

At 21:28 23/04/01 +0200, Warren van der Merwe wrote:
Hi,
Hi there

I have managed to download the Berkeley for Windows installation, however
I have noted that MYSQL will not run without a patched version of
berkeley's. Where can I obtain such a installation to run on Windows?

Download our source distribution for Unix and you should find a
directory called BDB, inside it you find the build_win32, follow
the instructions to build the static release. You only need the
lib: libdb32s.lib.

Regards,
Miguel

Kind Regards
Warren


~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Cell (083) 262-9163
Office (031) 767-0249



-
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

__  ___   __
   /  |/  /_ __/ __/ __ \/ /   http://www.mysql.com/
  / /|_/ / // /\ \/ /_/ / /__  Miguel Solórzano [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/  São Paulo, Brazil
___/  Development Team


-
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: Error codes

[ryc]

Type perror #error_num at the prompt, you can get what the error codes
mean from there.

ryan


 Hello,

 A few days ago I asked if anyone knows the numeric values of the
 Mysql error codes.  Nobody responded, so I looked through the source
 code to find the answer.  This info would be valuable if, for
 example, you wanted to programmatically handle certain types of
 errors.

 In the source distribution I found the file Docs/mysqld_error.txt,
 which I'm including here just in case anybody else had the same
 question.

 =


 /* Copyright Abandoned 1997 TCX DataKonsult AB  Monty Program KB  Detron
HB
 This file is public domain and comes with NO WARRANTY of any kind */

 #define ER_HASHCHK 1000
 hashchk,
 #define ER_NISAMCHK 1001
 isamchk,
 #define ER_NO 1002
 NO,
 #define ER_YES 1003
 YES,
 #define ER_CANT_CREATE_FILE 1004
 Can't create file '%-.64s' (errno: %d),
 #define ER_CANT_CREATE_TABLE 1005
 Can't create table '%-.64s' (errno: %d),
 #define ER_CANT_CREATE_DB 1006
 Can't create database '%-.64s'. (errno: %d),
 #define ER_DB_CREATE_EXISTS 1007
 Can't create database '%-.64s'. Database exists,
 #define ER_DB_DROP_EXISTS 1008
 Can't drop database '%-.64s'. Database doesn't exist,
 #define ER_DB_DROP_DELETE 1009
 Error dropping database (can't delete '%-.64s', errno: %d),
 #define ER_DB_DROP_RMDIR 1010
 Error dropping database (can't rmdir '%-.64s', errno: %d),
 #define ER_CANT_DELETE_FILE 1011
 Error on delete of '%-.64s' (errno: %d),
 #define ER_CANT_FIND_SYSTEM_REC 1012
 Can't read record in system table,
 #define ER_CANT_GET_STAT 1013
 Can't get status of '%-.64s' (errno: %d),
 #define ER_CANT_GET_WD 1014
 Can't get working directory (errno: %d),
 #define ER_CANT_LOCK 1015
 Can't lock file (errno: %d),
 #define ER_CANT_OPEN_FILE 1016
 Can't open file: '%-.64s'. (errno: %d),
 #define ER_FILE_NOT_FOUND 1017
 Can't find file: '%-.64s' (errno: %d),
 #define ER_CANT_READ_DIR 1018
 Can't read dir of '%-.64s' (errno: %d),
 #define ER_CANT_SET_WD 1019
 Can't change dir to '%-.64s' (errno: %d),
 #define ER_CHECKREAD 1020
 Record has changed since last read in table '%-.64s',
 #define ER_DISK_FULL 1021
 Disk full (%s). Waiting for someone to free some space,
 #define ER_DUP_KEY 1022
 Can't write, duplicate key in table '%-.64s',
 #define ER_ERROR_ON_CLOSE 1023
 Error on close of '%-.64s' (errno: %d),
 #define ER_ERROR_ON_READ 1024
 Error reading file '%-.64s' (errno: %d),
 #define ER_ERROR_ON_RENAME 1025
 Error on rename of '%-.64s' to '%-.64s' (errno: %d),
 #define ER_ERROR_ON_WRITE 1026
 Error writing file '%-.64s' (errno: %d),
 #define ER_FILE_USED 1027
 '%-.64s' is locked against change,
 #define ER_FILSORT_ABORT 1028
 Sort aborted,
 #define ER_FORM_NOT_FOUND 1029
 View '%-.64s' doesn't exist for '%-.64s',
 #define ER_GET_ERRNO 1030
 Got error %d from table handler,
 #define ER_ILLEGAL_HA 1031
 Table handler for '%-.64s' doesn't have this option,
 #define ER_KEY_NOT_FOUND 1032
 Can't find record in '%-.64s',
 #define ER_NOT_FORM_FILE 1033
 Incorrect information in file: '%-.64s',
 #define ER_NOT_KEYFILE 1034
 Incorrect key file for table: '%-.64s'. Try to repair it,
 #define ER_OLD_KEYFILE 1035
 Old key file for table '%-.64s'; Repair it!,
 #define ER_OPEN_AS_READONLY 1036
 Table '%-.64s' is read only,
 #define ER_OUTOFMEMORY 1037
 Out of memory. Restart daemon and try again (needed %d bytes),
 #define ER_OUT_OF_SORTMEMORY 1038
 Out of sort memory. Increase daemon sort buffer size,
 #define ER_UNEXPECTED_EOF 1039
 Unexpected eof found when reading file '%-.64s' (errno: %d),
 #define ER_CON_COUNT_ERROR 1040
 Too many connections,
 #define ER_OUT_OF_RESOURCES 1041
 Out of memory;  Check if mysqld or some other process uses all
 available memory. If not you may have to use 'ulimit' to allow mysqld
 to use more memory or you can add more swap space,
 #define ER_BAD_HOST_ERROR 1042
 Can't get hostname for your address,
 #define ER_HANDSHAKE_ERROR 1043
 Bad handshake,
 #define ER_DBACCESS_DENIED_ERROR 1044
 Access denied for user: '%-.32s@%-.64s' to database '%-.64s',
 #define ER_ACCESS_DENIED_ERROR 1045
 Access denied for user: '%-.32s@%-.64s' (Using password: %s),
 #define ER_NO_DB_ERROR 1046
 No Database Selected,
 #define ER_UNKNOWN_COM_ERROR 1047
 Unknown command,
 #define ER_BAD_NULL_ERROR 1048
 Column '%-.64s' cannot be null,
 #define ER_BAD_DB_ERROR 1049
 Unknown database '%-.64s',
 #define ER_TABLE_EXISTS_ERROR 1050
 Table '%-.64s' already exists,
 #define ER_BAD_TABLE_ERROR 1051
 Unknown table '%-.64s',
 #define ER_NON_UNIQ_ERROR 1052
 Column: '%-.64s' in %-.64s is ambiguous,
 #define ER_SERVER_SHUTDOWN 1053
 Server shutdown in progress,
 #define ER_BAD_FIELD_ERROR 1054
 Unknown column '%-.64s' in '%-.64s',
 #define ER_WRONG_FIELD_WITH_GROUP 1055
 '%-.64s' isn't in GROUP BY,
 #define ER_WRONG_GROUP_FIELD 1056
 Can't group on '%-.64s',
 #define ER_WRONG_SUM_SELECT 1057
 Statement has sum functions and columns in same statement,
 #define ER_WRONG_VALUE_COUNT 

Re: Berkelely MYSQL

[ryc]

It will run just fine, you need the patched version if you want transaction
support.

ryan


 Hi there

 I have managed to download the Berkeley for Windows installation,
however
 I have noted that MYSQL will not run without a patched version of
 berkeley's. Where can I obtain such a installation to run on Windows?

 Kind Regards
 Warren


 ~
 Warren van der Merwe
 Software Director
 PRT Trading (Pty) Ltd t/a RedTie
 Cell (083) 262-9163
 Office (031) 767-0249



 -
 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

how force mysql to use certain indexes

[Patrick J. Militzer]

Hi there,

I'm using mysql 3.22.27.  How can I force mysql to use index's in my select
statement?

When I use explain to see what the optimiser is doing I see that its using the
wrong index.  When I try to use the USE INDEX(KEY1,KEY) i get a syntax error.

Any ideas

Thanks,

Pat

Pat Militzer
Tech Support Supervisor
Metro/MLS Inc.
11430 W North Ave
Wauwatosa, WI 53226
414-778-5400 ext. 124
Fax 778-6143
email: [EMAIL PROTECTED]
web site: www.metromls.com
  www.wihomes.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

MySQL and php -- How do I force a connection open for a longer period ?

[Laloux, Dominique]

Hello,

On a NT4/Apache server, we have a php application that uses the following
syntax to open a connection :

$connect = mysql_connect($serverhost,$serveruser,$serverpass);
mysql_select_db($serverdb,$connect);
$mysql_link = $connect;

Since we upgraded to the latest version of mysql, the application was
behaving in a strange manner... We realized we could eliminate the new
problem by reestalishing the connection to the mysql database. 

It looks like the initial connection is no longer open for as long as it
needs to be. Is there a way to keep the connection open for longer ? Are we
overlooking a simple parameter somewhere ? Or... Why did this problem show
as we moved to the latest version of MySQL ? 

DL


-
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: Re: Reg. determining version

[Aigars Grins]

- Original Message -
From: [EMAIL PROTECTED]
To: Aigars Grins [EMAIL PROTECTED]
Sent: Monday, April 23, 2001 10:51 PM
Subject: Re: Re: Reg. determining version


 Your message cannot be posted because it appears to be either spam or
 simply off topic to our filter. To bypass the filter you must include
 one of the following words in your message:

 database,sql,query

 If you just reply to this message, and include the entire text of it in
the
 reply, your reply will go through. However, you should
 first review the text of the message to make sure it has something to do
 with MySQL. You have written the following:


  Yes, although 32235 represents 3.22.35, not 3.33.35.

 Yes. Typo. Sorry.

 --
 Aigars







-
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

MySQL CRASHED after some days with this message in errlog:

[Patric de Waha Lists]

Hi,
Mysql ran for 6 days.. It is a website
with heavy traffic.

/usr/libexec/ld-elf.so.1: /usr/local/libexec/mysqld: Undefined symbol
strtoull
010423 23:18:08  mysqld restarted
/usr/local/libexec/mysqld: ready for connections

What is this function about?

What feature shouldn't I use to avoid this problem?

Thanks in advance

Regards,
Patric de Waha


-
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

min () - sql troubles

[Christian Wix]

Hi
SQL troubles:
I have a table containing 4 columns: name - string, distance-
double,
speed - time and id - AUTO_INCREMENT (Primery key)
I want a list of the fastest (speed) runner (name) of each distance and
the
speed.
I use:
select name, distance, min(speed) from table1 group by distance;
I get a list where the speed and the distyance are always correct but
the
name is not always.
Why is that?
What should I do?

Thanks,

// Chris - Copenhagen

-
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

Problem Inserting/Updating TEXT Fields

[Florencia Vitale]

Hi all,

I'm new to this list, and would like to post a question.

I have a database with one table with a TEXT field where we save HTML files.
This table is Updated and Selected from a Servlet Applicacion, using JDBC.

Some TEXTs have a size of arround 60Kb. For records with this size (or
arround, I haven't guessed the limit yet) I have an error trying to Insert
or Update the record. With smaller sizes I have no problem, and even if I
load the TEXT directly from the server with the mysql command, I have no
problem at all, and I can do the Selects with no problem regardless the size
from the Servlet application too.

The error I get in the MYSQL Log for the hosts is :

Aborted connection 2 to db: 'dbname' user: 'xxx;password' host:
`hostname.domain.com' (Got an error reading communication packets)


I'm using MySQL 3.23.37, the JDBC Driver is MM version 2.0.4, and I'm
running under RedHat Linux 6.0. I've tried all kind of tests with the
configuration parameters for the MySQL server and the problem continues (I
have 64 MB RAM, but the database is rather small, few tables and records,
but with this TEXT field).

Basically I use a configuration file similar to the one that comes with the
documentation (for medium size servers my-medium.cnf) but with these
parameters touched for testing (with no results) :

set-variable  = max_allowed_packet=16M
set-variable  = net_buffer_length=16K
set-variable  = connect_timeout=15

Can anybody give me a clue, of what may be wrong ? Do I need to upgrade the
Linux kernell, or touch some more MySQL parameters ?

Thanks in advance,

Florencia Vitale
mailto:[EMAIL PROTECTED]


-
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

Compiling MYSQL for Win32 Platform BDB

[Warren van der Merwe]

Hi there

I have both the patched source for BDB and the Win32 source for MySql. So
now the next logical step is to compile them right? So I compile them, but
one thing is lurking in the back of my mind, how do I set the MYSQL up to
use the BDB table type? When I try and create a table and set the type to
BDB, it defaults to MYISAM. What am I missing. In all honesty this has been
a huge learning curve for me, I feel like I am almost there, and just need a
little more help.

Anymore's assistance will be greatly appreciated

Thanks
Warren


~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Cell (083) 262-9163
Office (031) 767-0249



-
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: Compiling MYSQL for Win32 Platform BDB

[Miguel Angel Solórzano]

At 00:27 24/04/01 +0200, Warren van der Merwe wrote:
Hi!
Below the instructions that I sent some time ago, only change the
version mentioned by the new ones that you have.

Regards,
Miguel

Assuming that you have on hand:

- The db-3.2.9 source stuff
- The MySQL 3.23.36 source stuff
- The VC++ 6.0 compiler

01.- Unpacked the db-3.2.9.zip file e.g.: c:\db-3.2.9
02.- Unpacked the mysql-3.23.36-win-src.zip file e.g.: c:\3.23.36
03.- Create the directory: c:\3.23.36\lib_release
04.- Build the BDB stuff:

Run the VC++ Compiler.
Using File/Open Workspace menu, open the workspace
c:\db-3.2.9\build_win32\Berkeley_DB.dsw.
When prompted to convert the project for the new version,
click Yes.
Open the screen Options by selecting: Tools/Options menu.
Click the Directories tab and you add the below directories:

C:\DB-3.2.9\BUILD_WIN32
C:\DB-3.2.9\INCLUDE

Now open the Set Active Project Configuration screen by
selecting the Build/Set Active Configuration menu.
Select the configuration called: db_buildall - Win32 Release Static
pressing the Ok button.
Press the F7 button to begin the compile process until see the
message: db_buildall.exe - 0 error(s), 0 warning(s).
Close the workspace.
Copy the lib c:\db-3.2.9\build_win32\Release_static\libdb32s.lib to
the directory c:\3.23.36\lib_release.

05.- Build the MySQL Server

Open the workspace c:\3.23.36\mysql.dsw.
You need to have the Microsoft Macro Assembler compiler 5.10 already
in the environment path. That is necessary to build the Strings.asm
and the Strxmov.asm from the strings tree. Otherwise, if you don't
have the masm.exe compiler, remove these 2 files from the strings tree
and add the following files to the strings project:

\strings\strmov.c
\strings\strend.c
\strings\strxmov.c
\strings\strmake.c
\strings\is_prefix.c
\strings\strnmov.c
\strings\strnlen.c
\strings\bmove_upp.c
\strings\strcend.c
\strings\strfill.c

Now, select the active configuration called mysqld- Win32 nt.
You can select other configuration option e.g.: mysqld.
Right click the mysqld files project and select Add Files to project.
Add the file c:\3.23.36\sql\ha_berkeley.cpp
Open the mysqld files settings screen. Click over the C/C++ tab.
Add the Preprocessor definition: HAVE_BERKELEY_DB
Now click the link tab and change the name for the output file
e.g.: ../client_release/mysqld-max-nt.exe
On the Object/Library modules, add the ..\lib_release\libdb32s.lib
Close the last screen mentioned.
Press F7 to build the MySQL Stuff and wait until see the message that
the mysqld-max-nt.exe file was copied.

3. Working with the MySQL Server

If you have already a server running, stop it and remove its service:
C:\mysql\binnet stop mysql
The MySql service is stopping
The MySql service was stopped successfully.

C:\mysql\binmysqld-nt --remove

Copy the mysqld-max-nt.exe to the /mysql/bin directory.

C:\mysql\binmysqld-max-nt --install

C:\mysql\binnet start mysql

The MySql service was started successfully.
C:\mysql\binmysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.35a

Type 'help;' or '\h' for help. Type '\c' to clear the buffer

mysql use test;
Database changed
mysql create table mybdb (id int not null primary key, idname char(50))
- type=bdb;
Query OK, 0 rows affected (0.77 sec)










Hi there

I have both the patched source for BDB and the Win32 source for MySql. So
now the next logical step is to compile them right? So I compile them, but
one thing is lurking in the back of my mind, how do I set the MYSQL up to
use the BDB table type? When I try and create a table and set the type to
BDB, it defaults to MYISAM. What am I missing. In all honesty this has been
a huge learning curve for me, I feel like I am almost there, and just need a
little more help.

Anymore's assistance will be greatly appreciated

Thanks
Warren


~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Cell (083) 262-9163
Office (031) 767-0249



-
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

__  ___   __
   /  |/  /_ __/ __/ __ \/ /   http://www.mysql.com/
  / /|_/ / // /\ \/ /_/ / /__  Miguel Solórzano [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/  São Paulo, Brazil
___/  Development Team


-
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: 

Cannot start logging.

[Brent Turley]

Hi.  I have a 3.23.22 test db running on Linux 6.2.  I am able to start the
database in log mode.
I also have a 3.23.28 production db running on Linux 6.2.  When I start this
database in log mode, there is no indication that logging is running.  There
are no log name.index or log name.nnn files anywhere.  Do you have any
idea what I can check to figure out why logging is not working?

Thank you.

Brent Turley
Insight Enterprises
Tempe, Arizona

MySQL++ ./configure error

[James Bonham]

Help !  Does anyone have a clue ?

tried to run configure on Ultra SPARC/Solaris 2.7

GNU binutils and libtool latest version, gcc 2.95.2

environment variables:
CC=gcc
CFLAGS=-O6
CXX=gcc
CXXFLAGS=-O6 -felide -constructors -fno-exceptions -fno-rtti

at the command line:./configure --prefix=myprefix --enable-assembler -- 
with-mysql=MySQL prefix

Any suggestions ?

Is MaxSQL backward compatible?

[Minh-Dang Ta]

Hi all.
Does anyone know for sure if MaxSQL backward
compatible with MySQL. I know this may be a silly
question but i have come across developments which are
not backward compatible and want to make sure.
If you also know of articles which states this then
please let me know as well. Thanks.


_
http://store.yahoo.com.au - Yahoo! Store
- It's time you had your business online!

-
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

you can help me

[ÌÕÓÀÇ¿]

mysql:

  hi ,i am a user in china.Now i have a problem that i cound't find 
mysql-3.22.30.tar.gz in the site www.mysql.com.
I think you can tell me where i can download it . Thanks!



yongqiang  tao 
[EMAIL PROTECTED]


-
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

innobase expects interactive input when disk is full

[ch]

Description:
My disc was full when I tried to restart mysql. The error log filled up 
with:

Innobase encountered a problem with file /var/lib/mysql/ib_logfile0.
Disk is full. Try to clean the disk to free space
before answering the following: How to continue?
(Y == freed some space: try again)
(N == crash the database: will restart it)?

Innobase encountered a problem with file /var/lib/mysql/ib_logfile0.
Disk is full. Try to clean the disk to free space
before answering the following: How to continue?
(Y == freed some space: try again)
(N == crash the database: will restart it)?


Not clever for a daemon process :)


How-To-Repeat:
see above
Fix:
output error to STDERR and quit with exit 1

Submitter-Id:  submitter ID
Originator:Christian Hammers
Organization:
Debian GNU/Linux
MySQL support: none
Synopsis:  innodb expects interactive input when disc is full
Severity:  non-critical
Priority:  low
Category:  mysql
Class: sw-bug
Release:   mysql-3.23.37 (Source distribution)

Environment:
Debian GNU/Linux unstable
System: Linux lathspell 2.4.2 #4 Don Feb 22 18:51:59 CET 2001 i586 unknown
Architecture: i586

Some paths:  /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs
gcc version 2.95.4 20010319 (Debian prerelease)
Compilation info: CC='gcc'  CFLAGS='-O2 -fomit-frame-pointer -g'  CXX='g++'  
CXXFLAGS='-O2 -fomit-frame-pointer -g -felide-constructors -fno-exceptions -fno-rtti'  
LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   14 17.04 20:05 /lib/libc.so.5 - libc.so.5.4.46
-rw-r--r--1 root root   567684 13.04 21:14 /lib/libc.so.5.4.46
lrwxrwxrwx1 root root   13 27.03 21:14 /lib/libc.so.6 - libc-2.2.2.so
-rwxr-xr-x1 root root  1108076 13.04 16:15 /lib/libc-2.2.2.so
-rw-r--r--1 root root  2526954 24.03 08:02 /usr/lib/libc.a
-rw-r--r--1 root root  178 24.03 08:02 /usr/lib/libc.so
-rw-r--r--1 root root   665260 01.09.2000 /usr/lib/libc-client.so.4.7
Configure command: ./configure  --prefix=/usr --exec-prefix=/usr 
--libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql 
--localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info 
--mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler 
--with-berkeley-db --with-innodb --enable-static --enable-shared --with-raid 
--without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock 
--with-mysqld-user=mysql --without-bench --with-extra-charsets=all


-
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: Compiling MYSQL for Win32 Platform BDB

[Warren van der Merwe]

Hi there

I have managed to follow your instructions, I have used the BDB source files
from the Unix download (build_win32 directory). And I have used the Windows
Source Files for MYSQL. Everything appears to compile correctly without any
errors, however when trying to do a net start mysql I get an error, upon
doing a debug I find the error happens on the following line which I
obtained from the Disassembly window (I do apologize, I am a VB programmer
and therefore a little unfamiliar with C++)

77F8E30E   int 2Eh

Does this help anyone at all, to explain why when issuing a net start ,
mysql crashes.

Below is a few more lines from the dissambelly window, with the faulty one
appearing about half way through as per above

77F8E27B   mov dword ptr [ebx+0B0h],0
77F8E285   mov dword ptr [ebx+0ACh],0
77F8E28F   mov dword ptr [ebx+0A8h],0
77F8E299   mov dword ptr [ebx+0A4h],0
77F8E2A3   mov dword ptr [ebx+0A0h],0
77F8E2AD   mov dword ptr [ebx+9Ch],0
77F8E2B7   mov word ptr [ebx+0BCh],cs
77F8E2BD   mov word ptr [ebx+98h],ds
77F8E2C3   mov word ptr [ebx+94h],es
77F8E2C9   mov word ptr [ebx+90h],fs
77F8E2CF   mov word ptr [ebx+8Ch],gs
77F8E2D5   mov word ptr [ebx+0C8h],ss
77F8E2DB   pushfd
77F8E2DC   pop dword ptr [ebx+0C0h]
77F8E2E2   mov eax,dword ptr [ebp+4]
77F8E2E5   mov dword ptr [ebx+0B8h],eax
77F8E2EB   mov eax,dword ptr [ebp]
77F8E2EE   mov dword ptr [ebx+0B4h],eax
77F8E2F4   lea eax,[ebp+8]
77F8E2F7   mov dword ptr [ebx+0C4h],eax
77F8E2FD   pop ebx
77F8E2FE   ret 4
77F8E301   mov eax,dword ptr [ebp+4]
77F8E304   ret
77F8E305   mov eax,9Fh
77F8E30A   lea edx,[esp+4]
77F8E30E   int 2Eh
77F8E310   jmp 77F98BAD
77F8E315   imulesi,ebx
77F8E318   add esi,ecx
77F8E31A   mov dword ptr [ebp-4],esi
77F8E31D   mov si,word ptr [edi]
77F8E320   inc edi
77F8E321   inc edi
77F8E322   push4
77F8E324   pushesi
77F8E325   call77F873D4
77F8E32A   pop ecx
77F8E32B   testeax,eax
77F8E32D   pop ecx
77F8E32E   je  77F8E3CA
77F8E334   movzx   ecx,si
77F8E337   sub ecx,30h
77F8E33A   cmp ecx,ebx

Regards
Warren

~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Cell (083) 262-9163
Office (031) 767-0249


 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]
 ]On Behalf
 Of Miguel Angel Solórzano
 Sent: 24 April 2001 12:50
 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Subject: Re: Compiling MYSQL for Win32 Platform  BDB


 At 00:27 24/04/01 +0200, Warren van der Merwe wrote:
 Hi!
 Below the instructions that I sent some time ago, only change the
 version mentioned by the new ones that you have.

 Regards,
 Miguel

 Assuming that you have on hand:

 - The db-3.2.9 source stuff
 - The MySQL 3.23.36 source stuff
 - The VC++ 6.0 compiler

 01.- Unpacked the db-3.2.9.zip file e.g.: c:\db-3.2.9
 02.- Unpacked the mysql-3.23.36-win-src.zip file e.g.: c:\3.23.36
 03.- Create the directory: c:\3.23.36\lib_release
 04.- Build the BDB stuff:

 Run the VC++ Compiler.
 Using File/Open Workspace menu, open the workspace
 c:\db-3.2.9\build_win32\Berkeley_DB.dsw.
 When prompted to convert the project for the new version,
 click Yes.
 Open the screen Options by selecting: Tools/Options menu.
 Click the Directories tab and you add the below directories:

 C:\DB-3.2.9\BUILD_WIN32
 C:\DB-3.2.9\INCLUDE

 Now open the Set Active Project Configuration screen by
 selecting the Build/Set Active Configuration menu.
 Select the configuration called: db_buildall - Win32 Release Static
 pressing the Ok button.
 Press the F7 button to begin the compile process until see the
 message: db_buildall.exe - 0 error(s), 0 warning(s).
 Close the workspace.
 Copy the lib c:\db-3.2.9\build_win32\Release_static\libdb32s.lib to
 the directory c:\3.23.36\lib_release.

 05.- Build the MySQL Server

 Open the workspace c:\3.23.36\mysql.dsw.
 You need to have the Microsoft Macro Assembler compiler 5.10 already
 in the environment path. That is necessary to build the Strings.asm
 and the Strxmov.asm from the strings tree. Otherwise, if you don't
 have the masm.exe compiler, remove these 2 files from the strings tree
 and add the following files to the strings project:

 \strings\strmov.c
 \strings\strend.c
 \strings\strxmov.c
 \strings\strmake.c
 \strings\is_prefix.c
 \strings\strnmov.c
 \strings\strnlen.c
 \strings\bmove_upp.c
 \strings\strcend.c
 \strings\strfill.c

 Now, select the active configuration called mysqld- Win32 nt.
 You can select other configuration option e.g.: mysqld.
 Right click the mysqld files project and select Add Files to project.
 Add the file c:\3.23.36\sql\ha_berkeley.cpp
 Open the mysqld files settings screen. Click over the C/C++ tab.

2 errrors while executing make

[Steven P. Kerscher]

I have installed mysql 3.23.36 for the first time ever
I did the test (ok)
I ran the bench mark and could not load DBI
I installed DBI 1.14
And Data Showtable 3.3
Then tried to install (Msql-Mysql-modules-1.2215)

Perl Makefile.pl worked fine
I run make and this is what it ends with:

make[1]: Entering directory `/usr/lib/perl5/Msql-Mysql-modules-1.2215/mysql'
LD_RUN_PATH=/usr/local/mysql/lib/mysql:/lib:/usr/lib:/usr/lib/gcc-lib/i486-
linux/2.7.2.3 gcc -o ../blib/arch/auto/DBD/mysql/mysql.so  -shared dbdimp.o
mysql.o -L/usr/local/mysql/lib/mysql-L/usr/local/mysql/lib/mysql -lmysql
client
-lm -lz -L/usr/lib/gcc-lib/i486-linux/2.7.2.3 -lgcc
/usr/i486-linux/bin/ld: cannot open -lz: No such file or directory
make[1]: *** [../blib/arch/auto/DBD/mysql/mysql.so] Error 1
make[1]: Leaving directory `/usr/lib/perl5/Msql-Mysql-modules-1.2215/mysql'
make: *** [subdirs] Error 2


I could use any help possible. I’m new to this entire thing


Thanks

doubt about a SELECT

[Pablo Pasqualino]

Hi, I have those tables:

CREATE TABLE citys (
   id mediumint(8) unsigned NOT NULL auto_increment,
   name varchar(100) NOT NULL,
   UNIQUE id (id)
);

CREATE TABLE route (
   id mediumint(8) unsigned NOT NULL auto_increment,
   id_from mediumint(8) unsigned DEFAULT '0' NOT NULL,
   id_to mediumint(8) unsigned DEFAULT '0' NOT NULL,
   UNIQUE id (id)
);

id_from and id_to are id's relationed with citys.id

Now I want to get it with the names:

SELECT citys.name as city_from, citys.name as city_to FROM citys,route
WHERE route.id_from=citys.id AND route.id_to=citys.id;

Obviusly that is wrong... so... how can I get both city names?

Thanks!

database,sql,query



-
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

2 errrors while executing make

[Steven P. Kerscher]

I have installed mysql 3.23.36 for the first time ever
I did the test (ok)
I ran the bench mark and could not load DBI
I installed DBI 1.14
And Data Showtable 3.3
Then tried to install (Msql-Mysql-modules-1.2215)

Perl Makefile.pl worked fine
I run make and this is what it ends with:

make[1]: Entering directory `/usr/lib/perl5/Msql-Mysql-modules-1.2215/mysql'
LD_RUN_PATH=/usr/local/mysql/lib/mysql:/lib:/usr/lib:/usr/lib/gcc-lib/i486-
linux/2.7.2.3 gcc -o ../blib/arch/auto/DBD/mysql/mysql.so  -shared dbdimp.o
mysql.o -L/usr/local/mysql/lib/mysql-L/usr/local/mysql/lib/mysql -lmysql
client
-lm -lz -L/usr/lib/gcc-lib/i486-linux/2.7.2.3 -lgcc
/usr/i486-linux/bin/ld: cannot open -lz: No such file or directory
make[1]: *** [../blib/arch/auto/DBD/mysql/mysql.so] Error 1
make[1]: Leaving directory `/usr/lib/perl5/Msql-Mysql-modules-1.2215/mysql'
make: *** [subdirs] Error 2


I could use any help possible. I’m new to this entire thing


Thanks

Multibyte export/import Question

[Hans Galic]

Hello to all,

i want to properly export Data from a MySQL Table with columns that contain
Thai and Latin characters and import this data to an Oracle Table with UTF8
characterset.

Who can give me some advice.
Where can i find detail MySQL-Information concerning this problem?

Thanks in advace.

Hans Galic | Product Development


mailto: [EMAIL PROTECTED]
Fon: + 49.6172.919-471
www.jobpilot.dewww.jobpilot.com
Europe´s career market on the internet
jobpilot AGSiemensstrasse 15-17D-61352 Bad Homburg


Amsterdam * Bangkok * Barcelona * Brussels * Budapest * Copenhagen
Frankfurt * Gothenburg * Kuala Lumpur *  London * Milan * Oslo
Paris * Prague * Singapore * Vienna * Warsaw * Zurich






-
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