RE: NT 2000

[Chris Bolt]

Try

net start mysql

at a command prompt

> Hi Team, 
> 
> Pls help, I'm new to mysql. 
> 
> I got the latest ver installed on NT2000 workstation. Upon I 
> tried the activate the daemon, under c:\mysql\bin\mysqld, 
> it won't work. Any advise. 
> 
> Thanks & Regards
> KA


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

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: $sth->{mysql_insertid} not working in 3.23.38?

[Colin Faber]

heh, my ($id) = $dbh->selectrow_array("SELECT MAX(id) FROM tbl;");

xris wrote:
> 
> > Woops sorry about that last message.
> > Try using the following:
> > my $id = $sth->{insertid};
> > That is what I had to change it to, to get it working.. despite what the
> > documentation says.
> 
> Actually, I can't use that.  The script dies, it's not like it just warns me
> that it doesn't work, but it actually stops executing when it reaches that
> statement.
> 
> I just do something like:
> 
> $id = $sh->{mysql_insertid};
> $sh->finish;
> if ($id < 1) {
> $sh = $dbh->prepare('SELECT MAX(id) FROM myTable');
> ...
> ($id) = $sh->fetchrow;
> ...
> }
> 
> It just seems a little silly to have to do this.
> 
> -Chris
> 
> > GL.
> >
> > ryan
> >
> >>> My ISP recently updated one of their servers to 3.23.38, and all of a
> >> sudden
> >>> a BUNCH of my code stopped working.   I use a number of insert queries
> >> (new
> >>> items, new search caches, etc), where I insert a blank record, and then
> >> take
> >>> notes of its id (usually "int unsigned auto_increment primary key"), to
> > be
> >>> used in a subsequent UPDATE statement (or INSERT, to a related 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
> >
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> 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: $sth->{mysql_insertid} not working in 3.23.38?

[xris]

> Woops sorry about that last message.
> Try using the following:
> my $id = $sth->{insertid};
> That is what I had to change it to, to get it working.. despite what the
> documentation says.

Actually, I can't use that.  The script dies, it's not like it just warns me
that it doesn't work, but it actually stops executing when it reaches that
statement.

I just do something like:

$id = $sh->{mysql_insertid};
$sh->finish;
if ($id < 1) {
$sh = $dbh->prepare('SELECT MAX(id) FROM myTable');
...
($id) = $sh->fetchrow;
...
}

It just seems a little silly to have to do this.

-Chris

> GL.
> 
> ryan
> 
>>> My ISP recently updated one of their servers to 3.23.38, and all of a
>> sudden
>>> a BUNCH of my code stopped working.   I use a number of insert queries
>> (new
>>> items, new search caches, etc), where I insert a blank record, and then
>> take
>>> notes of its id (usually "int unsigned auto_increment primary key"), to
> be
>>> used in a subsequent UPDATE statement (or INSERT, to a related 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
> 


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

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: $sth->{mysql_insertid} not working in 3.23.38?

[ryc]

Woops sorry about that last message.

Try using the following:

my $id = $sth->{insertid};

That is what I had to change it to, to get it working.. despite what the
documentation says.

GL.

ryan

> > My ISP recently updated one of their servers to 3.23.38, and all of a
> sudden
> > a BUNCH of my code stopped working.   I use a number of insert queries
> (new
> > items, new search caches, etc), where I insert a blank record, and then
> take
> > notes of its id (usually "int unsigned auto_increment primary key"), to
be
> > used in a subsequent UPDATE statement (or INSERT, to a related 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: $sth->{mysql_insertid} not working in 3.23.38?

[ryc]

I had the same problem when upgrading... and I found that using


> My ISP recently updated one of their servers to 3.23.38, and all of a
sudden
> a BUNCH of my code stopped working.   I use a number of insert queries
(new
> items, new search caches, etc), where I insert a blank record, and then
take
> notes of its id (usually "int unsigned auto_increment primary key"), to be
> used in a subsequent UPDATE statement (or INSERT, to a related table).
>
> Most of my (Perl) code uses $sh->{insertid}, which errors out in 3.23 and
> tells me to replace it with $sh->{mysql_insertid}.  So I wrote my code to
> autodetect the version (since $sh->{mysql_insertid} doesn't work in 3.22,
> which is still installed on most of their servers, where most of our
clients
> are set up).  Anyway, it doesn't work.  All of the 3.22 sites still work
> great, but when I move the same code to 3.23 (with the minor change noted
> before), I get all kinds of errors because $sh->{mysql_insertid} seems to
> return a null value (or maybe a nullstring), which breaks INSERT
statements
> (and makes UPDATE statements stop working).
>
> Does anyone know anything about this?
>
> 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
>


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

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

[KA]

Hi Team, 

Pls help, I'm new to mysql. 

I got the latest ver installed on NT2000 workstation. Upon I tried the activate the 
daemon, under c:\mysql\bin\mysqld, 
it won't work. Any advise. 

Thanks & Regards
KA

$sth->{mysql_insertid} not working in 3.23.38?

[xris]

My ISP recently updated one of their servers to 3.23.38, and all of a sudden
a BUNCH of my code stopped working.   I use a number of insert queries (new
items, new search caches, etc), where I insert a blank record, and then take
notes of its id (usually "int unsigned auto_increment primary key"), to be
used in a subsequent UPDATE statement (or INSERT, to a related table).

Most of my (Perl) code uses $sh->{insertid}, which errors out in 3.23 and
tells me to replace it with $sh->{mysql_insertid}.  So I wrote my code to
autodetect the version (since $sh->{mysql_insertid} doesn't work in 3.22,
which is still installed on most of their servers, where most of our clients
are set up).  Anyway, it doesn't work.  All of the 3.22 sites still work
great, but when I move the same code to 3.23 (with the minor change noted
before), I get all kinds of errors because $sh->{mysql_insertid} seems to
return a null value (or maybe a nullstring), which breaks INSERT statements
(and makes UPDATE statements stop working).

Does anyone know anything about this?

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

Re: TCP/IP Sockets, UNIX Sockets

[trogers]

unrelated:
many times an error reported will say unable to connect me 
@localhost... what do i do to use a remote host? e.g., 
[EMAIL PROTECTED]

thank you.


At 11:27 PM +0200 6/22/01, Benjamin Pflugmann wrote:
>Hi.
>
>On Fri, Jun 22, 2001 at 09:04:14PM +0200, [EMAIL PROTECTED] wrote:
>>  How do you force mysql to use either TCP/IP Sockets or UNIX Sockets?
>>  And how do you know which one it uses?
>
>"localhost" uses UNIX sockets, "" uses TCP/IP sockets.
>
>You can indirectly determine what connection was used by running
>
>SELECT USER();
>
>and looking whether you are considered to come from "localhost" or
>from "".
>
>Bye,
>
> Benjamin.
>
>
>-
>Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
>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

Problem with zip archive of mysqlgui-win32-static-1.7.4-2

[D. & S. Sandmann]

Win running winzip on the mysqlgui download I am receiving errors. I have already 
tried downloading it two times and both times I get the following errors:

  Errors were detected -- see below for details
  Testing ...
  testing: mysqlgui-win32-static-1.7.4-2/ OK
  testing: mysqlgui-win32-static-1.7.4-2/mysqlgui.exe Error: invalid compressed data 
to inflate
  testing: mysqlgui-win32-static-1.7.4-2/MySQL.help OK
  testing: mysqlgui-win32-static-1.7.4-2/README OK
  testing: mysqlgui-win32-static-1.7.4-2/my.cnf OK
  testing: mysqlgui-win32-static-1.7.4-2/my.cnf.win OK
  testing: mysqlgui-win32-static-1.7.4-2/polygraph.txt OK
  testing: mysqlgui-win32-static-1.7.4-2/readme.version_1.1 OK
  testing: mysqlgui-win32-static-1.7.4-2/readme.version_1.1.1 OK
  testing: mysqlgui-win32-static-1.7.4-2/readme.version_1.3 OK
  testing: mysqlgui-win32-static-1.7.4-2/readme.version_1.4 OK
  testing: mysqlgui-win32-static-1.7.4-2/readme.version_1.6 OK
  testing: mysqlgui-win32-static-1.7.4-2/readme.version_1.7 OK
  testing: mysqlgui-win32-static-1.7.4-2/readme.version_1.7.2 OK
  testing: mysqlgui-win32-static-1.7.4-2/readme.version_1.7.4 OK
  testing: mysqlgui-win32-static-1.7.4-2/readme.version_win32_1.5 OK
  testing: mysqlgui-win32-static-1.7.4-2/readme.version_win32_1.6 OK
  testing: mysqlgui-win32-static-1.7.4-2/readme.version_win32_1.7 OK
  testing: mysqlgui-win32-static-1.7.4-2/readme.version_win32_1.7.4 OK
  At least one error was detected in G:/Download/My 
Sql/mysqlgui-win32-static-1.7.4-2.zip.

Could you please verify on your end that the file is not corrupt. I am trying to 
download it at 37kbps

Thanks,
David

Interupting client-server-link during longlasting queries

[Hannes Niedner]

Hi Folks,

I just started a create table ... select from ...left-join query from my
laptop. It seems to take a while?
What happens if disconnect my client from the mysql daemon running on
another machine. Will the interupted mysqld-client crosstalk abrupt the
query, or will it continue to run on the server and die when it needs to
report back to the client, or will it even finish the job without the client
listening (the one that started the job in the first place).
This also raises the question for some kind of progress status bar etc.. All
I can do now is to monitor the processlist with mysqladmin which doesn' give
me any clue how long I still have to wait.

Comments appreciated

Hannes


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

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

myisam issues on indexing

[Robin Senior]

Hi,
While trying to index a 77million row table (I know, I'll shut up), I
started to fiddle with the mysql variables to get it done in under 3
weeks. Finally, I happened upon the myisam_max_sort_file_size and
myisam_max_extra_sort_file_size variables.
Messing with these allowed the indexing to go through the 'copy to temp
file' stage a lot quicker (5GB in 10 minutes), and start to proceed with
the 'repair by sorting' phase.

But ah, here's the rub:
mysql starts making temp files; first a 18.9GB file, then it starts on
another before it eats the remaining 5GB of space and gives me an error
28 (one of my favourite errors).

How can I adjust the variables to do the copying quickly, yet not fill my
drive with temp files?
One of the problems is that the two variables I mentioned supposedly
report their values in MB. If I use
set-variable=myisam_max_sort_file_size=1M, it reports that
myisam_max_sort_file_size is 1895825408,
but if I use set-variable=myisam_max_sort_file_size=1 (no 'M'), it
reports that myisam_max_sort_file_size is 1.
What's up with that? Why is it being so silly?

Anyways, could someone please help me set these bloody variables?
I'm on a athlon 1.33Ghz w/512MB RAM, 24GB HD space available.
The table is 5GB, and if the aforementioned variables are too small, it
takes eons to copy the table (and indexes on the fly for some reason),
then does a painfully slow repair by keycache (next to no processor
utilization).

my.ini looks like this:
set-variable=key_buffer=128M
set-variable=table_cache=16
set-variable=sort_buffer=64M
set-variable=record_buffer=64M
set-variable=join_buffer=16M
set-variable=tmp_table_size=16M
set-variable=myisam_sort_buffer_size=128M
set-variable=myisam_max_sort_file_size=1M <-kinda sure
set-variable=myisam_max_extra_sort_file_size=5000M <- guessing very wrong

Thank you in advance,
-robin (losing his sanity quickly)


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

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: Transaction Support in MySQL

[Trond Eivind Glomsrød]

"Alberni-dot-Net Tech Mailing Lists" <[EMAIL PROTECTED]> writes:

> What sort of support for transactions and table/record locking is
> there in MySQL right now?  I had heard that only table locking was
> supported, and limited support for transactions.

It varies, depending on table type - look at
http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.htm 
for more information. 

-- 
Trond Eivind Glomsrød
Red Hat, Inc.

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

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: MS Access not sending the username to MySQL

[Howard Lowndes]

I get two info boxes.

The first says "ODBC-call failed"

The second says "[TCX][MyODBC]Access denied for
user: '@dhcp85.lannet.com.au' to database 'Treasury' (#1044)"

In the TDX mysql Driver default configuration dialog box from Control
Panel->ODBC Data Source (32bit) the user name is set as LANNet, and that
user name is valid for connection to that database from a remote host as I
have tested it with the mysql command line.

I do not use a password.

I don't follow what you mean by "...so, when I connect from within the
database, I supply a username and password."  How?

-- 
Howard.  LANNet Computing Associates 
_
"We needn't, as socialists, get too concerned about privacy;
it's a bourgeois right, closely allied to the right to private property".
- Former Federal Health Minister Neal Blewett,
addressing the Fabian Society in 1988 in relation to the Australia Card issue.

On Wed, 20 Jun 2001, Joshua J. Kugler wrote:

> You say it's not sending the user name.  What connect string are you using?  
> Does it include the user name?  Can you post the exact connect string you are 
> using when you connect to the database?
> 
> As I have it set up on my windows side of things: the DSN in the ODBC setup 
> has no username or password, so, when I connect from within the database, I 
> supply a username and password.  How is your configuration set up?
> 
> j- k-
> 
> On Wednesday 20 June 2001 00:01, Howard Lowndes wrote:
> > I have a situation where the error I am getting in MS Access indicates
> > that the user name that I have set up in the OBC driver is not being sent
> > to MySQL.
> >
> > The irony is that when I set the ODBC driver up initially, it worked, but
> > then after closing MSA and restarting it the damned thing failed to work.
> >
> > I have tried reinstalling the ODBC driver, but without success.
> >
> > I have an option in MySQL to allow access frpm any host without a user
> > name so I am thoroughly confused.
> >
> > The version of MyODBC is the latest.
> >
> > Any ideas?
> 
> 


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

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: Transaction Support in MySQL

[MikeBlezien]

On Fri, 22 Jun 2001 15:17:18 -0700, "Alberni-dot-Net Tech Mailing Lists"
<[EMAIL PROTECTED]>   wrote:

>>What sort of support for transactions and table/record locking is there in MySQL 
>right now?  I had heard that only table locking was supported, and limited support 
>for transactions.

we've had good success with MySQL w/Innobase for transaction usage. Mainly for
development testing but so far so good,..we're happy with it. We use Perl w/DBI
1.18 and DBD::mysql


Mike(mickalo)Blezien

Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225) 686-2002
=
















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

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: KEY and index

[botanicus]

Quoting Cal Evans <[EMAIL PROTECTED]>:
> Regular keys are just indexes, not necessarily unique, not necessarily on
> fields that don't accept nulls. Their primary function is to speed up data
> retrieval.  Use them sparingly as they can have a negative impact on
> inserting and updating records.

I understand that indexes work so fast because they are usually smaller than the 
original table, since they contain on average just 1 column, or at least less 
information than the complete table. But how about a table with just 2 columns. 
Would an index based on the same 2 columns speed up processing, more specific, 
would it speed up a SELECT WHERE (the WHERE clause being related to the index 
algoritm)

Thanks, Marco

> - Original Message -
> From: "Marco Bleeker" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, June 22, 2001 9:36 AM
> Subject: KEY and index
> 
> 
> > Hello, I am learning MySQL and have a question. I know about the
> importance
> > of the PRIMARY KEY statement, but I also see a KEY statement being used
> > when creating a table. Is this just short for PRIMARY KEY, or what's the
> > difference?
> >
> > Second question, when I have a large table, but with only 2 small cells
> per
> > row (2 columns), is it useful to create a PRIMARY KEY, KEY, or INDEX for
> > speed (there is no set relation to another table).
> >
> > Third question, when exactly does MySQL use indexes. Is it used when the
> > indexed column is part of a (SELECT *) WHERE statement, together with a
> > non-indexed column? I just want to check if matching a row is present or
> > not, not actually retrieve information ("WHERE ip='$ip' and
> date>curdate()")
> >
> > Thanks, Marco
> > |
> > | Marco Bleeker, Amsterdam
> > | [EMAIL PROTECTED]
> > | http://www.euronet.nl/users/mbleeker/
> > |
> > | Attachments only after prior notice please.
> > | Don't put me on any kind of mailing list.
> > |
> > | I am now receiving the Snowhite virus 4x a day
> > | - some of you must be infected, please check !
> > | (No, you did not get it from me, I use Eudora)
> > | __@
> > |   _`\<,_
> > |__(*)/ (*)Ah, op DIE fiets !


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

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

Re: MySQL 'locking up'

[Daniel Åkerud]

It's sad that your MySQL crashes. But still, it's even more sad that there
exist human beings that rely on system administrators not being able to kill
a process under linux ;) (don't take that too hard, just kidding)

ps aux | grep mysqld

get the PID of the process

kill -9 PID

Make sure you have the rights to do it.

Daniel Åkerud

> Occasionally, MySQL seems to lock up on the Linux box and just sit there.
It
> did it today for three hours before we realized it.  When this happens,
the
> only thing we know of to do is restart it, and this time it wouldn't shut
> down so we had to reboot the Linux box. Does anyone have any idea what
> causes this and what we can do to keep it from happening in the future?
It's
> not a good thing when our customers who use MySQL databases suddenly can't
> access them.
>
> Thanks,
> Dawn H
>
> http://www.rdcss.com/ - R&D Computer Solutions
> http://wow.cooncheese.com/ - WOW.CoonCheese.com
> http://dpenguin.rdcss.com/ - Cornucopia
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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: Revoke ALL PRIVILEGES not working as expected?

[Paul DuBois]

At 1:39 PM -0800 6/22/01, Joshua J. Kugler wrote:
>I have read the manual about GRANT/REVOKE syntax.  I have set up several
>queries that worked to grant privileges, but then I sent this query to the
>MySQL server:
>
>REVOKE ALL PRIVILEGES ON *.* FROM 'testuser'@'xxx.xxx.xxx.xxx'
>
>testruser is a user that has an entry in the user table, as well as several
>entries in the tables_priv table.  (Yes, the IP addresses match)  After this
>query is run, the entry is still in the user table, and all the entries are

REVOKE doesn't remove the record from the user table, just any global
privileges the user might have.  You have to DELETE the record manually.
Not sure why you're still ending up with tables_priv records.

>still in the tables_priv table.  Am I missing something, or is this not
>working as expected?
>
>MySQL 3.23.38
>
>Thanks!
>
>j- k-
>
>--
>Joshua Kugler, Information Services Director
>Associated Students of the University of Alaska Fairbanks
>[EMAIL PROTECTED], 907-474-7601


-- 
Paul DuBois, [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: MySQL and replication?

[Daniel Åkerud]

*deep breath* - database,sql,query,table!!! *sigh*

> Have look in the fine manual for more details.

ooops... thanks :)

> Bye,
>
> Benjamin.
>

Daniel Åkerud




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

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

Transaction Support in MySQL

[Alberni-dot-Net Tech Mailing Lists]

What sort of support for transactions and table/record locking is there in MySQL right 
now?  I had heard that only table locking was supported, and limited support for 
transactions.

Aaron



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

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 'locking up'

[Dawn H]

Occasionally, MySQL seems to lock up on the Linux box and just sit there. It
did it today for three hours before we realized it.  When this happens, the
only thing we know of to do is restart it, and this time it wouldn't shut
down so we had to reboot the Linux box. Does anyone have any idea what
causes this and what we can do to keep it from happening in the future? It's
not a good thing when our customers who use MySQL databases suddenly can't
access them.

Thanks,
Dawn H

http://www.rdcss.com/ - R&D Computer Solutions
http://wow.cooncheese.com/ - WOW.CoonCheese.com
http://dpenguin.rdcss.com/ - Cornucopia


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

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

Revoke ALL PRIVILEGES not working as expected?

[Joshua J. Kugler]

I have read the manual about GRANT/REVOKE syntax.  I have set up several 
queries that worked to grant privileges, but then I sent this query to the 
MySQL server:

REVOKE ALL PRIVILEGES ON *.* FROM 'testuser'@'xxx.xxx.xxx.xxx'

testruser is a user that has an entry in the user table, as well as several 
entries in the tables_priv table.  (Yes, the IP addresses match)  After this 
query is run, the entry is still in the user table, and all the entries are 
still in the tables_priv table.  Am I missing something, or is this not 
working as expected?

MySQL 3.23.38

Thanks!

j- k-

-- 
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: MySQL and replication?

[Benjamin Pflugmann]

Hi.

On Fri, Jun 22, 2001 at 09:48:50PM +0200, [EMAIL PROTECTED] wrote:
> Anyone has any experience with mySQL in combination with data
> replication? Are there products available out there that allows
> this?

MySQL has built-in support for replication to another MySQL
server. Have look in the fine manual for more details.

If your question was something else, please elaborate.

Bye,

Benjamin.



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

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: TCP/IP Sockets, UNIX Sockets

[Benjamin Pflugmann]

Hi.

On Fri, Jun 22, 2001 at 09:04:14PM +0200, [EMAIL PROTECTED] wrote:
> How do you force mysql to use either TCP/IP Sockets or UNIX Sockets?
> And how do you know which one it uses?

"localhost" uses UNIX sockets, "" uses TCP/IP sockets.

You can indirectly determine what connection was used by running

SELECT USER();

and looking whether you are considered to come from "localhost" or
from "".

Bye,

Benjamin.


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

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

SQL query problem

[Thomas J Keller]

  I am using two versions of MySQL, on two different platforms, and having the
same problem on both.  One very odd aspect of this problem is that it behaves
precisely the same way on both platforms, down to which records are garbled
onscreen and how they are garbled.  Anyone with any ideas?   Thanks in advance

Platforms:

RedHat Linux 6.1   MySQL Ver. 3.23.28gamma  (locally compiled)
FreeBSD 3.4-STABLE MySQL Ver. 3.22.32

Problem:  when I use the following query, I get garbled data in the MySQL
command line client:

select zip, city, county from zipcodes where zip between 68400 and 68500;

here is a portion of the garbled output:

 |68442 | STELLA   | RICHARDSON
|43 | STERLING | JOHNSON
   |444 | STRANG   | FILLMORE
 |5 | SWANTON  | SALINE
   || SYRACUSE | OTOE
 |7 | TABLE ROCK   | PAWNEE
   || TALMAGE  | OTOE
|50 | TECUMSEH | JOHNSON
   || ONG  | CLAY
 |3 | TOBIAS   | SALINE
   || UNADILLA | OTOE
   || UNION| CASS
 |6 | UTICA| SEWARD
 |68457 | VERDON   | RICHARDSON
   || VIRGINIA | GAGE
   || WACO | YORK
  |8461 | WALTON   | LANCASTER
  |8462 | WAVERLY  | LANCASTER
   || WEEPING WATER| CASS
 |4 | WESTERN  | SALINE
 |5 | WILBER   | SALINE
   || WYMORE   | GAGE
   || YORK | YORK
+---+--+-+

BUT, if I use:  select zip, city, county from zipcodes where zip = 68465;I get:

 |68465 | WILBER | SALINE 

  This holds for any specific zipcode in the database.  There is one range,
68500 through 58600 which
display correctly.  Oddly enough, that is the range for the city I am in.

   The zipcodes database looks like this:

mysql> desc zipcodes;
+---++--+-+-+---+-+
| Field | Type   | Null | Key | Default | Extra |
Privileges  |
+---++--+-+-+---+-+
| zip   | int(11)|  | PRI | 0   |   |
select,insert,update,references |
| latitude  | float(7,4) | YES  | | NULL|   |
select,insert,update,references |
| longitude | float(8,4) | YES  | | NULL|   |
select,insert,update,references |
| city  | text   | YES  | | NULL|   |
select,insert,update,references |
| state | text   | YES  | | NULL|   |
select,insert,update,references |
| county| text   | YES  | | NULL|   |
select,insert,update,references |
+---++--+-+-+---+-+
6 rows in set (0.00 sec)

  This is a commercial database product named ZipPLUS.

   I also tried this:

mysql> check table zipcodes;
++---+--+--+
| Table  | Op| Msg_type | Msg_text |
++---+--+--+
| build.zipcodes | check | status   | OK   |
++---+--+--+
1 row in set (0.91 sec)


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

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: TCP/IP Sockets, UNIX Sockets

[Paul DuBois]

At 9:04 PM +0200 6/22/01, Daniel Åkerud wrote:
>How do you force mysql to use either TCP/IP Sockets or UNIX Sockets?
>And how do you know which one it uses?
>
>It is for a performance analysis.
>
>Thanks!
>
>Daniel Åkerud

If you connect to "localhost", MySQL will use a UNIX socket if possible.
If you connect to "127.0.0.1", MySQL will use a TCP/IP connection.

If you connect to a remote host, TCP/IP is always used.

--
Paul DuBois, [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: my sql query retrieval(Urgent)

[Benjamin Pflugmann]

Hi.

On Fri, Jun 22, 2001 at 05:31:32PM +0100, [EMAIL PROTECTED] wrote:
> Hi,
> Is there a way to retrieve the field values in the
> same order as during insertions based on something
> like rowid or so??

No. Insertion order is not kept anywhere. Use an AUTO_INCREMENT column
to obtain an key to ORDER BY.

If the stuff is already inserted, you are out of luck.

Bye,

Benjamin.


PS: Just passing the MySQL-Mailinglistfilter

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

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

How do I load data into a table that has fewer fields than input data.

[James E. Hicks III]

Ok, so maybe I'm just lazy, but I was wondering
if there was any way to load data into a table
from a CSV file that has more fields per line
than the table that I want to load it into.
Can this be achieved using mysqlimport or the
LOAD DATA command?

Example;

INPUT.CSV
field1,field2,field3,field4,field5,field6,field7,field8,field9,field10

DATABASE TABLE
field2,field3,field4,field5,field6,field7,field10


James E Hicks III
Noland Company
2700 Warwick Blvd
Newport News, VA 23607
757-928-9000 ext 435
[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: ~/.mysql_history

[Paul DuBois]

At 10:00 PM -0800 2/10/01, Thomas DeMartini wrote:
>I've been looking for a way to disable logging to mysql_history on a 
>global basis.  Does anyone know of a way to do this?  If so, please 
>e-mail me at this address (I don't check the list).  If not, can 
>someone tell me how to submit a feature request?
>
>My current work-around is to create the file ~/.mysql_history with 
>no permissions so that MySQL can't write it if it wanted to. 
>Fortunately MySQL doesn't complain about that and lets me go.

You could also make it a link to /dev/null.

>
>I'm looking for something like a command line option:
>   mysql --history=no
>and/or the related functionality in the /etc/my.cnf file.
>
>The problem I have is that a lot of my users type passwords into 
>their MySQL queries to insert them into the tables and then other 
>users without MySQL access come along and look at the first user's 
>.mysql_history file (which is created 644 by default) to look at the 
>passwords.  Then they go to the web

Perhaps each user's home directory should be set to 700 to keep out other
users.  Is that a possibility?

Another possibility: set each user's umask to 022.  Then the .mysql_history
file will be created mode 600, not 644.

>site that the first user setup and pretend to be the other people 
>who's passwords were in the history file.  I'd like to be able to 
>setup my site so that by default it doesn't write a history file 
>unless the user specifies mysql --history=yes or the equivalent.
>
>Thanks,
>Thomas.
>Please send replies to [EMAIL PROTECTED], I don't check the list.


-- 
Paul DuBois, [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: "configure" question

[Trond Eivind Glomsrød]

William Clifford <[EMAIL PROTECTED]> writes:

> Hi all. I recently downloaded the source distribution of MySQL version 3.23.39
> and am trying to compile it so that it installs it's files in the same manner
> as the binary RPM version does.

Just download the lastest SRPM from rawhide, and rebuild it.


-- 
Trond Eivind Glomsrød
Red Hat, Inc.

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

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

Re: MySql:delete

[Benjamin Pflugmann]

Hi.

In a relational database you may _not_ rely on internal order. It is
completely up to the RDBMS how it handles insertions. The internal
order is "undefined" by definition according to the SQL standard.
Therefore you should have no interest at all on where insert go to.

Use SELECT ... ORDER BY to retrieve rows in a certain order.

Bye,

Benjamin.


On Fri, Jun 22, 2001 at 04:14:07PM +, [EMAIL PROTECTED] wrote:
> Hi all,
> 
> When I perform a delete command and then I insert a new row, this new
> row is placed in the row just deleted. Is it possible to place newly
> inserted rows always at the end of the 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

MySQL and replication?

[Daniel Åkerud]

Anyone has any experience with mySQL in combination with data replication? Are there 
products available out there that allows this?

Thanks

Daniel Åkerud

TCP/IP Sockets, UNIX Sockets

[Daniel Åkerud]

How do you force mysql to use either TCP/IP Sockets or UNIX Sockets?
And how do you know which one it uses?

It is for a performance analysis.

Thanks!

Daniel Åkerud

RE: MySql:delete

[Don Read]

On 22-Jun-01 Martin Quevedo wrote:
> Hi all,
> 
> When I perform a delete command and then I insert a new row, this new
> row is placed in the row just deleted. Is it possible to place newly
> inserted rows always at the end of the table???
> 

There is no 'end' (or 'begin' for that matter) to a table.
If you need a specific order to the data, you have to impose it yourself.

 AUTO_INCREMENT might be a good place to start.

Regards,
-- 
Don Read   [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.

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

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

"configure" question

[William Clifford]

Hi all. I recently downloaded the source distribution of MySQL version 3.23.39
and am trying to compile it so that it installs it's files in the same manner
as the binary RPM version does. Does anyone have an idea what the prefix
directory and datadir directories are supposed to be set to? I'm running on Red
Hat 7.0 and I want to compile from the source to try and get a MySQL optimized
for my PC. The binary RPM installs the executables into /usr/bin and /usr/sbin,
its libraries into /usr/lib, and its databases into /var/lib/mysql. According
to the INSTALL-SOURCE file that comes with the source dist., you're supposed to
be able to set the various locations for the files, but I can't seem to figure
out how to set the database files location. I want to keep them in
/var/lib/mysql, as I have that mounted on a large partition specifically
designated for my database, and I really don't want to have to reinstall my
system, just to relocate that partition onto /usr/var or whatever the default
option happens to be.

Thanks in advance,
--Bill

-- 
William M. Clifford
Lorien Technologies, Inc.
[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: my sql query retrieval(Urgent)

[Don Read]

On 22-Jun-01 VVM Ravikumar Sarma Chengalvala wrote:
> Hi,
> Is there a way to retrieve the field values in the
> same order as during insertions based on something
> like rowid or so??
> Eg:
> Insertion order into a table for a text field:
> bbb
> 
> abaa
> aa
> 
> Retrieval order:
> I want to have the retrieval order also the same.The
> output of the query on that field should give :
> bbb
> 
> abaa
> aa
> 
> 
> Any  ideas??

AUTO_INCREMENT, TIMESTAMP ?

Regards,
-- 
Don Read   [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.

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

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: Question about weird filenames...

[Don Read]

On 22-Jun-01 Webmaster wrote:
> I have weis in my mysql data directory, and I was hoping someone could tell
> me what they were...
> 
> I understand that most tables will have 3 files associated with them (in my
> mysql setup anyway): .ISM, .ISD and .frm
> files.
> 
> However, I have files like this in my directory: B-431a.ISM, B-431a.ISD,
> B-431a.frm..
> 
> The problem is : I have no tables named "B-431a" in my schema.
> 
> Anyone have an idea of what those files are ?
> 
> 

These are temporary filenames created during a check/repair of tables,
& should have been deleted automagically, (you might also see some SQL
tables leftover ...)

Move them to some temporary directory, and if the system is ok after a few
day, rm 'em. 

Regards,
-- 
Don Read   [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.

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

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: ACCESS DB, and MySQL which one better to handle database driv en webpage

[Tyrone Mills]

Sounds like you could be a reference site for Microsoft!! Only 2 corruptions
using Access multi-user. That's incredibly good. I've supported systems with
only 3 concurrent users who suffered corruption on a nearly daily basis.

- Original Message -
From: "John Meyer" <[EMAIL PROTECTED]>
To: "MySQL (E-mail)" <[EMAIL PROTECTED]>
Sent: Friday, June 22, 2001 10:16 AM
Subject: Re: ACCESS DB, and MySQL which one better to handle database driv
en webpage


> It only corrupted your database twice?
>
> On Friday 22 June 2001 09:50, Patrick Calkins wrote:
>
> > MySQL can handle infinately more concurent connections to it, and handle
a
> > much bigger load than MDB can even dream of doing. A few years back I
used
> > to write database apps in visual basic and MDB. It was running on the
> > network, with only about 5 people accessing it at one time. MDB had
> > corrupted the files at least twice.
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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: Newbie: whos logged in..?

[Don Read]

On 22-Jun-01 Colm McCartan wrote:
> Hello all,
> 
> apologies if this has been posted before but I can't find it in the FAQ,
> docs or 
> anywhere...
> 
> Subject says it all: before closing down for a backup or whatever, how do I
> find 
> out who is logged into the server (as opposed to just getting connections 
> information)?

Not sure what you mean by that, but ...

 from the shell:
$ mysqladmin proc

 in the client:
mysql> show processlist;

spam cookies: database,sql,query,table

Regards,
-- 
Don Read   [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.

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

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 for the " ' " Syantax

[Daniel Åkerud]

Try
mysql_query("INSERT into mybtd(co_pe) values('Johsua''s Brother')");
or
mysql_query("INSERT into mybtd(co_pe) values('Johsua\\'s Brother')");

Daniel Åkerud

- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 22, 2001 7:15 PM
Subject: Error for the " ' " Syantax


> Dear sir;
>  I have find a big error from MySQL. I have one fields like that;
> co_na(Fields) = Johsua's Brother;
> mybtd is the data name, co_na is the fields;
> I cannot insert the data by using the php commands;
> mysql_query("INSERT into mybtd(co_pe) values('Johsua's Brother')"); canot
> be functioned. and also mysql_query("INSERT into mybtd(co_pe)
> values("Johsua's Brother")");
>
> but this command can be run on terminal use the command below:-
> INSERT into mybtd(co_pe) values("Johsua's Brother"); can be run...But
> INSERT into mybtd(co_pe) values('Johsua's Brother'); cannot run...
>
> can you give me some help..
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


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

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: Batch UPDATE with C API

[Don Read]

On 22-Jun-01 Jean-Philippe Cote wrote:
> 
> 
> Hello,
> 
> Suppose I want to update n rows (where n is a possibly large number)
> using the mySQL C API. I can create n separate UPDATE
> statements and send each of them to the server with mysql_[real_]query(),
> but that doesn't seem particularly efficient to me. Is there a better
> way to do it ? Can I create a single string containing all UPDATE
> statements (comma/semi-colon separated ???) and send this string 
> only once ?

If the action is the same for the records you can do:
UPDATE foo set bar='blah' WHERE id in (1,55,96,437 ...)

(See yesterday's thread: 
  mailto: <[EMAIL PROTECTED]>
  On size limitations & work-arounds. )


If action is different for each of the id's then you're stuck with
one statement per record.

For really huge (n) you might want to consider a tmp table:

CREATE TABLE tmp_tbl ( ...);

INSERT INTO tmp_tbl (field names)
  SELECT (unchanged), (changed) FROM original, updates
  WHERE original.id=updates.id;

REPLACE INTO original
  SELECT * from tmp_tbl;

DROP TABLE tmp_tbl,updates;

Regards,
-- 
Don Read   [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.

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

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 for the " ' " Syantax

[Colin Faber]

You need to escape your strings.

> INSERT into mybtd(co_pe) values('Johsua\'s Brother'); cannot run...

[EMAIL PROTECTED] wrote:
> 
> Dear sir;
>  I have find a big error from MySQL. I have one fields like that;
> co_na(Fields) = Johsua's Brother;
> mybtd is the data name, co_na is the fields;
> I cannot insert the data by using the php commands;
> mysql_query("INSERT into mybtd(co_pe) values('Johsua's Brother')"); canot
> be functioned. and also mysql_query("INSERT into mybtd(co_pe)
> values("Johsua's Brother")");
> 
> but this command can be run on terminal use the command below:-
> INSERT into mybtd(co_pe) values("Johsua's Brother"); can be run...But
> INSERT into mybtd(co_pe) values('Johsua's Brother'); cannot run...
> 
> can you give me some help..
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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

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: KEY and index

[Daniel Åkerud]

The manual also states that INDEX is a synonym for KEY, which means that
they have identical funcationality.

Daniel Åkerud

- Original Message -
From: "Cal Evans" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Marco Bleeker" <[EMAIL PROTECTED]>
Sent: Friday, June 22, 2001 6:27 PM
Subject: Re: KEY and index


> KEY is used to build other indexes.  It's not short for Primary Key.
There
> are PRIMARY KEY indexes, candidate key indexes (these COULD be a primary
key
> but for one reason or another , are not) and just regular indexes.
>
> All tables should have a primary key. (I'm partial to adding an
> auto_increment field to almost every table of the name ID and
> making this my primary key) Some tables will also have a candidate key.
This
> is especially true if you manufacture a PK like I do. Then there may be a
> piece of data that is unique to each record and never null that would
> normally serve as a primary key. (The reason I manufacture PKs is because
if
> a piece of data means something then it is always possible that it will
> change.This means that you would have to trace down all your FK
> relationships and change the data in those tables as well.SSN, phone
number,
> email address are all examples of candidate keys but also smart keys. I
> never use them as PKs. )
>
> Regular keys are just indexes, not necessarily unique, not necessarily on
> fields that don't accept nulls. Their primary function is to speed up data
> retrieval.  Use them sparingly as they can have a negative impact on
> inserting and updating records.
>
> HTH,
> Cal
> *
> * Cal Evans
> * Senior Internet Dreamer
> * http://www.calevans.com
> *
> - Original Message -
> From: "Marco Bleeker" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, June 22, 2001 9:36 AM
> Subject: KEY and index
>
>
> > Hello, I am learning MySQL and have a question. I know about the
> importance
> > of the PRIMARY KEY statement, but I also see a KEY statement being used
> > when creating a table. Is this just short for PRIMARY KEY, or what's the
> > difference?
> >
> > Second question, when I have a large table, but with only 2 small cells
> per
> > row (2 columns), is it useful to create a PRIMARY KEY, KEY, or INDEX for
> > speed (there is no set relation to another table).
> >
> > Third question, when exactly does MySQL use indexes. Is it used when the
> > indexed column is part of a (SELECT *) WHERE statement, together with a
> > non-indexed column? I just want to check if matching a row is present or
> > not, not actually retrieve information ("WHERE ip='$ip' and
> date>curdate()")
> >
> > Thanks, Marco
> > |
> > | Marco Bleeker, Amsterdam
> > | [EMAIL PROTECTED]
> > | http://www.euronet.nl/users/mbleeker/
> > |
> > | Attachments only after prior notice please.
> > | Don't put me on any kind of mailing list.
> > |
> > | I am now receiving the Snowhite virus 4x a day
> > | - some of you must be infected, please check !
> > | (No, you did not get it from me, I use Eudora)
> > | __@
> > |   _`\<,_
> > |__(*)/ (*)Ah, op DIE fiets !
> >
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


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

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

RE: PHP / get_lock() / release_lock()

[Don Read]

On 22-Jun-01 Carsten H. Pedersen wrote:
> Has anyone successfully passed the get_lock() 
> and release_lock() commands to a MySQL 
> server using PHP? If so, how did you go about it?

Yes;

mysql_query("SELECT GET_LOCK('signups',20)");
fillsignups();
mailsignups();
mysql_query( "SELECT RELEASE_LOCK('signups')");

> 
> PHP does not seem to implement these functions
> despite the fact that they have been around since
> sometime in March/April 1998.

It's a SQL statement, application language has nothing to do with it..

Regards,
-- 
Don Read   [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.

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

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

[MikeBlezien]

On Fri, 22 Jun 2001 11:28:19 -0500, "Cal Evans" <[EMAIL PROTECTED]>   wrote:


If your using Perl w/DBI, you may want to check out the use of place holders and
bind_columns. Create your create your insert statement outside the loop, then do
the execute() within the loop using placeholders or bind_columns. I just did
something very similar this morning, we did about 5500 inserts/updates in less
then 2secs!


>>It is my understanding that the first syntax is faster in mysql.
>>
>>Cal
>>*
>>* Cal Evans
>>* Senior Internet Dreamer
>>* http://www.calevans.com
>>*
>>- Original Message -
>>From: "Dvoøáèek Michal" <[EMAIL PROTECTED]>
>>To: <[EMAIL PROTECTED]>
>>Sent: Friday, June 22, 2001 11:48 AM
>>Subject: insert
>>
>>
>>> Hi,
>>>
>>> is better to create insert query for better performance this way:
>>> INSERT INTO table VALUES(val1, val2, val3), (val4, val5, val6), (...);
>>> or in this way:
>>> for (i = 0; i < 3000; i++) {
>>>   INSERT INTO table VALUES(val[i][1], val[i][2], val[i][2]);
>>> }
>>>
>>>
>>>
>>>Michal Dvoracek   [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

Mike(mickalo)Blezien

Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225) 686-2002
=
















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

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: Perl DBI and rollback()

[Paul DuBois]

At 12:17 PM -0400 6/22/01, Trond Eivind Glomsrød wrote:
>Batara Kesuma <[EMAIL PROTECTED]> writes:
>
>>  Hello,
>>
>>  I think it might not be a right mailing list for this question, but I
>>  don't know where else should I post it.
>>
>>  If I run Perl DBI's $dbh->connect() without $dbh->disconnect(), MySQL (or
>>  is it the Perl DBI module) will run rollback() with an error message:
>>  Issuing rollback() for database handle being DESTROY'd without explicit
>>  disconnect().
>>
>>  My question is, is there any bad effect for MySQL to run the rollback()?
>>  (ex. MySQL server will become slower, MySQL server will crash, etc).
>
>Well, you've just lost the effects of your operation...

And this is different from DBI issuing it automatically ?

>
>--
>Trond Eivind Glomsrød
>Red Hat, Inc.


--
Paul DuBois, [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: MySql:delete

[VVM Ravikumar Sarma Chengalvala]

Auto_increment is one of the options
--Ravi
--- Martin Quevedo <[EMAIL PROTECTED]> wrote: > Hi
all,
> 
> When I perform a delete command and then I insert a
> new row, this new
> row is placed in the row just deleted. Is it
> possible to place newly
> inserted rows always at the end of the table???
> 
> Martin
> 
> 
>
-
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list
> archive)
> 
> To request this thread, e-mail
> <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
>
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
> 



Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie

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

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: RAID advice :> (fwd)

[Seth Northrop]

Sorry for the delayed reply.. the list marked my reply as spam ! ;)

-- Forwarded message --
Date: Fri, 22 Jun 2001 02:48:14 -0700 (PDT)
From: Seth Northrop <[EMAIL PROTECTED]>
To: Wouter de Jong <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED]
Subject: Re:  RAID advice :>


> Let's say your OS crashes (Linux...bad libraries for example, that are
> not resolvable, for example :>), then you'll have to format all your disks
> including your \
> data to replace the OS.

I'm missing the link here between OS crashing and having to reinitalize
and rebuild the RAID array.

Ultimately, you want to avoid single points of failure.  Having the OS on
a none redundant disk seems like a pretty big one.  If that disk goes bad
(a much higher probability than linux crashing and destroying your disks
in a flaming explosion) then your database is down.  If it's on the RAID
array then you swap a new disk in and have zero downtime (assuming you can
hot swap).  You could certainly keep your / partition seperate.. this is
generally a good idea anyways; but, I see no advantage to keeping the OS
off the RAID array.


---
Seth Northrop
Manager of Information Technology
Reflectivity, Inc.
3910 Freedom Circle, Suite 103
Santa Clara, CA 95054
voice:  408-970-8881 x147
fax:408-970-8840
http://www.reflectivity.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: what does this mean please?

[Seth Northrop]

> ERROR 2002: Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)
>
> and how you fix it?

It means you have no local socket for mysql to connect through.  Meaning,
something/someone either deleted or mangled /tmp/mysql.sock or mysqld
isn't running to begin with.

Try to connect with the -host flag to connect (so it won't use the socket)
and shutdown and try to restart the mysqld - hopefully this will recreate
mysql.sock

Take care,
seth

---
Seth Northrop
Manager of Information Technology
Reflectivity, Inc.
3910 Freedom Circle, Suite 103
Santa Clara, CA 95054
voice:  408-970-8881 x147
fax:408-970-8840
http://www.reflectivity.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

Error for the " ' " Syantax

[ltping]

Dear sir;
 I have find a big error from MySQL. I have one fields like that;
co_na(Fields) = Johsua's Brother;
mybtd is the data name, co_na is the fields;
I cannot insert the data by using the php commands;
mysql_query("INSERT into mybtd(co_pe) values('Johsua's Brother')"); canot
be functioned. and also mysql_query("INSERT into mybtd(co_pe)
values("Johsua's Brother")");

but this command can be run on terminal use the command below:-
INSERT into mybtd(co_pe) values("Johsua's Brother"); can be run...But
INSERT into mybtd(co_pe) values('Johsua's Brother'); cannot run...

can you give me some help..


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

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

Re: ACCESS DB, and MySQL which one better to handle database driv en webpage

[John Meyer]

It only corrupted your database twice?

On Friday 22 June 2001 09:50, Patrick Calkins wrote:

> MySQL can handle infinately more concurent connections to it, and handle a
> much bigger load than MDB can even dream of doing. A few years back I used
> to write database apps in visual basic and MDB. It was running on the
> network, with only about 5 people accessing it at one time. MDB had
> corrupted the files at least twice. 

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

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: ACCESS DB, and MySQL which one better to handle database driven webpage

[John Meyer]

On Friday 22 June 2001 09:22, [EMAIL PROTECTED] wrote:
> MySQL has is used by alot of major players and there are pre made setup for
> building database driven websites like PHP-Nuke. Unsure on the strings
>
> I use Win2K and Mysql PHP and PHP Nuke with Apache for my site and it's
> working great! My Linux Server has the same and also does excellent.
>
> Cheers
>
> Mike


If you use ODBC strings with DSN names, chances are you won't have to change 
much of the code.   Of course, this is slower than an Oprah Winfrey show, but 
it can be done.
There are some great tools out there that will help you make the migration 
between MDB and MySQL.  DBTools is one of my favorites.  Either way, if you 
are using a web page server, get away from the Access databases!

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

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

Fw: Problem starting mysqlGui

[yann . carlier]

I think you must start the mySQL server to connect


- Original Message -
From: "Trond Eivind Glomsrød" <[EMAIL PROTECTED]>
To: "Arnor Sigfusson" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, June 22, 2001 5:07 PM
Subject: Re: Problem starting mysqlGui


> Arnor Sigfusson <[EMAIL PROTECTED]> writes:
>
> > Hi
> > I was trying MySQL on a RedHat 7.0 for the first time using
> > MySQLGUI. But when I try to connect I get:
>
> Have you applied all updates, and can you connect through the mysql
> CLI client?
> --
> Trond Eivind Glomsrød
> Red Hat, Inc.
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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: insert

[Cal Evans]

It is my understanding that the first syntax is faster in mysql.

Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: "Dvoøáèek Michal" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 22, 2001 11:48 AM
Subject: insert


> Hi,
>
> is better to create insert query for better performance this way:
> INSERT INTO table VALUES(val1, val2, val3), (val4, val5, val6), (...);
> or in this way:
> for (i = 0; i < 3000; i++) {
>   INSERT INTO table VALUES(val[i][1], val[i][2], val[i][2]);
> }
>
>
>
>Michal Dvoracek   [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: KEY and index

[Cal Evans]

KEY is used to build other indexes.  It's not short for Primary Key.  There
are PRIMARY KEY indexes, candidate key indexes (these COULD be a primary key
but for one reason or another , are not) and just regular indexes.

All tables should have a primary key. (I'm partial to adding an
auto_increment field to almost every table of the name ID and
making this my primary key) Some tables will also have a candidate key. This
is especially true if you manufacture a PK like I do. Then there may be a
piece of data that is unique to each record and never null that would
normally serve as a primary key. (The reason I manufacture PKs is because if
a piece of data means something then it is always possible that it will
change.This means that you would have to trace down all your FK
relationships and change the data in those tables as well.SSN, phone number,
email address are all examples of candidate keys but also smart keys. I
never use them as PKs. )

Regular keys are just indexes, not necessarily unique, not necessarily on
fields that don't accept nulls. Their primary function is to speed up data
retrieval.  Use them sparingly as they can have a negative impact on
inserting and updating records.

HTH,
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: "Marco Bleeker" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 22, 2001 9:36 AM
Subject: KEY and index


> Hello, I am learning MySQL and have a question. I know about the
importance
> of the PRIMARY KEY statement, but I also see a KEY statement being used
> when creating a table. Is this just short for PRIMARY KEY, or what's the
> difference?
>
> Second question, when I have a large table, but with only 2 small cells
per
> row (2 columns), is it useful to create a PRIMARY KEY, KEY, or INDEX for
> speed (there is no set relation to another table).
>
> Third question, when exactly does MySQL use indexes. Is it used when the
> indexed column is part of a (SELECT *) WHERE statement, together with a
> non-indexed column? I just want to check if matching a row is present or
> not, not actually retrieve information ("WHERE ip='$ip' and
date>curdate()")
>
> Thanks, Marco
> |
> | Marco Bleeker, Amsterdam
> | [EMAIL PROTECTED]
> | http://www.euronet.nl/users/mbleeker/
> |
> | Attachments only after prior notice please.
> | Don't put me on any kind of mailing list.
> |
> | I am now receiving the Snowhite virus 4x a day
> | - some of you must be infected, please check !
> | (No, you did not get it from me, I use Eudora)
> | __@
> |   _`\<,_
> |__(*)/ (*)Ah, op DIE fiets !
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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

my sql query retrieval(Urgent)

[VVM Ravikumar Sarma Chengalvala]

Hi,
Is there a way to retrieve the field values in the
same order as during insertions based on something
like rowid or so??
Eg:
Insertion order into a table for a text field:
bbb

abaa
aa

Retrieval order:
I want to have the retrieval order also the same.The
output of the query on that field should give :
bbb

abaa
aa


Any  ideas??

--Regards,
Ravi




Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie

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

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

Re: Re: Fw: Fw:

[Trond Eivind Glomsrød]

On 22 Jun 2001 [EMAIL PROTECTED] wrote:

> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> database,sql,query,table
>
> If you just reply to this message, and include the entire text of it in the
> reply, your reply will go through. However, you should
> first review the text of the message to make sure it has something to do
> with MySQL. You have written the following:
>
>
> [EMAIL PROTECTED] writes:
>
> > are you shore there is a rpm for DBI in RH 7.0 installation cdrom 1 & 2?
>
> Use the ones from Red Hat Linux 7.1.
>

-- 
Trond Eivind Glomsrød
Red Hat, Inc.


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

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 about weird filenames...

[Webmaster]

I have weis in my mysql data directory, and I was hoping someone could tell me what 
they were...

I understand that most tables will have 3 files associated with them (in my mysql 
setup anyway): .ISM, .ISD and .frm files.

However, I have files like this in my directory: B-431a.ISM, B-431a.ISD, B-431a.frm..

The problem is : I have no tables named "B-431a" in my schema.

Anyone have an idea of what those files are ?

Re: Perl DBI and rollback()

[Trond Eivind Glomsrød]

Batara Kesuma <[EMAIL PROTECTED]> writes:

> Hello,
> 
> I think it might not be a right mailing list for this question, but I
> don't know where else should I post it. 
> 
> If I run Perl DBI's $dbh->connect() without $dbh->disconnect(), MySQL (or
> is it the Perl DBI module) will run rollback() with an error message:
> Issuing rollback() for database handle being DESTROY'd without explicit
> disconnect().
> 
> My question is, is there any bad effect for MySQL to run the rollback()?
> (ex. MySQL server will become slower, MySQL server will crash, etc).

Well, you've just lost the effects of your operation...

-- 
Trond Eivind Glomsrød
Red Hat, Inc.

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

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

[Martin Quevedo]

Hi all,

When I perform a delete command and then I insert a new row, this new
row is placed in the row just deleted. Is it possible to place newly
inserted rows always at the end of the table???

Martin


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

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: Problem starting mysqlGui

[Trond Eivind Glomsrød]

Arnor Sigfusson <[EMAIL PROTECTED]> writes:

> Hi
> I was trying MySQL on a RedHat 7.0 for the first time using
> MySQLGUI. But when I try to connect I get:

Have you applied all updates, and can you connect through the mysql
CLI client?
-- 
Trond Eivind Glomsrød
Red Hat, Inc.

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

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

Fw: Fw: Fw:connect to mySQL via perl using DBI DBD

[yann . carlier]

I want to connect to mySQL via perl...
I have to install DBD::mysql?
is there a rpm for mysql drivers

I´d just installed the  perl DBI.rpm but it seams didn´t wrork

in
dir /usr/lib/perl5/site_perl/
I have:
5.6.0 and i386-linux dirs

help

- Original Message -
From: "Michael Ott" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, June 22, 2001 4:06 PM
Subject: Re: Fw: Fw:


hallo yann!

> are you shore there is a rpm for DBI in RH 7.0 installation cdrom 1 & 2?

yes, one is called perl-DBI and is at the powertools-cd and the other,
which you mean is at
ftp://ftp.redhat.com/pub/contrib/libc/i386/perl-DBD-msql-mysql...

but you must copy some files after installation
cp -iR /usr/lib/perl5/site_perl/5.005/i386-linux/* \
  /usr/lib/perl5/site_perl/5.6.0/i386-linux/

> >
> > I´m trying to install:
> > perl -MCPAN -e'install DBD::mysql'
> > in RH 7.0 to conect to mysql with perl
> > it fail first time...
> > 'BEGIN faild--compilation aborted at Makefile.PL line 5'
> >
> > how can I reinstall it, configure the script again??
> >
> why do you not use the rpm?
>

i hope i can help you

--
Gruß & bye

Michael Ott

-
- Siemens AG - I&S IT PS 51 ERL -
- Werner-von-Siemens-Strasse 60 -
- 91050 Erlangen-
- Tel. +49 91 31 7 42 0 54  -
- [EMAIL PROTECTED]   -
-

open-source and you have much fun

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

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





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

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

RE: what is the difference between, MDB and MySQL

[Patrick Calkins]

Well, that all depends on what language your apps are written in. VB?
Delphi? C? PHP? Perl? and what database architecture are you using within
the language (ie, in VB are you using ADO, or ODBC, or DAO, etc)...

Also, for a good comparison of databases, look at this:
http://www.mysql.com/information/crash-me.php

Patrick

# -Original Message-
# From: Colin [mailto:[EMAIL PROTECTED]]
# Sent: Wednesday, June 20, 2001 10:35 PM
# To: Siomara Pantarotto
# Cc: [EMAIL PROTECTED]
# Subject: Re: what is the difference between, MDB and MySQL
# 
# 
# I mean, the connecting string, what is the different
# 
# MySQL. Interbase SQL, ACCESS and MS SQL
# 
# is it the same, since, I have coded webstore by using 
# ACCESS's MDB, but,
# currently, we need to move to Lynex OS comes with mySQL installed in
# server.. so, if program move to lynex, will it work properly?
# 
# Thanks
# 
# 
# 
# 
# 
# - Original Message -
# From: "Siomara Pantarotto" <[EMAIL PROTECTED]>
# To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
# Sent: Thursday, June 21, 2001 10:46 PM
# Subject: Re: what is the difference between, MDB and MySQL
# 
# 
# > MySQL is a database just like others:
# >
# > Oracle (Oracle)
# > SQL Server (Microsoft - for large systems)
# > Access (Microsoft - for small systems)
# > DB2(IBM)
# > etc...
# >
# > MDB, as I know, is the termination (extension) given to a database
# generated
# > by MS Access.
# >
# > For example: NorthWind.mdb (example provided by Microsoft 
# when you install
# > Access)
# >
# > Siomara
# >
# >
# > >From: "Colin" <[EMAIL PROTECTED]>
# > >To: <[EMAIL PROTECTED]>
# > >Subject: what is the difference between, MDB and MySQL
# > >Date: Wed, 20 Jun 2001 22:47:15 -0500
# > >
# > >
# >
# > 
# __
# ___
# > Get Your Private, Free E-mail from MSN Hotmail at 
http://www.hotmail.com.
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


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

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

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

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: ACCESS DB, and MySQL which one better to handle database driven webpage

[Patrick Calkins]

First off, I wouldn't really want to call Access a database, as its little
more than just a file with 1/2 of a program trying to access it. And second,
I would say that MS SQL is both over-priced, and way too bloated, buggy,
slow, etc, etc. (but then again, everyone has their own opinion on this).

As far as MySQL goes, it seems to be a very excellent database system. Its
fast, lightweight, fairly bug-free (much, much, much better then the two
above), the support is unmatched, easy to use (if you understand SQL, which
you should for any database), etc, etc. One of the most popular combinations
to drive a dynamic web site is Apache, MySQL, PHP, all running on either
Linux or FreeBSD. Many, many, many more sites on the internet run in this
combination meaning that if you ever get stuck somewhere you won't have a
hard time finding any help on it.

MySQL can handle infinately more concurent connections to it, and handle a
much bigger load than MDB can even dream of doing. A few years back I used
to write database apps in visual basic and MDB. It was running on the
network, with only about 5 people accessing it at one time. MDB had
corrupted the files at least twice. I was very sad :o) Anyway, I have since
been writing all my database apps using the PHP language, on Apache web
server and accessing the MySQL database. The results? Never ever ever have I
had a corrupted database, very fast - can easily handle loads of 100+ users
at one time without even missing a step. This is good news to me! And best
of all, its 100% free (unless you would like to donate anything to the
project, or opt for professional support from the makers of the db).

I know all of this sounds much like just a personal opinion, so I'll have
you check out this link for yourself:

http://www.mysql.com/information/benchmarks.html

Hope this helps!
Patrick

# -Original Message-
# From: Colin TMC [mailto:[EMAIL PROTECTED]]
# Sent: Friday, June 22, 2001 6:56 AM
# To: [EMAIL PROTECTED]
# Subject: ACCESS DB, and MySQL which one better to handle 
# database driven
# webpage
# 
# 
# Can anybody help with the question about which one is the 
# best to handle database driven webpage,  Since, we are 
# running on ACCESS DB, and MS SQL for a long time, but, We 
# just have our new Lynex server it is running MySQL, my question is:
# 
# 1) What's the different between MDB and MySQL. I mean the 
# string of code?
# 2) Is it worth to have this upgrade?
# 
# Thanks for the time
# 

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

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

RE: Does not match

[Johnson, Gregert]

Try something like

SELECT fid, Family_Last_Name, Phone, playertable.Family_ID
FROM familytable
LEFT OUTER JOIN playertable ON playertable.Family_ID = familytable.fid
   AND playertable.SportRegistered = 'O'
GROUP BY fid
ORDER BY Family_Last_Name ASC;

The rows from familytable which are not matched by rows in playertable will be 
recognized by NULL values of playertable.Family_ID in the result set.

--Greg Johnson

-Original Message-
From:   Dave Carter [mailto:[EMAIL PROTECTED]]
Sent:   Friday, June 22, 2001 10:19 AM
To: mysql
Subject:Does not match

Can I show records from my SQL statement where records both have a match and
do NOT have a match. I'm having trouble with the syntax for "no matching
records" in a related table, my current SQL statment looks like this:


SELECT fid,Family_Last_Name,Phone  FROM familytable,playertable WHERE
playertable.Family_ID = familytable.fid AND playertable.SportRegistered =
'0' GROUP BY fid ORDER BY Family_Last_Name ASC;


This works fine, but I also want to show Families with NO matching records
in the player field, which the above statement does not do.

TIA,

Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464.2970





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

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

insert

[Dvoøáèek Michal]

Hi,

is better to create insert query for better performance this way:
INSERT INTO table VALUES(val1, val2, val3), (val4, val5, val6), (...);
or in this way:
for (i = 0; i < 3000; i++) {
  INSERT INTO table VALUES(val[i][1], val[i][2], val[i][2]);
}



   Michal Dvoracek   [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: mysql and c program?

[Laurent Oget]

On Fri, Jun 22, 2001 at 04:54:17PM +0800, eagle wrote:
> mysql
> hello all.
> I install mysql  3.23.32 on  red hat 6.0  .
> I have a c program source as bellow:
> //*
> gcc -I /usr/local/include/mysql mysql_test.c -L /usr/local/lib/mysql -lmysqlclient 
>-lz -o mysql_test
> 
> /insert_test: error in loading shared libraries: libmysqlclient.so.6: cannot open 
>shared object file: No such file or directory
> 
> Under the dirctory of /usr/local/lib/mysql ,I can see libmysqlclient.so.6.
> 
> 
yes, it is there, but your linker (ld) does not know it is
supposed to look there..

there are many ways to fix that

add /usr/local/lib in the environment variable $LD_LIBRARY_PATH
compile with the -rpath /usr/local/lib option
add /usr/local/lib to /etc/ld.so.conf and run ldconfig

L

-- 
Laurent Oget, Ph.D. [EMAIL PROTECTED]http://oget.net
Senior Engineer Zvolve Systems Inc  http://zvolve.com
Chercheur Associé   Liafa   http://liafa.jussieu.fr

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

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

Perl DBI and rollback()

[Batara Kesuma]

Hello,

I think it might not be a right mailing list for this question, but I
don't know where else should I post it. 

If I run Perl DBI's $dbh->connect() without $dbh->disconnect(), MySQL (or
is it the Perl DBI module) will run rollback() with an error message:
Issuing rollback() for database handle being DESTROY'd without explicit
disconnect().

My question is, is there any bad effect for MySQL to run the rollback()?
(ex. MySQL server will become slower, MySQL server will crash, etc).
Please help, and thanks so much :)

--bk
 

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

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: ACCESS DB, and MySQL which one better to handle database driven webpage

[massey]

MySQL has is used by alot of major players and there are pre made setup for building 
database driven websites like PHP-Nuke.
Unsure on the strings

I use Win2K and Mysql PHP and PHP Nuke with Apache for my site and it's working great!
My Linux Server has the same and also does excellent.

Cheers

Mike

-Original Message-
FROM: Colin TMC
TO: [EMAIL PROTECTED]
DATE: Fri 6/22/01 8:16
SUBJECT: ACCESS DB, and MySQL which one better to handle database driven webpage

Can anybody help with the question about which one is the best to handle =
database driven webpage,  Since, we are running on ACCESS DB, and MS SQL =
for a long time, but, We just have our new Lynex server it is running =
MySQL, my question is:

1) What's the different between MDB and MySQL. I mean the string of =
code?
2) Is it worth to have this upgrade?

Thanks for the time


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

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

Problem starting mysqlGui

[Arnor Sigfusson]

Hi
I was trying MySQL on a RedHat 7.0 for the first time using MySQLGUI. But 
when I try to connect I get:

Can't connect to local MySQL server through socket '' (111)"

Arnor Sigfusson

Arnor Sigfusson Tel:+354 5574488
FutureMedTecMobile: +354 8949960
Storhofda 17email:  [EMAIL PROTECTED]
112 - Reykjavik
ICELAND


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

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: whos logged in..?

[Colm McCartan]

Hello all,

apologies if this has been posted before but I can't find it in the FAQ, docs or 
anywhere...

Subject says it all: before closing down for a backup or whatever, how do I find 
out who is logged into the server (as opposed to just getting connections 
information)?

Many thanks for any help - I am subscribed to the digest so perhaps anyone who 
cares to reply could post to my address as well?

colm

PS - This just got bounced... hmmm...

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

Did that do the trick? Thats quite a strange system..
 
colm mccartan
panasonic owl uk
[EMAIL PROTECTED]
(44) 131 561 1035





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

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

Fw: Fw: Fw:

[yann . carlier]

can´t find rpm DBI in RH 7.0 installation cdrom 1 & 2
help



- Original Message -
From: "Michael Ott" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, June 22, 2001 4:06 PM
Subject: Re: Fw: Fw:


hallo yann!

> are you shore there is a rpm for DBI in RH 7.0 installation cdrom 1 & 2?

yes, one is called perl-DBI and is at the powertools-cd and the other,
which you mean is at
ftp://ftp.redhat.com/pub/contrib/libc/i386/perl-DBD-msql-mysql...

but you must copy some files after installation
cp -iR /usr/lib/perl5/site_perl/5.005/i386-linux/* \
  /usr/lib/perl5/site_perl/5.6.0/i386-linux/

> >
> > I´m trying to install:
> > perl -MCPAN -e'install DBD::mysql'
> > in RH 7.0 to conect to mysql with perl
> > it fail first time...
> > 'BEGIN faild--compilation aborted at Makefile.PL line 5'
> >
> > how can I reinstall it, configure the script again??
> >
> why do you not use the rpm?
>

i hope i can help you

--
Gruß & bye

Michael Ott

-
- Siemens AG - I&S IT PS 51 ERL -
- Werner-von-Siemens-Strasse 60 -
- 91050 Erlangen-
- Tel. +49 91 31 7 42 0 54  -
- [EMAIL PROTECTED]   -
-

open-source and you have much fun




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

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

[Peter Adamka]

Try also mysql_navigator (latest 1.2.3). You'll need qt 2.2.x (and a
little work with compillig :-).
Nice, simple, powerfull. I'm very happy with this GUI.
http://sql.kldp.org/mysql

Malmo

Malmo> If I only got 20$ for evryone who's too lazy to configure his own comp.
Bill Gates> "Why not?"

On Fri, 22 Jun 2001, Sinisa Milivojevic wrote:

> Ricardo Striquer Soares writes:
> > does enyone knows a GUI to use with mysql wich is verry friendly one?
> >
> > thanks advanced.
> >
> > _
> > Do You Yahoo!?
> > Get your free @yahoo.com address at http://mail.yahoo.com
> >
>
>
> Hi!
>
> Try our mysqlgui.
>
> New version for Windoes and bug-fix release for Linux is coming out
> soon.
>
>
> --
> 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
>


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

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

[Michael Ott]

hallo yann!

> are you shore there is a rpm for DBI in RH 7.0 installation cdrom 1 & 2?

yes, one is called perl-DBI and is at the powertools-cd and the other,
which you mean is at
ftp://ftp.redhat.com/pub/contrib/libc/i386/perl-DBD-msql-mysql...

but you must copy some files after installation
cp -iR /usr/lib/perl5/site_perl/5.005/i386-linux/* \
  /usr/lib/perl5/site_perl/5.6.0/i386-linux/

> >
> > I´m trying to install:
> > perl -MCPAN -e'install DBD::mysql'
> > in RH 7.0 to conect to mysql with perl
> > it fail first time...
> > 'BEGIN faild--compilation aborted at Makefile.PL line 5'
> >
> > how can I reinstall it, configure the script again??
> >
> why do you not use the rpm?
> 

i hope i can help you

-- 
Gruß & bye

Michael Ott

-
- Siemens AG - I&S IT PS 51 ERL -
- Werner-von-Siemens-Strasse 60 -
- 91050 Erlangen-
- Tel. +49 91 31 7 42 0 54  -
- [EMAIL PROTECTED]   -
-

open-source and you have much fun

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

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

Cannot start.

[Tomas Norre]

Hello.. Friends

I have just installed my OpenBSD 2.9 with mysql 3.23.37 and when i wanted to
startet i can do it first time, but if i have to restart the server. I
cannot start it again, why?

i come with this error.

w3# safe_mysqld
/usr/libexec/ld.so: my_print_defaults: libpthread.so.14.20: No such file or
directory
Starting mysqld daemon with databases from /var/mysql
010622 17:20:08  mysqld ended


>From Tomas


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

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

KEY and index

[Marco Bleeker]

Hello, I am learning MySQL and have a question. I know about the importance 
of the PRIMARY KEY statement, but I also see a KEY statement being used 
when creating a table. Is this just short for PRIMARY KEY, or what's the 
difference?

Second question, when I have a large table, but with only 2 small cells per 
row (2 columns), is it useful to create a PRIMARY KEY, KEY, or INDEX for 
speed (there is no set relation to another table).

Third question, when exactly does MySQL use indexes. Is it used when the 
indexed column is part of a (SELECT *) WHERE statement, together with a 
non-indexed column? I just want to check if matching a row is present or 
not, not actually retrieve information ("WHERE ip='$ip' and date>curdate()")

Thanks, Marco
|
| Marco Bleeker, Amsterdam
| [EMAIL PROTECTED]
| http://www.euronet.nl/users/mbleeker/
|
| Attachments only after prior notice please.
| Don't put me on any kind of mailing list.
|
| I am now receiving the Snowhite virus 4x a day
| - some of you must be infected, please check !
| (No, you did not get it from me, I use Eudora)
| __@
|   _`\<,_
|__(*)/ (*)Ah, op DIE fiets !



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

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

Re: deleted mysql.sock

[Michael Kirschenbaum]

I got the message when I try to run mysqld.

mysqld: Can't change dir to '/usr/local/mysql/var/' (Errcode: 2)
010622 10:35:41  Aborting

010622 10:35:41  mysqld: Shutdown Complete


-Michael Kirschenbaum


Rolf Hopkins wrote:

> You just crashed the mysql server.  Just restart it.
>
> - Original Message -
> From: "Michael Kirschenbaum" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, June 22, 2001 21:24
> Subject: deleted mysql.sock
>
> > Hi,
> > I accidentaly deleted the mysql.sock file, does anyone know how to
> > restore it?   Thanks.
> >
> > -Michael Kirschenbaum
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > 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

Does not match

[Dave Carter]

Can I show records from my SQL statement where records both have a match and
do NOT have a match. I'm having trouble with the syntax for "no matching
records" in a related table, my current SQL statment looks like this:


SELECT fid,Family_Last_Name,Phone  FROM familytable,playertable WHERE
playertable.Family_ID = familytable.fid AND playertable.SportRegistered =
'0' GROUP BY fid ORDER BY Family_Last_Name ASC;


This works fine, but I also want to show Families with NO matching records
in the player field, which the above statement does not do.

TIA,

Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464.2970





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

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

Batch UPDATE with C API

[Jean-Philippe Cote]

Hello,

Suppose I want to update n rows (where n is a possibly large number)
using the mySQL C API. I can create n separate UPDATE
statements and send each of them to the server with mysql_[real_]query(),
but that doesn't seem particularly efficient to me. Is there a better
way to do it ? Can I create a single string containing all UPDATE
statements (comma/semi-colon separated ???) and send this string 
only once ?

Thanks in advance,
J-P



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

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

Controlar Remotamente

[Ricardo Ferrari (SPO-LAB)]

como faço p/ desligar o servidor mysql remotamente?
estou usando win98 e o Mysql esta em uma maquina NT

falow
valeu

Re: deleted mysql.sock

[Rolf Hopkins]

You just crashed the mysql server.  Just restart it.

- Original Message -
From: "Michael Kirschenbaum" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 22, 2001 21:24
Subject: deleted mysql.sock


> Hi,
> I accidentaly deleted the mysql.sock file, does anyone know how to
> restore it?   Thanks.
>
> -Michael Kirschenbaum
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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

ACCESS DB, and MySQL which one better to handle database driven webpage

[Colin TMC]

Can anybody help with the question about which one is the best to handle database 
driven webpage,  Since, we are running on ACCESS DB, and MS SQL for a long time, but, 
We just have our new Lynex server it is running MySQL, my question is:

1) What's the different between MDB and MySQL. I mean the string of code?
2) Is it worth to have this upgrade?

Thanks for the time

mysql and c program?

[eagle]

mysql
hello all.
I install mysql  3.23.32 on  red hat 6.0  .
I have a c program source as bellow:
//*
//insert_test.c
#include 
#include 
#include "mysql.h"

  int main(int argc, char *argv[]) {
 MYSQL my_connection;
 int res;
 mysql_init(&my_connection); 
 if (mysql_real_connect(&my_connection, "localhost","root", "", "nvod", 0, 
NULL, 0)) {
printf("Connection success\n");
res = mysql_query(&my_connection, "insert into task_log(task_id,content) 
values(111,'c programing')");
if (!res) {
   printf("Inserted %lu rows\n", (unsigned 
long)mysql_affected_rows(&my_connection));
} else {
   fprintf(stderr, "Insert error %d: 
s\n",mysql_errno(&my_connection),mysql_error(&my_connection));
}
mysql_close(&my_connection);
 } else {
fprintf(stderr, "Connection failed\n");
if (mysql_errno(&my_connection)) {
fprintf(stderr, "Connection error %d: 
%s\n",mysql_errno(&my_connection),mysql_error(&my_connection));
}
 }
 return EXIT_SUCCESS;
}
//***

I  use the bellow command to compile it:
gcc -I /usr/local/include/mysql mysql_test.c -L /usr/local/lib/mysql -lmysqlclient -lz 
-o mysql_test

It can be successful .but when I excute the result,it report error as:
/insert_test: error in loading shared libraries: libmysqlclient.so.6: cannot open 
shared object file: No such file or directory

Under the dirctory of /usr/local/lib/mysql ,I can see libmysqlclient.so.6.

How I solve it .Thanks .

eagle
[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

Cannot start.

[Tomas Norre]

Hello.. Friends

I have just installed my OpenBSD 2.9 with mysql 3.23.37 and when i wanted to
startet i can do it first time, but if i have to restart the server. I
cannot start it again, why?

i come with this error.

w3# safe_mysqld
/usr/libexec/ld.so: my_print_defaults: libpthread.so.14.20: No such file or
directory
Starting mysqld daemon with databases from /var/mysql
010622 17:20:08  mysqld ended


>From Tomas


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

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

deleted mysql.sock

[Michael Kirschenbaum]

Hi,
I accidentaly deleted the mysql.sock file, does anyone know how to
restore it?   Thanks.

-Michael Kirschenbaum


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

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: my sql database query retrieval order

[Benjamin Pflugmann]

Hi.

There may be some internal order, but according to the SQL
specification, you may not rely on it. The order of records of a query
without ORDER BY is undefined on purpose.

Bye,

Benjamin.


On Fri, Jun 22, 2001 at 01:43:33PM +0100, [EMAIL PROTECTED] wrote:
> Hi,
> I wonder to know if mysql follows any order in
> retrieving the data from a table.i.e Is it based on
> ascending row order or descending row order.
> --Ravi

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

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: PHP / get_lock() / release_lock()

[Benjamin Pflugmann]

Hello.

I am not using PHP, so take my comment with a grain of salt.

PHP doesn't need explicit support for GET_LOCK and RELEASE_LOCK as
they are both just simply SQL functions. So I am not sure what you
problem is, just execute the following query:

SELECT GET_LOCK('whatever')

from PHP the usual way (and be sure to not close the connection, as
this would release the lock automatically).

Hope this helped.

Bye,

Benjamin.

On Fri, Jun 22, 2001 at 12:30:17PM +0200, [EMAIL PROTECTED] wrote:
> Has anyone successfully passed the get_lock() 
> and release_lock() commands to a MySQL 
> server using PHP? If so, how did you go about it?
> 
> PHP does not seem to implement these functions
> despite the fact that they have been around since
> sometime in March/April 1998.

> / Carsten

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

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

my sql database query retrieval order

[VVM Ravikumar Sarma Chengalvala]

Hi,
I wonder to know if mysql follows any order in
retrieving the data from a table.i.e Is it based on
ascending row order or descending row order.
--Ravi



Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie

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

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

[Benjamin Pflugmann]

Hello.

Have a look at the transaction safe table types (InnoDB, BDB, ...). I
did not try them myself, but from what I read on the list, there is a
good chance that they will return to a consistent state themselves.

Bye,

Philemon.


PS: Of course, the better solution would be a back-up power supply. ;)
 

On Fri, Jun 22, 2001 at 01:35:55AM -0700, [EMAIL PROTECTED] wrote:
> I have used MySQL for about 2 years nowand I love it.
> My only problem is that I am in africa were power
> fluctuations are rampant. I usally get table handelr
> error 127 after every power outage. S'times simple
> repair just doesn't work and the entire database must
> be restore. It there a way around this error occuring
> after every outage?. Otherwise MySQL is topmost.

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

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

[Sinisa Milivojevic]

Rich Duzenbury writes:
> And of course, right after I clicked send, I remembered reading about the 
> mysql gui client.  I installed a copy, and it works great.  I only had to 
> tweak it (options dialog) to use the socket name (/tmp/mysql.sock), rather 
> than it trying to use the IP address.
> 
> Regards
> Rich
> 


As you are using Windows, you can try Windows version and connect with
it to some other host. You do not have to run mysqlgui on the server
itself. . New version for Windows will come up after this weekend.


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

Fw: Fw:

[yann . carlier]

are you shore there is a rpm for DBI in RH 7.0 installation cdrom 1 & 2?



- Original Message -
From: "Michael Ott" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, June 22, 2001 11:59 AM
Subject: Re: Fw:


hallo!

With reference to [EMAIL PROTECTED] on 22.06 10:49:
>
> - Original Message -
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Sent: Friday, June 22, 2001 10:00 AM
>
>
> I´m trying to install:
> perl -MCPAN -e'install DBD::mysql'
> in RH 7.0 to conect to mysql with perl
> it fail first time...
> 'BEGIN faild--compilation aborted at Makefile.PL line 5'
>
> how can I reinstall it, configure the script again??
>
why do you not use the rpm?

>
> Yann carlier
> +351-21-4527104/5
> www.inteliware.net
> [EMAIL PROTECTED]

--
Gruß & bye

Michael Ott

-
- Siemens AG - I&S IT PS 51 ERL -
- Werner-von-Siemens-Strasse 60 -
- 91050 Erlangen-
- Tel. +49 91 31 7 42 0 54  -
- [EMAIL PROTECTED]   -
-

open-source and you have much fun




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

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

[Sinisa Milivojevic]

Ricardo Striquer Soares writes:
> does enyone knows a GUI to use with mysql wich is verry friendly one?
> 
> thanks advanced.
> 
> _
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
> 


Hi!

Try our mysqlgui.

New version for Windoes and bug-fix release for Linux is coming out
soon.


-- 
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: mysql crashing under 100 user loads

[Sinisa Milivojevic]

David Freeman writes:
> I am having a problem with mysql.  I am running a php web site that uses a (mysql 
>Ver 11.15 Disturb 3.23.39 for pc-linux-gnu (i686))database.  Whenever i get a load of 
>about 100 simultaneous users, mysql begins to spawn D stat processes and the site 
>dies. Everything works very well with smaller loads.
> 
> I am running this on a Quad Proc HP LH4 with 1GB Ram (which isn't being touched much)
> 
> running Slack ware 7.1 upgraded to kernel 2.4-efs
> 
> Apache http/https
> 
> any help would be greatly appreciated.
> 
> 
> here is a small sample of the spawned processes.


HI!

You are either running out of file descriptors or you have a lock
contention problem. 

Second problem can be solved by using our binary.


-- 
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: MySQL MAX HPUX 11x depot file????

[Sinisa Milivojevic]

Intekhab Choudhury writes:
> Hi 
>I have installed/configured Oracle under HPUX, but
> thinking of moving to mySQL.  But finding that a
> little difficult.  
> 
> First of all, document talks about (including
> throughout the Internet) a depot file (i.e.
> mysql.full) to be run with swinstall utility.  But I
> have yet to find it. 
> 
> I want to install mySQL Max with support for BDB, but
> where's a hpuX binary?
> 
> Secondly, documentation do not go to specific, but
> very generic.  I strongly recommend working on OS
> specific documentation.  I wouldn't mind working on
> HPUX specific doc (with right assistance from mySQL
> folks)
> 
> Regards
> 
> I
> 
> __
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/


HI!

If you follow instructions on building MySQL on HP-UX 11 as specified
in HP-UX section of our manual, you would have no major problems.

Next release of MySQL will contain some additional info, and they may
come a contributed binary too ...


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

[Alan W. Rateliff, II]

On 22-Jun-01, Wouter de Jong said something totally profound about RAID advice :> that 
made me ponder...

WdJ> We are planning to use RAID for backing-up MySQL-data. Is it adviced that
WdJ> we put the OS on the RAID-array too, or just the data ?
WdJ> 
WdJ> Let's say your OS crashes (Linux...bad libraries for example, that are
WdJ> not resolvable, for example :>), then you'll have to format all your
WdJ> disks including your data to replace the OS.
WdJ> 
WdJ> Ont he other hand, if the disk that contains your OS crashes, you still
WdJ> have a lot of downtime (well, depends on backup-disk, time it occurs,
WdJ> etc).
WdJ> 
WdJ> Anyone a good suggestion ? Or is it even possible to have your OS
WdJ> separate from the data, buth both mirrored (eg. 2 different raid-arrays)

We'll have a system running Solaris 8 with a RAID 1 array for the OS and
binaries, and a RAID 5 array for all data, including MySQL databases.

With the right controller, RAID is very good.  However, be warned, some
manufacturers do not totally support Solaris 8/i86.  Adaptec does not have
Solaris 8 drivers (at last check,) and AMI's (American Megatrends) driver for
their Enterprise/Elite 1500 RAID controller has driver issues with Solaris 8
as well.  After working with AMI for a month, they suddenly shrugged me off.

-- 
   Alan W. Rateliff, II: YourVillage.com
  Assistant Systems Administrator  :   2700 Apalachee Pkwy
 < [EMAIL PROTECTED] >  :  Tallahassee, FL 32301
(850) 942-7021---
< [EMAIL PROTECTED] >< http://support.yourvillage.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: Fw:

[Michael Ott]

hallo!

With reference to [EMAIL PROTECTED] on 22.06 10:49:
> 
> - Original Message - 
> From: [EMAIL PROTECTED] 
> To: [EMAIL PROTECTED] 
> Sent: Friday, June 22, 2001 10:00 AM
> 
> 
> I´m trying to install:
> perl -MCPAN -e'install DBD::mysql'
> in RH 7.0 to conect to mysql with perl
> it fail first time...
> 'BEGIN faild--compilation aborted at Makefile.PL line 5'
> 
> how can I reinstall it, configure the script again??
> 
why do you not use the rpm?

> 
> Yann carlier
> +351-21-4527104/5
> www.inteliware.net
> [EMAIL PROTECTED]

-- 
Gruß & bye

Michael Ott

-
- Siemens AG - I&S IT PS 51 ERL -
- Werner-von-Siemens-Strasse 60 -
- 91050 Erlangen-
- Tel. +49 91 31 7 42 0 54  -
- [EMAIL PROTECTED]   -
-

open-source and you have much fun

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

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

tables

[Dvoøáèek Michal]

Hi,

i'm standing before small problem. Which type of table i will use for
my application.

I will need row-locking and speed (maybe transaction)

What type of table do you prefer ? I prefer InnoDB

   Michal Dvoracek   [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: change table name?

[Nessi]

Is this what you are looking for?

RENAME TABLE tbl_name TO new_table_name[, tbl_name2 TO new_table_name2,...]

Just take a look at the manual!

Cheers, Nessi


At 09:22 22/06/01 , you wrote:
>how do i change a table's name without recreating it?
>
>-
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

PHP / get_lock() / release_lock()

[Carsten H. Pedersen]

Has anyone successfully passed the get_lock() 
and release_lock() commands to a MySQL 
server using PHP? If so, how did you go about it?

PHP does not seem to implement these functions
despite the fact that they have been around since
sometime in March/April 1998.

/ Carsten
--
Natural selection saw to it that professional heroes who 
at a crucial moment tended to ask themselves questions 
like "What is my purpose in life?" very quickly lacked both.
 -- (Terry Pratchett, Interesting Times)


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

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: Knowing if a table exits

[trogers]

1. mysql> SHOW databases;
2. mysql> USE MessageNotification;
3. mysql> SHOW TABLES FROM MessageNotification;

hth

At 10:58 AM +0200 6/22/01, Tiwonge Nathan Kawonga wrote:
>How can I query the database to know that a specific table exists in a
>given database. 
>
>for example my database is MessageNotification and I want to know if
>Message_data table exists in this database. I am using Mysql++ to query
>the database.
>
>Thanks in advanced
>
>Tiwonge
>
>-
>Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
>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

what does this mean please?

[trogers]

ERROR 2002: Can't connect to local MySQL server through socket 
'/tmp/mysql.sock' (2)

and how you fix it?

thanks.

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

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