Re: opaque error message [2]

[Dennis Allison]

I have found a work around, but I do wonder what the problem is with 
MySQL and BDB tables.  

When I rerun the load with the table type set to ISAM it all
works.  Looks like there may be some limitation of the BDB implementation
I am triggering.

In my previous post, I reported receiving an Error 1030 table_handler error 12 
when performaing an sql alter to add a triple index to a BDB table of 115000
500 byte database.   When I dropped the table and reloaded from scratch
with the index declared, it crashed the server (Error 2002).

Again, insight is solicited.


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

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

No Ä, Ö, Ü, etc.

[Sollinger Rainer (dienstlich)]

All 'ä', 'ö', 'ü', etc. are changing in ?,! 
 
What can I do against it?
 
Rainer

Sql, query

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

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

Re: Replication between Windows MSSQL and UNIX MYSQL

[Iikka Meriläinen]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Sun, 8 Dec 2002, shawn xu wrote:

> We have an application software which uses MSSQL 7.0
> or 2000 server on Windows. Now we want to use the
> MSSQL as a master, and MYSQL on UNIX as a slave. How
> can we configure Windows MSSQL and UNIX MYSQL both
> sides to implement replication?
>
> Any idea? Thanks in advance.

Hi,

With the normal replication supported by MySQL OR the replication schemes
(merge, transactional, snapshot) supported by MSSQL it's not possible. But
have you tried to schedule certain DTS transformation on MSSQL that format
the data properly and then send them to MySQL via ODBC?

Iikka


 Iikka Meriläinen
 Vaala, Finland
 E-mail: [EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.0 (GNU/Linux)

iD8DBQE99DkCCVGYZ+r4ZncRAu13AKCSK2DnfzQQq7TSY0lv7BniqVx5WQCeO/L/
uk3w+BU4KKUVzzWeaoRChy0=
=TKr0
-END PGP SIGNATURE-


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

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

Re: INSERT

[Iikka Meriläinen]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Sun, 8 Dec 2002 [EMAIL PROTECTED] wrote:

> I have a ntext data type on SQLServer7, and I have the following statement:
  ^^
First, cross-posting like this is stupid. Second, it's not needed. Third,
(could be 1. + 2:) This is a MySQL list, not an MS SQL Server list.

Please send your questions on MS SQL Server to sql_beginners list or to an
appropriate newsgroup. People here are interested in MySQL. These messages
only add noise to this list, as many people's expertise concentrates on
MySQL, not other SQL implementations.

Thanks, and Best Regards,
Iikka

ps. didn't want to be rude, but these questions are simply out of line here.
:-)


 Iikka Meriläinen
 Vaala, Finland
 E-mail: [EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.0 (GNU/Linux)

iD8DBQE99DhRCVGYZ+r4ZncRAnfRAJ913TLa41cAvKG8PeZKqnq0h7If/wCeKf/p
atNdoENCDwzN4i4QTj7lz+o=
=z34a
-END PGP SIGNATURE-


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

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

Opaque mysql error ...

[Dennis Allison]

I have a moderately large database (150K records of nine fields, a bit under 500 bytes
per record with a primary key.   The database is of Type BDB.

To improve query performance I concluded I needed to add a three element index.  
Running 

alter table foo add index udex( w_1, w_2, w3 );

genearated some error condition

Error 1030 table_handler error 12

A net posting suggested 

set SQL_BIG_TABLES=1

as a solution, but it made no change.

I then exported the table modified the create statement to include the index,
and then attempted to load the result.   It ran along fine, but eventually 
crashed the server producing 

Error 2002, Cannot connect to server

diagnostics--lots of them.

The host machine is a dual processor Athlon with 2GB of memory.  Operating system is 
Linux, RH7.3. 

Can anyone suggest what might be the problem?  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

Re: Select * From table where name Like 'help'; Help

[Beauford.2003]

I am doing this search from a website, and from what I can tell there is no
way to use a variable (i.e. $var) with REGEXP as the $ sign has a special
meaning to REGEXP. Any other suggestions, or would you know a way around
this.

TIA

- Original Message -
From: "Robert Citek" <[EMAIL PROTECTED]>
To: "Beauford.2003" <[EMAIL PROTECTED]>
Cc: "MySQL List" <[EMAIL PROTECTED]>
Sent: Sunday, December 08, 2002 8:16 PM
Subject: Re: Select * From table where name Like 'help'; Help


>
> Try the REGEXP modifier.  For example:
>
> mysql> select "Another One" regexp "[[:<:]]One[[:>:]]" ;
> mysql> select "Fashioned" regexp "[[:<:]]One[[:>:]]" ;
>
> The format differs from that used in sed, grep, awk, perl, python, etc.
>
>
http://www.mysql.com/documentation/mysql/bychapter/manual_Regexp.html#Regexp
>
> Regards,
> - Robert
>
> -
>
> At 07:50 PM 12/9/2002 -0500, Beauford.2003 wrote:
> > If I search for the word - One - I want to see:
> >Another One
> > But not:
> >Fashioned
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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

UNION

[D Bamud]

MySQL 3.23.53

I have a table T1 and want to do something like

SELECT * FROM T1 WHERE A = 1 AND xxx...
UNION
SELECT * FROM T1 WHERE A = 2 AND yyy...

Don't read to much in the WHERE clause, this is just for question
purpose. Also I know that UNION is available in MySQL 4.x but need to
have the REPLACEMENT of it in 3.23.x

I tried manual but.

--
Thanx

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

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

Quota Support

[Steven Adams]

Hey,
I was wondering if its possible to implant a quota system where i
can give a user just say access to 2 databases which is allowed to grow to
30Mb bewteen the two of them..

What i would really like is if its possible to make mysql use the disk quota
limits.. So i can give the uses say 50MB WebSpace on my server which will
iclude his mysql db

Thanks
/Steve


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

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

RE: Can't connect error 10061 - nothing but Mascon works remotely.

[Daevid Vincent]

Yes. I can not connect remotely using ANY Microsoft Windows
clients/tools EXCEPT "Mascon" -- which for some strange reason works
just fine. Yet EVERY OTHER WINDOWS mySQL PROGRAM fails with the same
error message (10061 Can't connect...)

I'm 98% positive my 'permissions' are correct in the mysql database
tables:

mysql> select * from host;
+-++-+-+-+--
---+-+---++-+---
-++
| Host| Db | Select_priv | Insert_priv | Update_priv |
Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv |
Index_priv | Alter_priv |
+-++-+-+-+--
---+-+---++-+---
-++
| localhost   | %  | Y   | Y   | Y   | Y
| Y   | Y | N  | Y   | Y  |
Y  |
| 192.168.0.% | %  | Y   | Y   | Y   | Y
| Y   | Y | Y  | Y   | Y  |
Y  |
| %daevid%| %  | Y   | Y   | Y   | Y
| N   | Y | Y  | Y   | Y  |
Y  |
| 192.168.1.% | %  | Y   | Y   | Y   | Y
| Y   | Y | Y  | Y   | Y  |
Y  |
+-++-+-+-+--
---+-+---++-+---
-++


Mysql> select * from user;
+-+--+--+-+-
+-+-+-+---+-+---
+--+---++-+-
---++
| Host| User | password | Select_priv | Insert_priv
| Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv |
Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv
| Index_priv | Alter_priv |
+-+--+--+-+-
+-+-+-+---+-+---
+--+---++-+-
---++
| localhost   | root |  | Y   | Y
| Y   | Y   | Y   | Y | Y   | Y
| Y| Y | Y  | Y   | Y  |
Y  |
| localhost   |  |  | N   | N
| N   | N   | N   | N | N   | N
| N| N | N  | N   | N  |
N  |
| 192.168.0.% | root | 6463872834e37889 | Y   | Y
| Y   | Y   | Y   | Y | Y   | Y
| Y| Y | Y  | Y   | Y  |
Y  |
| 192.168.1.% | root | 6463872834e37889 | Y   | Y
| Y   | Y   | Y   | Y | Y   | Y
| Y| Y | Y  | Y   | Y  |
Y  |
+-+--+--+-+-
+-+-+-+---+-+---
+--+---++-+-
---++

Again, I suspect it has to do with RH8, as this all worked fine before
the upgrade...

[root@daevid root]# rpm -qa | grep "glib" -i
glibc-2.2.93-5
glib2-2.0.6-2
glibc-kernheaders-2.4-7.20
glibc-utils-2.2.93-5
glib-devel-1.2.10-8
glib2-devel-2.0.6-2
glibc-common-2.2.93-5
glib-1.2.10-8
glibc-devel-2.2.93-5

[root@daevid root]# rpm -qa | grep "mysql" -i
MySQL-client-3.23.53a-1
MySQL-python-0.9.1-4
libdbi-dbd-mysql-0.6.5-2
MySQL-bench-3.23.53a-1
MySQL-3.23.53a-1
mysql-server-3.23.52-3
MySQL-devel-3.23.53a-1
MySQL-Max-3.23.53a-1
perl-DBD-MySQL-2.1017-3
qt-MySQL-3.0.5-17
mod_auth_mysql-1.11-1
MySQL-shared-3.23.53a-1
php-mysql-4.1.2-7.3.4

I don't think the "mysql-server-3.23.52-3" is really there though b/c I
can't "rpm -e" it.

[root@daevid root]# uname -r
2.4.18-14

> -Original Message-
> From: Michael She [mailto:[EMAIL PROTECTED]] 
> Sent: Sunday, December 08, 2002 8:26 PM
> To: Daevid Vincent
> Cc: [EMAIL PROTECTED]; 'Insanely Great'
> Subject: RE: Can't connect error 10061 - nothing but Mascon 
> works remotely.
> 
> 
> Sorry for jumping in late, but are you saying that you can't 
> connect from a 
> remote machine?
> 
> Did you add a Host '%' to your username in the users table?
> 
> 
> At 07:36 PM 12/8/2002 -0800, Daevid Vincent wrote:
> >*I* am the admin.  I don't have a command line utility on my 
> WinXP box. 
> >The command line util on Linux works just fine for itself 
> (localhost, 
> >daevid.com, 192.168.1.254, etc)
> >
> >MySQL *is* configured properly otherwise "mascon" would 

Re: E-Commerce, db-clustering and MySQL?

[Dietrich Speer]

Hello Bjorn:

Thanks for the encouragement. There are a lot of questions I still have,
though.

I am constantly working on moving the sql code into stored procedures in
order to improve speed.
I'd like to keep asp on 2000 servers. Doesn't the lack of stored procedures
force me to go back to parsed queries on the site? And am I right thinking
that that would be a big step backwards?

We're talking more than 100 stored procedures and tables with up to 750.000
rows.

But it sounds like it's doable .

DIetrich


- Original Message -
From: "Björn Pålsson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 08, 2002 3:14 PM
Subject: Re: E-Commerce, db-clustering and MySQL?


> First, I wish to say that you are making the right descision leaving M$
and
> taking a step into MySQL.
>
> Currently, I'm working on a project involving +500.000 rows and estimated
> 30.000 visitors / day on a 2 x dual 2.8 GHz Xeon dedicated for SQL.
> Additional servers are for HTTP and other tasks. There will be a lot of
> load on the SQL when the users searches our database on either category,
> area or on a fulltext keyword.
>
> The key to managing thousands of visitors is to have a system setup to
> minimize the number of querys and managing the traffic between the
diffrent
> machines. We will use a second gigabit-switch and a secondary net on the
> 10.0.0.0 to unload our primary public switch. We also have pre-cached
pages
> with the most popular products/listings. In our case, the visitor may
input
> data and therefore he will trigger a re-cache. A separate machine is used
> for this purpose as this may happen very often.
>
> To make a user allowed to input data you must setup the servers in a ring
> with each server acting as both master and slave. If you have a clean
> system with very few inserts/updates you may choose a simpler solution
with
> a single master an several slaves f.x. if the only insert is in the
> checkout in a webshop. If you have click counters, this simple solution
> will fall.
>
> If you have the ring-solution, you must make shure your script never makes
> any contradicting inserts. Use auto_increment if possible when inserting
> and/or use your session-id as an identifier. Always use relative updates
> when you must update a value.
>
> Do not write
>
> SELECT count from article WHERE id = '$id'
>
> $count++
>
> UPDATE count set count = '$count' WHERE id = '$id'
>
> but use
>
> UPDATE count = count + 1
>
> All these things to think about will force you to dig deep into your
script
> and if you have a script-in-a-box solution from a third party coder, you
> are definately in a difficult situation. If you know your script well, you
> will have an easier task.
>
> Please tell me about your future findings!
>
> Greets
>
> >Hello:
> >
> >We are running a large e-commerce site currently with ASP/MSSQL. The ever
> >increasing number of hits, complexity of the site and request for
reporting
> >is slowly but surely bringing us to the point were the current database
> >application is getting tired.
> >
> >Now we're thinking Linux, MySQL and clustering.
> >
> >I have been looking around a little and don't like the fact that there
are
> >no stored procedures and no triggers. However - if we cluster several
quad
> >processor machines we should be fine without.
> >
> >Right now it's all theory, and there don't seem to be a lot of articles
on
> >the web about this. At least I had no luck finding any.
> >
> >Does anybody have real life experiences with this kind of a setup? Does
> >anybody know where to find reports about this?
> >
> >I'd be greatful for any link or hint!
> >
> >Dietrich Speer
> >
> >
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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: Can't connect error 10061 - nothing but Mascon works remotely.

[Michael She]

Sorry for jumping in late, but are you saying that you can't connect from a 
remote machine?

Did you add a Host '%' to your username in the users table?


At 07:36 PM 12/8/2002 -0800, Daevid Vincent wrote:
*I* am the admin.  I don't have a command line utility on my WinXP box.
The command line util on Linux works just fine for itself (localhost,
daevid.com, 192.168.1.254, etc)

MySQL *is* configured properly otherwise "mascon" would not be able to
connect either.

I've done this for a while. The problem lies either with RedHat 8.0 and
their whacked glibc (still) _OR_ the MySQL*.rpm files on the mysql.com
site are not statically linked as they say they are.


--
Michael She  : [EMAIL PROTECTED]
Mobile   : (519) 589-7309
WWW Homepage : http://www.binaryio.com/



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

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

Re: Error: Can't lock file

[Geetika Tewari]

In answer to Paul's response: Line 54 does the following:

 $sth->execute() or die $sth->errstr;

in the following chunk of code that is in my Perl script:

# update the gpa of 1000 random students
for ($i = 1 ; $i <= $num_updates ; $i++) {
$r = int(rand()) + 1;
$sth=$dbh->prepare("update $table set gpa = gpa+0.01
where student_id = $r") or die $dbh->errstr;
$sth->execute() or die $sth->errstr;
}






On Sun, 8 Dec 2002, Paul DuBois wrote:

> At 23:09 -0500 12/8/02, Geetika Tewari wrote:
> >Hi,
> >
> >I am getting the following error while trying to do read-write queries on
> >MySQL.  Does anyone know what this error means?
> >The name of the script that generated this error is called
> >randomreadwrite.pl.
> >
> >Can't lock file (errno: 12) at ./randomreadwrite.pl line 54.
> >
> >Thanks very much.
>
>
> Without knowing more about the script, it's difficult to say.
> Does line 54 perform some MySQL operation, or is it doing some
> filesystem operation for itself, for example.  It may not be a
> MySQL-related error at all.
>



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

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

Re: Error: Can't lock file

[Paul DuBois]

At 23:09 -0500 12/8/02, Geetika Tewari wrote:

Hi,

I am getting the following error while trying to do read-write queries on
MySQL.  Does anyone know what this error means?
The name of the script that generated this error is called
randomreadwrite.pl.

Can't lock file (errno: 12) at ./randomreadwrite.pl line 54.

Thanks very much.



Without knowing more about the script, it's difficult to say.
Does line 54 perform some MySQL operation, or is it doing some
filesystem operation for itself, for example.  It may not be a
MySQL-related error at all.

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

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

Error: Can't lock file

[Geetika Tewari]

Hi,

I am getting the following error while trying to do read-write queries on
MySQL.  Does anyone know what this error means?
The name of the script that generated this error is called
randomreadwrite.pl.

Can't lock file (errno: 12) at ./randomreadwrite.pl line 54.


Thanks very much.


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

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_errno and mysql_error disagree on INSERT DELAYED

[chris]

>Description:
 On an unsuccessful INSERT DELAYED using mysql_query(), there is disagreement
 between the two functions mysql_error() and mysql_errno().  Specifically,
 mysql_errno() will return 0 (indicating no error), whereas mysql_error()
 will return what really happened, e.g. "Table 'foo' doesn't exist".

>How-To-Repeat:
 int retval;
 unsigned int real_error;
 char *query="insert delayed into `headers_out` (id, item, val) values 
('PfF5PsCoCj0AAEVCCiY','Content-Type','text/html')";
 /* table "headers_out" hasn't been created yet... */

 retval = mysql_query(mysql_log, query);
 real_error = mysql_errno(mysql_log);
 printf("Error %d, means %s", real_error, mysql_error(mysql_log));

 What gets output from this pseudocodish snippet is:
 "Error 0, means Table 'apache_test.notes' doesn't exist"

>Fix:
 Obviously the two error functions should agree; either, both reporting 'no
 error' or both agreeing that error 1146, nonexistent table, just happened.
 It would be preferable for the latter to be the fix, so one could then
 still check for success or failure of the INSERT DELAYED.  I do confess that
 a strict reading of the INSERT DELAYED docs indicates that it doesn't bother
 to wait around to check for success/failure...so the "desired" fix might not
 be totally in line with the "strict, by-the-book" fix.  It sure would be
 nice to know the fate of the delayed insert, though...

>Submitter-Id:  [EMAIL PROTECTED]
>Originator:[EMAIL PROTECTED]
>Organization: mod_log_sql http://www.grubbybaby.com/mod_log_sql
>MySQL support: none
>Synopsis:  Disagreement between mysql_error() and mysql_errno() on INSERT DELAYED
>Severity:  serious
>Priority:  medium
>Category:  mysql
>Class: sw-bug
>Release:   mysql-3.23.52 (Mandrake Linux MySQL RPM)

>Environment:

System: Linux crib.corp.grubbybaby.com 2.4.19-16mdkcustom #1 Sat Nov 30 17:47:29 PST 
2002 i686 unknown unknown GNU/Linux
Architecture: i686

Some paths:  /usr//bin/perl /usr//bin/make /usr//bin/gmake /usr//bin/gcc /usr//bin/cc
GCC: Reading specs from /usr//bin/../lib/gcc-lib/i586-mandrake-linux-gnu/3.2/specs
Configured with: ../configure --prefix=/usr --libdir=/usr/lib --with-slibdir=/lib 
--mandir=/usr/share/man --infodir=/usr/share/info --enable-shared 
--enable-threads=posix --disable-checking --enable-long-long --enable-__cxa_atexit 
--enable-languages=c,c++,ada,f77,objc,java --host=i586-mandrake-linux-gnu 
--with-system-zlib
Thread model: posix
gcc version 3.2 (Mandrake Linux 9.0 3.2-1mdk)
Compilation info: CC='gcc-3.2'  CFLAGS='-O3 -fomit-frame-pointer -pipe 
-mcpu=pentiumpro -march=i586 -ffast-math -fno-strength-reduce -fno-omit-frame-pointer' 
 CXX='g++-3.2'  CXXFLAGS='-O3 -fomit-frame-pointer -pipe -mcpu=pentiumpro -march=i586 
-ffast-math -fno-strength-reduce -fno-omit-frame-pointer'  LDFLAGS=''
LIBC: 
lrwxr-xr-x1 root root   13 Nov 30 16:34 /lib/libc.so.6 -> libc-2.2.5.so
-rwxr-xr-x1 root root  1147848 Aug 19 03:17 /lib/libc-2.2.5.so
-rw-r--r--1 root root  178 Aug 19 03:08 /usr/lib/libc.so
Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' 
'--with-client-ldflags=-all-static' '--with-other-libc=/lib' '--without-berkeley-db' 
'--without-innodb' '--enable-assembler' '--enable-local-infile' 
'--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' 
'--prefix=/' '--libdir=/usr/lib' '--with-extra-charsets=complex' '--exec-prefix=/usr' 
'--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' 
'--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' 
'--includedir=/usr/include' '--mandir=/usr/share/man' '--with-comment=Mandrake Linux 
MySQL RPM' 'CC=gcc-3.2' 'CFLAGS=-O3 -fomit-frame-pointer -pipe -mcpu=pentiumpro 
-march=i586 -ffast-math -fno-strength-reduce -fno-omit-frame-pointer' 'CXXFLAGS=-O3 
-fomit-frame-pointer -pipe -mcpu=pentiumpro -march=i586 -ffast-math 
-fno-strength-reduce -fno-omit-frame-pointer' 'CXX=g++-3.2'


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

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: Can't connect error 10061 - nothing but Mascon works remotely.

[Daevid Vincent]

*I* am the admin.  I don't have a command line utility on my WinXP box.
The command line util on Linux works just fine for itself (localhost,
daevid.com, 192.168.1.254, etc)

MySQL *is* configured properly otherwise "mascon" would not be able to
connect either.

I've done this for a while. The problem lies either with RedHat 8.0 and
their whacked glibc (still) _OR_ the MySQL*.rpm files on the mysql.com
site are not statically linked as they say they are.

> -Original Message-
> From: Insanely Great [mailto:[EMAIL PROTECTED]] 
> Sent: Sunday, December 08, 2002 7:05 PM
> To: Daevid Vincent
> Subject: Re: Can't connect error 10061 - nothing but Mascon 
> works remotely.
> 
> 
> Greetings...
> 
> Check out with your MySQL server administration. Are you able 
> to connect through the MySQL command line utility.
> 
> Probably your MySQL is not configured for remote connection.
> 
> Rgds
> Insane
> 
> - Original Message -
> From: "Daevid Vincent" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Cc: "'Karam Chand'" <[EMAIL PROTECTED]>
> Sent: Monday, December 09, 2002 2:07 AM
> Subject: RE: Can't connect error 10061 - nothing but Mascon 
> works remotely.
> 
> 
> > Error No. 2003
> > Can't connect to MySQL server on 'daevid.com'(10061)
> >
> > This is the same error I get with all the other programs too...
> >
> > No SSH or SSL.
> >
> > I'm connecting from my WinXP box to my Linux server over my 
> local LAN.
> >
> > > -Original Message-
> > > From: Karam Chand [mailto:[EMAIL PROTECTED]]
> > > Sent: Friday, December 06, 2002 8:55 PM
> > > To: Daevid Vincent
> > > Subject: RE: Can't connect error 10061 - nothing but Mascon works 
> > > remotely.
> > >
> > >
> > > Can you send me some details like:
> > >
> > > - The error msg. that SQLYog is reporting.
> > > - Are you using SSH or SSL?
> > > - Are you able to connect thru mysql.exe ( console
> > > client to mysql )
> > >
> > >
> > >
> > >
> > > --- Daevid Vincent <[EMAIL PROTECTED]> wrote:
> > > > Yes. I've done this all before, and I am aware of
> > > > the RH8 glibc issue,
> > > > but I thought that the current RPMS on the mysql
> > > > site fixed that. 'cept
> > > > it doesn't. I don't understand why mascon works but
> > > > other windows
> > > > clients don't work when everything else is the same.
> > > >
> > > > > -Original Message-
> > > > > From: Karam Chand [mailto:[EMAIL PROTECTED]]
> > > >
> > > > > Sent: Thursday, December 05, 2002 9:02 PM
> > > > > To: Daevid Vincent
> > > > > Subject: Re: Can't connect error 10061 - nothing
> > > > but Mascon
> > > > > works remotely.
> > > > >
> > > > >
> > > > > Are you trying to access Linux MySQL from a
> > > > Windows
> > > > > machine?
> > > > >
> > > > > If yes, you can try SQLYog at
> > > > http://www.webyog.com
> > > > >
> > > > > __
> > > > > Do you Yahoo!?
> > > > > Yahoo! Mail Plus - Powerful. Affordable. Sign up
> > > > now.
> > > > http://mailplus.yahoo.com
> > > >
> > >
> > >
> > > __
> > > Do you Yahoo!?
> > > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. 
> > > http://mailplus.yahoo.com
> > >
> >
> >
> > 
> -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: 
> http://lists.mysql.com/php/unsubscribe.php
> >
> 


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

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

Re: Want to create mySQL user through phpMyAdmin

[Manisha]

oh! god! -

Thanks a lot, I have a root access and with that I could create a user 
directly from command line.

I was thinking that thr phpMyAdmin 2.1.0 I can do it (New version can - but 
seems not this version)

Thanks once again

Manisha



At 10:21 PM 12/8/02 -0500, Joe Stump wrote:
It's not a phpMyAdmin function. If you can run raw SQL against the DB try 
running this:

FLUSH PRIVILEGES;

But you'll need to be root. If you have access to the command line you can 
flush them with mysqladmin. Check out 
http://www.mysql.com/doc/en/Adding_users.html for more information.

In the future you might want to check the manual and mailing list archives 
before posting.

--Joe


On Sunday, December 8, 2002, at 10:08 PM, Manisha wrote:

I am using phpMyAdmin 2.1.0. I created user from this (mysql.user) but do 
not know how to reload it ? I am not finding any such option on it. Can u 
please tell me more about it.

Thanks,
Manisha


At 09:45 PM 12/8/02 -0500, Joe Stump wrote:
Did you reload the privileges?

--Joe

On Sunday, December 8, 2002, at 09:21 PM, Manisha wrote:


I want to create mySQL user thr phpMyAdmin. I inserted one record in 
mysql.user table and one in mysql.db table,
testing with following program

$conn = @mysql_connect 
("localhost:/usr/home/nets/mysql/mysql-demo.sock", "manisha", "pass");
echo("before conn a");
if ($conn){
mysql_select_db ("demo");
echo("conn got it");
}
?>
but not getting the connection - if try with old user and password - 
can get connected
what's wrong ?
regards
Manisha



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

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail 
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Joe Stump - [EMAIL PROTECTED]
"Software never has bugs. It just develops random features."



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

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

--
Joe Stump - [EMAIL PROTECTED]
"Software never has bugs. It just develops random features."



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

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: Want to create mySQL user through phpMyAdmin

[Manisha]

I am using phpMyAdmin 2.1.0. I created user from this (mysql.user) but do 
not know how to reload it ? I am not finding any such option on it. Can u 
please tell me more about it.

Thanks,
Manisha


At 09:45 PM 12/8/02 -0500, Joe Stump wrote:
Did you reload the privileges?

--Joe

On Sunday, December 8, 2002, at 09:21 PM, Manisha wrote:


I want to create mySQL user thr phpMyAdmin. I inserted one record in 
mysql.user table and one in mysql.db table,
testing with following program

$conn = @mysql_connect ("localhost:/usr/home/nets/mysql/mysql-demo.sock", 
"manisha", "pass");
echo("before conn a");
if ($conn){
mysql_select_db ("demo");
echo("conn got it");
}
?>
but not getting the connection - if try with old user and password - can 
get connected
what's wrong ?
regards
Manisha



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

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

--
Joe Stump - [EMAIL PROTECTED]
"Software never has bugs. It just develops random features."



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

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: Want to create mySQL user through phpMyAdmin

[Joe Stump]

Did you reload the privileges?

--Joe

On Sunday, December 8, 2002, at 09:21 PM, Manisha wrote:


I want to create mySQL user thr phpMyAdmin. I inserted one record in 
mysql.user table and one in mysql.db table,
testing with following program

$conn = @mysql_connect 
("localhost:/usr/home/nets/mysql/mysql-demo.sock", "manisha", "pass");
echo("before conn a");
if ($conn){
mysql_select_db ("demo");
echo("conn got it");
}
?>
but not getting the connection - if try with old user and password - 
can get connected
what's wrong ?
regards
Manisha



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

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


--
Joe Stump - [EMAIL PROTECTED]
"Software never has bugs. It just develops random features."


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

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

Re: Replication between Windows MSSQL and UNIX MYSQL

[Michael She]

Did you read the Replicatoin Manual?

http://www.mysql.com/doc/en/Replication.html


At 09:15 PM 12/8/2002 -0500, shawn xu wrote:

We have an application software which uses MSSQL 7.0
or 2000 server on Windows. Now we want to use the
MSSQL as a master, and MYSQL on UNIX as a slave. How
can we configure Windows MSSQL and UNIX MYSQL both
sides to implement replication?


--
Michael She  : [EMAIL PROTECTED]
Mobile   : (519) 589-7309
WWW Homepage : http://www.binaryio.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: Date conversion

[Michael She]

You need to convert the date format to:

-MM-DD:

http://www.mysql.com/doc/en/Using_DATE.html


At 08:38 PM 12/8/2002 -0500, [EMAIL PROTECTED] wrote:

Hi all,

I have a datetime data field in SQLServer7, and I am trying to get a 
recordset according to criteria that the CallDate field in the database 
equals todays date 09/12/2002

  Dim TodaysDate
 TodaysDate= cDate(Date)



--
Michael She  : [EMAIL PROTECTED]
Mobile   : (519) 589-7309
WWW Homepage : http://www.binaryio.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

Want to create mySQL user through phpMyAdmin

[Manisha]

I want to create mySQL user thr phpMyAdmin. I inserted one record in 
mysql.user table and one in mysql.db table,
testing with following program

$conn = @mysql_connect ("localhost:/usr/home/nets/mysql/mysql-demo.sock", 
"manisha", "pass");
echo("before conn a");
if ($conn){
mysql_select_db ("demo");
echo("conn got it");
}
?>
but not getting the connection - if try with old user and password - can 
get connected
what's wrong ?
regards
Manisha



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

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

Replication between Windows MSSQL and UNIX MYSQL

[shawn xu]

We have an application software which uses MSSQL 7.0
or 2000 server on Windows. Now we want to use the
MSSQL as a master, and MYSQL on UNIX as a slave. How
can we configure Windows MSSQL and UNIX MYSQL both
sides to implement replication?

Any idea? Thanks in advance.

Shawn

__ 
Post your free ad now! http://personals.yahoo.ca

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

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 compiling mysql-3.23.53

[Pierre]

I tried mysql-4.0.5a-beta, and same error...


Pierre.


On 2002.12.08 02:36 Pierre wrote:

Hi,

I try to compile mysql-3.23.53 on my GNU/Linux system with gcc-3.2
there was no problem with the configure, but for the make I got this :

[...]
gmake[3]: Entering directory `/tmp/mysql-3.23.53/sql'
g++ -s -DMYSQL_SERVER 			 
-DDEFAULT_MYSQL_HOME="\"/usr/local\"" 			 
-DDATADIR="\"/usr/local/var\"" 			 
-DSHAREDIR="\"/usr/local/share/mysql\"" 			 
-DHAVE_CONFIG_H -I../innobase/include  			 
-I./../include 			 
-I./../regex 			 -I. -I../include -I.. -I.  
-I/usr/local/BerkeleyDB.4.1/include  -O3 -DDBUG_OFF -O3 -march=i686  
-fno-implicit-templates -fno-exceptions -fno-rtti -c mysqld.cc
/usr/include/tcpd.h: In function `void* 
handle_connections_sockets(void*)':
/usr/include/tcpd.h:131: too many arguments to function `void 
sock_host()'
mysqld.cc:2444: at this point in file
/usr/include/tcpd.h:69: too many arguments to function `int 
hosts_access()'
mysqld.cc:2445: at this point in file
/usr/include/tcpd.h:124: too many arguments to function `char* 
eval_client()'
mysqld.cc:2453: at this point in file
gmake[3]: *** [mysqld.o] Error 1
gmake[3]: Leaving directory `/tmp/mysql-3.23.53/sql'
gmake[2]: *** [all-recursive] Error 1
gmake[2]: Leaving directory `/tmp/mysql-3.23.53/sql'
gmake[1]: *** [all-recursive] Error 1
gmake[1]: Leaving directory `/tmp/mysql-3.23.53'
gmake: *** [all-recursive-am] Error 2



It would be great if you could help me with this !

Best regards,

Pierre.

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

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

Question

[Johan]

Hello, every body
I have 2 database server. the second is a copy of the first. It's replication.
But there is no connection line because it is not necesery to have an identical copy.
Every day, i have to update the second using a self made program.
To identified which record has changed,inserted or deleted, i have tables that contain
a primary key and type of action. For example :
taStudent (idx integer not null, name char(30),
address char(60),
primary key(idx))

taStudentAction(idx integer NOT NULL,
Action char(1) not null,
primary key(idx))

Action will contain 'A','U','D' for Add,Update & Delete.
The selfmade program will create a SQL script that contain script to insert,update and 
delete data in the second.
To update the second, the script must be transfered using FTP & dialupnetworking. The 
cost of dialupnetworking
is quite expensive,
The question are :
1. Is there any better approach to solve this problem ?
2. My friend told me to use XML, can this solve my problem in a effecient manner ?
3. Is there any drawback using this approach?
4. Thanks for your enlightment gurus.


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

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

Date conversion

[Sam4Software]

Hi all,

I have a datetime data field in SQLServer7, and I am trying to get a recordset 
according to criteria that the CallDate field in the database equals todays date 
09/12/2002

  Dim TodaysDate
 TodaysDate= cDate(Date)
  


  sCallsSQL = "SELECT 
CallBacks.CallDate,CallBacks.CallTime,LearnerDetails.LearnerID,CallBacks.LearnerID, 
LearnerDetails.FName,LearnerDetails.LName,LearnerDetails.TelPref,LearnerDetails.TelMobile
 From CallBacks,LearnerDetails WHERE LearnerDetails.LearnerID = CallBacks.LearnerID 
AND CallBacks.CallDate=" & TodaysDate


I have a Datetime data field i.g: 09/12/2002

I look forward to any input you make.

Regards,

Sam

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

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

Re: Error compiling mysql 3.23.53

[Pierre]

For information, same error with mysql-4.0.5a-beta


Pierre.

On 2002.12.09 02:11 Pierre wrote:

Hi,

I try to compile mysql-3.23.53 on my GNU/Linux system with gcc-3.2
there was no problem with the configure, but for the make I got this :

[...]
Making all in isam
gmake[2]: Entering directory `/tmp/mysql-3.23.53/isam'
/bin/sh ../libtool --mode=link gcc -s  -O3 -DDBUG_OFF -O3 
-march=i686  -L/usr/local/BerkeleyDB.4.1/lib -lpthread -lgpm 
-rdynamic  -o isamchk  isamchk.o sort.o libnisam.a 
../mysys/libmysys.a 			 ../dbug/libdbug.a 
../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm  -lpthread 
gcc -s -O3 -DDBUG_OFF -O3 -march=i686 -L/usr/local/BerkeleyDB.4.1/lib 
-lpthread -lgpm -rdynamic -o isamchk isamchk.o sort.o libnisam.a 
../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a 
-lpthread -lz -lcrypt -lnsl -lm -lpthread
../mysys/libmysys.a(my_tempnam.o): In function `my_tempnam':
my_tempnam.o(.text+0x51): the use of `tempnam' is dangerous, better 
use `mkstemp'
../mysys/libmysys.a(raid.o): In function `my_raid_create':
raid.o(.text+0xa5): undefined reference to `operator new(unsigned)'
raid.o(.text+0x132): undefined reference to `operator delete(void*)'
../mysys/libmysys.a(raid.o): In function `my_raid_open':
raid.o(.text+0x185): undefined reference to `operator new(unsigned)'
raid.o(.text+0x20f): undefined reference to `operator delete(void*)'
../mysys/libmysys.a(raid.o): In function `my_raid_close':
raid.o(.text+0x7c1): undefined reference to `operator delete(void*)'
collect2: ld returned 1 exit status
gmake[2]: *** [isamchk] Error 1
gmake[2]: Leaving directory `/tmp/mysql-3.23.53/isam'
gmake[1]: *** [all-recursive] Error 1
gmake[1]: Leaving directory `/tmp/mysql-3.23.53'
gmake: *** [all-recursive-am] Error 2




It would be great if you could help me with this !

Best regards,

Pierre.

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

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: Select * From table where name Like 'help'; Help

[Robert Citek]

Try the REGEXP modifier.  For example:

mysql> select "Another One" regexp "[[:<:]]One[[:>:]]" ;
mysql> select "Fashioned" regexp "[[:<:]]One[[:>:]]" ;

The format differs from that used in sed, grep, awk, perl, python, etc.

http://www.mysql.com/documentation/mysql/bychapter/manual_Regexp.html#Regexp

Regards,
- Robert

-

At 07:50 PM 12/9/2002 -0500, Beauford.2003 wrote:
> If I search for the word - One - I want to see:
>Another One
> But not:
>Fashioned


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

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 compiling mysql 3.23.53

[Pierre]

Hi,

I try to compile mysql-3.23.53 on my GNU/Linux system with gcc-3.2
there was no problem with the configure, but for the make I got this :

[...]
Making all in isam
gmake[2]: Entering directory `/tmp/mysql-3.23.53/isam'
/bin/sh ../libtool --mode=link gcc -s  -O3 -DDBUG_OFF -O3 -march=i686  
-L/usr/local/BerkeleyDB.4.1/lib -lpthread -lgpm -rdynamic  -o isamchk  
isamchk.o sort.o libnisam.a ../mysys/libmysys.a 			 
../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl 
-lm  -lpthread gcc -s -O3 -DDBUG_OFF -O3 -march=i686 
-L/usr/local/BerkeleyDB.4.1/lib -lpthread -lgpm -rdynamic -o isamchk 
isamchk.o sort.o libnisam.a ../mysys/libmysys.a ../dbug/libdbug.a 
../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm -lpthread
../mysys/libmysys.a(my_tempnam.o): In function `my_tempnam':
my_tempnam.o(.text+0x51): the use of `tempnam' is dangerous, better use 
`mkstemp'
../mysys/libmysys.a(raid.o): In function `my_raid_create':
raid.o(.text+0xa5): undefined reference to `operator new(unsigned)'
raid.o(.text+0x132): undefined reference to `operator delete(void*)'
../mysys/libmysys.a(raid.o): In function `my_raid_open':
raid.o(.text+0x185): undefined reference to `operator new(unsigned)'
raid.o(.text+0x20f): undefined reference to `operator delete(void*)'
../mysys/libmysys.a(raid.o): In function `my_raid_close':
raid.o(.text+0x7c1): undefined reference to `operator delete(void*)'
collect2: ld returned 1 exit status
gmake[2]: *** [isamchk] Error 1
gmake[2]: Leaving directory `/tmp/mysql-3.23.53/isam'
gmake[1]: *** [all-recursive] Error 1
gmake[1]: Leaving directory `/tmp/mysql-3.23.53'
gmake: *** [all-recursive-am] Error 2




It would be great if you could help me with this !

Best regards,

Pierre.

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

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: alter table syntax

[kayamboo]

Thanks for the suggestions.
(BIt worked fine
(B
(B
(Bregards
(B
(B- Original Message -
(BFrom: "Egor Egorov" <[EMAIL PROTECTED]>
(BTo: <[EMAIL PROTECTED]>
(BSent: Friday, December 06, 2002 11:36 PM
(BSubject: re: Re: alter table syntax
(B
(B
(B> kayamboo,
(B> Friday, December 06, 2002, 9:15:04 AM, you wrote:
(B>
(B>
(B> k> When I tried to drop the key, this was the error
(B>
(B> k> mysql> alter table town_db drop primary key ;
(B> k> ERROR 1025: Error on rename of '.\forest\#sql-f6_1' to
(B'.\forest\town_db'
(B> k> (errno: 150)
(B>
(B> k> I suppose some lock in the index somewhere but couldnot figure it out.
(B>
(B> Did you have another table with foreign key constraints for which
(B> town_db is a parent table? If so, you need to create index on the
(B> 'town' and then drop PRIMARY KEY.
(B>
(B>
(B>
(B>
(B> --
(B> For technical support contracts, goto https://order.mysql.com/?ref=ensita
(B> This email is sponsored by Ensita.net http://www.ensita.net/
(B>__  ___ ___   __
(B>   /  |/  /_ __/ __/ __ \/ /Egor Egorov
(B>  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
(B> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
(B><___/   www.mysql.com
(B>
(B>
(B>
(B>
(B> -
(B> Before posting, please check:
(B>http://www.mysql.com/manual.php   (the manual)
(B>http://lists.mysql.com/   (the list archive)
(B>
(B> To request this thread, e-mail <[EMAIL PROTECTED]>
(B> To unsubscribe, e-mail
(B<[EMAIL PROTECTED]>
(B> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
(B>
(B
(B
(B-
(BBefore posting, please check:
(B   http://www.mysql.com/manual.php   (the manual)
(B   http://lists.mysql.com/   (the list archive)
(B
(BTo request this thread, e-mail <[EMAIL PROTECTED]>
(BTo unsubscribe, e-mail <[EMAIL PROTECTED]>
(BTrouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: alter table syntax

[Dan Nelson]

In the last episode (Dec 09), kayamboo said:
> I don't get you.
> But when I executed the drop table syntax fromt he command line, the result
> was this error
> 
> mysql> alter table town_db drop primary key ;
> ERROR 1025: Error on rename of '.\forest\#sql-cc_1' to '.\forest\town_db'
> (errno: 150)
> mysql>

The alter table failed because of error 150.  Run the command "perror 150"
at your shell prompt (not the mysql prompt) to find out why the
command failed.

-- 
Dan Nelson
[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: Can u us a "source code" file to setup a db in MySQL ?

[Gerald R. Jensen]

Try:
mysql -u{username} -p {databasename}
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Sunday, December 08, 2002 6:43 PM
Subject: Can u us a "source code" file to setup a db in MySQL ?


When created a complicated db in MySQL can you first create a "source file"
with all the MySQL commands... and then either pipe them to MySQL or have
MySQL read the "source file" and then create the db accordingly ??

Or, must you input/key in one command at a time to the program in real time?

Thanks for any info.



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

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: Select * From table where name Like 'help'; Help

[Jocelyn Fournier]

Hi,

A "dirty" solution would be to search :

field LIKE '% one %' or field LIKE 'one %' or field LIKE '% one'  or
field='one';

Regards,
  Jocelyn

- Original Message -
From: "Beauford.2003" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Tuesday, December 10, 2002 12:50 AM
Subject: Select * From table where name Like 'help'; Help


> Hi,
>
> Hey, did this list change their spam filters? Now every time I send an
email
> it gets bounced unless the word MySQL  or Query is in the email. Anyway,
> Please read below for a recent problem I am having.
>
>  I want to be able to search on my database and be able to get the
> following, but running into a few snags.
>
>  If I search for the word - One - I want to see:
>
>  Another One
> One Day
> One on One
> Your The One
>
>  But not:
>
>  Fashioned
> Stone
> Everyone
>
>  Also, and maybe part of the solution - is there a way for the search to
be
> case sensitive.
>
>  TIA
>
>  Beauford
>
>
>
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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

Select * From table where name Like 'help'; Help

[Beauford.2003]

Hi,

Hey, did this list change their spam filters? Now every time I send an email
it gets bounced unless the word MySQL  or Query is in the email. Anyway,
Please read below for a recent problem I am having.

 I want to be able to search on my database and be able to get the
following, but running into a few snags.

 If I search for the word - One - I want to see:

 Another One
One Day
One on One
Your The One

 But not:

 Fashioned
Stone
Everyone

 Also, and maybe part of the solution - is there a way for the search to be
case sensitive.

 TIA

 Beauford







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

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

Can u us a "source code" file to setup a db in MySQL ?

[TopMailBox]

When created a complicated db in MySQL can you first create a "source file"
with all the MySQL commands... and then either pipe them to MySQL or have
MySQL read the "source file" and then create the db accordingly ??

Or, must you input/key in one command at a time to the program in real time?

Thanks for any info.



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

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: alter table syntax

[kayamboo]

I don't get you.
But when I executed the drop table syntax fromt he command line, the result
was this error

mysql> alter table town_db drop primary key ;
ERROR 1025: Error on rename of '.\forest\#sql-cc_1' to '.\forest\town_db'
(errno: 150)
mysql>

Can you make me clear?


regards



- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "kayamboo" <[EMAIL PROTECTED]>
Cc: "list mysql" <[EMAIL PROTECTED]>; "R. Hannes Niedner"
<[EMAIL PROTECTED]>
Sent: Saturday, December 07, 2002 2:19 AM
Subject: Re: alter table syntax


> In the last episode (Dec 06), kayamboo said:
> > When I tried to drop the key, this was the error
> >
> > mysql> alter table town_db drop primary key ;
> > ERROR 1025: Error on rename of '.\forest\#sql-f6_1' to
'.\forest\town_db' (errno: 150)
>
> And what does "perror 150" return (it's a shell command, not an SQL
> one)?
>
> --
> Dan Nelson
> [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: Desc question

[Jocelyn Fournier]

Hi,

if ($var=='grade_num')
  $filter='DESC';
else
  $filter='ASC';

$fetch = mysql_query("SELECT * FROM players ORDER BY $var $filter");

should work.

Regards,
  Jocelyn
- Original Message -
From: "Alex Behrens" <[EMAIL PROTECTED]>
To: "MYSQL" <[EMAIL PROTECTED]>
Sent: Monday, December 09, 2002 12:03 AM
Subject: Desc question


> hey all,
>
> I have a quick question. I'm trying to display a list of players by their
> name, number, position, and grade. Name, number, and position all display
> properly. However, grade (which is sorted grade number) is backwards,
since
> 12th grade is after 11, 10, etc. How can I make it so only one form
> selection adds a DESC tag to the query, is this possible?
>
> I'm using this code:
>
> $fetch = mysql_query("SELECT * FROM players ORDER BY $var");
>
> 
> Name
> Position
> Number
> Grade
>
> I want only the Grade option to use the desc option with the $fetch query.
> can I do this?
>
> -mysql
>
> Thanks!
> 
> -Alex "Big Al" Behrens
> E-mail: [EMAIL PROTECTED]
> Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)
> Phone: 651-482-8779
> Cell: 651-329-4187
> Fax: 651-482-1391
> ICQ: 3969599
> Owner of the 3D-Unlimited Network:
> http://www.3d-unlimited.com
> Send News:
> [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

Desc question

[Alex Behrens]

hey all,

I have a quick question. I'm trying to display a list of players by their
name, number, position, and grade. Name, number, and position all display
properly. However, grade (which is sorted grade number) is backwards, since
12th grade is after 11, 10, etc. How can I make it so only one form
selection adds a DESC tag to the query, is this possible?

I'm using this code:

$fetch = mysql_query("SELECT * FROM players ORDER BY $var");


Name
Position
Number
Grade

I want only the Grade option to use the desc option with the $fetch query.
can I do this?

-mysql

Thanks!

-Alex "Big Al" Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)
Phone: 651-482-8779
Cell: 651-329-4187
Fax: 651-482-1391
ICQ: 3969599
Owner of the 3D-Unlimited Network:
http://www.3d-unlimited.com
Send News:
[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

desc question

[Alex Behrens]

hey all,

I have a quick question. I'm trying to display a list of players by their
name, number, position, and grade. Name, number, and position all display
properly. However, grade (which is sorted grade number) is backwards, since
12th grade is after 11, 10, etc. How can I make it so only one form
selection adds a DESC tag to the query, is this possible?

I'm using this code:

$fetch = mysql_query("SELECT * FROM players ORDER BY $var");


Name
Position
Number
Grade

I want only the Grade option to use the desc option with the $fetch query.
can I do this?

-mysql

Thanks!

-Alex "Big Al" Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)
Phone: 651-482-8779
Cell: 651-329-4187
Fax: 651-482-1391
ICQ: 3969599
Owner of the 3D-Unlimited Network:
http://www.3d-unlimited.com
Send News:
[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

FULLTEXT

[Steffan A. Cline]

Hello Everyone!

I am a member of the Lasso list and heard this would be a good place to
ask about a few things about MySQL.

1. In a few places I read about FULLTEXT searches. In one place I saw it
said 16 columns and in another 15. But, I am finding that when using 15 I
get an error but then go down to 14 and all is well. One of these I am
searching is a TEXT field. Does this eat up 2 VARCHAR columns in the
FULLTEXT?

2. Is there a way in maybe a rebuild of the code to change from 4 or more
letters in the FULLTEXT search to 3 or more? I noticed on the FULLTEXT page
someone commented on this.

3. Almost the same as above but is there a way to increase the number of
columns for a FULLTEXT search?

Thanks

Steffan



---
T E L  6 0 2 . 5 7 9 . 4 2 3 0 | F A X  6 0 2 . 9 7 1 . 1 6 9 4
Steffan A. Cline
[EMAIL PROTECTED] Phoenix, Az
http://www.ExecuChoice.net  USA
AIM : SteffanC  ICQ : 57234309
The Executive's Choice in Lasso driven Internet Applications
---



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

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

[A. Berger -- Onlynux]

Should Be
sCVInsertSQL = "INSERT INTO CVs (CV) VALUES ('" & strCV &
"')"

Regards


   Andres Berger -- Gerente de Marketing -- OnLynux
   Hosting por $14.99 Anual -- www.onlynux.com/hosting




"insert into CVs (CV) values (
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, December 08, 2002 5:56 PM
Subject: INSERT


> Hi,
>
> I have a ntext data type on SQLServer7, and I have the
following statement:
>
>  sCVInsertSQL = "INSERT INTO CVs CV VALUE '" & strCV & "'"
>
> Whats wrong with that please ?
>
> Ps. strCV is a complete CV contains many lines.
>
>
>
> --
---
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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: Can't connect error 10061 - nothing but Mascon works remotely.

[Daevid Vincent]

[root@daevid]# mysqladmin ping -h daevid.com -uroot -p
Enter password: 
mysqld is alive

[root@daevid]# mysqladmin ping -h 192.168.1.254 -uroot -p  
Enter password: 
mysqld is alive


> -Original Message-
> From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] 
> Sent: Sunday, December 08, 2002 1:53 PM
> To: Daevid Vincent; [EMAIL PROTECTED]
> Cc: 'Karam Chand'
> Subject: Re: Can't connect error 10061 - nothing but Mascon 
> works remotely.
> 
> > Can't connect to MySQL server on 'daevid.com'(10061)
> 
> Try "mysqladmin ping -h mysql_host_name". This is the most 
> basic thing I can think of to connect to a MySQL server. It 
> should report "mysqld is alive".
> 
> If even that doesn't work, try "mysqladmin ping -h 
> 192.168.1.1" (or whatever your server host ip is). If that 
> fails, too, mail your Mascon connection settings to the list, 
> so someone more savvy than me may find out what's happening.
> 
> HTH!
> --
>   Stefan Hinz <[EMAIL PROTECTED]>
>   CEO / Geschäftsleitung iConnect GmbH 
>   Heesestr. 6, 12169 Berlin (Germany)
>   Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3
> 
> 
> - Original Message -
> From: "Daevid Vincent" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Cc: "'Karam Chand'" <[EMAIL PROTECTED]>
> Sent: Sunday, December 08, 2002 9:37 PM
> Subject: RE: Can't connect error 10061 - nothing but Mascon 
> works remotely.
> 
> 
> > Error No. 2003
> > Can't connect to MySQL server on 'daevid.com'(10061)
> >
> > This is the same error I get with all the other programs too...
> >
> > No SSH or SSL.
> >
> > I'm connecting from my WinXP box to my Linux server over my 
> local LAN.
> >
> > > -Original Message-
> > > From: Karam Chand [mailto:[EMAIL PROTECTED]]
> > > Sent: Friday, December 06, 2002 8:55 PM
> > > To: Daevid Vincent
> > > Subject: RE: Can't connect error 10061 - nothing but Mascon works 
> > > remotely.
> > >
> > >
> > > Can you send me some details like:
> > >
> > > - The error msg. that SQLYog is reporting.
> > > - Are you using SSH or SSL?
> > > - Are you able to connect thru mysql.exe ( console
> > > client to mysql )
> > >
> > >
> > >
> > >
> > > --- Daevid Vincent <[EMAIL PROTECTED]> wrote:
> > > > Yes. I've done this all before, and I am aware of
> > > > the RH8 glibc issue,
> > > > but I thought that the current RPMS on the mysql
> > > > site fixed that. 'cept
> > > > it doesn't. I don't understand why mascon works but
> > > > other windows
> > > > clients don't work when everything else is the same.
> > > >
> > > > > -Original Message-
> > > > > From: Karam Chand [mailto:[EMAIL PROTECTED]]
> > > >
> > > > > Sent: Thursday, December 05, 2002 9:02 PM
> > > > > To: Daevid Vincent
> > > > > Subject: Re: Can't connect error 10061 - nothing
> > > > but Mascon
> > > > > works remotely.
> > > > >
> > > > >
> > > > > Are you trying to access Linux MySQL from a
> > > > Windows
> > > > > machine?
> > > > >
> > > > > If yes, you can try SQLYog at
> > > > http://www.webyog.com
> > > > >
> > > > > __
> > > > > Do you Yahoo!?
> > > > > Yahoo! Mail Plus - Powerful. Affordable. Sign up
> > > > now.
> > > > http://mailplus.yahoo.com
> > > >
> > >
> > >
> > > __
> > > Do you Yahoo!?
> > > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. 
> > > http://mailplus.yahoo.com
> > >
> >
> >
> > 
> -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: 
> http://lists.mysql.com/php/unsubscribe.php
> >
> 


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

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

INSERT

[Sam4Software]

Hi,

I have a ntext data type on SQLServer7, and I have the following statement:

 sCVInsertSQL = "INSERT INTO CVs CV VALUE '" & strCV & "'"

Whats wrong with that please ?

Ps. strCV is a complete CV contains many lines.



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

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

[Stefan Hinz, iConnect \(Berlin\)]

Dear Bjoern,

> I have completed a new setup on WinXP, with Mysqld-nt as a service, and
> assigned a new password to root. However I am able to connect as root
> without password, alter and even drop tables and complete databases with
> the tool MySQLFront !!!

After setting up MySQL under Windows, the grant tables have automatically
been set up with some basic users. One of them is called "root", a user who
can connect from the local box without entering a password. This is done so
new users can just play around a little without having to worry about what a
"privilege system" is etc.

All user account information in MySQL is stored in a database called
"mysql". User accounts (with user privileges to the MySQL server) are stored
in mysql.user, and if access is limited to certain databases, account
information is also stored in mysql.db. You can find detailed information on
the MySQL privilege system at
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
inistration.html#User_Account_Management.

You can GRANT and REVOKE privileges like in other SQL DBMS. In MySQL, you
can also INSERT, UPDATE and DELETE users through the tables in the mysql
database. If you manipulate the mysql tables directly (instead of GRANTing
and REVOKEing), you will have to issue FLUSH PRIVILEGES to tell the server
to reload the grant tables (and thus, make the access privileges take
effect).

To make your MySQL server secure, you can do:

DELETE FROM mysql.user; DELETE FROM mysql.db; -- This will erase all current
users
GRANT ALL ON *.* TO 'superuser'@'localhost' IDENTIFIED BY 'secret' WITH
GRANT OPTION;
FLUSH PRIVILEGES; -- make the changes of the above DELETE take effect

Note that 'superuser' can only connect from localhost. If you need other
users, you can create new accounts as 'superuser' with GRANT statements like
in other SQL DBMS.

HTH!
--
  Stefan Hinz <[EMAIL PROTECTED]>
  CEO / Geschäftsleitung iConnect GmbH 
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3


- Original Message -
From: "Bjørn Stave" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 08, 2002 11:13 PM
Subject: Password protection


Hi MySQL

I am a new user of your product, and so far everything looks great, except
for password protection...

I have completed a new setup on WinXP, with Mysqld-nt as a service, and
assigned a new password to root. However I am able to connect as root
without password, alter and even drop tables and complete databases with
the tool MySQLFront !!!

If I try to connect using MySQLadmin at the command prompt without password
I am rejected as expected.

Did I miss out on something important, or is there a commonly known
backdoor to the MySQLdb

A litle extra info
Server: WinXP, MySQL ver. 3.23.49nt (commandprompt rejects acces without pw)
Client: WinXP, MySQLFRONT ver. 2.2 from MySQLfront.de (acces without pw
granted)
Purpose of use: development of a servicemanagement/CRM application as ISV

Being a bit worried to continue developing, I look forward to hering from
You.

Kind regards
Bjørn D. W. Stave
Expressive.dk


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

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

[Stefan Hinz, iConnect \(Berlin\)]

Dear Dan,

> I have a database that, I now realize, could use the benefits of
> row-locking and non-blocking SELECTs. So, I guess I need to change over
> to InnoDB tables. How do I convert my existing data structures (and the
> data they contain) into InnoDB tables?

ALTER TABLE mytable TYPE=innodb

> Also, Is there anything that MyISAM tables support (query-wise, like
> INSERT DELAYED), that is not supported by InnoDB that I might need to
> look out for in my application(s)?

Yep. "INSERT DELAYED" will not work with InnoDB, and this applies to some of
the other MySQL extensions that function as workarounds for the fact that
MyISAM tables cannot handle row level locking (LOW_PRIORITY etc.). You will
get error 1031 if you use those extensions with InnoDB tables.

Possible problems can derive from INSERT, UPDATE, DELETE, and even SELECT,
so you better check the manual
(http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Da
ta_Manipulation) for MySQL extensions with these DML words. Use the SQL
command line to find out which of these will still work with InnoDB and
which of these won't. (This is not as clear as one might think, e. g. SELECT
HIGH_PRIORITY still works, INSERT DELAYED doesn't work, INSERT LOW_PRIORITY
_does_ work!)

HTH!
--
  Stefan Hinz <[EMAIL PROTECTED]>
  CEO / Geschäftsleitung iConnect GmbH 
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3


- Original Message -
From: "Dan Cumpian" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 08, 2002 10:38 PM
Subject: MyISAM -> InnoDB


> Hello,
>
> I have a database that, I now realize, could use the benefits of
> row-locking and non-blocking SELECTs. So, I guess I need to change over
> to InnoDB tables. How do I convert my existing data structures (and the
> data they contain) into InnoDB tables?
>
> Also, Is there anything that MyISAM tables support (query-wise, like
> INSERT DELAYED), that is not supported by InnoDB that I might need to
> look out for in my application(s)?
>
> Thanks,
> Dan Cumpian
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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

Password protection

[Bjørn Stave]

Hi MySQL

I am a new user of your product, and so far everything looks great, except 
for password protection...

I have completed a new setup on WinXP, with Mysqld-nt as a service, and 
assigned a new password to root. However I am able to connect as root 
without password, alter and even drop tables and complete databases with 
the tool MySQLFront !!!

If I try to connect using MySQLadmin at the command prompt without password 
I am rejected as expected.

Did I miss out on something important, or is there a commonly known 
backdoor to the MySQLdb

A litle extra info
Server: WinXP, MySQL ver. 3.23.49nt (commandprompt rejects acces without pw)
Client: WinXP, MySQLFRONT ver. 2.2 from MySQLfront.de (acces without pw 
granted)
Purpose of use: development of a servicemanagement/CRM application as ISV

Being a bit worried to continue developing, I look forward to hering from You.

Kind regards
Bjørn D. W. Stave
Expressive.dk


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

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: Can't connect error 10061 - nothing but Mascon works remotely.

[Stefan Hinz, iConnect \(Berlin\)]

Dear Daevid,

> Can't connect to MySQL server on 'daevid.com'(10061)

Try "mysqladmin ping -h mysql_host_name". This is the most basic thing I can
think of to connect to a MySQL server. It should report "mysqld is alive".

If even that doesn't work, try "mysqladmin ping -h 192.168.1.1" (or whatever
your server host ip is). If that fails, too, mail your Mascon connection
settings to the list, so someone more savvy than me may find out what's
happening.

HTH!
--
  Stefan Hinz <[EMAIL PROTECTED]>
  CEO / Geschäftsleitung iConnect GmbH 
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3


- Original Message -
From: "Daevid Vincent" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "'Karam Chand'" <[EMAIL PROTECTED]>
Sent: Sunday, December 08, 2002 9:37 PM
Subject: RE: Can't connect error 10061 - nothing but Mascon works remotely.


> Error No. 2003
> Can't connect to MySQL server on 'daevid.com'(10061)
>
> This is the same error I get with all the other programs too...
>
> No SSH or SSL.
>
> I'm connecting from my WinXP box to my Linux server over my local LAN.
>
> > -Original Message-
> > From: Karam Chand [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, December 06, 2002 8:55 PM
> > To: Daevid Vincent
> > Subject: RE: Can't connect error 10061 - nothing but Mascon
> > works remotely.
> >
> >
> > Can you send me some details like:
> >
> > - The error msg. that SQLYog is reporting.
> > - Are you using SSH or SSL?
> > - Are you able to connect thru mysql.exe ( console
> > client to mysql )
> >
> >
> >
> >
> > --- Daevid Vincent <[EMAIL PROTECTED]> wrote:
> > > Yes. I've done this all before, and I am aware of
> > > the RH8 glibc issue,
> > > but I thought that the current RPMS on the mysql
> > > site fixed that. 'cept
> > > it doesn't. I don't understand why mascon works but
> > > other windows
> > > clients don't work when everything else is the same.
> > >
> > > > -Original Message-
> > > > From: Karam Chand [mailto:[EMAIL PROTECTED]]
> > >
> > > > Sent: Thursday, December 05, 2002 9:02 PM
> > > > To: Daevid Vincent
> > > > Subject: Re: Can't connect error 10061 - nothing
> > > but Mascon
> > > > works remotely.
> > > >
> > > >
> > > > Are you trying to access Linux MySQL from a
> > > Windows
> > > > machine?
> > > >
> > > > If yes, you can try SQLYog at
> > > http://www.webyog.com
> > > >
> > > > __
> > > > Do you Yahoo!?
> > > > Yahoo! Mail Plus - Powerful. Affordable. Sign up
> > > now.
> > > http://mailplus.yahoo.com
> > >
> >
> >
> > __
> > Do you Yahoo!?
> > Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> > http://mailplus.yahoo.com
> >
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


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

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

Re: E-Commerce, db-clustering and MySQL?

[Lou Scalpati]

Bjorn - you state to use auto_increment in 2-way replication.  Others have
said that this could cause a crash if the auto_increment field is
duplicated.  Have experienced any problems with it?


- Original Message -
From: "Björn Pålsson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 08, 2002 3:14 PM
Subject: Re: E-Commerce, db-clustering and MySQL?


> First, I wish to say that you are making the right descision leaving M$
and
> taking a step into MySQL.
>
> Currently, I'm working on a project involving +500.000 rows and estimated
> 30.000 visitors / day on a 2 x dual 2.8 GHz Xeon dedicated for SQL.
> Additional servers are for HTTP and other tasks. There will be a lot of
> load on the SQL when the users searches our database on either category,
> area or on a fulltext keyword.
>
> The key to managing thousands of visitors is to have a system setup to
> minimize the number of querys and managing the traffic between the
diffrent
> machines. We will use a second gigabit-switch and a secondary net on the
> 10.0.0.0 to unload our primary public switch. We also have pre-cached
pages
> with the most popular products/listings. In our case, the visitor may
input
> data and therefore he will trigger a re-cache. A separate machine is used
> for this purpose as this may happen very often.
>
> To make a user allowed to input data you must setup the servers in a ring
> with each server acting as both master and slave. If you have a clean
> system with very few inserts/updates you may choose a simpler solution
with
> a single master an several slaves f.x. if the only insert is in the
> checkout in a webshop. If you have click counters, this simple solution
> will fall.
>
> If you have the ring-solution, you must make shure your script never makes
> any contradicting inserts. Use auto_increment if possible when inserting
> and/or use your session-id as an identifier. Always use relative updates
> when you must update a value.
>
> Do not write
>
> SELECT count from article WHERE id = '$id'
>
> $count++
>
> UPDATE count set count = '$count' WHERE id = '$id'
>
> but use
>
> UPDATE count = count + 1
>
> All these things to think about will force you to dig deep into your
script
> and if you have a script-in-a-box solution from a third party coder, you
> are definately in a difficult situation. If you know your script well, you
> will have an easier task.
>
> Please tell me about your future findings!
>
> Greets
>
> >Hello:
> >
> >We are running a large e-commerce site currently with ASP/MSSQL. The ever
> >increasing number of hits, complexity of the site and request for
reporting
> >is slowly but surely bringing us to the point were the current database
> >application is getting tired.
> >
> >Now we're thinking Linux, MySQL and clustering.
> >
> >I have been looking around a little and don't like the fact that there
are
> >no stored procedures and no triggers. However - if we cluster several
quad
> >processor machines we should be fine without.
> >
> >Right now it's all theory, and there don't seem to be a lot of articles
on
> >the web about this. At least I had no luck finding any.
> >
> >Does anybody have real life experiences with this kind of a setup? Does
> >anybody know where to find reports about this?
> >
> >I'd be greatful for any link or hint!
> >
> >Dietrich Speer
> >
> >
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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

MyISAM -> InnoDB

[Dan Cumpian]

Hello,

I have a database that, I now realize, could use the benefits of
row-locking and non-blocking SELECTs. So, I guess I need to change over
to InnoDB tables. How do I convert my existing data structures (and the
data they contain) into InnoDB tables?

Also, Is there anything that MyISAM tables support (query-wise, like
INSERT DELAYED), that is not supported by InnoDB that I might need to
look out for in my application(s)?

Thanks,
Dan Cumpian




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

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: E-Commerce, db-clustering and MySQL?

[Björn Pålsson]

First, I wish to say that you are making the right descision leaving M$ and
taking a step into MySQL.

Currently, I'm working on a project involving +500.000 rows and estimated
30.000 visitors / day on a 2 x dual 2.8 GHz Xeon dedicated for SQL.
Additional servers are for HTTP and other tasks. There will be a lot of
load on the SQL when the users searches our database on either category,
area or on a fulltext keyword.

The key to managing thousands of visitors is to have a system setup to
minimize the number of querys and managing the traffic between the diffrent
machines. We will use a second gigabit-switch and a secondary net on the
10.0.0.0 to unload our primary public switch. We also have pre-cached pages
with the most popular products/listings. In our case, the visitor may input
data and therefore he will trigger a re-cache. A separate machine is used
for this purpose as this may happen very often. 

To make a user allowed to input data you must setup the servers in a ring
with each server acting as both master and slave. If you have a clean
system with very few inserts/updates you may choose a simpler solution with
a single master an several slaves f.x. if the only insert is in the
checkout in a webshop. If you have click counters, this simple solution
will fall.

If you have the ring-solution, you must make shure your script never makes
any contradicting inserts. Use auto_increment if possible when inserting
and/or use your session-id as an identifier. Always use relative updates
when you must update a value.

Do not write

SELECT count from article WHERE id = '$id'

$count++

UPDATE count set count = '$count' WHERE id = '$id'

but use 

UPDATE count = count + 1

All these things to think about will force you to dig deep into your script
and if you have a script-in-a-box solution from a third party coder, you
are definately in a difficult situation. If you know your script well, you
will have an easier task.

Please tell me about your future findings!

Greets

>Hello:
>
>We are running a large e-commerce site currently with ASP/MSSQL. The ever
>increasing number of hits, complexity of the site and request for reporting
>is slowly but surely bringing us to the point were the current database
>application is getting tired.
>
>Now we're thinking Linux, MySQL and clustering.
>
>I have been looking around a little and don't like the fact that there are
>no stored procedures and no triggers. However - if we cluster several quad
>processor machines we should be fine without.
>
>Right now it's all theory, and there don't seem to be a lot of articles on
>the web about this. At least I had no luck finding any.
>
>Does anybody have real life experiences with this kind of a setup? Does
>anybody know where to find reports about this?
>
>I'd be greatful for any link or hint!
>
>Dietrich Speer
>
>


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

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

Date field

[Sam4Software]

Hi.

I am trying to store a date in the following format '08/12/2002' pr '08/12/2002' or 
any other format if I have to ...on SQLServer 7.

Basically I want to use

TodaysDate = Date' Date is the system date function
 
strSQL = "SELECT * FROM CallBacks WHERE CallDate =" & TodaysDate

Is there any good way to follow please ??

Many thanks in advance.

Sam

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

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

RE: May someone try this script under Mandrake 9 and Mysql 4.0.5

[Adolfo Bello]

Thanks a lot. I´ll stick to 3.23.53 until 4.0.6 appears.

Adolfo

> -Original Message-
> From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] 
> Sent: Sunday, December 08, 2002 4:21 PM
> To: [EMAIL PROTECTED]
> Subject: Re: May someone try this script under Mandrake 9 and 
> Mysql 4.0.5
> 
> 
> Adolfo,
> 
> - Original Message -
> From: ""Adolfo Bello"" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.mysql
> Sent: Sunday, December 08, 2002 12:47 AM
> Subject: May someone try this script under Mandrake 9 and Mysql 4.0.5
> 
> 
> > I have used a database creation script for months under 3.23.53a.
> >
> > Now, I want to upgrade to version 4.0.5 and the script 
> doesn't work. 
> > The first table is created but mysql complains with:
> >
> > Error 1005 at line 10 Can't create table ./dbdir/tblbasestados.frm
> > (errno:150)
> >
> > = = = SCRIPT TO TRY = = =
> > CREATE TABLE tblbasregiones(
> > intregion INTEGER PRIMARY KEY,
> > strregion VARCHAR(30) NOT NULL
> > ) TYPE=InnoDB ;
> >
> > CREATE TABLE tblbasestados( // this is line 10
> > intestado INTEGER PRIMARY KEY,
> > strestado VARCHAR(50) NOT NULL,
> > intregion INTEGER NOT NULL,
> > INDEX(intregion),
> > FOREIGN KEY (intregion)
> > REFERENCES tblbasregiones(intregion)
> > ON DELETE RESTRICT ON UPDATE CASCADE
> > ) TYPE=InnoDB ;
> > = = = END OF SCRIPT = = =
> >
> > I just can't spot what's wrong and want to know if there is 
> something 
> > wrong in my installation.
> 
> InnoDB does not support ON UPDATE CASCADE yet, though the 
> support may be available already in 4.0.6.
> 
> 3.23 just ignores the ON UPDATE clause, but 4.0.5 gives an 
> error 150 from it.
> 
> > Thanks in advance,
> >
> > Adolfo
> 
> Best regards,
> 
> Heikki Tuuri
> Innobase Oy
> ---
> Order technical MySQL/InnoDB support at 
> https://order.mysql.com/ See > http://www.innodb.com for the 
> online manual and latest news on InnoDB
> 
> sql query
> 
> 
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 
> 
> 


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

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: mi_test_all error help

[Lenz Grimmer]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi,

please do not send questions to me directly - send them to our mailing
list instead (Cc:ed on this message again).

On Thu, 5 Dec 2002, shawn xu wrote:

> I am new to MySQL, and I don't know what you said
> about GNU version. Would you please expain it more?

Sure!

> I just downloaded from www.mysql.com's source code. I don't know it is
> GNU version or not?
>
>  --- Lenz Grimmer <[EMAIL PROTECTED]> wrote: > -BEGIN
>
> > > After untarring it, it passed ./configure --prefix=/usr/local/mysql.
> > > But when I run make, finally it says
> > >
> > > make: don't know how to make mi_test_all. Stop
> > >
> > > *** Error code 1
> > >
> > > Your help will be appreciated
> >
> > Is this GNU make? Make sure to use the GNU version.

Yes, the MySQL version you downloaded is of course licensed under the GNU
General Public License (GPL). What I was referring to was the version of
"make" you are using on your system - "make" must be a GNU make. You can
verify this by running "make --version", which should give you an output
similar to this:

[SNIP]
GNU Make version 3.79.1, by Richard Stallman and Roland McGrath.
Built for i686-pc-linux-gnu
Copyright (C) 1988, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 2000
Free Software Foundation, Inc.
This is free software; see the source for copying conditions.
There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A
PARTICULAR PURPOSE.

Report bugs to <[EMAIL PROTECTED]>.
[SNIP]

MySQL requires GNU make for compiling - if you don't have it, please
download and install it first.

Bye,
LenZ
- -- 
For technical support contracts, visit https://order.mysql.com/?ref=mlgr
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /  Mr. Lenz Grimmer <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer
/_/  /_/\_, /___/\___\_\___/ Hamburg, Germany
   <___/   www.mysql.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.0 (GNU/Linux)
Comment: For info see http://quantumlab.net/pine_privacy_guard/

iD8DBQE9864ZSVDhKrJykfIRAkJ8AJ9koKdBHHH30XMV/c9YFLFTNpBCjACfZMvU
iKehD4ebvgOyDbXgAa0nv0M=
=Mlne
-END PGP SIGNATURE-


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

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

RE: Can't connect error 10061 - nothing but Mascon works remotely.

[Daevid Vincent]

Error No. 2003
Can't connect to MySQL server on 'daevid.com'(10061)

This is the same error I get with all the other programs too...

No SSH or SSL.

I'm connecting from my WinXP box to my Linux server over my local LAN.

> -Original Message-
> From: Karam Chand [mailto:[EMAIL PROTECTED]] 
> Sent: Friday, December 06, 2002 8:55 PM
> To: Daevid Vincent
> Subject: RE: Can't connect error 10061 - nothing but Mascon 
> works remotely.
> 
> 
> Can you send me some details like:
> 
> - The error msg. that SQLYog is reporting.
> - Are you using SSH or SSL?
> - Are you able to connect thru mysql.exe ( console
> client to mysql )
> 
> 
> 
> 
> --- Daevid Vincent <[EMAIL PROTECTED]> wrote:
> > Yes. I've done this all before, and I am aware of
> > the RH8 glibc issue,
> > but I thought that the current RPMS on the mysql
> > site fixed that. 'cept
> > it doesn't. I don't understand why mascon works but
> > other windows
> > clients don't work when everything else is the same.
> > 
> > > -Original Message-
> > > From: Karam Chand [mailto:[EMAIL PROTECTED]]
> > 
> > > Sent: Thursday, December 05, 2002 9:02 PM
> > > To: Daevid Vincent
> > > Subject: Re: Can't connect error 10061 - nothing
> > but Mascon
> > > works remotely.
> > > 
> > > 
> > > Are you trying to access Linux MySQL from a
> > Windows
> > > machine?
> > > 
> > > If yes, you can try SQLYog at
> > http://www.webyog.com
> > > 
> > > __
> > > Do you Yahoo!?
> > > Yahoo! Mail Plus - Powerful. Affordable. Sign up
> > now.
> > http://mailplus.yahoo.com
> > 
> 
> 
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> 


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

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

Re: May someone try this script under Mandrake 9 and Mysql 4.0.5

[Heikki Tuuri]

Adolfo,

- Original Message -
From: ""Adolfo Bello"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Sunday, December 08, 2002 12:47 AM
Subject: May someone try this script under Mandrake 9 and Mysql 4.0.5


> I have used a database creation script for months under 3.23.53a.
>
> Now, I want to upgrade to version 4.0.5 and the script doesn't work. The
> first table is created but mysql complains with:
>
> Error 1005 at line 10 Can't create table ./dbdir/tblbasestados.frm
> (errno:150)
>
> = = = SCRIPT TO TRY = = =
> CREATE TABLE tblbasregiones(
> intregion INTEGER PRIMARY KEY,
> strregion VARCHAR(30) NOT NULL
> ) TYPE=InnoDB ;
>
> CREATE TABLE tblbasestados( // this is line 10
> intestado INTEGER PRIMARY KEY,
> strestado VARCHAR(50) NOT NULL,
> intregion INTEGER NOT NULL,
> INDEX(intregion),
> FOREIGN KEY (intregion)
> REFERENCES tblbasregiones(intregion)
> ON DELETE RESTRICT ON UPDATE CASCADE
> ) TYPE=InnoDB ;
> = = = END OF SCRIPT = = =
>
> I just can't spot what's wrong and want to know if there is something
> wrong in my installation.

InnoDB does not support ON UPDATE CASCADE yet, though the support may be
available already in 4.0.6.

3.23 just ignores the ON UPDATE clause, but 4.0.5 gives an error 150 from
it.

> Thanks in advance,
>
> Adolfo

Best regards,

Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and latest news on InnoDB

sql query




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

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

RE: mysql_installdb crashes on RedHat 8.0 ?

[Brian Ipsen]

Hi,

 Just for information - the stack trace gives:

0x808fdfc _Z15handle_segfaulti + 460
0x815adb8 __pthread_sighandler + 116
0x8171636 __strtol_internal + 1390
0x8098378
_Z17add_field_to_listPc16enum_field_typesS_S_jP4ItemS_P10st_typelib + 344
0x809aacb _Z7yyparsev + 3419
0x8092cdd _Z16handle_bootstrapPv + 669

/Brian

> -Original Message-
> From: Brian Ipsen [mailto:[EMAIL PROTECTED]]
> Sent: 8. december 2002 20:47
> To: [EMAIL PROTECTED]
> Subject: mysql_installdb crashes on RedHat 8.0 ?
>
>
> Hi!
>
>  I just compiled 3.23.53 on my RedHat 8.0 box - but when trying
> to start the
> mysql daemon, my init.d script tries to initialize the required
> tables. But
> this fails:
>
> Preparing db table
> Preparing host table
> Preparing user table
> Preparing func table
> Preparing tables_priv table
> Preparing columns_priv table
> Installing all prepared tables
> mysqld got signal 11;
> This could be because you hit a bug. It is also possible that this binary
> or one of the libraries it was linked agaist is corrupt, improperly built,
> or misconfigured. This error can also be caused by malfunctioning
> hardware.
> We will try our best to scrape up some info that will hopefully help
> diagnose
> the problem, but since we have already crashed, something is definitely
> wrong
> and this may fail
>
> key_buffer_size=67104768
> record_buffer=1044480
> sort_buffer=4194296
> max_used_connections=0
> max_connections=100
> threads_connected=1
> It is possible that mysqld could use up to
> key_buffer_size + (record_buffer + sort_buffer)*max_connections = 577131 K
> bytes of memory
> Hope that's ok, if not, decrease some variables in the equation
>
> Attempting backtrace. You can use the following information to find out
> where mysqld died. If you see no messages after this, something went
> terribly wrong...
> Stack range sanity check OK, backtrace follows:
> 0x808fdfc
> 0x815adb8
> 0x8171636
> 0x8098378
> 0x809aacb
> 0x8092cdd
> Stack trace seems successful - bottom reached
> Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow
> instructions on how to resolve the stack trace. Resolved
> stack trace is much more helpful in diagnosing the problem, so please do
> resolve it
> Trying to get some variables.
> Some pointers may be invalid and cause the dump to abort...
> thd->query at 0x8287580 =  CREATE TABLE db (   Host char(60)
> binary DEFAULT
> '' NOT NULL,   Db char(64) binary DEFAULT '' NOT NULL,   User char(16)
> binary DEFAULT '' NOT NULL,   Select_priv enum('N','Y') DEFAULT 'N' NOT
> NULL,   Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL,   Update_priv
> enum('N','Y') DEFAULT 'N' NOT NULL,   Delete_priv enum('N','Y')
> DEFAULT 'N'
> NOT NULL,   Create_priv enum('N','Y') DEFAULT 'N' NOT NULL,   Drop_priv
> enum('N','Y') DEFAULT 'N' NOT NULL,   Grant_priv enum('N','Y') DEFAULT 'N'
> NOT NULL,   References_priv enum('N','Y') DEFAULT 'N' NOT NULL,
> Index_priv
> enum('N','Y') DEFAULT 'N' NOT NULL,   Alter_priv enum('N','Y') DEFAULT 'N'
> NOT NULL, PRIMARY KEY Host (Host,Db,User), KEY User (User) )
> comment='Database privileges'
> thd->thread_id=1
>
> Some info from mysqlbug:
>
> >Release:   mysql-3.23.53 (Source distribution)
>
> >Environment:
> 
> System: Linux laforge.andebakken.dk 2.4.18-18.8.0 #1 Thu Nov 14
> 00:10:29 EST
> 2002 i686 i686 i386 GNU/Linux
> Architecture: i686
>
> Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
> /usr/bin/cc
> GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs
> Configured with:
> ../configure --prefix=/usr --mandir=/usr/share/man
> --infodir=/usr/share/info
>  --enable-shared --enable-threads=posix
>  --disable-checking --host=i386-redhat-linux --with-system-zlib
> --enable-__c
> xa_atexit
> Thread model: posix
> gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
> Compilation info: CC='gcc'
>  CFLAGS='-static -march=i686 -mcpu=i686 -funroll-loops'  CXX='g++'
> CXXFLAGS='-static -march=i686 -mcpu=i
> 686 -funroll-loops -felide-constructors -fno-exceptions -fno-rtti'
> LDFLAGS=''
> LIBC:
> lrwxrwxrwx1 root root   14 Dec  8 18:25 /lib/libc.so.6 ->
> libc-2.2.93.so
> -rwxr-xr-x1 root root  1235468 Sep  6 01:12
> /lib/libc-2.2.93.so
> -rw-r--r--1 root root  2233342 Sep  6 00:59 /usr/lib/libc.a
> -rw-r--r--1 root root  178 Sep  6 00:50 /usr/lib/libc.so
> Configure command:
> ./configure --prefix=/opt/mysql --libexecdir=/usr/sbin
> --localstatedir=/opt/
> mysql --sysconfdir=/etc --mandir=/usr
> /share/man --disable-shared --with-mysqld-user=mysql
> --with-unix-socket-path
> =/var/lib/mysql/mysql.sock --with-client-ldflags=-all-static
> --with-mysqld-l
> dflags=-all-static --without-debug --without-docs --without-bench
> 'CFLAGS=-static -march=i686 -mcpu=i686 -funrol l-loops'
> 'CXXFLAGS=-static -march=i686 -mcpu=i686 -funroll-loops
> -felide-constructors
>  -fno-exceptions -fno-rtti'
>
> Does anyone know how I get this problem solved ?? Using the
> Re

Re: Reading logs

[Heikki Tuuri]

Amittai,

- Original Message -
From: ""Amittai Aviram"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Sunday, December 08, 2002 9:46 PM
Subject: Reading logs


> In both the MySQL manual and Paul DuBois superb _MySQL_, I find
information
> about turning logging on, rotating log files, and maintaining log files --
> but I still do not understand how I am supposed to _read_ a log file.  I
am
> running MySQL 4.0.5-max-debug under Windows XP.  If I issue the bare
command
> mysqlbinlog, I get a torrent of help info telling me what commands I'm
> allows to issue, including the formula mysqlbinlog [options] log-files.
OK,
> I guess that means that I'm supposed to specify the log file or log files.
> So I look in the data directory and find, not one, but four different
files
> that seem appropriately named:
>
> ib_arch_log_0
> ib_logfile0
> ib_logfile1
> ibdata1
>
> If I try any of these without a path, I get "file not found."  If I
specify
> the full path, I get, in every case, "ERROR: File is not a binary log
file."
>   What am I supposed to do?

you should use mysqlbinlog to one of the files whose name is something like

yourhostname-bin.005

in the datadir of MySQL. I assume you have added the line

log-bin

to the [mysqld] section of your my.cnf or my.ini, so that mysqld knows to
produce these binlog files.

The files you listed above are InnoDB files, not binlog files.

> Thanks.
>
> Amittai

Best regards,

Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row level locking, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com

sql query




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

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

Re: Question about SLAVE STOP

[Heikki Tuuri]

Hi!

I was able to break replication with a single SLAVE STOP command in 4.0.6.

I ran an InnoDB stress test ibtest17.

>From the printout below we see that after SLAVE START immediately we got a
foreign key error in the slave. That shows the slave no longer was identical
to the master, since only successful SQL statements are logged in the
master.

heikki@hundin:~/mysql-4.0/sql>
mysqld --defaults-file=/home/heikki/slavemy.cnf
021208 20:39:45  InnoDB: Started
mysqld: ready for connections
021208 20:39:45  Slave I/O thread: connected to master
'slaveuser@hundin:3307',
 replication started in log 'FIRST' at position 4



021208 20:40:04  Slave I/O thread exiting, read up to log 'binlog.001',
position
 8634144
021208 20:40:04  Slave SQL thread exiting, replication stopped in log
'binlog.0
01' at position 8630891



ERROR: 1216  Cannot add a child row: a foreign key constraint fails
021208 20:40:12  Slave: error 'Cannot add a child row: a foreign key
constraint
fails' on query 'insert into ibtest17b (D, B, C) values (LAST_INSERT_ID(),
'
' ,'y')', error_code=1216
021208 20:40:12  Error running query, slave SQL thread aborted. Fix the
problem,
 and restart the slave SQL thread with "SLAVE START". We stopped at log
'binlog.
001' position 8630891
021208 20:40:12  Slave I/O thread: connected to master
'slaveuser@hundin:3307',
 replication started in log 'binlog.001' at position 8634144



We can say that SLAVE STOP cannot currently be used at all when you have
transactions bigger than a single SQL statement running.

I am forwarding this to the replication developer of MySQL AB. He must fix
SLAVE STOP.

Best regards,

Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com

sql query




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

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

mysql_installdb crashes on RedHat 8.0 ?

[Brian Ipsen]

Hi!

 I just compiled 3.23.53 on my RedHat 8.0 box - but when trying to start the
mysql daemon, my init.d script tries to initialize the required tables. But
this fails:

Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked agaist is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose
the problem, but since we have already crashed, something is definitely
wrong
and this may fail

key_buffer_size=67104768
record_buffer=1044480
sort_buffer=4194296
max_used_connections=0
max_connections=100
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (record_buffer + sort_buffer)*max_connections = 577131 K
bytes of memory
Hope that's ok, if not, decrease some variables in the equation

Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Stack range sanity check OK, backtrace follows:
0x808fdfc
0x815adb8
0x8171636
0x8098378
0x809aacb
0x8092cdd
Stack trace seems successful - bottom reached
Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow
instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x8287580 =  CREATE TABLE db (   Host char(60) binary DEFAULT
'' NOT NULL,   Db char(64) binary DEFAULT '' NOT NULL,   User char(16)
binary DEFAULT '' NOT NULL,   Select_priv enum('N','Y') DEFAULT 'N' NOT
NULL,   Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL,   Update_priv
enum('N','Y') DEFAULT 'N' NOT NULL,   Delete_priv enum('N','Y') DEFAULT 'N'
NOT NULL,   Create_priv enum('N','Y') DEFAULT 'N' NOT NULL,   Drop_priv
enum('N','Y') DEFAULT 'N' NOT NULL,   Grant_priv enum('N','Y') DEFAULT 'N'
NOT NULL,   References_priv enum('N','Y') DEFAULT 'N' NOT NULL,   Index_priv
enum('N','Y') DEFAULT 'N' NOT NULL,   Alter_priv enum('N','Y') DEFAULT 'N'
NOT NULL, PRIMARY KEY Host (Host,Db,User), KEY User (User) )
comment='Database privileges'
thd->thread_id=1

Some info from mysqlbug:

>Release:   mysql-3.23.53 (Source distribution)

>Environment:

System: Linux laforge.andebakken.dk 2.4.18-18.8.0 #1 Thu Nov 14 00:10:29 EST
2002 i686 i686 i386 GNU/Linux
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs
Configured with:
../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info
 --enable-shared --enable-threads=posix
 --disable-checking --host=i386-redhat-linux --with-system-zlib --enable-__c
xa_atexit
Thread model: posix
gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
Compilation info: CC='gcc'
 CFLAGS='-static -march=i686 -mcpu=i686 -funroll-loops'  CXX='g++'
CXXFLAGS='-static -march=i686 -mcpu=i
686 -funroll-loops -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
LIBC:
lrwxrwxrwx1 root root   14 Dec  8 18:25 /lib/libc.so.6 ->
libc-2.2.93.so
-rwxr-xr-x1 root root  1235468 Sep  6 01:12 /lib/libc-2.2.93.so
-rw-r--r--1 root root  2233342 Sep  6 00:59 /usr/lib/libc.a
-rw-r--r--1 root root  178 Sep  6 00:50 /usr/lib/libc.so
Configure command:
./configure --prefix=/opt/mysql --libexecdir=/usr/sbin --localstatedir=/opt/
mysql --sysconfdir=/etc --mandir=/usr
/share/man --disable-shared --with-mysqld-user=mysql --with-unix-socket-path
=/var/lib/mysql/mysql.sock --with-client-ldflags=-all-static --with-mysqld-l
dflags=-all-static --without-debug --without-docs --without-bench
'CFLAGS=-static -march=i686 -mcpu=i686 -funrol l-loops'
'CXXFLAGS=-static -march=i686 -mcpu=i686 -funroll-loops -felide-constructors
 -fno-exceptions -fno-rtti'

Does anyone know how I get this problem solved ?? Using the Redhat supplied
mysql is not good enough for me, sine I need to have my files located in
another manner.

Regards,

/Brian


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

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

Reading logs

[Amittai Aviram]

In both the MySQL manual and Paul DuBois superb _MySQL_, I find information
about turning logging on, rotating log files, and maintaining log files --
but I still do not understand how I am supposed to _read_ a log file.  I am
running MySQL 4.0.5-max-debug under Windows XP.  If I issue the bare command
mysqlbinlog, I get a torrent of help info telling me what commands I'm
allows to issue, including the formula mysqlbinlog [options] log-files.  OK,
I guess that means that I'm supposed to specify the log file or log files.
So I look in the data directory and find, not one, but four different files
that seem appropriately named:

ib_arch_log_0
ib_logfile0
ib_logfile1
ibdata1

If I try any of these without a path, I get "file not found."  If I specify
the full path, I get, in every case, "ERROR: File is not a binary log file."
  What am I supposed to do?

Thanks.

Amittai



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

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

[Paul DuBois]

At 9:25 -0800 12/8/02, Ryan McDougall wrote:

Hi thanx for the details... Ok I know I am thick... and for some reason I
cannot get my head around this, let me try to explain what I want to do then
maybe you can tell me its possible and how it is possible.

I want to create a user that can be creative as he wants... allow 
him to create
ANY databases he wants and delete them if he no longer needs them, but at that
same time not be able to mess with ANY other privileges or anyone elses DBs.

That's not how it works.   You can grant privileges for "any database",
but you can't grant privileges for "any database except certain databases".

One thing that may help is that you can use a pattern to specify the
database name in the GRANT statement.  Then the user can create any database
that has a name matching the pattern.  For example, GRANT ALL ON "xyz%".* ...
will allow the user to create and mess with any database having a name
that begins with "xyz".


The only other way I can think of it to compare it to a windows 
situation. Lets
say I'm in Windows and I start up MS Access... Now with me being a 
Windows user
I can create any DB I want and do whatever I want to the DBs I've created (as
long as its not in a read only folder) but I can't see or do 
anything to to the
other peoples creations becuase I don't have permissions to do so.

Am I going to have to, as root or another super user, create his DBs for him
and then give him privileges to them? I just don't get how that sort of
situation works in a production environment. But then again in a production
environment you don't usually have people just creating DBs at will.

Again sorry for my complete lack of understanding on this and 
stupidity, but my
brain just will not wrap itself around this issue.

You're probably trying to understand the MySQL privilege system as analogous
to some other type of privilege system.  Try to understand it as itself and
you'll probably get farther.



Thanx for all the help so far,
Ryan McDougall



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

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: E-Commerce, db-clustering and MySQL? Thanks to all!

[Dietrich Speer]

Thanks to everybody who helped me with this!


- Original Message -
From: "Brian P. Austin" <[EMAIL PROTECTED]>
To: "Dietrich Speer" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, December 08, 2002 9:01 AM
Subject: RE: E-Commerce, db-clustering and MySQL?


> There is no clustering in MySQL.  Replication features allow something
> similar.
>
> In my opinion, the reason I prefer MySQL is the fact that the basics are
> there to do what ever you need to.
> You are responsible for making the solution, not the vendor.
>
> Multiple MySQL slave servers, and multiple webservers with heartbeat or
> something similar to spread the web load, and some nifty programming
> can usually solve high load problems with MySQL.
>
> The lack of all the "advanced features" in MySQL is what makes it a joy to
> work with. (you get to be creative:)
>
> plus  the people hear on the lists are really good at helping in those
> "clustering" situations, when you get specific.
>
> As for people with wxperience in this,  I do high load stuff alot, you
just
> have to read the manual thouroghly and try out different techniques.
>
> I hope this helps at least somewhat.
>
> brian
>
> -Original Message-
> From: Dietrich Speer [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, December 07, 2002 6:20 PM
> To: [EMAIL PROTECTED]
> Subject: E-Commerce, db-clustering and MySQL?
>
>
> Hello:
>
> We are running a large e-commerce site currently with ASP/MSSQL. The ever
> increasing number of hits, complexity of the site and request for
reporting
> is slowly but surely bringing us to the point were the current database
> application is getting tired.
>
> Now we're thinking Linux, MySQL and clustering.
>
> I have been looking around a little and don't like the fact that there are
> no stored procedures and no triggers. However - if we cluster several quad
> processor machines we should be fine without.
>
> Right now it's all theory, and there don't seem to be a lot of articles on
> the web about this. At least I had no luck finding any.
>
> Does anybody have real life experiences with this kind of a setup? Does
> anybody know where to find reports about this?
>
> I'd be greatful for any link or hint!
>
> Dietrich Speer
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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

Exam takers near Columbia, SC

[Amittai Aviram]

Anybody out there planning to take the new MySQL Core Certification Exam
anytime soon and anywhere near Columbia, South Carolina, USA?  It might be
nice to chat on the phone and compare notes or whatever.  Thanks!

Amittai



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

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: Record Lock?

[Richard Reina]

Benjamin Pflugmann wrote:


Hello.

On Sat 2002-12-07 at 14:15:59 -0800, [EMAIL PROTECTED] wrote:
 

I would like to lock a specific record in a MySQL table so that no other 
user can update it while another user is is update the record via the 
user interface.  Can someone please tell me the easiest way to do this?
   


Depends on the table handler. With MYISAM, you can only lock the whole
table (via LOCK TABLE). So you would rather refrain from that way of
assuring no change has made.

With InnoDB you can lock a row by selecting it:


Ben, thanks so much for your respoonse.

How do I switch from MYISAM to InnoDB?  Are there any negative 
implication in swithing?


 SELECT *
 FROM your_table
 WHERE 
 FOR UPDATE

will lock that row for you. Of course, only as long as you keept the
connection open.


But usually it is a bad idea to implement application level locks by
using database locks.


I agree but it's only for in the office use on a small LAN so we could 
just walk over to the offending person computer and get them out -- 
atleast until I get some sort of timeout mechanism in place.

What if I leave my computer? You have to
implement some kind of timeout. And so on. Better to implement
conflict handling correctly from the start.


Any ideas here are of course welcomed. :-)



HTH,

	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: MySQL user privilages

[Ryan McDougall]

Hi thanx for the details... Ok I know I am thick... and for some reason I
cannot get my head around this, let me try to explain what I want to do then
maybe you can tell me its possible and how it is possible.

I want to create a user that can be creative as he wants... allow him to create
ANY databases he wants and delete them if he no longer needs them, but at that
same time not be able to mess with ANY other privileges or anyone elses DBs.
The only other way I can think of it to compare it to a windows situation. Lets
say I'm in Windows and I start up MS Access... Now with me being a Windows user
I can create any DB I want and do whatever I want to the DBs I've created (as
long as its not in a read only folder) but I can't see or do anything to to the
other peoples creations becuase I don't have permissions to do so.

Am I going to have to, as root or another super user, create his DBs for him
and then give him privileges to them? I just don't get how that sort of
situation works in a production environment. But then again in a production
environment you don't usually have people just creating DBs at will.

Again sorry for my complete lack of understanding on this and stupidity, but my
brain just will not wrap itself around this issue.

Thanx for all the help so far,
Ryan McDougall
--- "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]> wrote:
> Dear Ryan,
> 
> have a look at the manual:
> 
> http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
> inistration.html#User_Account_Management
> 
> With the exception of Paul's book on MySQL, you probably won't find a better
> explanation of the MySQL privilege system.
> 
> > PLEASE I'M GOING CRAZY trying to figure this out... my book doesn't say
> > anything about what EXACTLY a user can/can't touch with which privilages
> 
> Just in short:
> 
> Put this in my.cnf / my.ini:
> 
> [mysqld]
> safe-show-database
> 
> This will prevent MySQL users to see databases to which they have no access
> privilege. Starting with MySQL 4.0.5a, this have changed. Now, there is a
> special privilege "show_database" which is set to "N" by default.
> safe-show-database will still work, though.
> 
> > grant select,insert,update,delete,create,drop
> > on somedb.* to someusr@"%" identified by 'passwrd';
> 
> This means, someusr can access the somedb database and all its tables from
> anywhere (%). someusr can create and drop tables, and might even drop
> database somedb, but cannot add or drop any other databases. So this should
> be exactly what you want.
> 
> If applicable, you may want to restrict the access to something which is not
> "%", but rather something like "192.168.%" (e. g. intranet users) or even
> "62.115.92.78" (if your users have a static ip address).
> 
> HTH!
> --
>   Stefan Hinz <[EMAIL PROTECTED]>
>   CEO / Geschäftsleitung iConnect GmbH 
>   Heesestr. 6, 12169 Berlin (Germany)
>   Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3
> 

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

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

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

Re: LOAD DATA command

[Beauford.2003]

If your using a Linux machine try using this when logging on to mysql:

mysql --local-infile=1 -u username -p

Not sure about Windows.

There is apparently a security issue with this so it is not enable by
default. Can't remember where I read this, but the above works for me.

Beauford

- Original Message -
From: "Insanely Great" <[EMAIL PROTECTED]>
To: "Padma kuruganti" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, December 07, 2002 12:32 PM
Subject: Re: LOAD DATA command


> Greetings...
>
> Are you using Windows to connect to the MySQL. Then you can try SQLyog at
> http://www.webyog.com/sqyog/download.html It will help you a lot in these
> works and you dont have to write queries also.
>
> Rgds
> Insane
>
> - Original Message -
> From: "Padma kuruganti" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, December 07, 2002 12:46 AM
> Subject: LOAD DATA command
>
>
> > Hi I just downloaded version 3.23.53 for evaluation.
> > when I try to use LOAD DATA LOCAL INFILE 'some.txt"
> > into TABLE sometable I get a message saying 'the used
> > command is not allowed in this version of mySQL. IS
> > there any update on this? I could not find any info on
> > your web site.
> > Thanks
> > KP
> >
> > __
> > Do you Yahoo!?
> > Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> > http://mailplus.yahoo.com
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>



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

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

Fw: Thanks

[Beauford.2003]

Thanks to all who recently answered some of my MySQL questions, although I
am still having some problems with the concept of joins, but what I have
figured out certainly does make it more efficient and versatile. I have
managed to eliminate two tables (actually combine them into one) which made
my searches easier.

Thanks again, Beauford




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

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

RE: How is DBTools Software?

[Michael She]

MySQL-Front isn't being developed anymore right?


Anyhow, the last version I used was very very buggy.


At 06:37 AM 12/8/2002 -0400, Chris Mason wrote:

I've found mysql-front to be far superior, in fact, I can't complain
about it at all.

-Original Message-
From: Michael She [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 07, 2002 3:27 PM
To: Will Standley
Cc: Sandeep Murphy; Crercio O. Silva; MySQL List
Subject: Re: How is DBTools Software?


Hi,

I used it for a while, it's quite good for free software, but it is
rough
around the edges.  Some of the menus are a bit hard to navigate and it
crashes once in a while too.

I'm currently using EMS Hitech's MySQL Manager.  It's one of the best
GUI's
I've come across.  There are a couple of glitches with the program, but
nothing severe.  The author is really responsive in returning questions
and
comments.  The only drawback - It's not free...

http://www.ems-hitech.com/mymanager

I'm debating if I should register it (might go back to DB Tools), but
that's because I'm building a charity/non-profit site and funds are kind
of
tight!


At 08:15 AM 12/7/2002 -0500, Will Standley wrote:
>Has anyone used DBTools Software? (http://www.dbtools.com.br/EN/)
>
>It is a free utility for managing MySQL & other db's.
>
>I also discovered Intelligent Converters at www.convert-in.com
>
>Both look good.
>
>The first is free and does more than convert Access to MySQL.
>
>The second converts more stuff... like Excel to MySQL.
>
>All comments encouraged.

--
Michael She  : [EMAIL PROTECTED]
Mobile   : (519) 589-7309
WWW Homepage : http://www.binaryio.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

--
Michael She  : [EMAIL PROTECTED]
Mobile   : (519) 589-7309
WWW Homepage : http://www.binaryio.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: How is DBTools Software?

[Insanely Great]

Greetings

I like SQLyog. http://www.webyog.com/sqlyog/download.html

Rgds
Insane

- Original Message -
From: "Chris Mason" <[EMAIL PROTECTED]>
To: "'MySQL List'" <[EMAIL PROTECTED]>
Sent: Sunday, December 08, 2002 4:07 PM
Subject: RE: How is DBTools Software?


> I've found mysql-front to be far superior, in fact, I can't complain
> about it at all.
>
> -Original Message-
> From: Michael She [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, December 07, 2002 3:27 PM
> To: Will Standley
> Cc: Sandeep Murphy; Crercio O. Silva; MySQL List
> Subject: Re: How is DBTools Software?
>
>
> Hi,
>
> I used it for a while, it's quite good for free software, but it is
> rough
> around the edges.  Some of the menus are a bit hard to navigate and it
> crashes once in a while too.
>
> I'm currently using EMS Hitech's MySQL Manager.  It's one of the best
> GUI's
> I've come across.  There are a couple of glitches with the program, but
> nothing severe.  The author is really responsive in returning questions
> and
> comments.  The only drawback - It's not free...
>
> http://www.ems-hitech.com/mymanager
>
> I'm debating if I should register it (might go back to DB Tools), but
> that's because I'm building a charity/non-profit site and funds are kind
> of
> tight!
>
>
> At 08:15 AM 12/7/2002 -0500, Will Standley wrote:
> >Has anyone used DBTools Software? (http://www.dbtools.com.br/EN/)
> >
> >It is a free utility for managing MySQL & other db's.
> >
> >I also discovered Intelligent Converters at www.convert-in.com
> >
> >Both look good.
> >
> >The first is free and does more than convert Access to MySQL.
> >
> >The second converts more stuff... like Excel to MySQL.
> >
> >All comments encouraged.
>
> --
> Michael She  : [EMAIL PROTECTED]
> Mobile   : (519) 589-7309
> WWW Homepage : http://www.binaryio.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: E-Commerce, db-clustering and MySQL?

[Brian P. Austin]

There is no clustering in MySQL.  Replication features allow something
similar.

In my opinion, the reason I prefer MySQL is the fact that the basics are
there to do what ever you need to.
You are responsible for making the solution, not the vendor.

Multiple MySQL slave servers, and multiple webservers with heartbeat or
something similar to spread the web load, and some nifty programming
can usually solve high load problems with MySQL.

The lack of all the "advanced features" in MySQL is what makes it a joy to
work with. (you get to be creative:)

plus  the people hear on the lists are really good at helping in those
"clustering" situations, when you get specific.

As for people with wxperience in this,  I do high load stuff alot, you just
have to read the manual thouroghly and try out different techniques.

I hope this helps at least somewhat.

brian

-Original Message-
From: Dietrich Speer [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 07, 2002 6:20 PM
To: [EMAIL PROTECTED]
Subject: E-Commerce, db-clustering and MySQL?


Hello:

We are running a large e-commerce site currently with ASP/MSSQL. The ever
increasing number of hits, complexity of the site and request for reporting
is slowly but surely bringing us to the point were the current database
application is getting tired.

Now we're thinking Linux, MySQL and clustering.

I have been looking around a little and don't like the fact that there are
no stored procedures and no triggers. However - if we cluster several quad
processor machines we should be fine without.

Right now it's all theory, and there don't seem to be a lot of articles on
the web about this. At least I had no luck finding any.

Does anybody have real life experiences with this kind of a setup? Does
anybody know where to find reports about this?

I'd be greatful for any link or hint!

Dietrich Speer


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

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: Question about SLAVE STOP

[Heikki Tuuri]

Hi!

- Original Message -
From: "Benjamin Pflugmann" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, December 07, 2002 4:59 PM
Subject: Re: Question about SLAVE STOP


> Hello.
>
> On Sat 2002-12-07 at 14:26:00 +0100, [EMAIL PROTECTED] wrote:
> > Hello.
> >
> > On Fri 2002-12-06 at 16:13:54 -0600, [EMAIL PROTECTED]
wrote:
> > >
> > > First off, we are using Innodb tables on version 3.23.53a-max.
> > >
> > > If the command STOP SLAVE is issued in the middle of the following
type of
> > > transaction:
> > >
> > > set autocommit = 0;
> > > update...;
> > > update...;
> > > update...;
> > > commit;
> > >
> > > does it roll back the current transaction or wait for it to complete?
> [...]
> > I decided to dig in the source a bit (v3.23.46).
> [...]
> > In short, it seems the slave thread effectively runs in auto-commit
> > mode which is not what you want.
> >
> > I found a somewhat old post by Heikki (the InnoDB deveoper) which
> > basically says the same:
> >
> >   http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:79650
>
> I just happened to see in the changelog, that this is out of date. As
> of 3.23.52, it wraps BEGIN/COMMIT:
>
>   D.3.3 Changes in release 3.23.52 (14 Aug 2002)
>
> * Wrap BEGIN/COMMIT around transaction in the binary log. This
>   makes replication honour transactions.
>
> Sorry about that. Teaches me to not presume that there were no
> important changes in the last few stable releases.

a good point from Carl. It may be the slave rolls back the current
transaction if SLAVE STOP is issued in the middle of a transaction.

Thus, we may have a defect in replication: if execution was inside BEGIN ...
END, when you issue SLAVE START it should restart the slave from the latest
BEGIN in the binlog.

Since MySQL atomically writes to the binlog the records associated with a
transaction, it may be that SLAVE STOP + SLAVE START usually does not break
transactions. But it might happen.

I guess the easy solution is simply to prevent the slave from stopping when
we have a BEGIN open in the replication. It should wait for END.

I looked into the source code of 4.0.6, but I did not see how slave_stop()
and terminate_slave_thread() protect against killing the slave thread in the
middle of an SQL statement. If that is allowed, then SLAVE STOP might also
break MyISAM replication. But we have no bug reports of SLAVE STOP breaking
replication. If there is a bug, it does not occur too often.

I am forwarding this to the replication developer of MySQL AB. He has to
check the mechanisms.

> Bye,
>
> Benjamin.
>
> --
> [EMAIL PROTECTED]

Best regards,

Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com

sql query




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

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

Re: Order By or Group By Help Please

[Bill Easton]

SOLUTION 1:

It's probably simplest, conceptually, to build a temporary table which
provides the proper ordering.  The "ordering" column below is a computed
value which determines the desired orderint of the File's.  Then, you
can join with an ORDER BY clause that gives the desired order.

mysql> create temporary table temp
-> select substring(FileNumber,1,6) as File,
->min(concat(1-RUSH, PDate, PTime, substring(FileNumber,1,6)))
as ordering
-> from mytable
-> group by File;
Query OK, 7 rows affected (0.04 sec)
Records: 7  Duplicates: 0  Warnings: 0

mysql> select * from temp;
++---+
| File   | ordering  |
++---+
| 1-1023 | 012/0408:001-1023 |
| 1- | 012/0408:301- |
| 1- | 012/0406:001- |
| 1-6655 | 112/1108:401-6655 |
| 1-7654 | 012/0508:001-7654 |
| 1-9868 | 112/0514:001-9868 |
| 1- | 012/0408:001- |
++---+
7 rows in set (0.00 sec)

mysql> select mytable.* from
-> mytable, temp
-> where substring(mytable.FileNumber,1,6) = temp.File
-> order by ordering,RUSH desc,PDate,PTime;
+--++---+---+
| RUSH | FileNumber | PTime | PDate |
+--++---+---+
|1 | 1--001 | 06:00 | 12/04 |
|1 | 1-1023-001 | 08:00 | 12/04 |
|0 | 1-1023-002 | 14:00 | 12/09 |
|0 | 1-1023-003 | 11:00 | 12/10 |
|1 | 1--123 | 08:00 | 12/04 |
|0 | 1--124 | 09:30 | 12/09 |
|0 | 1--125 | 10:00 | 12/15 |
|1 | 1--000 | 08:30 | 12/04 |
|1 | 1-7654-043 | 08:00 | 12/05 |
|0 | 1-9868-000 | 14:00 | 12/05 |
|0 | 1-6655-021 | 08:40 | 12/11 |
|0 | 1-6655-022 | 13:30 | 12/15 |
+--++---+---+
12 rows in set (0.01 sec)

SOLUTION 2:

Yes, you can do it in one select statement.  You join two copies of your
table,
using one to compute the ordering.  I don't know how to get rid of the
ordering column in the result, as the expression won't work in the ORDER BY
clause.

mysql> select A.*,
->min(concat(1-B.RUSH, B.PDate, B.PTime,
substring(B.FileNumber,1,6))) as ordering
-> from mytable A, mytable B
-> where substring(A.FileNumber,1,6) = substring(B.FileNumber,1,6)
-> group by A.FileNumber
-> order by ordering, A.RUSH desc, A.PDate, A.PTime;
+--++---+---+---+
| RUSH | FileNumber | PTime | PDate | ordering  |
+--++---+---+---+
|1 | 1--001 | 06:00 | 12/04 | 012/0406:001- |
|1 | 1-1023-001 | 08:00 | 12/04 | 012/0408:001-1023 |
|0 | 1-1023-002 | 14:00 | 12/09 | 012/0408:001-1023 |
|0 | 1-1023-003 | 11:00 | 12/10 | 012/0408:001-1023 |
|1 | 1--123 | 08:00 | 12/04 | 012/0408:001- |
|0 | 1--124 | 09:30 | 12/09 | 012/0408:001- |
|0 | 1--125 | 10:00 | 12/15 | 012/0408:001- |
|1 | 1--000 | 08:30 | 12/04 | 012/0408:301- |
|1 | 1-7654-043 | 08:00 | 12/05 | 012/0508:001-7654 |
|0 | 1-9868-000 | 14:00 | 12/05 | 112/0514:001-9868 |
|0 | 1-6655-021 | 08:40 | 12/11 | 112/1108:401-6655 |
|0 | 1-6655-022 | 13:30 | 12/15 | 112/1108:401-6655 |
+--++---+---+---+
12 rows in set (0.03 sec)

From: "Roger Davis" <[EMAIL PROTECTED]>
To: "Mysql" <[EMAIL PROTECTED]>
Subject: Order By or Group By Help Please
Date: Thu, 5 Dec 2002 19:54:57 -0500

Ok, I will try this one again.

I need some help on a select if it is possible.  Take for Example the
following data.

--
| RUSH | FileNumber | PTime  | PDate |
--
|  1   | 1-1023-001 | 08:00  | 12/04 |
|  1   | 1--001 | 06:00  | 12/04 |
|  0   | 1-1023-002 | 14:00  | 12/09 |
|  1   | 1--000 | 08:30  | 12/04 |
|  0   | 1-1023-003 | 11:00  | 12/10 |
|  1   | 1--123 | 08:00  | 12/04 |
|  0   | 1--124 | 09:30  | 12/09 |
|  0   | 1-6655-021 | 08:40  | 12/11 |
|  0   | 1--125 | 10:00  | 12/15 |
|  1   | 1-7654-043 | 08:00  | 12/05 |
|  0   | 1-6655-022 | 13:30  | 12/15 |
|  0   | 1-9868-000 | 14:00  | 12/05 |
--

To end up grouped like this.

--
| RUSH | FileNumber | PTime  | PDate |
--
|  1   | 1--001 | 06:00  | 12/04 |
|  1   | 1-1023-001 | 08:00  | 12/04 |
|  0   | 1-1023-002 | 14:00  | 12/09 |
|  0   | 1-1023-003 | 11:00  | 12/10 |
|  1   | 1--123 | 08:00  | 12/04 |
|  0   | 1--124 | 09:30  | 12/09 |
|  0   | 1--125 | 10:00  | 12/15 |
|  1   | 1--000 | 08:30  | 12/04 |
|  1   | 1-7654-043 | 08:00  | 12/05 |
|  0   | 1-9868-000 | 14:00  | 12/05 |
|  0   | 1-6655-021 | 08:40  | 12/11 |
|  0   | 1-6655-022 | 13:30  | 12/15 |
--

Basically, I need this.

If it is a RUSH (1), It needs to be first
If there are duplicate files (Like 1- (it has 2 dups) or 1-1023 (2
dups)) and one of them is a rush
Th

Re: Error in Query

[Doug Thompson]

MySQL doesn't accept variables for field length values.
Your query should look something like this:


CREATE TABLE `db` 
(`host` VARCHAR(localhost) NOT NULL, 
`db` VARCHAR(64) NOT NULL,
`user` VARCHAR(64) NOT NULL,
`select_priv` CHAR(1) NOT NULL,
`insert_priv` CHAR(1) NOT NULL,
`update_priv` CHAR(1) NOT NULL,
`delete_priv` CHAR(1) NOT NULL,
`create_priv` CHAR(1) NOT NULL,
`drop_priv` CHAR(1) NOT NULL);

I inserted arbitrary values for 'db' and 'user' columns.
You should use field lengths that you choose for your
application.

The CHAR(1) type could also be BOOL. The explanation at

http://www.mysql.com/doc/en/Column_types.html

provides more detailed information.

Regards,
Doug

On Sat, 7 Dec 2002 20:50:38 -0600, Deepak Suthar wrote:

>I'm using Phpadmin to add these fields with these values, and it keeps
>crashing...what am I missing?
>
>-Deepak
>
>Error
>
>SQL-query :
>
>CREATE TABLE `db` (`host` VARCHAR(localhost) NOT NULL, `db` VARCHAR(dsuthar)
>NOT NULL, `user` VARCHAR(dsuthar) NOT NULL, `select_priv` VARCHAR(Y) NOT
>NULL, `insert_priv` VARCHAR(Y) NOT NULL, `update_priv` VARCHAR(Y) NOT NULL,
>`delete_priv` VARCHAR(Y) NOT NULL, `create_priv` VARCHAR(Y) NOT NULL,
>`drop_priv` VARCHAR(Y) NOT NULL)
On Sat, 7 Dec 2002 20:50:38 -0600, Deepak Suthar wrote:




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

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: Innodb row locking question

[Heikki Tuuri]

Mike,

- Original Message -
From: "Mike Gohlke" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, December 07, 2002 6:44 PM
Subject: Re: Innodb row locking question


>
>
> Benjamin Pflugmann wrote:
>
> >Hello.
> >
> >On Fri 2002-12-06 at 10:28:23 -0600, [EMAIL PROTECTED] wrote:
> >
...

> Because I'm not using transactions explicitly.  And the whole point of
> setting the thread id is because if thread 1 select's 5k records for
> update I'm not sure that thread 2 won't select the same 5k records.
> I've read the docs forwards and backwards and some things just aren't
> clear to me.
> If a table has 10k records and thread 1 selects the first 5k in update
> mode, when thread 2 executes a microsecond after thread 1 will it get
> the same 5k records?

yes. When MySQL or any ordinary database executes a SELECT, record locks do
not affect the row set it is going to pick. Thus, it will NOT jump over
locked records, but rather will stop to wait.

...
> >Although the name sounds otherweise, FOR UPDATE is not only suited for
> >updates. IMHO, the write lock should work for the DELETE as for the

The name FOR UPDATE comes from Oracle. A better name would be LOCK IN
EXCLUSIVE MODE.

...
> Thanks for your reply and information.  The problem is that I'm
> conservative as hell when it comes to coding and must be absolutely sure
> things will work the way they should.  Otherwise, I'll choose the
> inefficient route just because I know it's safe.

Some notes which may help:

1. I would like to clarify that InnoDB holds locks till the current
transaction
COMMIT or ROLLBACK. Thus, in the AUTOCOMMIT=1 mode it makes no sense to use
FOR UPDATE.

When MySQL ends a connection, it rolls back the current transaction. Thus,
locks are never kept after the connection ended.

2. In a MySQL UPDATE statement you can also use the LIMIT clause.

3. In an UPDATE or DELETE, InnoDB automatically sets exclusive locks on the
index records it encounters in the search for the rows to be updated or
deleted.

> Mike...

Best regards,

Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and latest news on InnoDB

sql query




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

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

Re: Record Lock?

[Heikki Tuuri]

Hi!
- Original Message -
From: "Benjamin Pflugmann" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Sunday, December 08, 2002 3:14 AM
Subject: Re: Record Lock?


> Hello.
...
> With InnoDB you can lock a row by selecting it:
>
>   SELECT *
>   FROM your_table
>   WHERE 
>   FOR UPDATE
>
> will lock that row for you. Of course, only as long as you keept the
> connection open.

I would like to clarify that InnoDB holds locks till the current transaction
COMMIT or ROLLBACK. Thus, in the AUTOCOMMIT=1 mode is makes no sense to use
FOR UPDATE.

When MySQL ends a connection, it rolls back the current transaction. Thus,
locks are never kept after the connection ended.

...
> HTH,
>
> Benjamin.

Best regards,

Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and latest news on InnoDB

sql query




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

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

mysql_install_db crashed

[shivaken]

>Originator:
>Organization:
>MySQL support: none
>Category:  mysql
>Release:   mysql-3.23.53 (Source distribution)
>Environment:

System: Linux cj1398237-a 2.5.49-ac1 #3 SMP Sun Dec 8 17:01:39 JST 2002 i686 
unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i686-pc-linux-gnu/3.2.1/specs
Configured with: /usr/src/gcc-3.2.1/configure --host=i686-pc-linux-gnu 
--prefix=/usr --enable-threads=posix --enable-languages=c,c++
Thread model: posix
gcc version 3.2.1
Compilation info: CC='gcc'  CFLAGS='-O3 '  CXX='g++'  CXXFLAGS='-O3 
-felide-constructors -fno-exceptions -fno-rtti'  LDFLAGS=' -s'
LIBC: 
lrwxrwxrwx1 root root   13 Dec  7 12:15 /lib/libc.so.6 -> 
libc-2.3.1.so
-rwxr-xr-x1 root root  1507581 Dec  7 12:15 /lib/libc-2.3.1.so
-rw-r--r--1 root root  2561994 Dec  7 12:14 /usr/lib/libc.a
-rw-r--r--1 root root  178 Dec  7 12:14 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr --enable-assembler 
--libexecdir=/usr/sbin --localstatedir=/var/mysql 
--with-mysqld-ldflags=-all-static --without-bench --with-char-set=sjis 
'CFLAGS=-O3 ' 'CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti' 
'LDFLAGS= -s'



mysql_install_db show this message.

Some pointers may be invalid and cause the dump to abort...
thd->query at 0x82a7c50 =  CREATE TABLE db (   Host char(60) binary DEFAULT '' 
NOT NULL,   Db char(64) binary DEFAULT '' NOT NULL,   User char(16) binary 
DEFAULT '' NOT NULL,   Select_priv enum('N','Y') DEFAULT 'N' NOT NULL,   
Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL,   Update_priv enum('N','Y') 
DEFAULT 'N' NOT NULL,   Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL,   
Create_priv enum('N','Y') DEFAULT 'N' NOT NULL,   Drop_priv enum('N','Y') 
DEFAULT 'N' NOT NULL,   Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL,   
References_priv enum('N','Y') DEFAULT 'N' NOT NULL,   Index_priv 
enum('N','Y') DEFAULT 'N' NOT NULL,   Alter_priv enum('N','Y') DEFAULT 'N' 
NOT NULL, PRIMARY KEY Host (Host,Db,User), KEY User (User) ) 
comment='Database privileges'
thd->thread_id=1




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

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

[Stefan Hinz, iConnect \(Berlin\)]

Dear Ryan,

have a look at the manual:

http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
inistration.html#User_Account_Management

With the exception of Paul's book on MySQL, you probably won't find a better
explanation of the MySQL privilege system.

> PLEASE I'M GOING CRAZY trying to figure this out... my book doesn't say
> anything about what EXACTLY a user can/can't touch with which privilages

Just in short:

Put this in my.cnf / my.ini:

[mysqld]
safe-show-database

This will prevent MySQL users to see databases to which they have no access
privilege. Starting with MySQL 4.0.5a, this have changed. Now, there is a
special privilege "show_database" which is set to "N" by default.
safe-show-database will still work, though.

> grant select,insert,update,delete,create,drop
> on somedb.* to someusr@"%" identified by 'passwrd';

This means, someusr can access the somedb database and all its tables from
anywhere (%). someusr can create and drop tables, and might even drop
database somedb, but cannot add or drop any other databases. So this should
be exactly what you want.

If applicable, you may want to restrict the access to something which is not
"%", but rather something like "192.168.%" (e. g. intranet users) or even
"62.115.92.78" (if your users have a static ip address).

HTH!
--
  Stefan Hinz <[EMAIL PROTECTED]>
  CEO / Geschäftsleitung iConnect GmbH 
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3


- Original Message -
From: "Ryan McDougall" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Sunday, December 08, 2002 6:39 AM
Subject: MySQL user privilages


> Hey everyone,
>
> Ok if I issue this command:
>
> mysql> grant select,insert,update,delete,create,drop
> -> on *.* to someusr@"%" identified by 'passwrd';
>
> I already know that this statement creates the user someusr w/
password=passwrd
> and it can connect from anywhere. What I don't know: Can this user now
mess up
> the privilage tables? Can this user mess with other users DBs and tables?
>
> I want to create a normal user for me that can create my own DBs and
delete
> them if I want (it my stuff anyway ) but I don't want me to be able to see
or
> do anything to anybody elses stuff. Would I then have to run this
command???
>
> mysql> grant select,insert,update,delete,create,drop
> -> on somedb.* to someusr@"%" identified by 'passwrd';
>
> And create this test DB so that this user can have initial privilages on
some
> DB then that user will be ale to create their own DBs at will?? I just
don't
> get the whole user aspect of MySQL... I want it to be like a normal *nix
user
> create their own crap and delete it if they want... but don't touch whats
not
> theirs! Is this accomplished with either of those commands, if so which
one, if
> not how do I do that?
>
> PLEASE I'M GOING CRAZY trying to figure this out... my book doesn't say
> anything about what EXACTLY a user can/can't touch with which privilages
>
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


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

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

RE: How is DBTools Software?

[Chris Mason]

I've found mysql-front to be far superior, in fact, I can't complain
about it at all.

-Original Message-
From: Michael She [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, December 07, 2002 3:27 PM
To: Will Standley
Cc: Sandeep Murphy; Crercio O. Silva; MySQL List
Subject: Re: How is DBTools Software?


Hi,

I used it for a while, it's quite good for free software, but it is
rough 
around the edges.  Some of the menus are a bit hard to navigate and it 
crashes once in a while too.

I'm currently using EMS Hitech's MySQL Manager.  It's one of the best
GUI's 
I've come across.  There are a couple of glitches with the program, but 
nothing severe.  The author is really responsive in returning questions
and 
comments.  The only drawback - It's not free...

http://www.ems-hitech.com/mymanager

I'm debating if I should register it (might go back to DB Tools), but 
that's because I'm building a charity/non-profit site and funds are kind
of 
tight!


At 08:15 AM 12/7/2002 -0500, Will Standley wrote:
>Has anyone used DBTools Software? (http://www.dbtools.com.br/EN/)
>
>It is a free utility for managing MySQL & other db's.
>
>I also discovered Intelligent Converters at www.convert-in.com
>
>Both look good.
>
>The first is free and does more than convert Access to MySQL.
>
>The second converts more stuff... like Excel to MySQL.
>
>All comments encouraged.

-- 
Michael She  : [EMAIL PROTECTED]
Mobile   : (519) 589-7309
WWW Homepage : http://www.binaryio.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