date:20010828

Re: autoincrement

2001-08-28 Thread Grigory Bakunov


Date |Tue, 28 Aug 2001 12:49:52 +0100
>From |[EMAIL PROTECTED]

Hello!

S> When you have just inserted a record into a table that autoincrements the
S> primary key,
S> is there a way of retrieving the id assigned at the same time? I'm using ASP
S> to write the 
S> code in question , and I'm trying to find a better solution that looking at
S> the max key value
S> just before/after in code, and praying no other query was run at the same
S> time. Does mysql
S> have any  feature to accomadate this?

You can use LAST_INSERT_ID() function for it.
Read for example here 
http://www.mysql.com/doc/G/e/Getting_unique_ID.html
___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
   <___/   www.mysql.com


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

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

Re: reports? from MySQL (oops, on a Mac)

2001-08-28 Thread get86

i untarred the siag app (very cool, hope it'll work) and dropped in 
my home dir.
then i ran ./configure, make  and make install...
i got:

checking host system type... configure: error: can not guess host 
type; you must specify one
configure: error: ./configure failed for XawM
[ichi:~/apps/siag-3.4.9] ichi% make
make  all-recursive
Making all in XawM
make[2]: *** No rule to make target `all'.  Stop.
make[1]: *** [all-recursive] Error 1
make: *** [all-recursive-am] Error 2
[ichi:~/apps/siag-3.4.9] ichi% make install
Making install in XawM
make[1]: Nothing to be done for `install'.
Making install in siod
Making install in docs
make[3]: Nothing to be done for `install-exec-am'.
make  install-man1
/bin/sh ../../mkinstalldirs /usr/local/man/man1
mkdir /usr/local/man
mkdir /usr/local/man/man1
make[4]: *** [install-man1] Error 1
make[3]: *** [install-man] Error 2
make[2]: *** [install-am] Error 2
make[1]: *** [install-recursive] Error 1
make: *** [install-recursive] Error 1

the readme says:

Usually `configure' can figure that out, but if it prints
a message saying it can not guess the host type, give it the
`--host=TYPE' option.  TYPE can either be a short name for the system
type, such as `sun4', or a canonical name with three fields:
  CPU-COMPANY-SYSTEM

dumb question: what do i put for macintosh G4/450 OS X?

TIA

At 11:26 AM +0500 8/29/01, Grigory Bakunov wrote:
>Date |Wed, 29 Aug 2001 00:24:25 -0400
>From |[EMAIL PROTECTED]
>
>Hello!
>
>>>i'd like to ask...
>>>if any of you are familar with (File Maker Pro, most recent
>>>versions)... how does one go about using MySQL to create a printable
>>>report? e.g., where you select the fields you wanted in the report
>>>and then create a layout and page setup for the report, (then print
>>>it)?
>
>G> Thanks again.
>G> (Mac OS 9 or X)
>
>I use for it Siag office - look to http://siag.nu/
>For example look to this screenshot http://siag.nu/siag/mysql.png
>
>___
>For technical support contracts, visit https://order.mysql.com/
>This email is sponsored by SWSoft, http://www.asplinux.ru/
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
>  / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
>/_/  /_/\_, /___/\___\_\___/
><___/   www.mysql.com

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

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

Re: Deleted mysql.host Table!

2001-08-28 Thread Grigory Bakunov


Date |Tue, 28 Aug 2001 14:16:23 +0200
>From |Steffen Hainke <[EMAIL PROTECTED]>

Hello!

SH> Hallo,

SH> i'm new to mysql. I delete a mysal.host table. Does it means i can't
SH> access the rest of my tables in the database? If so, can i rebuild this
SH> table or is there another way, to access the rest of the tables?

SH> I'am running MySQL under Linux.

SH> Thank's for Comment's, Help ...

SH> Steffen
Copy all YOUR databases files to another directory or use
mysqldump to your databases when
start mysql_install_db for restore mysql.host table.
___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
   <___/   www.mysql.com


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

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

Re: SQL syntax near 'IDENTIFIED BY'...

2001-08-28 Thread Grigory Bakunov


Date |Tue, 28 Aug 2001 15:14:54 +0500
>From |Alexander Barkov <[EMAIL PROTECTED]>

Hello!


AB> Hello!


AB> These query produces an SQL syntax error
AB> in  3.23.29a-gamma:

AB> GRANT ALL PRIVILEGES ON databases.*  
AB> TO 'foo'@'localhost' IDENTIFIED BY 'bar';

AB> SHOW TABLES FROM databases;
AB> Probably this is because of "databases" is 
AB> a keyword. However, mysqladmin does allow to
AB> create database 'databases'.
AB> Is it a bug? Or is that already fixed in 
AB> later releases?


AB> "mysqladmin create databases" does not output any
AB> error messages, however it does not create database
AB> "databases".
AB> However, "mysqladmin drop databases" produce this:

AB> /usr/local/mysql/etc/ access.grant > mysqladmin drop databases
AB> Dropping the database is potentially a very bad thing to do.
AB> Any data stored in the database will be destroyed.
AB> 
AB> Do you really want to drop the 'databases' database [y/N]
AB> y
AB> mysqladmin: drop of 'databases' failed;
AB> error: 'You have an error in your SQL syntax near 'databases' at line 1'

I'll try to do all what you write.

~| mysqladmin -u root -p create databases
Enter password: 
~|
so - create base 'databases' complete.
~| mysqladmin -u root -p drop databases
Enter password: 
Dropping the database is potentially a very bad thing to do.
Any data stored in the database will be destroyed.

Do you really want to drop the 'databases' database [y/N] y
Database "databases" dropped


In short words - mysqladmin create and drop databases not through
mysql but directly.
PS: I use 3.23.39 version.

___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
   <___/   www.mysql.com


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

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

Re: Need info

2001-08-28 Thread Grigory Bakunov


Date |28 Aug 2001 08:05:19 -
>From |"Nilesh Keshavji Parmar" <[EMAIL PROTECTED]>

Hello!

NKP> Hello Everybody :-)
NKP> Well, I just suscribed to the mailing lists and would like to know a few more 
things about mysql. I have heard a lot about it and i think i will enjoy learning it a 
lot. I would be glad if anyone could care answering to my query.
NKP> what is mysql most usefull for ,i mean in what areas of technology are people 
using mysql, is it web or whatever and how successfull is it.
NKP> I am sorry if i sound stupid.
NKP> hope i can get a response as soon as possible.
NKP> many thanx
NKP> Nilesh

MySQL is a database management system what provide SQL interface
to data.
You can read more about it here
http://www.mysql.com/products/what_is_mysql.html





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

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

___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
   <___/   www.mysql.com


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

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

Re: reports? from MySQL (oops, on a Mac)

2001-08-28 Thread Grigory Bakunov


Date |Wed, 29 Aug 2001 00:24:25 -0400
>From |[EMAIL PROTECTED]

Hello!

>>i'd like to ask...
>>if any of you are familar with (File Maker Pro, most recent 
>>versions)... how does one go about using MySQL to create a printable 
>>report? e.g., where you select the fields you wanted in the report 
>>and then create a layout and page setup for the report, (then print 
>>it)?

G> Thanks again.
G> (Mac OS 9 or X)

I use for it Siag office - look to http://siag.nu/
For example look to this screenshot http://siag.nu/siag/mysql.png

___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
   <___/   www.mysql.com


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

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

Re: iASP Engine...

2001-08-28 Thread Grigory Bakunov


Date |Mon, 27 Aug 2001 18:20:01 +0100
>From |"Neil Tompkins" <[EMAIL PROTECTED]>

Hello!

NT> Hello,

NT> My ISP suppports iASP.  I've moved my site from running on Windows 2000
NT> Server to a linux zeus web server.  Everything runs fine from querying the
NT> mySQL  database and returning records.  But after about 5-10 queries of the
NT> database returning 20 records at a time the iASP engine slow right down, and
NT> this results in time out problems.

NT> Has anyone seen this problem, or know a fix for it ???

NT> Thanks

NT> Neil
I think it's not a MySQL problems. Looks like something
wrong with your iASP engine.

___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
   <___/   www.mysql.com


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

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

compiling mysql with InnoDB for AMD Athlon cpu

2001-08-28 Thread Stanislav Dmitrenko


G'day,

Is it possible to compile mysql with InnoDB for AMD Athlon processor ?
Error produced during compilation follows:

make[4]: Entering directory `/usr/local/src/mysql-3.23.41/innobase/sync'
gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include
-DDBUG_OFF -O3
-DDBUG_OFF-DDEBUG_OFF -DUNIV_INTEL_X86 -c sync0sync.c
sync0sync.c: In function `sync_gnuc_intelx86_test_and_set':
sync0sync.c:187: impossible register constraint in `asm'
sync0sync.c:187: impossible register constraint in `asm'
sync0sync.c:187: impossible register constraint in `asm'
sync0sync.c:1259: confused by earlier errors, bailing out
make[4]: *** [sync0sync.o] Error 1
make[4]: Leaving directory `/usr/local/src/mysql-3.23.41/innobase/sync'
make[3]: *** [all-recursive] Error 1
make[3]: Leaving directory `/usr/local/src/mysql-3.23.41/innobase'
make[2]: *** [all-recursive-am] Error 2
make[2]: Leaving directory `/usr/local/src/mysql-3.23.41/innobase'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/local/src/mysql-3.23.41'
make: *** [all-recursive-am] Error 2

Thank you beforehand.

With best regards,
Stanislav Dmitrenko


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

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

Re: query

2001-08-28 Thread Grigory Bakunov


Date |Tue, 28 Aug 2001 16:32:49 +0530
>From |"muruganandam" <[EMAIL PROTECTED]>

Hello!

M> for a particular query i have to select data from five tables.
M> can any one suggest me a best way to do that in terms of performace..

M> thanks in advance

M> muruganandam


Please give more details. Like table structures, indexes etc.

___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
   <___/   www.mysql.com


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

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

reports? from MySQL (oops, on a Mac)

2001-08-28 Thread get86


>i'd like to ask...
>if any of you are familar with (File Maker Pro, most recent 
>versions)... how does one go about using MySQL to create a printable 
>report? e.g., where you select the fields you wanted in the report 
>and then create a layout and page setup for the report, (then print 
>it)?

Thanks again.
(Mac OS 9 or X)



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

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

New MySQL Site

2001-08-28 Thread Mike



Just a kudos to those that redid the MySQL site.


   DAMMM IT LOOKS GOOD

Excellent job!!!


Cheers

M;)

Quote from The Young Ones:

I suppose you think it's pretty weird, don't you Mike? Well, you'd be right.
Because THAT's the kind of guy I am, right! WEIRD! Which is why I go over
people's heads...a bit like a aeroplane! You think I'm an aeroplane, don't
you, Mike? Well, I'm not!
- Rik


 DATBASE  MySQL ENLIGHTENMENT


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

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 to import a text file into the mysql database

2001-08-28 Thread Daniel Woods


> shell # mysqlimport -u root -p webcalendar tables-mysql.sql
> 
> where, 'webcalendar' is the database that i have created for this
> purpose. after entering the password at the password prompt it is
> displaying the following error:
> 
> mysqlimport: Error: You have an error in your SQL syntax near
> 'tables-mysql' at line 1, when using table: tables-mysql

Looks like there's nothing wrong with the command. Instead, you
have bad sql syntax on line 1, or first uncommented line in the
tables-mysql.sql file.

Thanks... Dan.



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

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

binary bin problems on HPUX 11.0

2001-08-28 Thread William Chi


Hi,

we are using mysql 3.23.33 on HPUX11 and every time we reboot the machine,
it overwrites the binary log and starts from 001 again. This is only
happening on a couple of machines. It doesn't do this if i manually
restart mysql, only when the machine is rebooted.

On one of the machines, mysql receives signal 10, dies and restarts, this
once again only occurs when the machine is rebooted.

Any help is greatly appreciated,

William


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

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: FULLTEXT exact match queries?

2001-08-28 Thread Ed Carp

Alok K. Dhir ([EMAIL PROTECTED]) writes:

> 
> > select * from Laws WHERE MATCH(Line) AGAINST ('growth 
> > hormone') AND Line like '%growth hormone%' ORDER BY ID;
> 
> This defeats the purpose of the fulltext index, don't you think?

Not really - since the WHERE clause is executed left to right, the LIKE clause is run 
against the output of the MATCH clause, a much smaller subset.

I tried it - on a 250MB database containing almost 1.7 million records, the query time 
went from 100+ seconds to just under 1 second - a significant increase in speed!
--
Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 - http://www.pobox.com/~erc

Is your web site data driven?  Are you swamped with work managing, updating,
and deploying that data on to your web site?  You need Escapade!  Check us
out at http://www.squishedmosquito.com/cgi-bin/esp?PAGE=esp_intro.html

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

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

Re: Root password revisited

2001-08-28 Thread Gregg Baker


Hi all, I got a "No Database Chosen". What's the syntax for adding the
database? I tried *.*, mysql, and test between UPDATE and user but all
returned syntax error.

Thanks much, Gregg

UPDATE user SET Password=PASSWORD("desiredpasswordhere") WHERE User="root";



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

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: Solaris 2.8 configure problem...

2001-08-28 Thread Michael Widenius

Hi!

> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:

Sinisa> Jeremy Zawodny writes:
>> I have a fairly new Solaris 2.8 (Ultra Sparc) machine on which I'm
>> trying to build the MySQL client libraries.  According to the
>> INSTALL-SOURCE file, I need to use a command-line like this:
>> 
>> CC=gcc CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions 
>-fno-rtti" ./configure --without-server --with-low-memory --enable-assembler >& 
>config.err
>> 
>> When I do that and look at config.err, I see the error message:
>> 
>> configure: error: can not run test program while cross compiling
>> 
>> Here's the whole thing (since the list won't take attachments).  It's
>> not too long.
>> 
>> 
>> According to the INSTALL-SOURCE file, that error means "you have
>> something wrong with your compiler installation!"  But I've already
>> used this exact same compiler to bulild a *ton* of other packages on
>> the machine.
>> 
>> What can I do to fix/debug this problem?

Sinisa> Jeremy, 

Sinisa> In our manual, chapter on Solaris, there are instructions on which
Sinisa> lines to delete from configure script in the case like above.

Sinisa> Just do that !

This was up a short while ago and it seams like Jeremy hasn't yet
updated our documentation regarding this.

Here is the missing information regarding this:

If you are using the SFW version of gcc (which comes
with Solaris 8), you must add /opt/sfw/lib to the
environment variable LD_LIBRARY_PATH before running
configure.

If you are using the gcc available from sunfreeware.com,
you may have many problems.  You should recompile gcc
and GNU binutils on the machine you will be running them
from to avoid any problems.

Regards,
Monty

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

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

Error Install MySQL Binary on AIX

2001-08-28 Thread Michael Widenius

Hi!

> "ajgrif" == ajgrif  <[EMAIL PROTECTED]> writes:

>> Description:
ajgrif> I downloaded the lated AIX binary from mysql.com, and unpacked it to 
/usr/local/mysql.  I then cd'd to /usr/local/mysql and ran scripts/mysql_install_db 
per the INSTALL-BINARY file.  This is the error I recieve:

ajgrif> exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the 
following errors:
ajgrif> 0509-130 Symbol resolution failed for my_print_defaults because:
ajgrif> 0509-136   Symbol strcat (number 60) is not exported from
ajgrif>dependent module /usr/local/lib/libz.a(shr.o).
ajgrif> 0509-136   Symbol memmove (number 61) is not exported from
ajgrif>dependent module /usr/local/lib/libz.a(shr.o).
ajgrif> 0509-136   Symbol bcopy (number 62) is not exported from 
ajgrif>dependent module /usr/local/lib/libz.a(shr.o).
ajgrif> 0509-192 Examine .loader sections symbols with the 
ajgrif>  'dump -Tv' command.

ajgrif> I also recieve similar errors to that referencing ./bin/mysqld instead of 
./bin/my_print_defaults.

Thanks for the bug report;

We will start building 3.23.42 shortly and I will try to build this
staticly on AIX.

In the mean time;  Please use the source distribution on AIX if the
binary doesn't work for you.

Regards,
Monty

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

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

Root password revisited

2001-08-28 Thread Gregg Baker


Hi all, I just joined list. I spent a couple hours in the archive and
decided MySQL better improve their install message regarding setting the
root password! Half the posts are about it going badly. ;)

I believe I found the answer in the archives, but they all aren't the same
answer. So is the concensus for resetting the root password, whether it was
set or not the following?

If it is, add it to your binaries! (I'm actually quite friendly and patient
:)

root# ./bin/safe_mysqld --user=mysql --skip-grant-tables &
root# ./bin/mysql -u root -p
Enter password: (hit return at this point)
>  UPDATE user SET Password=PASSWORD("desiredpasswordhere") WHERE
User="root";
>  Exit
root# ./bin/mysqladmin flush-privileges
root# ./bin/mysql -u root -p
Enter password: desiredpasswordhere


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

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

mysqladmin is missing from RPM distribution

2001-08-28 Thread root


>Description:
I downloaded, via ftp, and installed MySQL-3.23.41-1.i386.rpm.
The user instructions at the end of the rpm -i ./*.rpm command
proscripbed the use of /usr/bin/mysqladmin -u root -p password 'new-password'
and /usr/bin/mysqladmin -u root -h 'my-dns-name' -p password 'new-password'.
Unfortunately, 'mysqladmin' cannot be found on the machine, via
find / -name "mysqladmin*".  A list of the distribution files also shows it
missing; via rpm -qpl ./*.rpm.
>How-To-Repeat:
run rpm -qpl MySQL-3.23.41-1.i386.rpm.  look for /usr/bin/mysqladmin
>Fix:
Found and installed /usr/bin/mysqladmin from a previous rpm


>Submitter-Id:  
>Originator:root
>Organization:  
>MySQL support: none
>Synopsis:  mysqladmin missing from MySQL-3.23.41-1.i386.rp.
>Severity:  non-critial
>Priority:  medium
>Category:  mysql
>Release:   mysql-3.23.41 (Official MySQL RPM)

>Environment:

System: Linux ravi2.orem.volera.com 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 2001 i686 unknown
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/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81)
Compilation info: CC='egcs'  CFLAGS='-O6 -fno-omit-frame-pointer -mpentium'  
CXX='egcs'  CXXFLAGS='-O6 -fno-omit-frame-pointer-felide-constructors 
-fno-exceptions -fno-rtti -mpentium'  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 Aug 24 08:37 /lib/libc.so.6 -> libc-2.2.2.so
-rwxr-xr-x1 root root  1236396 Apr  6 15:58 /lib/libc-2.2.2.so
-rw-r--r--1 root root 26350254 Apr  6 13:27 /usr/lib/libc.a
-rw-r--r--1 root root  178 Apr  6 13:27 /usr/lib/libc.so
Configure command: ./configure  --disable-shared --with-mysqld-ldflags=-all-static 
--with-client-ldflags=-all-static --without-berkeley-db --without-innodb 
--enable-assembler --with-mysqld-user=mysql 
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ 
--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin 
--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql 
--infodir=/usr/info --includedir=/usr/include --mandir=/usr/man 
'--with-comment=Official MySQL RPM'












































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

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 1044: Access denied

2001-08-28 Thread Dana Powers


The way mysql access tables work, if it cant find a user named 'user2', it
will default to the blank user ( '' ).
dpk

- Original Message -
From: "Pierre-Yves" <[EMAIL PROTECTED]>
To: "Dana Powers" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, August 28, 2001 4:39 PM
Subject: Re: ERROR 1044: Access denied


>
> - Original Message -
> From: "Dana Powers" <[EMAIL PROTECTED]>
> To: "Pierre-Yves" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Wednesday, August 29, 2001 1:22 AM
> Subject: Re: ERROR 1044: Access denied
>
>
> > > ERROR 1044: Access denied for user: '@localhost' to database 'hello'
> > This says that you are connected as user '' ( blank ) from localhost.
Make
> > sure you're logging on correctly and try again.
> > dpk
>
> but I use the following command to connect mysql :
>
> mysql --user=user2 --host=localhost
>
> (there is no password for this user)
> and when I do this with the user1 it is working...
> so i don't think that's the problem.
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>


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

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

how to import a text file into the mysql database

2001-08-28 Thread Chakravarthy K Sannedhi


hello all,

i am trying to install web calendar software on my machine, which is
available at sourceforge.net website. to run that software first of all
a textfile named tables-mysql.sql needs to imported into the mysql
database. for doing that i typed the following command at the shell
prompt

shell # mysqlimport -u root -p webcalendar tables-mysql.sql

where, 'webcalendar' is the database that i have created for this
purpose. after entering the password at the password prompt it is
displaying the following error:

mysqlimport: Error: You have an error in your SQL syntax near
'tables-mysql' at line 1, when using table: tables-mysql

how can i avoid this error?

TIA

=
Chakravarthy K Sannedhi
Research Assistant, CTER, UAB
Birmingham, AL-35205
Ph: (205) 821-6805 (M)
http://www.dpo.uab.edu/~kalyan

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.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: ERROR 1044: Access denied

2001-08-28 Thread Pierre-Yves

- Original Message -
From: "Dana Powers" <[EMAIL PROTECTED]>
To: "Pierre-Yves" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, August 29, 2001 1:22 AM
Subject: Re: ERROR 1044: Access denied

> > ERROR 1044: Access denied for user: '@localhost' to database 'hello'
> This says that you are connected as user '' ( blank ) from localhost. Make
> sure you're logging on correctly and try again.
> dpk

but I use the following command to connect mysql :

mysql --user=user2 --host=localhost

(there is no password for this user)
and when I do this with the user1 it is working...
so i don't think that's the problem.

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

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 1044: Access denied

2001-08-28 Thread Dana Powers


> ERROR 1044: Access denied for user: '@localhost' to database 'hello'
This says that you are connected as user '' ( blank ) from localhost. Make
sure you're logging on correctly and try again.
dpk


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

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: cannot get mysqld to start

2001-08-28 Thread Dana Powers


This is covered in the mysql manual here:
http://www.mysql.com/doc/P/o/Post-installation.html

First, you need to install the default databases ( installs
mysql/host.frm ):

bash> mysql_install_db

Then tell mysql not to use InnoDB:
put this in your /etc/my.cnf file:

[mysqld]
skip-innodb


dpk

- Original Message -
From: "Sheena Sidhu" <[EMAIL PROTECTED]>
To: "Mysql (E-mail)" <[EMAIL PROTECTED]>
Sent: Tuesday, August 28, 2001 2:42 PM
Subject: cannot get mysqld to start


> Hello,
>   I just installed mysql-max-3.23.41 on Linux. All went smooth but
> alas cannot get myqld to start. here is the log from the .err
> file in mysql/data directory:
>
> 010828 14:26:30  mysqld started
> Can't initialize InnoDB as 'innodb_data_file_path' is not set
> 010828 14:26:30
/usr/local/mysql-max-3.23.41-pc-linux-gnu-i686/bin/mysqld:
> Can't find file: './mysql/host.frm' (errno: 13)
> 010828 14:26:30  mysqld ended
>
> Now, I am interested in BDB only, so don't care about Innodb. Seems like I
> have to . But what do I do about the host.frm file ?
> Gosh , can someone PLEASE help me here ???
>
> Thanks,
> Sheena.
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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

ERROR 1044: Access denied

2001-08-28 Thread Pierre-Yves


Hello,

I have a problem with the access :

I have created 2 users with no privileges in the user table (privileges are
set in the db table, so those users can only access one particular db).

the first user has all the privileges set to Y for the db "hello", this user
works fine.
the second user has exactly the same config as the first one, but with less
privileges : only the Select_priv, Insert_priv, Update_priv and Delete_priv
set to 'Y' for the db "hello".

I can connect my sql with that user, but I can't use the db hello :

mysql> use hello
ERROR 1044: Access denied for user: '@localhost' to database 'hello'
mysql>

I'm surprised to have this error message... do I have to set a particular
privilege to 'Y' in order to allow this user to connect to the db ???


Table db :

HostDbUserSelect_privInsert_privUpdate_privDelete_privCreate_privDrop_privGr
ant_privReferences_privIndex_privAlter_priv
localhosthellouser2NN
localhosthellouser1YY


Thanks for your help !


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

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

RE: FULLTEXT exact match queries?

2001-08-28 Thread Ed Carp


> On Aug 28, Ed Carp wrote:
> > How do I do exact phrase matches using FULLTEXT?
> >
> > I have this 2 million row table, full of text data, that I want
> to search
> > for an exact phrase.  When I say:
> >
> > select * from Laws WHERE MATCH(Line) AGAINST ('MDMA') ORDER BY ID;
> >
> > It works correctly, returning 1 row, MUCH faster than doing a
> "select ...
> > LIKE"!
> >
> > But when I do:
> >
> > select * from Laws WHERE MATCH(Line) AGAINST ('growth hormone')
> ORDER BY ID;
> >
> > MySQL returns every row with either "growth" OR "hormone" in
> it, which isn't
> > what I wanted.  Is there a way to only return the rows where the exact
> > phrase "growth hormone" is present?
>
> Try
>
> select * from Laws WHERE MATCH(Line) AGAINST ('growth hormone') AND
> Line like '%growth hormone%' ORDER BY ID;

It works - thanks!  Hmmm...why didn't I think of that? ;)
--
Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 -
http://www.pobox.com/~erc

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


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

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

Re: FULLTEXT exact match queries?

2001-08-28 Thread Sergei Golubchik


Hi!

On Aug 28, Ed Carp wrote:
> How do I do exact phrase matches using FULLTEXT?
> 
> I have this 2 million row table, full of text data, that I want to search
> for an exact phrase.  When I say:
> 
> select * from Laws WHERE MATCH(Line) AGAINST ('MDMA') ORDER BY ID;
> 
> It works correctly, returning 1 row, MUCH faster than doing a "select ...
> LIKE"!
> 
> But when I do:
> 
> select * from Laws WHERE MATCH(Line) AGAINST ('growth hormone') ORDER BY ID;
> 
> MySQL returns every row with either "growth" OR "hormone" in it, which isn't
> what I wanted.  Is there a way to only return the rows where the exact
> phrase "growth hormone" is present?

Try

select * from Laws WHERE MATCH(Line) AGAINST ('growth hormone') AND
Line like '%growth hormone%' ORDER BY ID;

Regards,
Sergei

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

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

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

FULLTEXT exact match queries?

2001-08-28 Thread Ed Carp


How do I do exact phrase matches using FULLTEXT?

I have this 2 million row table, full of text data, that I want to search
for an exact phrase.  When I say:

select * from Laws WHERE MATCH(Line) AGAINST ('MDMA') ORDER BY ID;

It works correctly, returning 1 row, MUCH faster than doing a "select ...
LIKE"!

But when I do:

select * from Laws WHERE MATCH(Line) AGAINST ('growth hormone') ORDER BY ID;

MySQL returns every row with either "growth" OR "hormone" in it, which isn't
what I wanted.  Is there a way to only return the rows where the exact
phrase "growth hormone" is present?
--
Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 -
http://www.pobox.com/~erc

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


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

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

cannot get mysqld to start

2001-08-28 Thread Sheena Sidhu


Hello,
  I just installed mysql-max-3.23.41 on Linux. All went smooth but
alas cannot get myqld to start. here is the log from the .err
file in mysql/data directory: 

010828 14:26:30  mysqld started
Can't initialize InnoDB as 'innodb_data_file_path' is not set
010828 14:26:30  /usr/local/mysql-max-3.23.41-pc-linux-gnu-i686/bin/mysqld:
Can't find file: './mysql/host.frm' (errno: 13)
010828 14:26:30  mysqld ended

Now, I am interested in BDB only, so don't care about Innodb. Seems like I
have to . But what do I do about the host.frm file ?
Gosh , can someone PLEASE help me here ???

Thanks,
Sheena.

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

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

show create table URGENT

2001-08-28 Thread Martin Jeremic


This is really stupid, but I can remember how to save results of "SHOW
CREATE TABLE tbl_name" and "SHOW COLUMNS FROM tbl_name" in to text file. I'm
running mysql 23.41 on Win2k.

Thanks in advance

--
Martin Jeremic
mailto:[EMAIL PROTECTED]
http://solair.eunet.yu/~martinj/
ICQ# : 128620743


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

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: fwd: What is "Pupport" ? :)

2001-08-28 Thread Matt Wagner


Hi,

Damn you guys are fast! :)

Fixed. But the udmsearch is busted right now for unknown reasons. I
will fix shortly.


 Matt


Jeremy Zawodny writes:
> FYI...
> 
> - Forwarded message from Sam Masiello <[EMAIL PROTECTED]> -
> 
> From: "Sam Masiello" <[EMAIL PROTECTED]>
> To: "MySQL General" <[EMAIL PROTECTED]>
> Date: Tue, 28 Aug 2001 17:10:17 -0400
> X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
> Subject: What is "Pupport" ? :)
> 
> 
> Not really a MySQL question, but it is related to the MySQL web site
> 
> If I go to:
> 
> http://www.mysql.com/udmsearch/search.php
> 
> the "Support" link is spelled "Pupport" (on other pages it is spelled
> correctly, however)whoops :)
> 
> --Sam
> 
> Sam Masiello
> Software Quality Assurance Engineer (providing quality Pupport :) )
> Synacor
> (716) 853-1362 x289
> [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
> 
> 
> - End forwarded message -
> 
> -- 
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936
> 
> MySQL 3.23.41-max: up 11 days, processed 137,299,690 queries (137/sec. avg)

-- 
For technical support contracts, visit https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Herr Direktor
/_/  /_/\_, /___/\___\_\___/   Hopkins, Minnesota  USA
   <___/   www.mysql.com


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

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

Re: What is "Pupport" ? :)

2001-08-28 Thread Jeremy Zawodny

On Tue, Aug 28, 2001 at 05:10:17PM -0400, Sam Masiello wrote:
> 
> Not really a MySQL question, but it is related to the MySQL web site

I forwarded it to [EMAIL PROTECTED], which is where that sort of
thing should go...  Few folks on this list have any control of MySQL's
web site.

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

MySQL 3.23.41-max: up 11 days, processed 137,301,168 queries (137/sec. avg)

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

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

What is "Pupport" ? :)

2001-08-28 Thread Sam Masiello



Not really a MySQL question, but it is related to the MySQL web site

If I go to:

http://www.mysql.com/udmsearch/search.php

the "Support" link is spelled "Pupport" (on other pages it is spelled
correctly, however)whoops :)

--Sam

Sam Masiello
Software Quality Assurance Engineer (providing quality Pupport :) )
Synacor
(716) 853-1362 x289
[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

Progress indicator in a query

2001-08-28 Thread Pires Claudio


Hi guys, could anybody help me? I have a very big database. When I make
querys to my database, depends on the type of query, it takes a lot of time.
I want to implement a progress indicator. Is there any way to implement
something like this?

Thanks

Claudio P.


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

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

RE: dbf2mysql problem please help

2001-08-28 Thread Venu


Hi !!!

)-Original Message-
)From: Armando Cerna [mailto:[EMAIL PROTECTED]]
)Sent: Tuesday, August 28, 2001 1:27 PM
)To: [EMAIL PROTECTED]
)Subject: dbf2mysql problem please help
)
)
)I have problems only converting certain DBF files to mysql with
)dbf2mysql.
)Some work but some don't and when they dont' I get the following error
)
)bash-2.05$ dbf2mysql -d maria -t cusine -c -P pass -U user CUSINE.DBF
)Error creating table!
)Detailed report: You have an error in your SQL syntax near 'DESC
)varchar(20)
)not null)

You can't use the SQL/MySQL standard keywords as the table/column names.
Here DESC is a standard keyword. So, change DESC to DESC1 and it will
absolutely work fine.

Regards
Venu
--
For technical support contracts, go to https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Venu 
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Developer
/_/  /_/\_, /___/\___\_\___/   Woodside, California  USA
   <___/   www.mysql.com


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

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

dbf2mysql problem please help

2001-08-28 Thread Armando Cerna


I have problems only converting certain DBF files to mysql with dbf2mysql.  
Some work but some don't and when they dont' I get the following error

bash-2.05$ dbf2mysql -d maria -t cusine -c -P pass -U user CUSINE.DBF 
Error creating table!
Detailed report: You have an error in your SQL syntax near 'DESC varchar(20) 
not null)
' at line 2

I have no clue why this happens if anyone could help it would be great thanks


Armando

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

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

BDB questions

2001-08-28 Thread Sheena Sidhu


Greetings everyone!
I had 2 questions related to using BDB and mysql. I
don't see any startup options for BDB, so can I safely assume that there
are'nt any , so don't need a my.cnf file? Also, how do I specify 'autocommit
off' every time BDB starts, instead of specifying it explicitly whenever
needed, also I believe even if it is on, I can use begin and end transaction
to achieve the same ?

Thanks!
Sheena.

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

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

2001-08-28 Thread Gerald Clark


Check the source.
include/mysqld_error.h

A. Clausen wrote:

> I'm developing some MySQL applications using VB6 and ADO, and need to do some work 
>on error handling.  I can get the error code easily enough from ADO's Error 
>collection, but is there a list of error codes and their descriptions.  I've been 
>doing this by generating errors and seeing what codes come back, but it would be nice 
>to have a definitive list.
> 
> Aaron
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
[EMAIL PROTECTED]


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

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

Re: reports? from MySQL

2001-08-28 Thread j.urban


If you're accessing via Windows, you can use MyODBC and a reporting
package such as Crystal Reports or Quick Reports or just about any
ODBC-compliant reporting package.  You should also be able to link MS
Access to your MySQL database...

For simple reports where you just want to print some data, you can use a
tool like urSQL (http://www.urbanresearch.com/ursql) and MyODBC to build
your query and then export the results.  Results can be exported to HTML,
Text, Excel, etc...


> - Original Message -
> > i'd like to ask...
> >   if any of you are familar with (File Maker Pro, most recent
> > versions)... how does one go about using MySQL to create a printable
> > report? e.g., where you select the fields you wanted in the report
> > and then create a layout and page setup for the report, (then print
> > it)?


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

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

MySQL Error Codes

2001-08-28 Thread A. Clausen


I'm developing some MySQL applications using VB6 and ADO, and need to do some work on 
error handling.  I can get the error code easily enough from ADO's Error collection, 
but is there a list of error codes and their descriptions.  I've been doing this by 
generating errors and seeing what codes come back, but it would be nice to have a 
definitive list.

Aaron

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

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

Re: Drop Down Boxes

2001-08-28 Thread Jeremy Zawodny


On Tue, Aug 28, 2001 at 02:56:13PM -0700, Webmaster Odell wrote:
>
> We are trying to populate a form drop down box (HTML) with a column
> from our database. What is the query that will get us that without
> repeating the items (in the 500 or so records this column has only
> 12 non-repeated items)

You need to use the DISTINCT keyword in your query.

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

MySQL 3.23.41-max: up 11 days, processed 135,375,627 queries (136/sec. avg)

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

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

Re: Drop Down Boxes

2001-08-28 Thread Cal Evans


Select Distinct.
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: "Webmaster Odell" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Tuesday, August 28, 2001 04:56
Subject: Drop Down Boxes


> HI
> We are trying to populate a form drop down box (HTML) with a column from
our
> database. What is the query that will get us that without repeating the
> items (in the 500 or so records this column has only 12 non-repeated
items)
>
> Thanks.
>
> Kevin Pottie
>
>
> Internet Designer
> O'Dell Web Design
> http://www.odellwebdesign.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

Drop Down Boxes

2001-08-28 Thread Webmaster Odell


HI
We are trying to populate a form drop down box (HTML) with a column from our
database. What is the query that will get us that without repeating the
items (in the 500 or so records this column has only 12 non-repeated items)

Thanks.

Kevin Pottie


Internet Designer
O'Dell Web Design
http://www.odellwebdesign.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: reports? from MySQL

2001-08-28 Thread Dana Powers


linking tables via MyODBC + MS Access works great for me.
dpk

- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 28, 2001 12:06 AM
Subject: reports? from MySQL


> hello.
>
> with a lot of help from many of you and some very nice folks, i have
> been able to build some example/experiment/'mess around' type of dbs.
> yay.
>
> i'd like to ask...
>   if any of you are familar with (File Maker Pro, most recent
> versions)... how does one go about using MySQL to create a printable
> report? e.g., where you select the fields you wanted in the report
> and then create a layout and page setup for the report, (then print
> it)?
>
> ALL 'directional' aids are welcome... books, websites, tips, personal
> knowledge. EXAMPLES are super.
>
> Thanks in Advance.
>
> TR
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>


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

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

Re: problems compiling on FreeBSD 3.3 (mysql-3.23.41)

2001-08-28 Thread Angel Behar


I just update the gcc version and still the same problem :

absa# gcc -v
Reading specs from
/usr/local/lib/gcc-lib/i386-unknown-freebsd3.3/3.0.1/specs
Configured with: ../configure --enable-languages=c++
Thread model: posix
gcc version 3.0.1


Any Ideas ?

thanks
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Angel Behar" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, August 23, 2001 11:50 PM
Subject: Re: problems compiling on FreeBSD 3.3 (mysql-3.23.41)


> On Thu, Aug 23, 2001 at 01:50:36PM -0700, Angel Behar wrote:
> > Hi !!
> >
> > I'm trying to compile mysql-3.23.41 on a FreebSD 3.3 box but I can't
> >
> > I'm using latest gnu make version and this is the first time that I
> > have problems compiling mysql so if any of you can help me I'll
> > appreciate.
> >
> > Thanks in advance.
>
> Which compiler version are you using?
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936
>
> MySQL 3.23.41-max: up 6 days, processed 89,579,267 queries (148/sec. avg)
>


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

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

Re: Roles

2001-08-28 Thread John Meyer

At 09:57 AM 8/28/01 -0700, you wrote:
> > In Oracle, I remember working with roles that I could assign to a user.
>Is
> > there such a mechanism, or are there plans to implement such a mechanism,
> > in MySQL.
>
>This sounds a lot link granting a user certain privileges. Here's the part
>of the documentation that talks about this:

Actually, you grant the permissions to a "role" (such as manager, 
secretary, etc), and then you grant the role to a specific user.  It madkes 
user management a whole lot easier.

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

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

2001-08-28 Thread Kurt Hansen


> In Oracle, I remember working with roles that I could assign to a user.
Is
> there such a mechanism, or are there plans to implement such a mechanism,
> in MySQL.

This sounds a lot link granting a user certain privileges. Here's the part
of the documentation that talks about this:

http://www.mysql.com/doc/U/s/User_Account_Management.html

HTH,

Kurt Hansen
[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

mySQL

2001-08-28 Thread Thomas Ekegren Christensen


Hi mySQL,
 
I have a huge problem and unfortunately my Domain Hosting Services has no interest in 
helping me. I am running mySQL with ASP and use a DSN-less call to connect to mySQL.
The problem is a little bit weird because running the query using phpmyadmin gives me 
a perfect recordset. Running it in ASP using ADO returns an empty recordset. The MySQL 
manual talks about setting the option flag "return matching rows". Since I haven't got 
the faintest idea of how to do this, I assume that's the reason for my empty recordset.
Can anyone please tell me how to do this and preferable using a DSN-less call to MySQL.
 
Kind regards,
 
Thomas Christensen
 
NB! The SQL query is listed below.
 
strSQL = "SELECT COUNT(Bog.Bogid), Brugere.Navn FROM Brugere INNER JOIN Bog ON 
Bog.mailadresse = Brugere.mailadresse GROUP BY Brugere.Navn"
objRs.CursorLocation = adUseClient

objRs.Open strSQL, strConnect, adCmdText




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

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

Please..Desperate for Help |||||||

2001-08-28 Thread nrwalker


I am trying to install the "dbf2mysql" converter and really 
getting a headache. Someone told me that I need to 
install the "Include files and libraries for MySQL" and I 
have been searching frantically all over the web for the 
source for this. All I have been able to find is the RPM's.
I am on Mac OS X Server and would like to set this up. 
Is it possible to install the developer edition of MySQL 
for X Server ??  If so, can someone point me to where I 
can get this. I have got to get this converter to work 
under X Server but it seems that I have to have the 
mysql-devel installed. Can someone please help me?
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

Roles

2001-08-28 Thread John Meyer


In Oracle, I remember working with roles that I could assign to a user.  Is 
there such a mechanism, or are there plans to implement such a mechanism, 
in MySQL.


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

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

Trying to build MySQL 3.23.39 on LynxOS 3.1.0

2001-08-28 Thread Mott Brian-P28702


Hello,

I'm trying to build MySQL 3.23.39 for a LynxOS 3.1.0 platform.  I believe that I only 
need the client, and have selected the no-server options.  However, when trying to run 
make it bombs out in the client directory due to the sql_string.cc file which has 
declared an include for floatingpoint.h.  Apparently, I do not have this file.

I did some searching on some other systems and found a floatingpoint.h file however 
using this file comes with it's own set of problems (I knew it was risky, but I tried 
it anyways out of desparation).

Does anyone out there have any other suggestions?

Thanks
Brian.

PS - Some config information
OS = LynxOS3.1.0
Processor = PPC
Compiler = gcc2.8.1  (I've tried to upgrade to 2.95.X but I am having other problems 
there)

Thanks again.
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

Maximum number of keys

2001-08-28 Thread joseph . bueno


Hello,

According to MySQL documentation (Chap. 7.1 "MyISAM Tables"):
"Maximum number of keys/table is 32 as default." 

However when I try to create more than 16 keys, I get:
ERROR 1069 at line 1: Too many keys specified. Max 16 keys allowed

This table is of MyISAM type.

I am currently running MySQL 3.23.41 on Linux (2.4.5) from precompiled
binaries (MySQL-3.23.41-1.i386.rpm).

Is there any way to use more than 16 keys ?

Thanks your help
--
Joseph Bueno
NetClub/Trader.com

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

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

RE: Updating auto_increment ID Column/Selecting Duplicate Rows

2001-08-28 Thread Daniel Von Fange


This would give you a list of all users that have entered things more than
once; However, it would not give you all the rows that are duplicated.

SELECT Count(User) from mail_form2 GROUP BY User HAVING Count(User) > 1

Hope this helps!

Daniel Von Fange


-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
2)
in a table i have a column called User.  some people have entered things
into this table multiple times.  how do i create a SELECT statement to
select
only those rows that have multiple Users?  i need something like this
(but this
is wrong, of course):

SELECT * FROM mail_form2 WHERE 'count(User) >1'

SELECT * from mail_form2 GROUP BY User HAVING Count(User) > 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: limits to volume handled by MySQL

2001-08-28 Thread Sergei Golubchik


Hi!

On Aug 28, Bernard-Olivier Clist wrote:
> Hi there
> We are switching to a MySQL 3.23.38 on a PIII 933 MHz machine running with 
> a FreeBSD and a web Apache server 1.3.19 .
> The hosting company has just argued MySQL cannot handle more than 1Go in 
> database files opened per session.
> Is it true ?

That's not true.
I've myself played with 12GB tables on FreeBSD - I didn't
face a single problem with it.

Regards,
Sergei

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

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

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

MySQLGUI Version 1.7.5 Question and Comment

2001-08-28 Thread Marion Berryman


I've been trying out MySQLGUI Version 1.7.5, and it seems to work fine on my Win 98SE 
client. I do have a question about the menu entries under Commands, Tables for "Edit 
table" and "Create tables".  I've searched through the help file and didn't find any 
mention of these two menu entries, and when I select them nothing seems to happen. 
What is the purpose of these menu items and shouldn't they at least give me an "Info" 
message when I select them? 

My comment or suggestion is that the help needs to have a section relating functional 
capabilities to user interface items such as menus and mouse actions.  I really liked 
your program, but it wasn't so easy to decipher how to operate the user interface, 
which I thought was clean and useful once I begin to see how things worked. Something 
along the lines of a short How-To list would be useful.  Or, one could make a list of 
all user interface items with a description of what they do. 

Thank you for your consideration.

Marion Berryman
[EMAIL PROTECTED]







__
Your favorite stores, helpful shopping tools and great gift ideas. Experience the 
convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/

Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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

design

2001-08-28 Thread Mallikarjuna Rao N


Hi
 Is there any design document available of the complete architecture
of the mysql database. I wanted to try out small changes . I want to
make sure that it does not effect any transactions or anythings like
that in any way.
mallik
-- 

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

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: Updating auto_increment ID Column/Selecting Duplicate Rows

2001-08-28 Thread Gerald Clark




Tom Churm wrote:

> hi,
> 
> i have 2 questions that i badly need answered.  i use phpmyadmin, but 
> any answers containing SQL syntax should work in this app...
> 
> 1)
> this should be simple but i don't know it.  i use the following mysql
> table field as the Key for my tables:
> 
> "id int(10) unsigned NOT NULL auto_increment,"
> 
> now, when i have to clean up items in my tables, like when users have
> sent off a .html form multiple times and i want to delete duplicate
> submissions, how can i quickly & easily update all of the 'id' fields in
> the entire table, to reflect the numeration change?
> 
> now, using phpmyadmin, if i go in and delete a few entries, the id's
> have gaps in them.
You don't reorder them.  The gaps remain.  Besides, if the id is used in
any other table, changing a value would be a serious data integrity issue.


> 
> 2)
> in a table i have a column called User.  some people have entered things
> into this table multiple times.  how do i create a SELECT statement to
> select
> only those rows that have multiple Users?  i need something like this
> (but this
> is wrong, of course):
> 
> SELECT * FROM mail_form2 WHERE 'count(User) >1' 
> 
> many thanks from a newbie,
> 
> tom
> 
What things, besides user names, would people be entering here?
If you are concerned about duplicate user names, add a unique index on 
this column, you can use 'ALTER IGNORE mail_form2 add unique (User)',
but I'm not sure this is what you meant.

> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
[EMAIL PROTECTED]


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

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

Re: MySQLgui problems

2001-08-28 Thread Stefan Murariu




[EMAIL PROTECTED] wrote:

>Your message cannot be posted because it appears to be either spam or
>simply off topic to our filter. To bypass the filter you must include
>one of the following words in your message:
>
>database,sql,query,table
>
>If you just reply to this message, and include the entire text of it in the
>reply, your reply will go through. However, you should
>first review the text of the message to make sure it has something to do
>with MySQL. Just typing the word MySQL once will be sufficient, for example.
>
>You have written the following:
>
>I didn't find file edfile.o even in Fl_Editor package but I suppose that 
>libfleditor is enough.
>The really problem is that I didn't find (and I don't imagine where to 
>search) the rcl (maybe librcl.so) and rcleditor (maybe librcleditor.so).
>Please help
>Regards,
>Stefan Murariu
>
>
>



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

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

limits to volume handled by MySQL

2001-08-28 Thread Bernard-Olivier Clist


Hi there
We are switching to a MySQL 3.23.38 on a PIII 933 MHz machine running with 
a FreeBSD and a web Apache server 1.3.19 .
The hosting company has just argued MySQL cannot handle more than 1Go in 
database files opened per session.
Is it true ?
If so how to go over that 1Go limit ? ( :-) yes i know scratch the project 
.. seriously ?)
Cheers
Bernard Clist
Bernard-Olivier Clist
Administrateur du site Internet de l'OGE
Site Web : http://www.geometre-expert.fr/
Mél : [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: strange problems with MySQL db

2001-08-28 Thread Gerald Clark


When the temp directory runs out of space, the thread executing will
wait for space to become free.
If you kill the server, this client has not closed the table properly.

How do you determine that the server "crashed" ?
If it stopped responding, maybe it is just waiting for space to become
available.  Killing it at this point may crash a table.

Wintercom New Media wrote:

> Hello list.
> 
> I am having strange problems with my Tables since the partition had been
> running out of space and mysql crashed. I repaired all the tables and
> thought it was a success (no errors were detected anymore) but some days
> later there was an error in another table and I fixed it  but then
> there was another error and so on. I cannot reproduce the error.
> 
> The error is: 1 clients is using or hasn't closed the table properly
> 
> Normally this is not a problem... just someone is using the table. But
> the table sometimes crashes.
> 
> What may be my problem?
> 
> Mfg
> S. winter
> 
> +---++
> | Wintercom New Media   | Telefon:  +49 (0)2381/378373   |
> | Eibenweg 12   | Fax:+49 (0)2381/378374 |
> | D-59071 Hamm  | E-Mail: [EMAIL PROTECTED]  |
> | Germany   | http://www.wintercom.de|
> |   ||
> | Wir freuen uns auf Ihre Anfrage...||
> +---++
> | Web-Design, Webhosting, Server-Housing, Netzwerktechnik und mehr   |
> +---++
>   
> 
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
[EMAIL PROTECTED]


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

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

MYSQL Stops for no reason

2001-08-28 Thread Michael Fontbin


Hello all

Please if could someone help, I am running MYSQL to record print
transactions at my company..the way I have set this up is by after a print
job has completeda bat file is run whih basically says...go and insert into
the table the following values

Now on more than 1 occasion the MYSQL database has stopped recording the
transactionssimple solution is recreate the table and change the bat
file to point to the new tableHOWEVER this as you will all agree with me
is not a proper solution..

Please advise

Kind regards
Mike


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

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

2001-08-28 Thread Simon Green

See V 4

-Original Message-
From: Alexander Barkov [mailto:[EMAIL PROTECTED]]
Sent: 28 August 2001 14:13
To: [EMAIL PROTECTED]
Subject: Feature suggestion

  Hello!

Currently replication is implemented between
two mysqld. I would like to suggest new feature.
Make it possible for two mysqld to exchange data
between each other. For example, MERGE tables
distributed between two machines. 

Question to authors. How do you think, will
it ever be implemented. If so, how soon?

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

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

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: 6 (Errcode: 13)

2001-08-28 Thread Gerald Clark


It means mysql does not have write permission on the sports directory.

Grigory Bakunov wrote:

> Date |Fri, 24 Aug 2001 14:09:20 -0500
>>From |"Tyler Longren" <[EMAIL PROTECTED]>
> 
> Hello!
> 
> TL> DROP TABLE Track
> TL> Error: 6 - Error on delete of '.\sports\track.ISD' (Errcode: 13)
> 
> TL> Anyone know what that means?  As you can see, it came from tryign to do a
> TL> DROP on a table.
> 
> TL> Thanks,
> TL> Tyler Longren
> 
> Looks like file permissions problems.
> Check this instructions:
> http://www.mysql.com/doc/F/i/File_permissions.html
> 
> ___
> For technical support contracts, visit https://order.mysql.com/
> This email is sponsored by SWSoft, http://www.asplinux.ru/
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
>  / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
> /_/  /_/\_, /___/\___\_\___/
><___/   www.mysql.com
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
[EMAIL PROTECTED]


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

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

Feature suggestion

2001-08-28 Thread Alexander Barkov


  Hello!

Currently replication is implemented between
two mysqld. I would like to suggest new feature.
Make it possible for two mysqld to exchange data
between each other. For example, MERGE tables
distributed between two machines. 

Question to authors. How do you think, will
it ever be implemented. If so, how soon?

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

autoincrement

2001-08-28 Thread sean . odonnell


When you have just inserted a record into a table that autoincrements the
primary key,
is there a way of retrieving the id assigned at the same time? I'm using ASP
to write the 
code in question , and I'm trying to find a better solution that looking at
the max key value
just before/after in code, and praying no other query was run at the same
time. Does mysql
have any  feature to accomadate this?

Thanks

Sean

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

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

2001-08-28 Thread Ian Barwick


On Tuesday 28 August 2001 13:55, Harald Fuchs wrote:
> In article <01082813314101.11299@redgrave>,
>
> Ian Barwick <[EMAIL PROTECTED]> writes:
> > You mean using SELECT LAST_INSERT_ID() ?
> >
> >> and praying no other query was run at the same
> >> time.
> >
> > Try locking the table for writes just before your insertion, do the
> > insert, SELECT LAST_INSERT_ID() and release the lock. This should 
> > prevent another insert being carried out before you retrieve the ID.
>
> This is not necessary.  LAST_INSERT_ID is client-specific; thus you
> get guaranteed the ID of the last INSERT issued by yourself,
> regardless of what other clients might do in the meantime.

Aha, thanks, nice to know. I tend to assume the worst with MySQL (slight 
personal prejudice due to lack of referential integrity etc., please don't 
flame, I think it is excellent otherwise, else I would't be using it ;-) 

Note to self: RTFM more often...

Ian Barwick

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

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

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

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

Deleted mysql.host Table!

2001-08-28 Thread Steffen Hainke


Hallo,

i'm new to mysql. I delete a mysal.host table. Does it means i can't
access the rest of my tables in the database? If so, can i rebuild this
table or is there another way, to access the rest of the tables?

I'am running MySQL under Linux.

Thank's for Comment's, Help ...

Steffen

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

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

2001-08-28 Thread Ian Barwick

On Tuesday 28 August 2001 12:36, [EMAIL PROTECTED] wrote:
> When you have just inserted a record into a table that autoincrements the
> primary key,
> is there a way of retrieving the id assigned at the same time? I'm using
> ASP to write the
> code in question , and I'm trying to find a better solution that looking at
> the max key value
> just before/after in code, 

You mean using SELECT LAST_INSERT_ID() ?

> and praying no other query was run at the same
> time.

Try locking the table for writes just before your insertion, do the insert, 
SELECT LAST_INSERT_ID() and release the lock. This should  prevent another 
insert being carried out before you retrieve the ID.

HTH

Ian Barwick

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

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

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

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

query

2001-08-28 Thread muruganandam


for a particular query i have to select data from five tables.
can any one suggest me a best way to do that in terms of performace..

thanks in advance

muruganandam


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

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 Still a wise choice for developers?

2001-08-28 Thread Ilya Martynov



Let me add my $.02

CHP> A) There's no *point* in keeping the image in the database.
CHP> A DBMS is all about searching, comparing, relations, etc. You
CHP> get *none* of these by storing the image data in the DB.

Sometimes it just easier to store all things in same place. Right now
I working on one web project where there is exist notion of user
profiles. User can edit various fields and upload his/her
pictures. Right now it is implemented in 'right' way. I.e. database
stores only pathnames of files. But I thinking to rewrite it and store
pictures in database to simplify my code.

CHP> B) Unless you're careful, you totally defeat both the
CHP> web servers and the clients ability to make use of caching
CHP> mechanisms. While you may not see a big difference on the
CHP> server, it can make one h... of a difference to the user
CHP> stuck behind a 33.6K modem.

It is not that hard. Code which takes images from database should
generate headers like Last-Modified and so on. Often web server works
together with proxy working in web accelerate mode. In such case
images will be served from database only on first hit and all next
requests will be served from proxy cache. Such approach removes
unnecessary load from database and gives speed of static data
requests.

-- 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/)|
| GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80  E4AE BE1A 53EB 323B DEE6 |
| AGAVA Software Company (http://www.agava.com/)  |
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

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

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

strange problems with MySQL db

2001-08-28 Thread Wintercom New Media


Hello list.

I am having strange problems with my Tables since the partition had been
running out of space and mysql crashed. I repaired all the tables and
thought it was a success (no errors were detected anymore) but some days
later there was an error in another table and I fixed it  but then
there was another error and so on. I cannot reproduce the error.

The error is: 1 clients is using or hasn't closed the table properly

Normally this is not a problem... just someone is using the table. But
the table sometimes crashes.

What may be my problem?

Mfg
S. winter

+---++
| Wintercom New Media   | Telefon:  +49 (0)2381/378373   |
| Eibenweg 12   | Fax:+49 (0)2381/378374 |
| D-59071 Hamm  | E-Mail: [EMAIL PROTECTED]  |
| Germany   | http://www.wintercom.de|
|   ||
| Wir freuen uns auf Ihre Anfrage...||
+---++
| Web-Design, Webhosting, Server-Housing, Netzwerktechnik und mehr   |
+---++
  



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

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

Problem: MERGE tables for different databases

2001-08-28 Thread Alexander Barkov


  HEllo!

Is it possible to create a merge table for
tables from different databases.


I wrote this script for database "collection":

CREATE TABLE dict
(
  url_id int(11) DEFAULT '0' NOT
NULL, 
  word varchar(32) DEFAULT '' NOT
NULL,
  intag int(11) DEFAULT '0' NOT
NULL,  
  KEY url_id
(url_id), 
  KEY word_url
(word)  
) TYPE=MERGE UNION=(www.url,dbms.url); 


MySQL took it without any errors.
However, when I try to access MERGE table
in "collection" database, it fails:


--
/usr/home/bar > mysql collection
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 210 to server version: 3.23.29a-gamma-log

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

mysql> select * from dict; 
ERROR 1017: Can't find file: 'dict.MRG' (errno: 2)
mysql> 
---


I think this may helps in solving:

In /usr/local/mysql/var/collection/dict.MRG I can see this:

url
url

I supposed it should be 

www.url
dbms.url




Is that a bug? I suggest this to be fixed in future release.
I use 3.23.29a-gamma.
Please make a copy to me when replying...

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

autoincrement

2001-08-28 Thread sean . odonnell


When you have just inserted a record into a table that autoincrements the
primary key,
is there a way of retrieving the id assigned at the same time? I'm using ASP
to write the 
code in question , and I'm trying to find a better solution that looking at
the max key value
just before/after in code, and praying no other query was run at the same
time.

Thanks

Sean

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

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: Equivalent as UNION (Oracle)

2001-08-28 Thread Rafal Jank


Järkeborn Joacim wrote:
> 
> Hi,
> 
> We have Oracle SQL statements that uses UNION is there an equivalent for this in 
>mySQL?
Not yet. It should be in version 4.0
-- 
_/_/  _/_/_/  - Rafał Jank [EMAIL PROTECTED] -
 _/  _/  _/  _/   _/ Wirtualna Polska SA   http://www.wp.pl 
  _/_/_/_/  _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625
   _/  _/  _/ ==*  http://szukaj.wp.pl *==--

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

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

More info

2001-08-28 Thread Alexander Barkov




Sorry, It was a little mistake in my previous letter.

"mysqladmin create databases" does not output any
error messages, however it does not create database
"databases".

However, "mysqladmin drop databases" produce this:


/usr/local/mysql/etc/ access.grant > mysqladmin drop databases
Dropping the database is potentially a very bad thing to do.
Any data stored in the database will be destroyed.

Do you really want to drop the 'databases' database [y/N]
y
mysqladmin: drop of 'databases' failed;
error: 'You have an error in your SQL syntax near 'databases' at line 1'


Regards.

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

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

SQL syntax near 'IDENTIFIED BY'...

2001-08-28 Thread Alexander Barkov



  Hello!


These query produces an SQL syntax error
in  3.23.29a-gamma:

GRANT ALL PRIVILEGES ON databases.*  
TO 'foo'@'localhost' IDENTIFIED BY 'bar';

SHOW TABLES FROM databases;

Probably this is because of "databases" is 
a keyword. However, mysqladmin does allow to
create database 'databases'.


Is it a bug? Or is that already fixed in 
later releases?

Please honor my address when replying,
currently I'm not a subscriber.

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

2001-08-28 Thread Ute Hoffmann



>Hi all,
>I work with mysql 3.23.40 on Mac Os X 10.0.x and have created a Database.
>This Database has to move to another mysql server 3.23.40 on a Mac OS X
>Server. In older versions (up to 3.23.39 I think) it was sufficient to
>create an empty database on the destination machine and just copy and paste
>the whole information (all three tables, complete with PK table to the new
>destination).
>
>This will not work any longer. (Mysql does not find the .frm tables, but we
>can see them in the terminal listed at the appropiate place in the
>database).
>
>Is there a built in way to export complete Databases in mysql? We searched
>the docs but in vain.
>
>Does sql provide for this situation anyway and we just don't know about
>this?
>
>Is there any way to get the database from machine a to machine b?
>
>Please help- there must be a way:-).
>
>Thanks.
>
>Ute
>



_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


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

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

Equivalent as UNION (Oracle)

2001-08-28 Thread Järkeborn Joacim


Hi,

We have Oracle SQL statements that uses UNION is there an equivalent for this in mySQL?

// Jocke

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

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

Re: MySQL and GPL license: questions and discussion

2001-08-28 Thread Sinisa Milivojevic


Neil Zanella writes:
> 
> 
> 1. What was the name of the first GPL file release of MySQL?

3.23.xx

> 2. Which portions are not distributed by mysql.com as part of MySQL?

All are.

> 3. Which portions of the Windows MySQL release
>are not released under the GPL if any? For instance is the
>windows installer program (is there one?) released under the GPL?

All stuff built by us is under GPL. Install program is not ours, it is
standard Windows program. 

> 4. Are the Linux versions shipped with Red Hat 7 and 7.1 entirely
>distributed under the GPL?

Yes.

> 5. Do PHP web applications that use PHP and MySQL require a MySQL license?
>Such applications are not derivative works as they are merely interfaces.
>Thus they do not require a license. Correct?
> 

Only if you sell your PHP application to somebody, and that somebody
requires to install server. Otherwise, no licence. 

> References: 1.  (announces GLP release of 
>source code)
> The most ambiguous aspect of the GPL is that it does not seem to clearly
> specify what and what not comprises a derivative work. Does a web application
> which uses MySQL comprise a derivative work. I don't think so.
> Do such web applications have to be placed under the GPL.
> I don't see anything in the GPL that states this.
> 
> Thanks for the clarification,
> 
> Neil
> 

If you use that PHP program for your site, there are no licences and
no need to publish anything.


-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com


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

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

Re: Max table size in MySQL on Redhat 7.0 be default

2001-08-28 Thread Grigory Bakunov


Date |Fri, 24 Aug 2001 10:29:53 -0700
>From |"Benjamin Arai" <[EMAIL PROTECTED]>

Hello!

BA> What is the maximum table size allowed by MySQL and Redhat 7.0 be default?

BA> Benjamin Arai
Read about it here:
http://www.mysql.com/doc/T/a/Table_size.html

___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
   <___/   www.mysql.com


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

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

Re: Error: 6 (Errcode: 13)

2001-08-28 Thread Grigory Bakunov


Date |Fri, 24 Aug 2001 14:09:20 -0500
>From |"Tyler Longren" <[EMAIL PROTECTED]>

Hello!

TL> DROP TABLE Track
TL> Error: 6 - Error on delete of '.\sports\track.ISD' (Errcode: 13)

TL> Anyone know what that means?  As you can see, it came from tryign to do a
TL> DROP on a table.

TL> Thanks,
TL> Tyler Longren

Looks like file permissions problems.
Check this instructions:
http://www.mysql.com/doc/F/i/File_permissions.html

___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
   <___/   www.mysql.com


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

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

Re: ERROR: Lost connection to MySQL server during query

2001-08-28 Thread Grigory Bakunov


Date |Fri, 24 Aug 2001 14:08:43 -0400 (EDT)
>From |boulat <[EMAIL PROTECTED]>

Hello!


B> Hi group,

B> Im using the latest mySQL 3.23.41,  ever since I installed the new
B> version I've been getting "Lost connection to MySQL server during query"
B> 50% of the time on my mySQL server. I have a load average of 247 queries
B> per second accordig to mysqladmin status. 

B> Anyone experienced the same problem with mySQL?

B> Regards,
B> Boulat

Looks like you need to increase queries packet buffer
by start mysqld with -O max_alowed_packed=#

http://www.mysql.com/doc/G/o/Gone_away.html
___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
   <___/   www.mysql.com


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

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

Re: unique()

2001-08-28 Thread Grigory Bakunov


Date |Sat, 25 Aug 2001 00:24:07 +0200
>From |"Boaz Yahav" <[EMAIL PROTECTED]>

Hello!

BY> Hi

BY> I have a table with a filed that is unique (used unique() in the
BY> creation).
BY> how do I undo this unique()?

unique is an index property.
Just remove them by ALTER TABLE command
http://www.mysql.com/doc/A/L/ALTER_TABLE.html


___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
   <___/   www.mysql.com


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

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

RE: Need info

2001-08-28 Thread Simon Green


Hi Nilesh
MySQL is very fast but has not got all the things SQL can have (this is for
speed).
So we use it for web sites and for authenticating users over radius.

Simon

-Original Message-
From: Nilesh Keshavji Parmar [mailto:[EMAIL PROTECTED]]
Sent: 28 August 2001 09:05
To: [EMAIL PROTECTED]
Subject: Need info


Hello Everybody :-)
 Well, I just suscribed to the mailing lists and would like to know a
few more things about mysql. I have heard a lot about it and i think i will
enjoy learning it a lot. I would be glad if anyone could care answering to
my query.
  what is mysql most usefull for ,i mean in what areas of technology are
people using mysql, is it web or whatever and how successfull is it.
 I am sorry if i sound stupid.
 hope i can get a response as soon as possible.
 many thanx
 Nilesh
 
 
   

 




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

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

Need info

2001-08-28 Thread Nilesh Keshavji Parmar


Hello Everybody :-)
 Well, I just suscribed to the mailing lists and would like to know a few more 
things about mysql. I have heard a lot about it and i think i will enjoy learning it a 
lot. I would be glad if anyone could care answering to my query.
  what is mysql most usefull for ,i mean in what areas of technology are people using 
mysql, is it web or whatever and how successfull is it.
 I am sorry if i sound stupid.
 hope i can get a response as soon as possible.
 many thanx
 Nilesh
 
 
   

 




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

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

Help with blobs

2001-08-28 Thread Doug


 Hi All, can someone point me in the right direction for saving
 formatted RichEdit Text to a blob field and then loading the RichEdit field
 with the data from the blob. I am using Borland Builder 5 odbc to MySQL
database.

 Regards
 Doug
 [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: Need Help Setting Up MySQL on Win98

2001-08-28 Thread Grigory Bakunov


Date |Mon, 27 Aug 2001 12:54:25 -0700 (PDT)
>From |S K Bryan <[EMAIL PROTECTED]>

Hello!

SKB> Hello -

SKB> I'm very new at this, so please pardon the very beginner questions...

SKB> I'm attemtping to install MySQL to my local machine running Win98. The
SKB> install seems to go alright, but when I try "mysqld--standalone" it
SKB> gives me an error. Then I tried "mysqld -standalone", which seemed to
SKB> work.

SKB> Then I entered, "mysqladmin create testDB" and I got the error message
SKB> "Can't connect to MySQL Server on 'localhost'. I tried telnetting to
SKB> "telnet localhost 3306" and got an error that it couldn't connect.

SKB> Can anyone offer help?

You need to use just
c:\mysql\bin\mysqld
command to start mysqld

Also note that you need to have winsock 2 installed on your 
Win.

http://www.mysql.com/doc/W/i/Win95_start.html


___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
   <___/   www.mysql.com


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

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

Updating auto_increment ID Column/Selecting Duplicate Rows

2001-08-28 Thread Tom Churm


hi,

i have 2 questions that i badly need answered.  i use phpmyadmin, but 
any answers containing SQL syntax should work in this app...

1)
this should be simple but i don't know it.  i use the following mysql
table field as the Key for my tables:

"id int(10) unsigned NOT NULL auto_increment,"

now, when i have to clean up items in my tables, like when users have
sent off a .html form multiple times and i want to delete duplicate
submissions, how can i quickly & easily update all of the 'id' fields in
the entire table, to reflect the numeration change?

now, using phpmyadmin, if i go in and delete a few entries, the id's
have gaps in them.

2)
in a table i have a column called User.  some people have entered things
into this table multiple times.  how do i create a SELECT statement to
select
only those rows that have multiple Users?  i need something like this
(but this
is wrong, of course):

SELECT * FROM mail_form2 WHERE 'count(User) >1' 

many thanks from a newbie,

tom

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

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

88 matches

Mail list logo