Any function to convert string to integer?

2001-08-30 Thread Iago Sineiro

Hi all.

Anybody knows a function or some way to convert a string to a integer? I've
looked in the manual and I haven't seen anything.

I need it to order a query by a column which contains numbers but the type
of the column is varchar. I want to convert the values to integer before
ordering the query.

Iago.

 
__
mensaje enviado desde http://www.iespana.es
emails (pop)-paginas web (espacio illimitado)-agenda-favoris (bookmarks)-foros



-
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: myisampack dumps core on some tables

2001-08-30 Thread Martin MOKREJ

On Wed, 29 Aug 2001, Sasha Pachev wrote:

 On Wednesday 29 August 2001 15:14, Martin MOKREJ? wrote:
  Description:
I have on Linux running 3.23.41 the following problem:
  
  $ /usr/local/mysql/bin/myisampack -v -v -f --tmpdir=/tmp 
 /data/mysql/Aactinomycetemcomitans/blimps.MYI
  Compressing /data/mysql/Aactinomycetemcomitans/blimps.MYD: (1443 records)
  - Calculating statistics
  
  normal:  7  empty-space:   0  empty-zero: 0  empty-fill:   7
  pre-space:   0  end-space: 3  intervall-fields:   0  zero: 1
  Original trees:  16  After join: 9
  - Compressing file
  Segmentation fault (core dumped)
  $ gdb /usr/local/mysql/bin/myisampack ./core
  [...]
  Core was generated by `/usr/local/mysql/bin/myisampack -v -v -f 
 --tmpdir=/tmp /data/mysql/Aactinomycet'.
  Program terminated with signal 11, Segmentation fault.
  #0  0x400f00d5 in ?? ()
  (gdb) where
  #0  0x400f00d5 in ?? ()
  #1  0x8050557 in compress_isam_file ()
  #2  0x804e18c in compress ()
  #3  0x804d4b4 in main ()
  #4  0x400b3a42 in ?? ()
  (gdb) quit
  $
  
  The calling perl script reports as an error value in $! Illegal seek.
  
  It happens to me with 3 table-types:
  Packing blast Aactinomycetemcomitans failed: Illegal seek
  Packing blimps Aactinomycetemcomitans failed: Illegal seek
  Packing rep Aactinomycetemcomitans failed: Illegal seek
  Packing rep Aeropyrum_pernix_K1 failed: Illegal seek
  Packing rep Anabaena failed: Illegal seek
  Packing rep Aquifex_aeolicus_VF5 failed: Illegal seek
  Packing rep Archaeoglobus_fulgidus failed: Illegal seek
  Packing rep Athaliana_I failed: Illegal seek
  
  
  May I upload you some tables? ;-)
 
 Go ahead. For future refrence, if you can type How-to-repeat with good 
 instructions after that, write directly to [EMAIL PROTECTED]

Look in pub/mysql/secret for myisampack_failing.tgz .
It contains I hope representative sample of our failing tables, i.e. not
all of them, but all table-types are included.

-- 
Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / Institute for Bioinformatics http://mips.gsf.de
GSF - National Research Center for Environment and Health
Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany


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

2001-08-30 Thread Ed Carp

Matthew Walker ([EMAIL PROTECTED]) writes:

 What's the best way of doing a hot backup on a database? Our server is
 set up in such a way that it's not a simple matter to shut down
 apache/mysql and do the backup then. So, is it safe to just copy the
 mysql directories, or is there some recommended procedure for this?

RTFM, RTFM, RTFM!

That being said, most everyone I know uses mysqldump for hot backups.

Now, STOP what you're doing and go bookmark
http://www.bitbybit.dk/mysqlfaq/faq.html,
if you have time to do nothing else - this is Carsten Pederson's *excellent*
MySQL FAQ.
--
Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 - http://www.pobox.com/~erc

Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London

-
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




Help Urgent!!!

2001-08-30 Thread Eugene

Hello... 

I got a big problem in MYODBC. I am using myodbc-2.50.31-win95. When I use any MySQL 
Administrator to query the database that I had created for example:- SELECT * FROM 
dbname, they come out error like:=

Your command could not be completed. MySQL returned the following error:
Got error 127 from table handler.

There is an error too if I format my PC and reinstall all over again.
So, can I know what is going on? Can you me and give me instruction to overcome this 
problem. Thanks.

From Eugene



Re: Help Urgent!!!

2001-08-30 Thread Rafal Jank

Eugene wrote:
 
 Hello...
 
 I got a big problem in MYODBC. I am using myodbc-2.50.31-win95. When I use any MySQL 
Administrator to query the database that I had created for example:- SELECT * FROM 
dbname, they come out error like:=
 
 Your command could not be completed. MySQL returned the following error:
 Got error 127 from table handler.
 
 There is an error too if I format my PC and reinstall all over again.
 So, can I know what is going on? Can you me and give me instruction to overcome this 
problem. Thanks.
That means that the table has crashed. Repair it with command:
repair table dbname;
-- 
_/_/  _/_/_/  - Rafa Jank [EMAIL PROTECTED] -
 _/  _/  _/  _/   _/ Wirtualna Polska SA   http://www.wp.pl 
  _/_/_/_/  _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625
   _/  _/  _/ ==*  http://szukaj.wp.pl *==--

-
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




Reply-to and this list

2001-08-30 Thread Carl Troein

A quick question: How come the mailing list software
doesn't add a reply-to header? Is this intentional to
keep replies off the mysql list, and if so why?
I'll try to remember to reply to the list rather than
directly to the people who ask the questions, as replying
in private does little to stop the same questions from
reappearing, and if there's something this list has too
much of it's the same questions over and over... :-o

//Círdan

-- 
 Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
 Amiga user since '89, and damned proud of it too.


-
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




Index Create Speed

2001-08-30 Thread Mark kirkwood

Dear List,

I have a (standard table handler ) table defined as follows :

CREATE TABLE fact0 ( d0keyINTEGER,
 d1keyINTEGER,
 d2keyINTEGER,
 val  INTEGER,
 filler   VARCHAR(200)
   );

I then LOAD 300 rows into it ( about 350Mb)
This takes about 2m30s on my ( fairly old ) hardware ( I think this is quite 
fast ).

Distribution wise the d0key values are loaded in order. there are 300 
distinct d0keys, 300 distinct d0keys and 100 distinct d2keys.

The next step is creating an index as follows :

CREATE UNIQUE INDEX fact0_pk ON fact0(d0key,d1key,d2key) ;

Whichunfortunatly  takes about 20m ( which I think is a bit slow )

Here is my relevant .cnf configuration : ( I am using 3.23.39 compiled from 
source with gcc 2.96 on Mandrake 8.0 )

[mysqld]
port= 3306
socket  = /tmp/mysql.sock
skip-locking
set-variable= key_buffer=16M
set-variable= max_allowed_packet=1M
set-variable= table_cache=100
set-variable= sort_buffer=10M
set-variable= join_buffer=16M
set-variable= record_buffer=5M
set-variable= myisam_sort_buffer_size=32M
set-variable= thread_cache=8


any suggestions ? ( as I would love to create indexes faster ! ) 

regards

Mark

-
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: Primary Key pairs and auto-incrementing

2001-08-30 Thread Carl Troein

On 29-Aug-01, Paul DuBois wrote:

 Create a single PRIMARY KEY that consists of the two columns chapter and
 section, and make section an AUTO_INCREMENT column.  When you insert
 rows, set chapter to the proper chapter number and section to NULL.
 This will cause MySQL to generate independent sequences for each chapter.
 (In essence, you have multiple sequences within the same table.)
 
 This requires that you have MySQL 3.22.25 or later.  That's when this
 feature was introduced.

That's odd. There's nothing about it in the changelog for 3.22.25 in the
documentation, and the only reference to this behavior I've been able to
find in the manual is this (from the chapter on MyIsam): Note that when
an AUTO_INCREMENT is defined on the end of a multi-part-key the old
behavior is still present.

I hate having to ask for this, but could you please point me to the
chapter in the manual where this is discussed? I just can't seem to
find it. :-P

//C

-- 
 Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
 Amiga user since '89, and damned proud of it too.


-
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




Thanks!

2001-08-30 Thread Joyce Vermeulen

Hi all,

On the subject of licensing: I've seen the discussions around this topic
and would like to approach it from another angle.
Until recently I were a student and if it weren't for the free
distribution of mySQL I would have had problems.
On the other hand I will  be the first to - as soon as my budget
allow - pay to get the added resources, I think it's only fair to
the developers and us. It will also allow them to keep developing /
maintain  mySQL to its current standard.

Thank you all at mySQL for the great product. 
I am new to mySQL but like it alot. 

Regards

Joyce

-
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




database location

2001-08-30 Thread Thomas Mayerhofer

hy,

i want to set up a apache web server with mysql database connection
for different users which should have their databases in their
homedirectories.

for ex: user x use .jsp to write data from forms in a mysql database -
for ex: homedir: /home/x/htdocs
   but the mysqldatabases are by default in
/usr/local/mysql/var

is it possible do configure mysql to create the databases in
each users homedirectory ??

are there any solutions ?

thomas m.


-
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




discussion: mysql licensing issue and funding issues

2001-08-30 Thread Michael Widenius


Hi!

 Neil == Neil Zanella [EMAIL PROTECTED] writes:

Neil I would like to comment on the following mysql.com question

Neil  We have made our product available at zero price under the GNU
Neil  General Public Licence (GPL), and we also sell it under a commercial
Neil  licence to those who do not wish to be bound by the terms of the GPL.

Neil Out of curiosity, how does the second statement
Neil not violate the GNU GPL? It seems like the GPL
Neil can be bypassed by keeping two identical copies
Neil of the source code, one under the GNU GPL bundled
Neil with the GNU licence file called COPYING, and
Neil another bundled with a proprietary license file.
Neil Since the two source files can be considered as
Neil being updated separately the two licenses can
Neil be kept alive concurrently. This approach which
Neil as I see it is perfactly legal (as long as it
Neil is made clear which is the GPL'd release and
Neil which is the proprietary release on the download
Neil section of the mysqld.com web site) can lead
Neil to forking. In particular, contributions made
Neil to the GPL'd source code cannot be applied to
Neil the proprietary source code unless the contributor
Neil explicitly states that the contribution goes
Neil to both the GPL'd software release and the
Neil proprietary source code simultaneously.

cut

How we do it here at MySQL (And according to what I know, this is
identically to how FSF does it):

All files in the MySQL distribution that is part of the core MySQL
server clearly states that MySQL AB has the copyright to this file.

Patches that are emailed to us for these files that just cover a few
lines are not considered 'copyrightable work' and can thus be applied
both to the GPL and proprietary version of MySQL.
(See http://www.gnu.org/software/gcc/contribute.html for details about
this)

In other words, we don't have to change the copyright text of the file
just because someone asks us to do a small change to the file.

For larger patches we ask the author for a copyright assignment/shared
copyright before applying the patch (just like FSF does).

Another issue is that most patches, from outside sources, that goes into
the core server are rewritten by me to be more in line with the rest
of the MySQL code.

For source that doesn't affect the core MySQL server (like the InnoDB
or Gemini table handler or patches to the MySQL clients) we don't
require a copyright assignment.

cut

Neil I do not believe that the mysql.org folks have the
Neil experience to improve on mysql otherwise they would
Neil have started theirsql from scratch. For this very
Neil reason I would urge mysql.com and mysql.org to come
Neil to some compromise that would avoid the uglyness of
Neil what I deem as unnecessary code forking. Let us not
Neil have two separate code versions of mysql.
Neil Let us all cooperate.

The main problem with mysql.org is that it clearly violates our
trademark and other rights.  If we would accept mysql.org we would put
our trademark on risk and this could seriously affect our future
possibilities to do business.

Another problem with mysql.org is that this is driven by NuSphere, who
don't have any rights to copy, modify or distribute MySQL (because
they have violated the MySQL GPL license).  This also makes it hard
for us to work together with them.

We have also tried to talk with NuSphere to solve our issues but so
far in vain. During the two talks we have had with NuSphere after
mysql.org was launched they have just said they are note authorized to
talk about anything that is mentioned in the lawsuits (like the usage
of mysql.org). It's a little hard to sort out things when one of the
parties refuses to talk about the main issues at hand.

Neil Also, how is mysql.org's funding strategy any better
Neil than mysql.com? The two parties should perhaps merge.
Neil Having two mysql's will simply weaken mysql's
Neil popularity if there is no cooperation among
Neil the two parties.

I personally don't see any need for a mysql.org;  This site doesn't
provide anything important that mysql.com doesn't or couldn't provide.

I you want us to help avoid confusion, I would urge you to help us to
change those few links that are still pointing at mysql.org to point
to mysql.com.

Regards,
Monty
CTO of MySQL AB

-
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: Index Create Speed

2001-08-30 Thread Ed Carp

Mark kirkwood ([EMAIL PROTECTED]) writes:

 CREATE UNIQUE INDEX fact0_pk ON fact0(d0key,d1key,d2key) ;
 
 Whichunfortunatly  takes about 20m ( which I think is a bit slow )

Have you tried building the table structure with the index already in place,
then importing the data?
--
Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 - http://www.pobox.com/~erc

Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London

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

2001-08-30 Thread Ed Carp

daniel james ([EMAIL PROTECTED]) writes:

 I need to generate a tab-delimited text dump of table
 data ONLY and have it output to a text file. I don't
 want any table info, delimiters, etc.  I need this to
 copy/paste into a excel spreadsheet.  What's the
 syntax?
 
 I'm stuck here:
 
 % mysqldump dbname tablename  ???

Easier:

echo select * into outfile 'tablename.tsv' from tablename|mysql dbname
--
Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 - http://www.pobox.com/~erc

Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London

-
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: Index Create Speed

2001-08-30 Thread joseph . bueno

Mark kirkwood wrote:
 
 Dear List,
 
 I have a (standard table handler ) table defined as follows :
 
 CREATE TABLE fact0 ( d0keyINTEGER,
  d1keyINTEGER,
  d2keyINTEGER,
  val  INTEGER,
  filler   VARCHAR(200)
);
 
 I then LOAD 300 rows into it ( about 350Mb)
 This takes about 2m30s on my ( fairly old ) hardware ( I think this is quite
 fast ).
 
 Distribution wise the d0key values are loaded in order. there are 300
 distinct d0keys, 300 distinct d0keys and 100 distinct d2keys.
 
 The next step is creating an index as follows :
 
 CREATE UNIQUE INDEX fact0_pk ON fact0(d0key,d1key,d2key) ;
 
 Whichunfortunatly  takes about 20m ( which I think is a bit slow )
 
 Here is my relevant .cnf configuration : ( I am using 3.23.39 compiled from
 source with gcc 2.96 on Mandrake 8.0 )
 
 [mysqld]
 port= 3306
 socket  = /tmp/mysql.sock
 skip-locking
 set-variable= key_buffer=16M
 set-variable= max_allowed_packet=1M
 set-variable= table_cache=100
 set-variable= sort_buffer=10M
 set-variable= join_buffer=16M
 set-variable= record_buffer=5M
 set-variable= myisam_sort_buffer_size=32M
 set-variable= thread_cache=8
 
 any suggestions ? ( as I would love to create indexes faster ! )
 
 regards
 
 Mark
 

Hi,

Try with a bigger key_buffer.
You will get better performance if key_buffer is greater than your index.

Regards
--
Joseph Bueno
NetClub/Trader.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: Use of the MySQL logo - licensing agreement

2001-08-30 Thread Sinisa Milivojevic

Van writes:
 
 I'm also advertising for MySQL all over my site with the original logo.
 
 Do I need to remove it?  I'd rather not, since it's just a link to point people
 to a valuable resource.  Is my site violating the terms of the trademark?
 
 Van
 -- 
 =
 Linux rocks!!!   http://www.dedserius.com/
 =
 

Hi Van!

You do not have to do anything right now. Our people responsible for
this issue are trying to come out with something that would both
please MySQL community and protect us from some sharks out there.

I guess that you know what I am talking about.

After a new policy comes out, usage of logo  should be much clearer.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   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]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Index Create Speed

2001-08-30 Thread Sergei Golubchik

Hi!

On Aug 30, Mark kirkwood wrote:
 Dear List,
 
 I then LOAD 300 rows into it ( about 350Mb)
 This takes about 2m30s on my ( fairly old ) hardware ( I think this is quite 
 fast ).
 
 CREATE UNIQUE INDEX fact0_pk ON fact0(d0key,d1key,d2key) ;
 
 Which unfortunatly  takes about 20m ( which I think is a bit slow )
 
 any suggestions ? ( as I would love to create indexes faster ! ) 

I doubt you can do it much faster, but here're some hints:

Be sure that SHOW PROCESSLIST during index creation
shows repair by sort not repair with keycache.
Increase myisam_max_sort_file_size otherwise.

The most important parameter for repair by sort is
myisam_sort_buffer_size. The more, the better.
Most of other variables don't matter here.

Regards,
Sergei

-- 
MySQL Development Team
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
   ___/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Problems getting into MySQL.com

2001-08-30 Thread Sinisa Milivojevic

Philip Daggett writes:
 Is anybody else not able to get onto mysql.com???
 
There were some temporary problems with firewall. It should be OK by now.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   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]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Replication: Push by Master or Pop by Slaves ?

2001-08-30 Thread Claudio Cicali


There is an issue that confuse me a bit, altough it is not important
for an operational point of view:

 From the manual:

The master server keeps a binary log of updates and an index file to
binary logs to keep track of log rotation.  The slave, upon connecting,
informs the master where it left off since the last successfully propagated
update, catches up on the updates, and then blocks and waits for the master
to notify it of the new updates.

So, it seems that is the master that pushes information to the slave(s)

But I can also read:

MySQL replication is based on the server keeping track of all changes
to your database (updates, deletes, etc) in the binary log
and the slave server(s) reading the saved queries from the master
server's binary log so that the slave can execute the same queries
on its copy of the data.

Here, seems that are the slaves that pop data from master.
So where is the truth ? Is the master that pushes or the slaves the pops ?
Or it is a combination of the two ?

Thanks.


--
Claudio Cicali aka FleXer
[EMAIL PROTECTED]
http://www.flexer.it
GPG Key Fingerprint = 2E12 64D5 E5F5 2883 0472 4CFF 3682 E786 555D 25CE


-
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: Replication: Push by Master or Pop by Slaves ?]

2001-08-30 Thread Peter van Dijk

On Thu, Aug 30, 2001 at 12:44:46PM +0200, Claudio Cicali wrote:
[snip]
 Here, seems that are the slaves that pop data from master.
 So where is the truth ? Is the master that pushes or the slaves the pops ?
 Or it is a combination of the two ?

In normal operation, the master pushes to the slave. When a slave is
turned off temporarily and is turned back on, it pops all changes that
happened while it was down. After that, the master starts pushing
again.

Magic 5 letter word: MySQL. Tsk.

Greetz, Peter
-- 
Monopolyhttp://www.dataloss.nl/monopoly.html

-
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: Replication: Push by Master or Pop by Slaves ?

2001-08-30 Thread Jeremy Zawodny

On Thu, Aug 30, 2001 at 12:44:46PM +0200, Claudio Cicali wrote:
 
 Here, seems that are the slaves that pop data from master.  So where
 is the truth ? Is the master that pushes or the slaves the pops ?
 Or it is a combination of the two ?

It's a pull mechanism...  The slave simply contacts the master and
waits for updates to come down the channel.  But the slave is in
control of which updates it handles, etc.  And the master actually has
no idea who its slaves are.

Jeremy
-- 
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.41-max: up 0 days, processed 602,992 queries (192/sec. avg)

-
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: mysqld as root

2001-08-30 Thread Sinisa Milivojevic

Ken Menzel writes:
 Wasn't there something awhile back that was supposed to prevent
 running the daemon as root?  When the daemon was started through
 safe_mysqld it would tell you to select a user as root you had to
 use --user=root,  this seems to be gone!
 
 from the manual:
 F.2.26 Changes in release 3.23.15
  To start mysqld as root, you must now use the --user=root option.
 
 This does not seem to be true (tested on freebsd 3.23.41 etc),   the
 reason I have a problem with this is I am getting some files owned by
 root,  which is a problem if someone restarts mysql as
 safe_mysqld.  I am adding the user to my.cnf to avoid this, but it
 does seem to confict with the manual unless I missed a change note to
 remove that feature!
 
 
 Ken
 -
 Ken Menzel  ICQ# 9325188
 www.icarz.com  [EMAIL PROTECTED]
 

Seems that you are right !!

We would either have to change a code or docs 

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   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]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Use of the MySQL logo - licensing agreement

2001-08-30 Thread Van

Sinisa Milivojevic wrote:
 
 Van writes:
 
  I'm also advertising for MySQL all over my site with the original logo.
 
  Do I need to remove it?  I'd rather not, since it's just a link to point people
  to a valuable resource.  Is my site violating the terms of the trademark?
 
  Van
  --
  =
  Linux rocks!!!   http://www.dedserius.com/
  =
 
 
 Hi Van!
 
 You do not have to do anything right now. Our people responsible for
 this issue are trying to come out with something that would both
 please MySQL community and protect us from some sharks out there.
 
 I guess that you know what I am talking about.
 
 After a new policy comes out, usage of logo  should be much clearer.
 
 --
 Regards,
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
 /_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
___/   www.mysql.com
 
 -
Sinisa:

I've never had a doubt about the integrity of the MySQL AB approach to such
issues, nor this one.  

Thank you for confirming my assumption that MySQL AB is maintaining a
responsible approach in addressing this issue amid shark-infested waters.

As always, I offer my full support and endorsement of MySQL AB, Monty's efforts
and the MySQL Team for continued support and development of the superior
Database for UNIX/Linux/Windows Internet developers.

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: myisampack dumps core on some tables

2001-08-30 Thread Michael Widenius


Hi!

 Sasha == Sasha Pachev [EMAIL PROTECTED] writes:

Sasha On Wednesday 29 August 2001 15:14, Martin MOKREJ? wrote:
 Description:
 I have on Linux running 3.23.41 the following problem:
 
 $ /usr/local/mysql/bin/myisampack -v -v -f --tmpdir=/tmp 
Sasha /data/mysql/Aactinomycetemcomitans/blimps.MYI
 Compressing /data/mysql/Aactinomycetemcomitans/blimps.MYD: (1443 records)
 - Calculating statistics
 
 normal:  7  empty-space:   0  empty-zero: 0  empty-fill:   7
 pre-space:   0  end-space: 3  intervall-fields:   0  zero: 1
 Original trees:  16  After join: 9
 - Compressing file
 Segmentation fault (core dumped)

cut

Thanks Martin for the test case;  It enabled me to quickly find the
bug.

Here is a patch for this (This will be in 3.23.42)

= myisam/myisampack.c 1.9 vs edited =
*** /tmp/myisampack.c-1.9-8558  Wed Aug 22 01:45:03 2001
--- edited/myisam/myisampack.c  Thu Aug 30 14:09:40 2001
***
*** 251,257 
  
  static void print_version(void)
  {
!   printf(%s  Ver 1.9 for %s on %s\n,my_progname,SYSTEM_TYPE,MACHINE_TYPE);
  }
  
  static void usage(void)
--- 251,257 
  
  static void print_version(void)
  {
!   printf(%s  Ver 1.10 for %s on %s\n,my_progname,SYSTEM_TYPE,MACHINE_TYPE);
  }
  
  static void usage(void)
***
*** 1670,1676 
max_calc_length+=huff_counts[i].tree-height;
  else if (huff_counts[i].field_type == FIELD_BLOB ||
 huff_counts[i].field_type == FIELD_VARCHAR)
!   max_calc_length=huff_counts[i].tree-height*huff_counts[i].max_length + 
huff_counts[i].length_bits +1;
  else
max_calc_length+=
(huff_counts[i].field_length - huff_counts[i].max_zero_fill)*
--- 1670,1676 
max_calc_length+=huff_counts[i].tree-height;
  else if (huff_counts[i].field_type == FIELD_BLOB ||
 huff_counts[i].field_type == FIELD_VARCHAR)
!   max_calc_length+=huff_counts[i].tree-height*huff_counts[i].max_length + 
huff_counts[i].length_bits +1;
  else
max_calc_length+=
(huff_counts[i].field_length - huff_counts[i].max_zero_fill)*

Regards,
Monty

-
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: fulltext indexes for innodb?

2001-08-30 Thread Sergei Golubchik

Hi!

On Aug 30, Alexander wrote:
 Hello, mysql team!
 
 Any chance (in the near future) to get FullText indexing working with innodb
 table handler?
 
 Alexander

I doubt it will be done it the near future
(unless a customer would like to pay for the feature, of course).

Regards,
Sergei

-- 
MySQL Development Team
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
   ___/

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

2001-08-30 Thread Sinisa Milivojevic

Joyce Vermeulen writes:
 Hi all,
 
 On the subject of licensing: I've seen the discussions around this topic
 and would like to approach it from another angle.
   Until recently I were a student and if it weren't for the free
 distribution of mySQL I would have had problems.
   On the other hand I will  be the first to - as soon as my budget
 allow - pay to get the added resources, I think it's only fair to
 the developers and us. It will also allow them to keep developing /
 maintain  mySQL to its current standard.
 
 Thank you all at mySQL for the great product. 
 I am new to mySQL but like it alot. 
 
 Regards
 
 Joyce

On the behalf of MySQL AB, thank you for your kind words.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   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]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Syntax Question: deleting previous duplicate entries

2001-08-30 Thread Tom Churm

hi,

i've got a table collecting info from html forms.  problem is, certain
wiseguys always make multiple entries.  could someone clue me in to how
i can select the Last entry where there is a duplicate for the User
(type text, these are email addresses), and automatically delete any
previous entries?  i'm using a column 'id' int auto_increment as my
index: the last entry from a User will automatically have a higher id #.

example:  i've only gotten this far: this selects all users with
multiple entries

SELECT * from table_name GROUP BY User HAVING Count(User)  1

thanks muchly,

tom

-
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: Syntax Question: deleting previous duplicate entries

2001-08-30 Thread Ed Carp

Tom Churm ([EMAIL PROTECTED]) writes:

 hi,
 
 i've got a table collecting info from html forms.  problem is, certain
 wiseguys always make multiple entries.  could someone clue me in to how
 i can select the Last entry where there is a duplicate for the User
 (type text, these are email addresses), and automatically delete any
 previous entries?  i'm using a column 'id' int auto_increment as my
 index: the last entry from a User will automatically have a higher id #.

Try looking at the excellent MySQL FAQ! Here's a link that may help:

http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_8_0

:)
--
Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 - http://www.pobox.com/~erc

Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London

-
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




stopwords

2001-08-30 Thread Christopher Thorpe

Is there any way to remove the treatment of words three letters and under
being treated as a stopword when performing a query of a full text index on
a table. If it is a recompile of MySQL is there a good resource on how to do
this... I'm a newbie to the world of compiling MySQL

thanks
Chris



Dr Christopher Thorpe
Information Architect

GenomeBiology - biology for the post-genomic era
w   http://www.genomebiology.com
t   +44 (0) 20 7631 9184 (direct)



-
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 select statements

2001-08-30 Thread Ian Barwick

On Thursday 30 August 2001 15:28, Andre Konopka wrote:
 Hi,

 I have, three tables (one,two, three) with the rows id/value. id is the
 key for all the tables.


 with


 select value from one where id=xx;
 select value from two where id=xx;
 select value from three where id=xx;


 I can select all values from the tables with the id=xx.

 How can I do this with one select statement. Notice, it's possible that
 there is an entry for id=xx in table one, but
 not in table two, or three. Of course ist's possible that there is only
 a value in table three.

 The output could be

 id one.value two.value three.value
 x1  233  2342   NULL
 x2  NULL 998NULL
 x3  33   232 23

 Clear enough?

A couple of LEFT JOINs should probably do the trick

HTH

Ian Barwick


-- 
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de

To query tables in a MySQL database is more fun than eating spam

-
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




MySQLGUI file save function

2001-08-30 Thread Jeff Isom

I am using MySQLGUI 1.7.5-1 on Windows 2000.  When I save a query result to
a file it seems to save it as a Hex output. Is this what is supposed to
happen?  Can this be used to backup a database?

Thanks in advance.

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




Re: Use of the MySQL logo - licensing agreement

2001-08-30 Thread Sinisa Milivojevic

Van writes:
 Sinisa:
 
 I've never had a doubt about the integrity of the MySQL AB approach to such
 issues, nor this one.  
 
 Thank you for confirming my assumption that MySQL AB is maintaining a
 responsible approach in addressing this issue amid shark-infested waters.
 
 As always, I offer my full support and endorsement of MySQL AB, Monty's efforts
 and the MySQL Team for continued support and development of the superior
 Database for UNIX/Linux/Windows Internet developers.
 
 Best Regards,
 Van
 -- 
 =
 Linux rocks!!!   http://www.dedserius.com/
 =
 


Thank you Van !

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   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]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Use of the MySQL logo - licensing agreement

2001-08-30 Thread Frank Fisher

And then there's the sad situation I'm in.

I'm using MySQL to do a site for the U.S. Army, but I am not allowed to 
put the logo up as it would be considered an endorsement of a commercial 
product, which is a major no-no.

And I'd like so much to do it.  I'm thinking of a way, but I'll have to 
consult Legal to see if I'm okay (contact/about this site page with 
logo, and with required disclaimer that we don't endorse, etc.).

Frank.


-
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




order by number

2001-08-30 Thread Philip Montgomery

When doing a select with an order by clause, how do you make mysql list the items in 
correct numberical order.  Normally, when I run the command mysql will list 1000 
before 200 because of the initial digit.  How do I correct this?

Thanks,

Phil


Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/

-
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: MySQLGUI file save function

2001-08-30 Thread Sinisa Milivojevic

Jeff Isom writes:
 I am using MySQLGUI 1.7.5-1 on Windows 2000.  When I save a query result to
 a file it seems to save it as a Hex output. Is this what is supposed to
 happen?  Can this be used to backup a database?
 
 Thanks in advance.
 
 Jeff
 

It will save query results in a file in  escaped form. 

For backup use mysqldump or mysqlhotcopy or BACKUP TABLE command.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   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]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Database Disappeared

2001-08-30 Thread Ken Menzel

Hi Van,
  If you don't give drop privileges how can the user drop tables?  Is
there a way to give just drop table privileges, because 'drop' will
let you drop tables and the database?  If so I missed it and would be
very happy to know how to do this, as I would feel a little better
about that as well,  Ideally I would only want to be allow the user to
drop temp tables (in my case).
Ken
- Original Message -
From: Van [EMAIL PROTECTED]
cut

 If yes, and yes, then your user dropped the db.  Bummer.  You should
NEVER give
 drop db privileges to anyone.  Not even yourself.  :)

 Van



-
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: order by number

2001-08-30 Thread Adams, Bill TQO

If the column is an int then it will order it numerically.  Other wise you have to 
cast it.  And dont for get the difference between ORDER BY x ASC and ORDER BY x DESC.

--Bill


DROP TABLE IF EXISTS test;
CREATE TABLE test ( i int, c char(20));
INSERT INTO test VALUES
( 1, '5' ),
( 2, '4' ),
( 3, '3' ),
( 4, '2' ),
( 5, '1' ),
( 1, '5' );

SELECT '-- Natural Order';
SELECT * FROM test;
SELECT '- ORDER by INT';
SELECT * FROM test ORDER BY i;
SELECT '- ORDER BY cast char-- ';
SELECT *, ( c + 0) AS o_col FROM test ORDER BY o_col;


Philip Montgomery wrote:

 When doing a select with an order by clause, how do you make mysql list the items in 
correct numberical order.  Normally, when I run the command mysql will list 1000 
before 200 because of the initial digit.  How do I correct this?

 Thanks,

 Phil

 Get 250 color business cards for FREE!
 http://businesscards.lycos.com/vp/fastpath/

 -
 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

--
Bill Adams
TriQuint Semiconductor




-
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: Licensing terms for an Intranet site

2001-08-30 Thread Jay Fesco

  -- 
  Jeremy D. Zawodny, [EMAIL PROTECTED]
  Technical Yahoo - Yahoo Finance
  Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936
  
 
 Is anyone else getting a strange flag associated with Jeremy's 
 email, or is it just me?  Every one of his posts comes in flagged 
 in Outlook, and the headers have a line which reads:
 
 X-message-flag: Mailbox corrupt.  Please upgrade your mail software.
 
 This is definitely OT for this forum, but this forum is the only 
 place where I see the problem.
 
 Jay

database,sql,query,table

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

2001-08-30 Thread Sinisa Milivojevic

Mike writes:
 I'll probably get brow beat for this but hey the coffee has not kicked in
 yetg
 
 How to I allow connections from remote  clients?
 
 I lost my note but I thought it was GRANT ALL PRIVILEGES ON *.* TO
 [EMAIL PROTECTED];
 
 The rights are high but this is the example I seen somewhere.
 
 Mine keeps saying host@dsl-boi-111-111-111-1 not allowed to connect
 
 I am using MySQLFront client.
 
 Thanks
 
 M;)
 
 Quote of the day;
 Instead of having answers on a math test, they should just call them
 impressions, and if you got a different impression, so what, can't we
 all be brothers?
 - Jack Handey
 

Either grant privileges to user@% or insert that host into host
table and reload privileges.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   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]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Db maintenance

2001-08-30 Thread April Sims

Is there anything I need to be doing maintenance wise on a mysql database?
I have inherited one that was installed as follows

As far as database stuff that we do, we basically
installed the server, set up databases and tables, and use them.
Indices have been created on many of the tables to speed up access
times.

It is being replicated to another server continuously.
In particular  mysqldump, mysqladmin, optimize, mysqlcheck, etc.

Thanks.





 
April Sims  MCSE, CNE   Abilene Christian University
OCP 8i DBA  ACU Box 29005
Information Technology  Abilene, TX 79699
[EMAIL PROTECTED]   Vx:(915)674-2681 Fx:674-6724
 



-
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: MySQLGUI file save function

2001-08-30 Thread Jeff Isom

I am fairly new to MySQL and I am unfamiliar with the term escaped form.
Can anyone point me to documentation that explains what that is and how it
can be used.

Also,  I am trying to perform a backup remotely.  My understanding is that
the mysqldump and mysqlhotcopy commands can only be used on the local
machine.  Is this correct?  What is the best way to perform a backup
remotely.

Thanks,

Jeff

- Original Message -
From: Sinisa Milivojevic [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, August 30, 2001 9:29 AM
Subject: Re: MySQLGUI file save function


 Jeff Isom writes:
  I am using MySQLGUI 1.7.5-1 on Windows 2000.  When I save a query result
to
  a file it seems to save it as a Hex output. Is this what is supposed to
  happen?  Can this be used to backup a database?
 
  Thanks in advance.
 
  Jeff
 

 It will save query results in a file in  escaped form.

 For backup use mysqldump or mysqlhotcopy or BACKUP TABLE command.

 --
 Regards,
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
 /_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
___/   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]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Precision of Scientific Notation

2001-08-30 Thread George.T.Essig

For a float column, is there any way to change the decimal precision for
scientific notation returned from a select statement?  For instance, a
select statement currently returns 1.19573e+06 although the actual value is
1.195731e+06.

Also, is there any way to prevent MySQL from using scientific notation for
float columns in a select statement?

Thanks,

George Essig




-
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: Licensing terms for an Intranet site

2001-08-30 Thread Robert Alexander

Hi Jay,

I'd definitely suspect Outlook (or LOOKOUT! as a few of my network support buddies 
call it) as the source of the problem, rather than anything to do with Jeremy's emails.

I'm having no problems here -- but then again, I don't use any Microsoft products. :

Good luck,

/Rob


As Rob Glaser, a former Microsoft exec, told Time magazine last year, 
Gates is relentless. He's Darwinian. He doesn't look for win-win 
situations with others, but for ways to make others lose. Success 
is defined as flattening the competition, not creating excellence. 


Ob. MySQL: database, sql, query, table


 Is anyone else getting a strange flag associated with Jeremy's 
 email, or is it just me?  Every one of his posts comes in flagged 
 in Outlook, and the headers have a line which reads:
 
 X-message-flag: Mailbox corrupt.  Please upgrade your mail software.
 
 This is definitely OT for this forum, but this forum is the only 
 place where I see the problem.
 
 Jay

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

2001-08-30 Thread Luc Foisy

Has anyone tested dropping a master database?
I have dropped the master database that was replicating just to see how it
would affect the slave. The slave kept its data.

What would the proper proceedure be in this case?

I wouldnt be able to snapshot the slave and then port the snapshot back into
the master, the bin logs would be messed up then.
If I was replicating multiple databases on the master (bin logging multiple
databases) and I had a slave only replicating one of those databases, I
wouldnt be able to just remove all the bin logs and start the process over
again without losing the rest of the replicated databases.

A note: Nothing occurs in the error log or in SHOW MASTER STATUS on the
master when a database is dropped that it is supposed to be replicating.
Does it not realize that the database is not there?

If I was only replicating one database (bin logging one database), could I
just port in a copy from the slave, remove the bin logs and index(or modify
it in some way) from the master, do something with the master.info on the
slave and then let it go from there?

Has anyone ever been through this scenario? (Luckily I am only testing these
things and I am not on a live database!)

Luc Foisy

Technical Magic Corporation
1 Stafford Road, Suite 325, Nepean, Ontario, K2H 1B9
Phone: (613) 829-7117 Fax: (613) 596-5096
E-Mail: [EMAIL PROTECTED]

 Fulfilling the Promise of Technology 


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

2001-08-30 Thread Ed Carp

April Sims ([EMAIL PROTECTED]) writes:

 Is there anything I need to be doing maintenance wise on a mysql database?
 I have inherited one that was installed as follows
 
 As far as database stuff that we do, we basically
 installed the server, set up databases and tables, and use them.
 Indices have been created on many of the tables to speed up access
 times.
 
 It is being replicated to another server continuously.
 In particular  mysqldump, mysqladmin, optimize, mysqlcheck, etc.

We don't do anything here.  Every now and then the server gets rebooted for one reason 
or another (every 45-60 days), and either isamchk -r -e -s -o -f or myisamchk -r 
gets run, followed by optimize table commands on some of the most updated tables.
--
Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 - http://www.pobox.com/~erc

Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London

-
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 adding tables, databases, or records

2001-08-30 Thread joseph . bueno

Benjamin Krajmalnik wrote:
 
 I have a deployment of mySQL 3.23.26-beta running on FreeBSD 4.2-RELEASE.
 I am running 3 databases off of a single mySQL server.
 In one particular database I am unable to insert records - the process just
 hangs.
 My intuition would tell me that maybe something is corrupted in the index.
 Since I have no problem whatsoever selecting records from the database, I
 thought I would create a new table with the same schema and copy the records
 over.
 HOWEVER, although I am logged in as root and root has full priviledges in
 the user table, I am unable to either create new databases or add new
 tables.  This is getting extremely frustrating.
 Below is a sample of the results:
 
 mysql use aplcore
 Reading table information for completion of table and column names
 You can turn off this feature to get a quicker startup with -A
 
 Database changed
 mysql create table test (ID int);
 ERROR 3: Error writing file './aplcore/test.frm' (Errcode: 28)
 mysql
 
 I have set the access rights for the aplcore directory under mySQL to 776 to
 make sure it was not an access issue.
 Any help will be deeply appreciated - this needs to be resolved ASAP.
 
 Also, I am logged in as the superuser account.

Hi,

$ perror 28
Error code  28:  No space left on device

Have you checked disc space ?

Regards
--
Joseph Bueno
NetClub/Trader.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 adding tables, databases, or records

2001-08-30 Thread Benjamin Krajmalnik

OK.  I tracked the problem to being out of disk space in the var partition.
The default source installation plaved the data in the /var/db directory.
The var partition is not that large by default, and therefore I am now out
of space.
I would like to move the data to a /usr/local/mysql/data directory.
What is the proper process to do this by?
Is moving the data to that directory and changing the datadir location in
safe_mysqld sufficient?
Any help will be deeply appreciated.



-
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 adding tables, databases, or records

2001-08-30 Thread Gerald Clark

perror 28
Error code 28:  No space left on device




Benjamin Krajmalnik wrote:

 I have a deployment of mySQL 3.23.26-beta running on FreeBSD 4.2-RELEASE.
 I am running 3 databases off of a single mySQL server.
 In one particular database I am unable to insert records - the process just
 hangs.
 My intuition would tell me that maybe something is corrupted in the index.
 Since I have no problem whatsoever selecting records from the database, I
 thought I would create a new table with the same schema and copy the records
 over.
 HOWEVER, although I am logged in as root and root has full priviledges in
 the user table, I am unable to either create new databases or add new
 tables.  This is getting extremely frustrating.
 Below is a sample of the results:
 
 
 mysql use aplcore
 Reading table information for completion of table and column names
 You can turn off this feature to get a quicker startup with -A
 
 Database changed
 mysql create table test (ID int);
 ERROR 3: Error writing file './aplcore/test.frm' (Errcode: 28)
 mysql
 
 I have set the access rights for the aplcore directory under mySQL to 776 to
 make sure it was not an access issue.
 Any help will be deeply appreciated - this needs to be resolved ASAP.
 
 Also, I am logged in as the superuser account.
 
 
 
 -
 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


-- 
Gerald L. Clark
[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




[OT] Old sources

2001-08-30 Thread Rodney Broom

Hi all,

I hate to bring this up in the group, but I haven't found an answer on the site. I've 
got mysql-3.23.30-gamma-unknown-freebsdelf4.2-i386.tar.gz installed, but I need to 
recompile a little differently. My problem is that I can't find this version in source.
Can anybody tell me where I can find this version in source?

---
Rodney Broom
Programmer: Desert.Net




-
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: Licensing terms for an Intranet site (way beyond OT)

2001-08-30 Thread Jay Fesco

 i think this is jeremy's not-so-subtle way of bashing your choice of email
 client.
 check this link:
 http://www.rodos.net/outlook/#messageflag

 -ravi.


Yeah, yeah - I got it.  Only problem is that I DON'T have a choice (company
policy et al)...
\:^{

Jay Fesco

Magical Mystery Words: database,sql,query,table


-
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




newbie password issue

2001-08-30 Thread gabriel

now i changed the root password just fine
but now i have to enter it every time i run mysqladmin
even mysqladmin version reqires a -p

tell me there's a simpler way


-
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: newbie password issue

2001-08-30 Thread Chris Bolt

 now i changed the root password just fine
 but now i have to enter it every time i run mysqladmin
 even mysqladmin version reqires a -p

 tell me there's a simpler way

http://www.mysql.com/doc/C/o/Connecting.html

* You can specify connection parameters in the [client] section of the
`.my.cnf' configuration file in your home directory. The relevant section of
the file might look like this:

[client]
host=host_name
user=user_name
password=your_pass


-
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_connect () and mysql_pconnect are not recognized ! Pls help.

2001-08-30 Thread root

Hi,

I'm running mysql MAX 3.23.41 on LinuxPPC, everything was installed from
an RPM.
My problem is whenever I try to call mysql_connect (), from a php3
script, I got the error function not found or misconfigured  
The script is a simple form, that passes the data to be added to an
empty database, with an empty table, both  the MySQL server and Apache
reside on the same machine, and because it's just a test, I'm entering
as root.
I am developing a more complex script  , but I need to solve the
connection problem first 
BTW ifyou define a var $link = mysql_connect ( localhost ) or   ;  ,
which is the correct syntax ? localhost or 'localhost' ?
Why is the command failing ??? From the console it works 

BTW The server is on a static IP without a DNS, is it correct to set
mysql_connect (xxx.xxx.xxx.xxx) or ('xxx.xxx.xxx.xxx' when you are
running as localhost 

Thank you

Regards,

Rick




-
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: order by number

2001-08-30 Thread William R. Mussatto

What about a number field w/zero fill?
On Thu, 30 Aug 2001, Adams, Bill TQO wrote:

 Date: Thu, 30 Aug 2001 08:48:11 -0700
 From: Adams, Bill TQO [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Subject: Re: order by number
 
 If the column is an int then it will order it numerically.  Other wise you have to 
cast it.  And dont for get the difference between ORDER BY x ASC and ORDER BY x DESC.
 
 --Bill
 
 
 DROP TABLE IF EXISTS test;
 CREATE TABLE test ( i int, c char(20));
 INSERT INTO test VALUES
 ( 1, '5' ),
 ( 2, '4' ),
 ( 3, '3' ),
 ( 4, '2' ),
 ( 5, '1' ),
 ( 1, '5' );
 
 SELECT '-- Natural Order';
 SELECT * FROM test;
 SELECT '- ORDER by INT';
 SELECT * FROM test ORDER BY i;
 SELECT '- ORDER BY cast char-- ';
 SELECT *, ( c + 0) AS o_col FROM test ORDER BY o_col;
 
 
 Philip Montgomery wrote:
 
  When doing a select with an order by clause, how do you make mysql list the items 
in correct numberical order.  Normally, when I run the command mysql will list 1000 
before 200 because of the initial digit.  How do I correct this?
 
  Thanks,
 
  Phil
 
  Get 250 color business cards for FREE!
  http://businesscards.lycos.com/vp/fastpath/
 
  -
  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
 
 --
 Bill Adams
 TriQuint Semiconductor
 
 
 
 
 -
 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
 

Sincerely,

William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27


-
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 (command line program) enhancement request

2001-08-30 Thread Chris Johnson

I use MySQL a number of different ways:  the C API, from PHP, from the
command line, and often from shell scripts run by other users or from
crontab entries.  The latter two uses present a couple of problems that
could be fixed easily through some minor changes to the code for the mysql
program (mysql.cc).

I'd like to see the following 2 changes:

(1) Blank out the password in the environment variables while running for
security.

Otherwise, on any system where one can run a ps command (most Unix
derivatives), any user can easily see the password when it is given on the
command line to the '-p' argument.  As there is no other reasonable way to
provide the password, this is a common problem.  The C/C++ code to do this
is simple, small and efficient.


(2) When running in a batch mode, one usually wants to know if the command
worked or not.  The default is to tell the user absolutely nothing (example
1 below).  Adding the '-v' (verbose) flag gets the user some feedback -- the
SQL that was submitted -- but says nothing about success (example 2 below).
Adding a second 'v' (-vv) adds the results of the command to the feedback
(example 3 below).  This seems completely backwards.  I know what SQL I
submitted; I want to know if it worked.

I'd like to see the meaning of the '-v' and '-vv' flags reversed, giving the
results with the first 'v', and then echoing the SQL along with the results
with the second 'v'.

Example 1:
49 hostname:~ mysql -pmypass -e 'Update foo Set val = 1 Where id = 1;' temp
50 hostname:~


Example 2:
50 hostname:~ mysql -v -pmypass -e 'Update foo Set val = 1 Where id = 1;'
temp
--
Update foo Set val = 1 Where id = 1
--

51 hostname:~


Example 3:
51 hostname:~ mysql -vv -pmypass -e 'Update foo Set val = 1 Where id = 1;'
temp
--
Update foo Set val = 1 Where id = 1
--

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

Bye
52 hostname:~



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

2001-08-30 Thread Adams, Bill TQO

I have been playing around with merge tables.  You MUST have the columns and
indexes in the same order.

Eg. Do
SHOW INDEX FROM real_table;
SHOW INDEX FROM merge_table;

If the Column_name order is different you will get either no records or a
bunch of null records when you select on a column that is indexed.

b.

Sergei Golubchik wrote:

 Hi!

 On Aug 29, Johnny Withers wrote:
  I'm not sure if this is a bug or if this is the way MERGE TABLES works
  in MySQL.
 
  It seems that if I have an INDEX in a field (id for instance), and I try
  to
  SELECT using a WHERE id=NUMBER, it will fail, even though that NUMBER is
  a
  valid id. ID is an int unsigned field with a key on it. However, when I
  drop
  the key, everything works as expected..
 
  Is this a bug?
 
  (also if I tried to ORDER BY id, while indexed, that didn't work either)
 

 Both look like a bug.
 Could you create a repeatable test case ?

 Regards,
 Sergei

 --
 MySQL Development Team
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik [EMAIL PROTECTED]
  / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
 /_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
___/

 -
 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

--
Bill Adams
TriQuint Semiconductor




-
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




Virtualizing MySQL

2001-08-30 Thread Mustafa Hashmi

Hi all,

I am in the process of creating a Virtual Server - and pretty much all
aspects have been completed to my liking. This includes web / mail / ftp and
ssh.

The next hurdle is virtualizing MySQL, and I would like to do this by
sharing the same MySQL server across multiple chrooted clients. This way,
they can have unlimied databases / tables under their userID without looking
at, or disrupting, any of the other clients in their chroot.

I am also rather new to this, so please feel free to point me to a URL which
may help. I've tried though - couldn't find anything relevant to my cause.

I appreciate your time.

Cheers,
Mustafa.



-
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




Storing the mysql data in a different location

2001-08-30 Thread Philip Daggett

Hello everyone!!

I am installing the latest rpm for mysql 3-23.41 on a RedHat 7.1 box and 
want the datadir to be /data/mysql/data. In my /etc/my.cnf file I 
have the directive:

[mysqld]
datadir=/data/mysql/data

The installation completes but the daemon won't start. I do the 
mysql_install_db command and the requisite tables are installed in my new 
data directory, the message states that it is starting with the data in the 
new directory, then the server stops and the error message from the error 
log is :

/usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)

This file in fact exists in the new data directory as well as the 
/var/lib/mysql directory.

Does anyone know how to do this correctly??

Thanks,

Phil


-
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: Select without taking all items

2001-08-30 Thread Fabio Caponera



Webmaster Odell wrote:

 Hi

 I am trying to write a query that pulls all the items from a database except
 two

 here is what I am using:

 $query = 'SELECT DISTINCT Type FROM Products WHERE Type != System,
 Upgrade';

 This populates the drop down box with all including the System and Upgrade.
 What do I have to do to make this work?

 Thanks

 Kevin

Try with the query
SELECT DISTINCT Type FROM Products WHERE Type  'System' AND Type  'Upgrade'
Bye
Fabio




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

2001-08-30 Thread Johnny Withers

Well, I don't know if you can specify what order to put these in,
but mine just happen to not be in the same order:

mysql show index from all_records;
++-+--+-+---+---
--+--++
| Non_unique | Key_name| Seq_in_index | Column_name | Collation |
Cardinality | Sub_part | Packed |
++-+--+-+---+---
--+--++
|  1 | catalog_key |1 | catalog | A |
NULL | NULL | NULL   |
|  1 | id_key  |1 | id  | A |
NULL | NULL | NULL   |
++-+--+-+---+---
--+--++
2 rows in set (0.00 sec)

mysql show index from data1[,2,3,4,5];
++-+--+-+---+---
--+--++
| Non_unique | Key_name| Seq_in_index | Column_name | Collation |
Cardinality | Sub_part | Packed |
++-+--+-+---+---
--+--++
|  0 | PRIMARY |1 | id  | A |
93 | NULL | NULL   |
|  1 | catalog_key |1 | catalog | A |
NULL | NULL | NULL   |
++-+--+-+---+---
--+--++

As you can see, the data1,2,3,4,5 tables that make up the 'all_records'
table
have a primary key defined on ID.  I was unable to define the ID field
in
my merged table as primary because it has to be non_unique. This may
have
caused the problem.

Maybe making the id columns in data1,2,3,4,5 a normal key instead of 
PIMARY will solve the problem.

(Filter : MySQL,database,SQL,etc)

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

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Adams, Bill TQO
Sent: Thursday, August 30, 2001 1:11 PM
To: Sergei Golubchik
Cc: Johnny Withers; Mysql-List
Subject: Re: MERGE TABLES


I have been playing around with merge tables.  You MUST have the columns
and
indexes in the same order.

Eg. Do
SHOW INDEX FROM real_table;
SHOW INDEX FROM merge_table;

If the Column_name order is different you will get either no records or
a
bunch of null records when you select on a column that is indexed.

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

2001-08-30 Thread Adams, Bill TQO


Monty helped me with this, and this is my
understanding.

Regardless of what order you generate the keys,
MySQL puts the primary key first, then the UNIQUE
keys, then the others.

When you add a new UNIQUE key, it puts it after
the primary key but before the other existing
UNIQUE keys.

In your case you have only non-UNIQUE keys in the
merge table so you just need to add them in the
same order as is in the dataN tables and MySQL
will maintain the order:

ALTER TABLE all_records DROP INDEX id_kex, DROP
INDEX catalog_key;
ALTER TABLE all_records ADD INDEX id_key (id_key),
ADD INDEX catalog_key (catalog_key);


--Bill


Johnny Withers wrote:

 Well, I don't know if you can specify what order
 to put these in,
 but mine just happen to not be in the same
 order:

 mysql show index from all_records;
 ++-+---
 --+-+---+---
 --+--++
 | Non_unique | Key_name| Seq_in_index |
 Column_name | Collation |
 Cardinality | Sub_part | Packed |
 ++-+-
 +-+---+---
 --+--++
 |  1 | catalog_key |1 |
 catalog | A |
 NULL | NULL | NULL   |
 |  1 | id_key  |1 |
 id  | A |
 NULL | NULL | NULL   |
 ++
 +--+-+---+---
 --+--++
 2 rows in set (0.00 sec)

 mysql show index from data1[,2,3,4,5];
 ++-+---
 --+-+---+---
 --+--++
 | Non_unique | Key_name| Seq_in_index |
 Column_name | Collation |
 Cardinality | Sub_part | Packed |
 ++-+-
 +-+---+---
 --+--++
 |  0 | PRIMARY |1 |
 id  | A |
 93 | NULL | NULL   |
 |  1 | catalog_key |1 |
 catalog | A |
 NULL | NULL | NULL   |
 ++
 +--+-+---+---
 --+--++

 As you can see, the data1,2,3,4,5 tables that
 make up the 'all_records'
 table
 have a primary key defined on ID.  I was unable
 to define the ID field
 in
 my merged table as primary because it has to be
 non_unique. This may
 have
 caused the problem.

 Maybe making the id columns in data1,2,3,4,5 a
 normal key instead of
 PIMARY will solve the problem.

 (Filter : MySQL,database,SQL,etc)

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


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
 Behalf Of Adams, Bill TQO
 Sent: Thursday, August 30, 2001 1:11 PM
 To: Sergei Golubchik
 Cc: Johnny Withers; Mysql-List
 Subject: Re: MERGE TABLES

 I have been playing around with merge tables.
 You MUST have the columns
 and
 indexes in the same order.

 Eg. Do
 SHOW INDEX FROM real_table;
 SHOW INDEX FROM merge_table;

 If the Column_name order is different you will
 get either no records or
 a
 bunch of null records when you select on a
 column that is indexed.

 b.

--
Bill Adams
TriQuint Semiconductor






-
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




Enabling Logging of Slow Queries

2001-08-30 Thread Ryan Shrout

I have tried to enable slow query logging for a couple days now, with no
success.

I have tried adding the line to the my.cnf file as well as stoppign the
service then starting it with the command line version.  Both ways, the
server refuses to restart.  I have checked the syntax over and over and I
think I have it correct!

[mysqld]
log-slow-queries=/root/slow-queries.log

and

/etc/usr/bin/safe_mysqld --log-slow-queries=/root/slow-queries.log

Either way, the server will not start.  I take the line out and it works
again.  What am I doing wrong?

Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[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




COUNTNULL function

2001-08-30 Thread kyndig

Evening Gurus,

  I have a small problem that I've beaten to death the past 2 days. I am
trying to get the value of a row, and update another table accordingly.
The data within the row is either a 1 or 0.  My issue is in trying to
increment a count for both 1's and 0's.

  In other words, I want to SUM up all the 1's and update a table with
this sum. I also want to sum up all the 0's and add this total count to
the table as well. This can be accomplished in  a long query, or in
through a language..what I am trying to accomplish is to get the total sum
of each value without using a WHERE clause. Something akin to:

SELECT ...
 SUM(bool_was_connected),
 COUNTNULL(bool_was_connected),
etc...

the SUM will sum up all non-null values. The COUNTNULL would sum up all
rows which have a value of 0.

Does anyone have a UDF for this function? I currently don't have room on
my laptop to download the mysql source code in order to write this up. (
Also have not written a udf for mysql up to this point either)

Thankyou kindly for any reply,
Calvin



-
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: Storing the mysql data in a different location

2001-08-30 Thread Gerald Clark

Unfortunately, when you moved the directories, you forgot to make mysql 
the owner
of the new directory.

chown -R mysql /data/mysql


Philip Daggett wrote:

 Hello everyone!!
 
 I am installing the latest rpm for mysql 3-23.41 on a RedHat 7.1 box and 
 want the datadir to be /data/mysql/data. In my /etc/my.cnf file I 
 have the directive:
 
 [mysqld]
 datadir=/data/mysql/data
 
 The installation completes but the daemon won't start. I do the 
 mysql_install_db command and the requisite tables are installed in my 
 new data directory, the message states that it is starting with the data 
 in the new directory, then the server stops and the error message from 
 the error log is :
 
 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
 
 This file in fact exists in the new data directory as well as the 
 /var/lib/mysql directory.
 
 Does anyone know how to do this correctly??
 
 Thanks,
 
 Phil
 
 
 -
 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


-- 
Gerald L. Clark
[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: COUNTNULL function

2001-08-30 Thread Adams, Bill TQO

SELECT SUM( bool_was_connected=1 ) AS was_connected,
SUM( bool_was_connected=0 ) AS was_not_connected, etc...


b.


[EMAIL PROTECTED] wrote:

 Evening Gurus,

   I have a small problem that I've beaten to death the past 2 days. I am
 trying to get the value of a row, and update another table accordingly.
 The data within the row is either a 1 or 0.  My issue is in trying to
 increment a count for both 1's and 0's.

   In other words, I want to SUM up all the 1's and update a table with
 this sum. I also want to sum up all the 0's and add this total count to
 the table as well. This can be accomplished in  a long query, or in
 through a language..what I am trying to accomplish is to get the total sum
 of each value without using a WHERE clause. Something akin to:

 SELECT ...
  SUM(bool_was_connected),
  COUNTNULL(bool_was_connected),
 etc...

 the SUM will sum up all non-null values. The COUNTNULL would sum up all
 rows which have a value of 0.

 Does anyone have a UDF for this function? I currently don't have room on
 my laptop to download the mysql source code in order to write this up. (
 Also have not written a udf for mysql up to this point either)



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

2001-08-30 Thread Gerald Clark

Two problems.
The clients don't have access to the databases, the server does.

Chrooted clients will not be able to read and write the named pipe
unless it is in their new root structure.

Mustafa Hashmi wrote:

 Hi all,
 
 I am in the process of creating a Virtual Server - and pretty much all
 aspects have been completed to my liking. This includes web / mail / ftp and
 ssh.
 
 The next hurdle is virtualizing MySQL, and I would like to do this by
 sharing the same MySQL server across multiple chrooted clients. This way,
 they can have unlimied databases / tables under their userID without looking
 at, or disrupting, any of the other clients in their chroot.
 
 I am also rather new to this, so please feel free to point me to a URL which
 may help. I've tried though - couldn't find anything relevant to my cause.
 
 I appreciate your time.
 
 Cheers,
 Mustafa.
 
 
 
 -
 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


-- 
Gerald L. Clark
[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: COUNTNULL function

2001-08-30 Thread kyndig

Thankyou kindly Bill. Just to verify, SUM adds up values. My data
is only 1 or 0. I used SUM as an example, the below query you recommend
will count all 'rows' which are 0, thus returning a number which
represents how many 0's were found?

Thankyou for the fast reply,
Calvin

On Thu, 30 Aug 2001, Adams, Bill TQO wrote:

 SELECT SUM( bool_was_connected=1 ) AS was_connected,
 SUM( bool_was_connected=0 ) AS was_not_connected, etc...


 b.


 [EMAIL PROTECTED] wrote:

  Evening Gurus,
 
I have a small problem that I've beaten to death the past 2 days. I am
  trying to get the value of a row, and update another table accordingly.
  The data within the row is either a 1 or 0.  My issue is in trying to
  increment a count for both 1's and 0's.
 
In other words, I want to SUM up all the 1's and update a table with
  this sum. I also want to sum up all the 0's and add this total count to
  the table as well. This can be accomplished in  a long query, or in
  through a language..what I am trying to accomplish is to get the total sum
  of each value without using a WHERE clause. Something akin to:
 
  SELECT ...
   SUM(bool_was_connected),
   COUNTNULL(bool_was_connected),
  etc...
 
  the SUM will sum up all non-null values. The COUNTNULL would sum up all
  rows which have a value of 0.
 
  Does anyone have a UDF for this function? I currently don't have room on
  my laptop to download the mysql source code in order to write this up. (
  Also have not written a udf for mysql up to this point either)
 



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

2001-08-30 Thread Jay Fesco

Calvin,

Maybe I'm just confused (fairly likely), but it appears that you are
confusing 'null' with zero.  If you actually want to count all values
including nulls, COUNT(*) will do it.  If you want to count NON nulls,
COUNT(a_field_name) does it.  SUM(a_field_name) returns the sum of all
non-null values for a_field_name.  Appropriate WHERE, IN, or NOT IN clauses
combined with a version of the COUNT and/or SUM functions should give you
the results you need.

Jay


 Evening Gurus,

   I have a small problem that I've beaten to death the past 2 days. I am
 trying to get the value of a row, and update another table accordingly.
 The data within the row is either a 1 or 0.  My issue is in trying to
 increment a count for both 1's and 0's.

   In other words, I want to SUM up all the 1's and update a table with
 this sum. I also want to sum up all the 0's and add this total count to
 the table as well. This can be accomplished in  a long query, or in
 through a language..what I am trying to accomplish is to get the total sum
 of each value without using a WHERE clause. Something akin to:

 SELECT ...
  SUM(bool_was_connected),
  COUNTNULL(bool_was_connected),
 etc...

 the SUM will sum up all non-null values. The COUNTNULL would sum up all
 rows which have a value of 0.

 Does anyone have a UDF for this function? I currently don't have room on
 my laptop to download the mysql source code in order to write this up. (
 Also have not written a udf for mysql up to this point either)

 Thankyou kindly for any reply,
 Calvin




-
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




Is this a bug?

2001-08-30 Thread randy

Hi People,

   I'm trying to execute this Simple query:

SET SQL_SAFE_MODE=0;

The server doesn't like it; However, SET any other option will work fine
except this one.

I'm still using mysqld v3.23.36 . If someone can try it on the latest version.


Thanks.

Randy,


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

2001-08-30 Thread Adams, Bill TQO

Yes.

A feature of MySQL is that it returns 1 for true and 0 for false.  When you
select ... you can put logic tests and sum up the number of true values.  In the
case of bool_was_connected=0 will have a value of 1 when it is true and then
you sum up the results.

You could also do something like:
SUM( bool_was_connected IS NULL )
SUM( boul_was_connected IS NULL OR boul_was_connected=0 )
and do on.  Just put the condition you want to be true and count in the SUM().

b.

[EMAIL PROTECTED] wrote:

 Thankyou kindly Bill. Just to verify, SUM adds up values. My data
 is only 1 or 0. I used SUM as an example, the below query you recommend
 will count all 'rows' which are 0, thus returning a number which
 represents how many 0's were found?

 Thankyou for the fast reply,
 Calvin

 On Thu, 30 Aug 2001, Adams, Bill TQO wrote:

  SELECT SUM( bool_was_connected=1 ) AS was_connected,
  SUM( bool_was_connected=0 ) AS was_not_connected, etc...
 
 
  b.
 
 
  [EMAIL PROTECTED] wrote:
 
   Evening Gurus,
  
 I have a small problem that I've beaten to death the past 2 days. I am
   trying to get the value of a row, and update another table accordingly.
   The data within the row is either a 1 or 0.  My issue is in trying to
   increment a count for both 1's and 0's.
  
 In other words, I want to SUM up all the 1's and update a table with
   this sum. I also want to sum up all the 0's and add this total count to
   the table as well. This can be accomplished in  a long query, or in
   through a language..what I am trying to accomplish is to get the total sum
   of each value without using a WHERE clause. Something akin to:
  
   SELECT ...
SUM(bool_was_connected),
COUNTNULL(bool_was_connected),
   etc...
  
   the SUM will sum up all non-null values. The COUNTNULL would sum up all
   rows which have a value of 0.
  
   Does anyone have a UDF for this function? I currently don't have room on
   my laptop to download the mysql source code in order to write this up. (
   Also have not written a udf for mysql up to this point either)
  
 

--
Bill Adams
TriQuint Semiconductor




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

2001-08-30 Thread kyndig

Evening Jay,

 I'm still abit new to MySQL. Spending the last 6 months I have worked
with it more on my CGI development, than good SQL query practicing. My
technical jargon is lacking. In laymens terms ( I know no other at this
point in time ) I have a row that has '1' or '0' in it. I'm trying to do:
What is the total number of '1's?  What is the total number of 0's?

Thanks for the patience list,
Calvin


Update: Just read Bill's reply to my request. Looks like he's got my
answer. Thankyou much gents.


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

2001-08-30 Thread Mustafa Hashmi

Gerhard,

Thank you for your response.

Emphasizing that I am new to this, could you describe in a bit more detail
how I could put this in the new root structure? (client's chrooted
structure)

If this is too extensive to properly explain, is there some documentation
available which might help?

I appreciate your help.

Regards,
Mustafa.

- Original Message -
From: Gerald Clark [EMAIL PROTECTED]
To: Mustafa Hashmi [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, August 30, 2001 1:03 PM
Subject: Re: Virtualizing MySQL


 Two problems.
 The clients don't have access to the databases, the server does.

 Chrooted clients will not be able to read and write the named pipe
 unless it is in their new root structure.

 Mustafa Hashmi wrote:

  Hi all,
 
  I am in the process of creating a Virtual Server - and pretty much all
  aspects have been completed to my liking. This includes web / mail / ftp
and
  ssh.
 
  The next hurdle is virtualizing MySQL, and I would like to do this by
  sharing the same MySQL server across multiple chrooted clients. This
way,
  they can have unlimied databases / tables under their userID without
looking
  at, or disrupting, any of the other clients in their chroot.
 
  I am also rather new to this, so please feel free to point me to a URL
which
  may help. I've tried though - couldn't find anything relevant to my
cause.
 
  I appreciate your time.
 
  Cheers,
  Mustafa.
 
 
 
  -
  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


 --
 Gerald L. Clark
 [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: MySQLGUI file save function

2001-08-30 Thread Sinisa Milivojevic

Jeff Isom writes:
 I am fairly new to MySQL and I am unfamiliar with the term escaped form.
 Can anyone point me to documentation that explains what that is and how it
 can be used.
 
 Also,  I am trying to perform a backup remotely.  My understanding is that
 the mysqldump and mysqlhotcopy commands can only be used on the local
 machine.  Is this correct?  What is the best way to perform a backup
 remotely.
 
 Thanks,
 
 Jeff

Escaped form means that binary data are escaped, i.e. some characters
are converted to a combo of backslash and readable character. Read a
manual on the subject.

You can use mysqldump from remote hosts, without any problems.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   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]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Storing the mysql data in a different location

2001-08-30 Thread Philip Daggett

Thanks Gerald!!

That did the trick and everything seems to be running perfectly!

At 01:59 PM 8/30/2001 -0500, Gerald Clark wrote:
Unfortunately, when you moved the directories, you forgot to make mysql 
the owner
of the new directory.

chown -R mysql /data/mysql


Philip Daggett wrote:

Hello everyone!!
I am installing the latest rpm for mysql 3-23.41 on a RedHat 7.1 box and 
want the datadir to be /data/mysql/data. In my /etc/my.cnf file I 
have the directive:
[mysqld]
datadir=/data/mysql/data
The installation completes but the daemon won't start. I do the 
mysql_install_db command and the requisite tables are installed in my new 
data directory, the message states that it is starting with the data in 
the new directory, then the server stops and the error message from the 
error log is :
/usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
This file in fact exists in the new data directory as well as the 
/var/lib/mysql directory.
Does anyone know how to do this correctly??
Thanks,
Phil

-
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


--
Gerald L. Clark
[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




Installation on Solaris questions

2001-08-30 Thread Sujay Daniel

I'm a newbie to Unix and MySQL. I have a few
questions.

With 'uname -a' I got the following message

SunOS [EMAIL PROTECTED] 5.7 Generic_106541-06 sun4u sparc
SUNW,Ultra-1

Can i install mysql-3.23.41-sun-solaris2.8-sparc in
it.

Theres no installation instructions for Unix/Solaris
machines in the Documentation page. I'd appreciate it
if someone can give me pointers on installing MySql on
a Sun Solaris machine

Thank you

( tables )


__
Do You Yahoo!?
Get email alerts  NEW webcam video instant messaging with Yahoo! Messenger
http://im.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




Support Contracts

2001-08-30 Thread chwill

Anyone,

I apologize for broadcasting to the group, but I've been trying to set-up a 
maintenance contract
and licenses for about a month and no-one seems to be listening to the sales and 
licensing 
e-mail drops for MySQL AB Company.

I assume those that are 'in the know' can direct me to some 'reliable' way of 
contacting 
any? business folks.

Again my apologies for spamming the group.

Thanks,
Chris

-
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




help renumbering unique

2001-08-30 Thread Jaime Teng

Hi,

I have a mysql table:
+---+--+--+-+
| Field | Type | Null | Key |
+---+--+--+-+
| sessionid | int(10) unsigned |  | PRI |
| username  | char(20) |  | MUL |
| start | int(10) unsigned |  | MUL |
| stop  | int(10) unsigned |  | MUL |
| ipaddress | char(15) | YES  | |
+---+--+--+-+

sessionid is a unique key.

Is there a way to change the values of sessionid such that
the values will be numbered from 1 and increments by 1?

ie, if the numbers were 1,20,22,25,40,45,47.
the new data will be 1,2,3,4,5,6,7,8,9. ?


Jaime



-
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: MySQLGUI file save function

2001-08-30 Thread s. keeling

On Thu, Aug 30, 2001 at 10:22:02AM -0600, Jeff Isom wrote:
 I am fairly new to MySQL and I am unfamiliar with the term escaped form.

This a Unix-ism.  For instance:

   this line
   'this line'
   this\ line

The last two are functionally equivalent.  The last one has an
'escaped' space embedded within it.  Ie., the shell is forced to
interpret the third line just like it would the second line.

All of these have to do with how the shell interprets them.  

Here's some more:

   $var
   $var
   '$var'

In this, the first two are equivalent.  Single quotes protect
variables from shell interpretation.  Double quotes do not.


All of this is explained in most introductory Unix books. 


-- 
 Any technology distinguishable from magic is insufficiently advanced.
 [EMAIL PROTECTED] TopQuark Software  Serv. Contract programmer, server bum.


-
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: order by number

2001-08-30 Thread Adams, Bill TQO

You mean leading zeros?  MySQL will translate as much of a string as it can into a 
number when it is cast:

mysql select ('a'+0);
+-+
| ('a'+0) |
+-+
|   0 |
+-+
1 row in set (0.00 sec)

mysql select ('00010'+0);
+-+
| ('00010'+0) |
+-+
|  10 |
+-+
1 row in set (0.00 sec)

mysql select ('0010a'+0);
+-+
| ('0010a'+0) |
+-+
|  10 |
+-+
1 row in set (0.00 sec)

mysql

--bill

William R. Mussatto wrote:

 What about a number field w/zero fill?
 On Thu, 30 Aug 2001, Adams, Bill TQO wrote:

  Date: Thu, 30 Aug 2001 08:48:11 -0700
  From: Adams, Bill TQO [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Cc: [EMAIL PROTECTED]
  Subject: Re: order by number
 
  If the column is an int then it will order it numerically.  Other wise you have to 
cast it.  And dont for get the difference between ORDER BY x ASC and ORDER BY x DESC.
 
  --Bill
 
 
  DROP TABLE IF EXISTS test;
  CREATE TABLE test ( i int, c char(20));
  INSERT INTO test VALUES
  ( 1, '5' ),
  ( 2, '4' ),
  ( 3, '3' ),
  ( 4, '2' ),
  ( 5, '1' ),
  ( 1, '5' );
 
  SELECT '-- Natural Order';
  SELECT * FROM test;
  SELECT '- ORDER by INT';
  SELECT * FROM test ORDER BY i;
  SELECT '- ORDER BY cast char-- ';
  SELECT *, ( c + 0) AS o_col FROM test ORDER BY o_col;
 
 
  Philip Montgomery wrote:
 
   When doing a select with an order by clause, how do you make mysql list the 
items in correct numberical order.  Normally, when I run the command mysql will list 
1000 before 200 because of the initial digit.  How do I correct this?
  
   Thanks,
  
   Phil
  
   Get 250 color business cards for FREE!
   http://businesscards.lycos.com/vp/fastpath/
  
   -
   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
 
  --
  Bill Adams
  TriQuint Semiconductor
 
 
 
 
  -
  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
 

 Sincerely,

 William Mussatto, Senior Systems Engineer
 CyberStrategies, Inc
 ph. 909-920-9154 ext. 27

--
Bill Adams
TriQuint Semiconductor




-
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: Enabling Logging of Slow Queries

2001-08-30 Thread Sven Huster

i think the server does not run with privileges
to write to /root

regards

Sven Huster
Senior IT Systems Engineer


Sven Huster
Senior IT Systems Engineer



 -Original Message-
 From: Ryan Shrout [mailto:[EMAIL PROTECTED]]
 Sent: 30 August, 2001 20:51
 To: [EMAIL PROTECTED]
 Subject: Enabling Logging of Slow Queries


 I have tried to enable slow query logging for a couple days
 now, with no
 success.

 I have tried adding the line to the my.cnf file as well as
 stoppign the
 service then starting it with the command line version.  Both
 ways, the
 server refuses to restart.  I have checked the syntax over
 and over and I
 think I have it correct!

 [mysqld]
 log-slow-queries=/root/slow-queries.log

 and

 /etc/usr/bin/safe_mysqld --log-slow-queries=/root/slow-queries.log

 Either way, the server will not start.  I take the line out
 and it works
 again.  What am I doing wrong?

 Ryan Shrout
 Owner - Amdmb.com
 http://www.amdmb.com/
 [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




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

2001-08-30 Thread Joshua J. Kugler

The short answer is that you can't, if you're using a named pipe 
(/tmp/mysql.sock, or some such).  That would require every user having their 
own installation of MySQL, which may be what you want.

Why not have the users connect via TCP/IP, and just set permissions 
correctly?  They would be able to list the other databases on the server, but 
if permissions are set correctly, they will only be able to have access to 
their own databases.

Hope that helps.

j- k-

On Thursday 30 August 2001 12:21, Mustafa Hashmi wrote:
 Gerhard,

 Thank you for your response.

 Emphasizing that I am new to this, could you describe in a bit more detail
 how I could put this in the new root structure? (client's chrooted
 structure)

 If this is too extensive to properly explain, is there some documentation
 available which might help?

 I appreciate your help.

 Regards,
 Mustafa.

 - Original Message -
 From: Gerald Clark [EMAIL PROTECTED]
 To: Mustafa Hashmi [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Sent: Thursday, August 30, 2001 1:03 PM
 Subject: Re: Virtualizing MySQL

  Two problems.
  The clients don't have access to the databases, the server does.
 
  Chrooted clients will not be able to read and write the named pipe
  unless it is in their new root structure.
 
  Mustafa Hashmi wrote:
   Hi all,
  
   I am in the process of creating a Virtual Server - and pretty much all
   aspects have been completed to my liking. This includes web / mail /
   ftp

 and

   ssh.
  
   The next hurdle is virtualizing MySQL, and I would like to do this by
   sharing the same MySQL server across multiple chrooted clients. This

 way,

   they can have unlimied databases / tables under their userID without

 looking

   at, or disrupting, any of the other clients in their chroot.
  
   I am also rather new to this, so please feel free to point me to a URL

 which

   may help. I've tried though - couldn't find anything relevant to my

 cause.

   I appreciate your time.
  
   Cheers,
   Mustafa.
  
  
  
   -
   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
 
  --
  Gerald L. Clark
  [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

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
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 sequence generator function?

2001-08-30 Thread Jaime Teng

Hi,

Is there a number sequence generator/function in
MySQL such that if I were to execute:
UPDATE mytable SET id = thisfunction;
it will update the table mytable and set the column
id to a numbered sequence 1,2,3,4,5,6,7,8,9.?

currently, i have a table with 2.5 million records and
i want to change one of the field and sequence it and
am doing it the hard way of updating one at a time.

regards
Jaime

-
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: myisampack dumps core on some tables

2001-08-30 Thread Martin MOKREJ

On Thu, 30 Aug 2001, Michael Widenius wrote:

Hi,
  yes this patch *fixes* all of my problems, except one table which is/was
probably too big? I haven't found any options that would make myisamchk to
ask for less memory.

/usr/local/mysql/bin/myisamchk: Out of memory (Needed 4294922813 bytes)
/usr/local/mysql/bin/myisamchk: error: 12 when opening MyISAM-table 
'/data/mysql/Celegans/rep.MYI'
/usr/local/mysql/bin/myisamchk: Out of memory (Needed 4294922813 bytes)
/usr/local/mysql/bin/myisamchk: error: 12 when opening MyISAM-table 
'/data/mysql/Celegans/rep.MYI'

-rwxrwx---1 mysqlmysql21108759 Aug 28 20:31 /data/mysql/Celegans/rep.MYD
-rwxrwx---1 mysqlmysql1024 Aug 29 21:55 /data/mysql/Celegans/rep.MYI
-rwxrwx---1 mysqlmysql9247 Aug 28 20:30 /data/mysql/Celegans/rep.frm

 Well, the other rep tables are fine. I'm a bit angry about myself,
because I dropped the Celegans.rep tables:!!!


mysql drop table rep;
Query OK, 0 rows affected (0.05 sec)


and dumped them again via network from master site, so I got:

-rw-rw1 mysqlmysql44130688 Aug 30 21:39 /data/mysql/Celegans/rep.MYD
-rw-rw1 mysqlmysql 2411520 Aug 30 21:39 /data/mysql/Celegans/rep.MYI
-rw-rw1 mysqlmysql9247 Aug 30 21:38 /data/mysql/Celegans/rep.frm


I managed successfully to run myisamchk -rq on it, myisampack and again
myisamchk -rq. So now I can only tell you that broken datafile can cause
myisamchk to ask for too much memory. :(

  This is on master site:
-rw-rw1 pedant   users44130688 Jul 11 13:41 /home/mysql/Celegans/rep.MYD
-rw-rw1 pedant   users 1645568 Jul 11 13:41 /home/mysql/Celegans/rep.MYI
-rw-rw1 pedant   users9247 Jul 11 13:40 /home/mysql/Celegans/rep.frm

mysql select count(id) from rep;
+---+
| count(id) |
+---+
| 19223 |
+---+
1 row in set (0.02 sec)

mysql 


  and this is on backup site after compression and rebuilding index:
-rw-rw1 mysqlmysql21108573 Aug 30 21:41 /data/mysql/Celegans/rep.MYD
-rw-rw1 mysqlmysql 1644544 Aug 30 21:41 /data/mysql/Celegans/rep.MYI
-rw-rw1 mysqlmysql9247 Aug 30 21:38 /data/mysql/Celegans/rep.frm

  and also 19223 lines.

  So unfortunately, I don't have the broken table anymore, only the
screen dumps (size od .MYD and .MYI differed). It seems the
broken datafile had 6 bytes more, broken index was much smaller.
That's all I can tell you. ;)
Maybe it helps.

 
 Hi!
 
  Sasha == Sasha Pachev [EMAIL PROTECTED] writes:
 
 Sasha On Wednesday 29 August 2001 15:14, Martin MOKREJ? wrote:
  Description:
  I have on Linux running 3.23.41 the following problem:
  
  $ /usr/local/mysql/bin/myisampack -v -v -f --tmpdir=/tmp 
 Sasha /data/mysql/Aactinomycetemcomitans/blimps.MYI
  Compressing /data/mysql/Aactinomycetemcomitans/blimps.MYD: (1443 records)
  - Calculating statistics
  
  normal:  7  empty-space:   0  empty-zero: 0  empty-fill:   7
  pre-space:   0  end-space: 3  intervall-fields:   0  zero: 1
  Original trees:  16  After join: 9
  - Compressing file
  Segmentation fault (core dumped)
 
 cut
 
 Thanks Martin for the test case;  It enabled me to quickly find the
 bug.
 
 Here is a patch for this (This will be in 3.23.42)
 
 = myisam/myisampack.c 1.9 vs edited =
 *** /tmp/myisampack.c-1.9-8558Wed Aug 22 01:45:03 2001
 --- edited/myisam/myisampack.cThu Aug 30 14:09:40 2001
 ***
 *** 251,257 
   
   static void print_version(void)
   {
 !   printf(%s  Ver 1.9 for %s on %s\n,my_progname,SYSTEM_TYPE,MACHINE_TYPE);
   }
   
   static void usage(void)
 --- 251,257 
   
   static void print_version(void)
   {
 !   printf(%s  Ver 1.10 for %s on %s\n,my_progname,SYSTEM_TYPE,MACHINE_TYPE);
   }
   
   static void usage(void)
 ***
 *** 1670,1676 
 max_calc_length+=huff_counts[i].tree-height;
   else if (huff_counts[i].field_type == FIELD_BLOB ||
huff_counts[i].field_type == FIELD_VARCHAR)
 !   max_calc_length=huff_counts[i].tree-height*huff_counts[i].max_length + 
huff_counts[i].length_bits +1;
   else
 max_calc_length+=
   (huff_counts[i].field_length - huff_counts[i].max_zero_fill)*
 --- 1670,1676 
 max_calc_length+=huff_counts[i].tree-height;
   else if (huff_counts[i].field_type == FIELD_BLOB ||
huff_counts[i].field_type == FIELD_VARCHAR)
 !   max_calc_length+=huff_counts[i].tree-height*huff_counts[i].max_length + 
huff_counts[i].length_bits +1;
   else
 max_calc_length+=
   (huff_counts[i].field_length - huff_counts[i].max_zero_fill)*
 
 Regards,
 Monty
 

-- 
Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / Institute for Bioinformatics http://mips.gsf.de
GSF - National Research Center for Environment and Health
Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany



Re: Enabling Logging of Slow Queries

2001-08-30 Thread Ken Menzel

Hi Ryan,
   Did you look in you hostname.err file for the error at the end of
the file?  Are you running the mysql daemon as root?  Could it be the
user you are running mysqld as does not have permission to write to
/root?  The .err file by default is in the directory with your other
logs (on my system /usr/local/var/picard.icarz.com.err ).  Either tail
or cat the file and look at the error on the end.
Best of luck
Ken
- Original Message -
From: Ryan Shrout [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 30, 2001 2:50 PM
Subject: Enabling Logging of Slow Queries


 I have tried to enable slow query logging for a couple days now,
with no
 success.

 I have tried adding the line to the my.cnf file as well as stoppign
the
 service then starting it with the command line version.  Both ways,
the
 server refuses to restart.  I have checked the syntax over and over
and I
 think I have it correct!

 [mysqld]
 log-slow-queries=/root/slow-queries.log

 and

 /etc/usr/bin/safe_mysqld --log-slow-queries=/root/slow-queries.log

 Either way, the server will not start.  I take the line out and it
works
 again.  What am I doing wrong?

 Ryan Shrout
 Owner - Amdmb.com
 http://www.amdmb.com/
 [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




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

2001-08-30 Thread Mustafa Hashmi

Thanks for the response Joshua,

That is an option - however not one I would be very comfortable with. I have
a similar setup for virtual hosts generally - wanted something more flexible
and powerful for a virtual server implementation without taxing the actual
server too much.

For example, the mail server (qmail) is not chrooted as such - however pop
is chrooted via tcpserver, delivering messages to users in a virtual env.
SMTP works the same way, chrooting to say /home/user/etc/tcp.cdb to check
relay.

Unfortunately, I know little about the actual how-does-it-work part of
MySQL and need some direction :)

I am going to try something in the next 3-4 days and hopefully I'll post a
positive outcome.

If this works, I'll write a HowTo :)

Thanks again for your response.

Mustafa.

 OS: debian-2.2.19

- Original Message -
From: Joshua J. Kugler [EMAIL PROTECTED]
To: Mustafa Hashmi [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, August 30, 2001 1:51 PM
Subject: Re: Virtualizing MySQL


 The short answer is that you can't, if you're using a named pipe
 (/tmp/mysql.sock, or some such).  That would require every user having
their
 own installation of MySQL, which may be what you want.

 Why not have the users connect via TCP/IP, and just set permissions
 correctly?  They would be able to list the other databases on the server,
but
 if permissions are set correctly, they will only be able to have access to
 their own databases.

 Hope that helps.

 j- k-

 On Thursday 30 August 2001 12:21, Mustafa Hashmi wrote:
  Gerhard,
 
  Thank you for your response.
 
  Emphasizing that I am new to this, could you describe in a bit more
detail
  how I could put this in the new root structure? (client's chrooted
  structure)
 
  If this is too extensive to properly explain, is there some
documentation
  available which might help?
 
  I appreciate your help.
 
  Regards,
  Mustafa.
 
  - Original Message -
  From: Gerald Clark [EMAIL PROTECTED]
  To: Mustafa Hashmi [EMAIL PROTECTED]
  Cc: [EMAIL PROTECTED]
  Sent: Thursday, August 30, 2001 1:03 PM
  Subject: Re: Virtualizing MySQL
 
   Two problems.
   The clients don't have access to the databases, the server does.
  
   Chrooted clients will not be able to read and write the named pipe
   unless it is in their new root structure.
  
   Mustafa Hashmi wrote:
Hi all,
   
I am in the process of creating a Virtual Server - and pretty much
all
aspects have been completed to my liking. This includes web / mail /
ftp
 
  and
 
ssh.
   
The next hurdle is virtualizing MySQL, and I would like to do this
by
sharing the same MySQL server across multiple chrooted clients. This
 
  way,
 
they can have unlimied databases / tables under their userID without
 
  looking
 
at, or disrupting, any of the other clients in their chroot.
   
I am also rather new to this, so please feel free to point me to a
URL
 
  which
 
may help. I've tried though - couldn't find anything relevant to my
 
  cause.
 
I appreciate your time.
   
Cheers,
Mustafa.
   
   
   
  
 -
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
  
   --
   Gerald L. Clark
   [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

 --
 Joshua Kugler, Information Services Director
 Associated Students of the University of Alaska Fairbanks
 [EMAIL PROTECTED], 907-474-7601



-
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: Enabling Logging of Slow Queries

2001-08-30 Thread s. keeling

On Thu, Aug 30, 2001 at 02:50:47PM -0400, Ryan Shrout wrote:
 I have tried to enable slow query logging for a couple days now, with no
 success.
 
 I have tried adding the line to the my.cnf file as well as stoppign the
 service then starting it with the command line version.  Both ways, the
 server refuses to restart.  I have checked the syntax over and over and I
 think I have it correct!
 
 [mysqld]
 log-slow-queries=/root/slow-queries.log

Is mysqld running owned by root?  No?  Then mysql will have no right to
write to /root.  Mine runs as mysql.


-- 
 Any technology distinguishable from magic is insufficiently advanced.
 [EMAIL PROTECTED] TopQuark Software  Serv. Contract programmer, server bum.


-
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 adding tables, databases, or records

2001-08-30 Thread s. keeling

On Thu, Aug 30, 2001 at 11:00:14AM -0600, Benjamin Krajmalnik wrote:
 OK.  I tracked the problem to being out of disk space in the var partition.
 The default source installation plaved the data in the /var/db directory.
 The var partition is not that large by default, and therefore I am now out
 of space.
 I would like to move the data to a /usr/local/mysql/data directory.
 What is the proper process to do this by?
 Is moving the data to that directory and changing the datadir location in
 safe_mysqld sufficient?

That might work; dunno.  Or you could:

   shell_ cd /var
   shell_ rmdir db
   shell_ ln -s /usr/local/mysql/data ./db

... I think.  Then you wouldn't have to fiddle with mysql defaults at
all.  Of course, get your data out of /var/db before you rmdir /var/db.


-- 
 Any technology distinguishable from magic is insufficiently advanced.
 [EMAIL PROTECTED] TopQuark Software  Serv. Contract programmer, server bum.


-
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: help renumbering unique

2001-08-30 Thread Gerald Clark

That seems like rather a bad idea to me.
Would that not leave anything else that references the sessions
looking at the wrong session?

Jaime Teng wrote:

 Hi,
 
 I have a mysql table:
 +---+--+--+-+
 | Field | Type | Null | Key |
 +---+--+--+-+
 | sessionid | int(10) unsigned |  | PRI |
 | username  | char(20) |  | MUL |
 | start | int(10) unsigned |  | MUL |
 | stop  | int(10) unsigned |  | MUL |
 | ipaddress | char(15) | YES  | |
 +---+--+--+-+
 
 sessionid is a unique key.
 
 Is there a way to change the values of sessionid such that
 the values will be numbered from 1 and increments by 1?
 
 ie, if the numbers were 1,20,22,25,40,45,47.
 the new data will be 1,2,3,4,5,6,7,8,9. ?
 
 
 Jaime
 
 
 
 -
 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


-- 
Gerald L. Clark
[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




bug in return value of jdbc call

2001-08-30 Thread Shell, Allyn M.

When using the Java call to executeUpdate() for an update statement, the return value 
should be the number of rows affected.

mysql is returning a value of 0 on a successful update when it should return 1.  The 
database is being updated properly, only the response is wrong.


-
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: any sequence generator function?

2001-08-30 Thread Gerald Clark

Add an auto_increment column of an appropriate int size.

Jaime Teng wrote:

 Hi,
 
 Is there a number sequence generator/function in
 MySQL such that if I were to execute:
 UPDATE mytable SET id = thisfunction;
 it will update the table mytable and set the column
 id to a numbered sequence 1,2,3,4,5,6,7,8,9.?
 
 currently, i have a table with 2.5 million records and
 i want to change one of the field and sequence it and
 am doing it the hard way of updating one at a time.
 
 regards
 Jaime
 
 -
 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


-- 
Gerald L. Clark
[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




straneg replication problem

2001-08-30 Thread Dave Berk

the master has the correct permission.  however the slave reports this
error.

Slave: Failed reading log event, reconnecting to retry, log
'mysql-bin.log' position 30
Slave: reconnected to master 'mysql@mydb203:3306',replication resumed in
log 'mysql-bin.log' at position 30
Slave: received 0 length packet from server, apparent master shutdown:
(0)

Searching the list it looks like others have run up against this.  There
does not seem to be an answer anywhere tho.

Thanks

David Berk


-
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: straneg replication problem

2001-08-30 Thread dwilkers

Hi,
Every time we have run into this one, is
because somthing updating, was out of sync.



Best Regards




On Thu, 30 Aug 2001, Dave Berk wrote:

 the master has the correct permission.  however the slave reports this
 error.
 
 Slave: Failed reading log event, reconnecting to retry, log
 'mysql-bin.log' position 30
 Slave: reconnected to master 'mysql@mydb203:3306',replication resumed in
 log 'mysql-bin.log' at position 30
 Slave: received 0 length packet from server, apparent master shutdown:
 (0)
 
 Searching the list it looks like others have run up against this.  There
 does not seem to be an answer anywhere tho.
 
 Thanks
 
 David Berk
 
 
 -
 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




Backing up a MySQL database on a remote server

2001-08-30 Thread Jeff Isom

I'm new to MySQL and I'm sure this has been covered, but I can't find it so
I'll ask here.  What is the best way to backup a MySQL database that is
hosted on a remote server.

Our web site is hosted by a hosting company and they configured MySQL.  I
want to backup the database periodically.  I've tried using PhPMyAdmin to
get data dumps, but the databases are quite large and the browser times out
before the file download begins.  How can I connect to the MySQL server from
my Win2000 machine and perform a dump to my hard drive?  Also, what is the
best way to reverse the process and restore the dump from my hard drive to
the remote server.

I apologize if this question is obvious.  I've looked in the documentation,
but haven't been able to figure it out.  Thanks in advance for the help.

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




[fwd] Re: Re: any sequence generator function? (from: mysql@lists.mysql.com)

2001-08-30 Thread Alexander Skwar

 database,sql,query,table

So sprach =BBJaime Teng=AB am 2001-08-31 um 03:53:47 +0800 :
 Is there a number sequence generator/function in

you can set the INT types to auto_increment, which will do just that
when you insert rows.

Alexander Skwar
-- 
How to quote:   http://learn.to/quote (german) http://quote.6x.to (english)
Homepage:   http://www.digitalprojects.com   |   http://www.iso-top.de
   iso-top.de - Die günstige Art an Linux Distributionen zu kommen
Uptime: 1 day 8 hours 30 minutes

-
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




question concerning the mysqld process

2001-08-30 Thread joe . balderrama



  Question,

 Could some one tell me why our mysqld daemon appears to be incrementing on time.
 For instance I get the following output when I use  ps -elf. the 470 you see below 
was 460
 30 secs ago. Is there a memory leak or  ?we are using  MySql 3.23.30

 What can I do to resolve this???   besides restart mysqld

Thanks, Joe Balderrama

 F S  UID   PID  PPID  C PRI NI ADDR SZWCHANSTIME TTY  TIME CMD
19 T root 0 0  0   0 SY 10414c50  0Aug 16 ?0:00 
sched
 8 S root 1 0  0  41 20 70111848 94 70111a70   Aug 16 ?0:14 
/etc/init -
 8 S root   287 1  0  84 20 70a3a728373 7019e83a   Aug 16 ?0:00 
/usr/lib/dmi/dmispd
 8 Omysql 22907 22897  1  81 20 70892e20   3190Aug 26 ?   470:02 
/usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/local_home/my
 8 S http 23257   305  0  41 20 7160e798   1168 706ae3ac   Aug 26 ?   15:38 
/local_home/apache/v1.3.20/bin/http
 8 S root 28988  1408  0  41 20 70c20a58178 70d5baa6   Aug 28 pts/10:00 
/bin/csh
 8 O root  3058  2673  0  51 20 7160eea0119  14:18:37 pts/70:00 ps 
-elf
 8 S http 24038   305  1  81 20 716103b8   1161 70d5bbae   Aug 27 ?   15:26 
/local_home/apache/v1.3.20/bin/http
 8 S http 23925   305  0  41 20 70c21160   1170 7055662c   Aug 27 ?   15:11 
/local_home/apache/v1.3.20/bin/http


-
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




Replication stalls

2001-08-30 Thread Jeff Adams

Greetings,

We're having some problems with our one way replication stalling. 
There are no errors in the errors logs, and the status reports seem to 
indicate things are still running, however, changes to the master are 
not being received by our slaves.

We're running a farm of 4 slave mysql machines (MySQL version 3.23.41) 
that talk to a single master (also version 3.23.41) machine. We're 
running two databases on the machines (I'll call them db1 and db2), but 
I only wish to replicate one of them (db2).

I've sync'd the databases, and turned on replication, and everything 
works great until we load data into _db1_ via the 'load data infile' 
command.

At that point, any further changes to db2 are not replicated to the 
slave machines.

Running 'show processlist' at that point, on any of the slaves, gives 
the following:

| 1294 | system user | none | NULL | Connect | 5233 | Reading master 
update | NULL


Running 'show slave status' gives:

| master | user | 3306 | 60 | p23-bin.004 | 380 | Yes | db2 | db1 
| 0 | | 0 |


Running 'show processlist' on the master reveals:

|  4 | repl | 10.1.1.108 | NULL | Binlog Dump | 2666 | Reading from net 
| NULL


Running 'show master status' on the master gives:

| p23-bin.004 | 11283 | db2 | db1 |


If I run 'mysqlbinlog -j 380 p23-bin.004 |head' on master I get:

# at 380
#010830 15:39:21 server id  1   Query   thread_id=32exec_time=0 
error_code=0
use db1;
SET TIMESTAMP=999203961;replace into time_last_updated (time,table_name) 
values ('2001-08-30 15:24:16','person_function');

If I issue 'slave stop' and 'slave start' on a slave, it syncs up to the 
master, and will continue replicating until db1 is updated. Restarting 
the master will also allow all of the slaves to sync up.

Here's the mysqld section of my.cnf from the master:

[mysqld]
#port= 3306
#socket  = /tmp/mysql.sock
skip-locking
set-variable= key_buffer=384M
set-variable= max_allowed_packet=16M
set-variable= table_cache=512
set-variable= sort_buffer=6M
set-variable= record_buffer=1M
set-variable= myisam_sort_buffer_size=128M
set-variable= thread_cache_size=4
set-variable= thread_concurrency=4  # Try number of CPU's*2
set-variable= tmp_table_size=4M
set-variable= net_read_timeout=300
set-variable= net_write_timeout=300

# Uncomment the following if you are using BDB tables
#set-variable   = bdb_cache_size=64M

# Point the following paths to different dedicated disks
#tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname
# Replication
log-bin
server-id=1
binlog-do-db=db2
binlog-ignore-db=db1


And from the slaves:

[mysqld]
#port= 3306
#socket  = /tmp/mysql.sock
skip-locking
set-variable= key_buffer=384M
set-variable= max_allowed_packet=16M
set-variable= table_cache=512
set-variable= sort_buffer=5M
set-variable= record_buffer=1M
set-variable= myisam_sort_buffer_size=128M
set-variable= thread_cache_size=4
set-variable= thread_concurrency=4  # Try number of CPU's*2
set-variable= tmp_table_size=3M
set-variable= net_read_timeout=300
set-variable= net_write_timeout=300
set-variable= max_connections=500
log-update

# Replication
master-host=master
master-user=user
master-password=password
master-port=3306
server-id=3
replicate-do-db=db2
replicate-ignore-db=db1
log-slave-updates
#log-bin


If anyone could shed some light on this is happening, and more 
importantly, how we can keep the replication going, or if you need any 
other information, please let me know.

Thanks,

Jeff Adams
Webmaster
Hoover's 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




remove? revoke?

2001-08-30 Thread franky


Can I remove the rigth  for one user to see one specific table in database?

for exemple:
user: bob
table: tab_secret
database: Customer_service

Bob can see any table in DB Customer_service except the table tab_secret.


--=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--
 François Boucher
   [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: M$ SQL Export to Mysql Help

2001-08-30 Thread Gerald Jensen

Curtis ...

Do you have the database/table created on the MySQL server? If so, you can
use MSAccess (need ODBC connections to both servers) to Link Tables and move
the data acros that way.

We did it that way until our programmers wrote a C++ app that replicates
server-to-server.

Gerald Jensen

- Original Message -
From: Curtis Spencer [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 30, 2001 2:54 PM
Subject: M$ SQL Export to Mysql Help


 I have a nicely sized database of about 40 records, which I have in
 MS SQL but I need to move it to my production server, which is Mysql.  I
 was going to do it this way:

 Export MS SQL database into a file and then use LOAD DATA INFILE

 But I was wondering if there were a way to export into SQL and then just
 use \. Database.sql to import it very quickly.  I am worried that the
 exporter will mess up the file because it is so large.


 -
 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: Installation on Solaris questions

2001-08-30 Thread Steve Edberg

At 12:30 PM -0700 8/30/01, Sujay Daniel wrote:
I'm a newbie to Unix and MySQL. I have a few
questions.

With 'uname -a' I got the following message

SunOS [EMAIL PROTECTED] 5.7 Generic_106541-06 sun4u sparc
SUNW,Ultra-1

Can i install mysql-3.23.41-sun-solaris2.8-sparc in
it.

Theres no installation instructions for Unix/Solaris
machines in the Documentation page.


Evidently you didn't see

http://www.mysql.com/doc/S/o/Solaris.html

I'd suspect using a 2.8 binary on a 2.7 system might cause problems, 
but it shouldn't hurt to test it...

There are also older binaries (including some for Solaris 2.7) at

ftp://ftp.mysql.com/MySQL-3.23/

Lastly, you could always compile it yourself from source...t'aint that hard!

-steve



I'd appreciate it
if someone can give me pointers on installing MySql on
a Sun Solaris machine

Thank you

( tables )


-- 
+ Open source questions? +
| Steve Edberg   University of California, Davis |
| [EMAIL PROTECTED]   Computer Consultant |
| http://aesric.ucdavis.edu/  http://pgfsun.ucdavis.edu/ |
+--- http://pgfsun.ucdavis.edu/open-source-tools.html ---+

-
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: Reply-to and this list

2001-08-30 Thread Leon D. McClatchey

On Thursday 30 August 2001 04:13 am, Carl Troein wrote:
 A quick question: How come the mailing list software
 doesn't add a reply-to header? Is this intentional to
 keep replies off the mysql list, and if so why?

Generally, I hit reply-All, and then just edit the To Line:-)

 I'll try to remember to reply to the list rather than
 directly to the people who ask the questions, as replying
 in private does little to stop the same questions from
 reappearing, and if there's something this list has too
 much of it's the same questions over and over... :-o

 //Círdan

-- 
cya l8r
Leon D. McClatchey
mailto:[EMAIL PROTECTED]
ICQ:#112341159

In 1880 the French captured Detroit but gave it back ... they couldn't
get parts.

-
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




duplicate delete query

2001-08-30 Thread Rory O'Connor

excuse me if this is too newbie...but I need to perform a duplicate
delete on my database using the e-mail address as the key.  I understnad
how to use COUNT and DISTINCT together...

select count(DISTINCT email) FROM table;  

but I can't seem to find any info on how to perform the actual deletion
of the duplicate records.  Any info is appreciated!

Thanks!



providing the finest in midget technology

-
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




  1   2   >