--myisam-recover reliable on master and eventually slaves

[Jean-Luc Fontaine]

I am planning to use the --myisam-recover option on a master MySQL server.
I would like to know about your experiences on the matter: is it reliable?

What about the consequences on the slaves: should they use it as well?

Many thanks in advance to this great mailing list :-).


-- 
SQL Jean-Luc Fontaine

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

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 access mysql using vb as front end

[phani krishna S.V]

hi,
i am using vb as frontend.can we use database as mysql.can we access data using mysql 
ac database.if so how.pls send me teh details at the earliest.
  regards,
  venkat


Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at 
http://www.eudoramail.com

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

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

Re: how to access mysql using vb as front end

[Van]

phani krishna S.V wrote:
 
 hi,
 i am using vb as frontend.can we use database as mysql.can we access data using 
mysql ac database.if so how.pls send me teh details at the earliest.
   regards,
   venkat
 
VenKat:

You need MyODBC.  It's right there one the http://www.mysql.com/ web-site.

Download it here: 
http://download.sourceforge.net/pub/mirrors/mysql/Downloads/MyODBC/

Van
-- 
=
Linux rocks!!!   http://www.dedserius.com
=

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

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

After replication

[Kissandrakis S. George]

Hello 

i installed replication between two mysql servers

Now what?

is there any software which does insert,deletes,updates on the master
and select on both
machines or on slave('s) only?

is there any recommended setup (virtual ips, NAT anything) that will do
the above?

-- 
Kissandrakis S. George [[EMAIL PROTECTED]]
Network and System Administrator   [http://www.phaistosnetworks.gr/]
Tel:(+30 81) 391882/Fax:(+30 892) 23206
Phaistos Networks S.A. - A DOL Digital Company

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

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

messages in log with 3.23.37 and ezmlm

[Joel Sana]

Since I upgrade from MySQL 3.22.32 to 3.23.37 I've got a lot of messages in the 
'host.err' log saying:

010511 11:01:56  Aborted connection 359914 to db: 'ezmlmbase' user: '' host: 
`localhost' (Got an error reading communication
packets)

where 'ezmlmbase' is the name of the database used for ezmlm mailing lists.
This message never show up for any of the others database on the same machine.

I've recompiled ezmlm with the new mysql 3.23.37 libs and includes, but the messages 
still appear.

Is anybody experienced the same thing ?

Thanks

--
Joel Sana


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

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

log event entry exceeded max_allowed_packet error: findings

[Jean-Luc Fontaine]

Today on a slave I got:

Slave: connected to master '[EMAIL PROTECTED]:3306',  replication started in log 
'xxx-bin.040' at position 47694
010511 10:37:19  Error reading packet from server: log event entry exceeded 
max_allowed_packet - increase max_allowed_packet on master (read_errno 
0,server_errno=65535)
010511 10:37:19  Slave: Failed reading log event, reconnecting to retry, log 
'xxx-bin.040' position 47694
010511 10:37:19  Slave: reconnected to master 
'[EMAIL PROTECTED]:3306',replication resumed in log 'xxx-bin.040' at position 
47694
010511 10:37:19  Error reading packet from server: log event entry exceeded 
max_allowed_packet - increase max_allowed_packet on master (read_errno 
0,server_errno=65535)
010511 10:37:31  Slave thread killed while waiting to reconnect after a 
failed read

Then I looked on the master:

$ mysqlbinlog  xxx-bin.040 | more
# at 47032
#010511  8:26:40 server id  1   Query   thread_id=1044  exec_time=0 
error_code=0
use Xxx;
SET TIMESTAMP=989562400;
UPDATE xxx set n=n+1,date='2001-05-11  8:26:40' where id='72';
# at 47160
#010511  8:26:40 server id  1   Query   thread_id=1044  exec_time=0 
error_code=0

Note that the 47694 position does not exist.

So I did the following on the slave (picked the valid position right before 
47694):
 change master to master_log = 47672;

then restarted the slave and it now works.



Suggestion: maybe the error message in the log could be changed from:

* Error reading packet from server: log event entry exceeded 
max_allowed_packet - increase max_allowed_packet on master (read_errno 
0,server_errno=65535)

to:

* Error: position 47694 does not exist in log 'xxx-bin.040' 


What do you think?




-- 
SQL Jean-Luc Fontaine

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

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

firewall

[nicola]

hi all,
just a newbie question.

can i use a (win) gui mysql client, if i have
a firewall installed between my intranet and
mysql server. how?

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

To 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 access mysql using vb as front end

[Eugénio Veiga]

Hi

I've been looking in mysql.com and I didn't find myvbql.dll. The MySql website you
talk is www.mysql.com?
You know all the functions and Sub of the dll that can be used ?

Thanks

Eugénio Veiga

Warren van der Merwe wrote:

 Hi

 I am successfully developing with VB and MYSQL using the MYSQL API, which
 can be found on the mysql website, look at the download section and it is
 called myvbql.dll

 Similar to ADO, but a little different.

 Works like a dream
 Warren

 ~
 Warren van der Merwe
 Software Director
 PRT Trading (Pty) Ltd t/a RedTie
 Durban, South Africa
 Cell (+27-83) 262-9163
 Office (+27-31) 767-0249

  -Original Message-
  From: [EMAIL PROTECTED]
  [mailto:[EMAIL PROTECTED]
  ]On Behalf
  Of phani krishna S.V
  Sent: 11 May 2001 09:59
  To: [EMAIL PROTECTED]
  Subject: how to access mysql using vb as front end
 
 
  hi,
  i am using vb as frontend.can we use database as mysql.can we
  access data using mysql ac database.if so how.pls send me teh
  details at the earliest.
regards,
venkat
 
 
  Join 18 million Eudora users by signing up for a free Eudora
  Web-Mail account at http://www.eudoramail.com
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
  [EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 
 

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

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


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

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

mysqlbugs

[khuram . 2 . khan]

this is the binary version which i downloaded and tried to install when i
try to start the server this is the error i get . anyone see anything wrong
with this ! 

010511 11:27:05  mysqld started
ld.so.1: /usr/local/mysql-3.23.33-sun-solaris2.7-sparc/bin/mysqld: fatal:
libcrypt_i.so.1: open f
ailed: No such file or directory
010511 11:27:05  mysqld ended

 Regards 
 Khuram Khan
 
 
 

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

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

Tr: myphpnuke - please help!

[clictime]

- Message d'origine - 
De : clictime 
À : [EMAIL PROTECTED] 
Envoyé: jeudi 10 mai 2001 12:58
Objet : Tr: myphpnuke - please help!

Hello,
I am trying to solve the following problem with mysql on 
myphpnuke-full. Everything is OK in my "localhost" (please see the 
links)
Can you help me?
Thanks a lot
PS: I send you in attachment the "config" file I use on the 
site
Patrick

- Message d'origine - 

De : clictime 
À : [EMAIL PROTECTED] 
Envoyé: mercredi 9 mai 2001 18:40
Objet : myphpnuke - please help!

Hello,
First I'am sorry for my bad english...becausemy 
goodfrench...
Thank you very much for your work with Myphpnuke, it's 
great.
Now to the problem:
Everything is OK in my "local" portal (conf. in Apache server 
as "localhost")
But, I have a (big?) problem with my portal on-line 
at:
http://www.viti-vini.com/essaispr/portail/admin.php
or with the index page:
http://www.viti-vini.com/essaispr/portail/index.php
the data base is OK (the database name is "newsite"), and the 
install procedure works well
I don't understand why there isa parse error in the 
mainfile and fatal error with undifined function
Please help me if you have time for that (I'd like very much 
to use your program)
best regardsPatrick REMONT (from 
Montpellier-France)


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

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

Re: firewall

[Basil Hussain]

Hi,

 can i use a (win) gui mysql client, if i have
 a firewall installed between my intranet and
 mysql server. how?

You should have no trouble, so long as your firewall allows port 3306
through. Also, if your firewall performs Network Address Translation (NAT)
then you'll need to make sure that the access privileges on your MySQL
server allow you to connect from the IP of the firewall.

Other than that, there is nothing else you need to do.

Regards,


Basil Hussain ([EMAIL PROTECTED])


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

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

doesn't have a correct index definition. You need to recreate it before you can do a repair

[root]

Description
I rebooted my server this morning to add more memory, when it was brought back online 
I receive errnor 127 from mysql when I do simple queries like select * from table; I 
run myisamchk --safe-recover and get the following on every single table 
doesn't have a correct index definition. You need to recreate it before you can do a 
repair

Please advise!

Submitter-Id:  submitter ID
Originator:root
Organization:
 
MySQL support: [none ]
Synopsis:  errnor 127 when useing mysql
Severity:  
Priority:  
Category:  mysql
Class: 
Release:   mysql-3.23.33 (Official MySQL RPM)

Environment:
dual p4 450, Linux Mandrake 7.2,
System: Linux sampier.com 2.2.17-21mdksecure #1 SMP Thu Oct 5 12:52:38 CEST 2000 i586 
unknown
Architecture: i586

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/i586-mandrake-linux/2.95.3/specs
gcc version 2.95.3 19991030 (prerelease)
Compilation info: CC='egcs'  CFLAGS='-O6 -fomit-frame-pointer -mpentium'  CXX='egcs'  
CXXFLAGS='-O6 -fomit-frame-pointer  -felide-constructors 
-fno-exceptions -fno-rtti -mpentium'  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 Feb 25 21:09 /lib/libc.so.6 - libc-2.1.3.so
-rwxr-xr-x1 root root   931668 Oct  4  2000 /lib/libc-2.1.3.so
-rw-r--r--1 root root 20749008 Oct  4  2000 /usr/lib/libc.a
-rw-r--r--1 root root  178 Oct  4  2000 /usr/lib/libc.so
-rw-r--r--1 root root   781824 Oct  2  2000 /usr/lib/libc-client.a
Configure command: ./configure  --disable-shared --with-mysqld-ldflags=-all-static 
--with-client-ldflags=-all-static --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 --without-berkeley-db 
'--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: how to access mysql using vb as front end

[Warren van der Merwe]

Hi there

Herewith is the DLL you require (sent on seperate email so as not to clog
the group). This zip file includes the source for the dll as well as some
documentation. Really easy to use and even more so if you already familiar
with ADO.

Regards
Warren

Some sample code

Private Sub Form_Load()

Dim rst as new MYSQL_RS
Dim myDB as new MYSL_CONNECTION

myDB.OpenConnection localhost, root, , Test
if mydb.error.number 0 then goto errorrun

set rst = mydb.execute(SELECT * FROM test ORDER BY id)
if mydb.error.number 0 then goto errorrun

while not rst.eof
text1=trim(rst.fields(Name).value)
rst.movenext
wend

rst.closerecordset
mydb.closeconnection

Exit Sub
ErrorRun:
msgbox Number :   mydb.error.number   Description :  
mydb.error.description,vbcritical,Error!
End Sub


~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Durban, South Africa
Cell (+27-83) 262-9163
Office (+27-31) 767-0249


 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]
 ]On Behalf
 Of Eugénio Veiga
 Sent: 11 May 2001 12:54
 To: [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Subject: Re: how to access mysql using vb as front end


 Hi

 I've been looking in mysql.com and I didn't find myvbql.dll.
 The MySql website you
 talk is www.mysql.com?
 You know all the functions and Sub of the dll that can be used ?

 Thanks

 Eugénio Veiga

 Warren van der Merwe wrote:

  Hi
 
  I am successfully developing with VB and MYSQL using the
 MYSQL API, which
  can be found on the mysql website, look at the download
 section and it is
  called myvbql.dll
 
  Similar to ADO, but a little different.
 
  Works like a dream
  Warren
 
  ~
  Warren van der Merwe
  Software Director
  PRT Trading (Pty) Ltd t/a RedTie
  Durban, South Africa
  Cell (+27-83) 262-9163
  Office (+27-31) 767-0249
 
   -Original Message-
   From: [EMAIL PROTECTED]
   [mailto:[EMAIL PROTECTED]
   ]On Behalf
   Of phani krishna S.V
   Sent: 11 May 2001 09:59
   To: [EMAIL PROTECTED]
   Subject: how to access mysql using vb as front end
  
  
   hi,
   i am using vb as frontend.can we use database as mysql.can we
   access data using mysql ac database.if so how.pls send me teh
   details at the earliest.
 regards,
 venkat
  
  
   Join 18 million Eudora users by signing up for a free Eudora
   Web-Mail account at http://www.eudoramail.com
  
  
 -
   Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
  
   To request this thread, e-mail [EMAIL PROTECTED]
   To unsubscribe, e-mail
   [EMAIL PROTECTED]
   Trouble unsubscribing? Try:
 http://lists.mysql.com/php/unsubscribe.php
  
  
  
 
 
 -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
 [EMAIL PROTECTED]
  Trouble unsubscribing? Try:
 http://lists.mysql.com/php/unsubscribe.php


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

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





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

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

group by and order by

[Sandman]

I have a table with texts, all of different type, I have field named 
type to know which is which. What I would want is with one SQL query 
select the latest from each type, but this query...

select id, headline, type from texts group by type order by date;

will give the first of each type. I would like to specify order by 
before group by, but that won't work. Is there a way to list the 
latest of each type?

thanks for any answers...
-- 
Sandman[.net]




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

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

Re: Problem getting INNOBASE (3.23.37) working on FreeBSD (4.2)

[Heikki Tuuri]

Hi!

In the last episode (May 10), Eric J. Schwertfeger said:
 Also, my initial testing shows that INNOBASE tables are even faster
 than MyISAM, at least for insertions, though the same tupples in a
 similar table seem to take up more room.  Aside from the restrictions

InnoDB tables are faster than MyISAM also for SELECTs. You may look
at the benchmarks at www.innobase.fi. InnoDB calculates simple joins
over 10 times faster than PostgreSQL.

The indexes and data in InnoDB take more room than in MyISAM because
of multiversioning and lack of index compression. You can look at section
8.7.10.4 of MySQL online manual at www.mysql.com, or section 10.4
at the InnoDB online manual at www.innobase.fi. The manual at
www.innobase.fi is always the most up-to-date.

 mentioned in 8.7.4 of the reference manual, are there any other
 gotcha's that I should be looking out for?

You should look at the up-to-date online manual at www.mysql.com
or www.innobase.fi. For example:

- InnoDB tables should not be created as TEMPORARY before 3.23.38.
- In the MySQL replication 'load table from master' does not work yet for
InnoDB tables. A workaround is to alter the table to MyISAM in the master,
do then the load, and after that alter back to InnoDB in the master. 
- You cannot create an index on a prefix of a column: 
CREATE TABLE T (A CHAR(20), B INT, INDEX T_IND (A(5))) TYPE = InnoDB;
The above will not work. For a MyISAM table the above would create an index
where only the first 5 characters from column A are stored. 
-INSERT DELAYED is not supported for InnoDB tables.

Here are two more minuses:

  No ANALYZE TABLE - correct key and subkey cardinality counts work
  wonders for complex queries (probably easy to add).

InnoDB does the estimation of cardinalities required by the MySQL optimizer.
But the counts are not exact, only estimates based on a few dives into the
index tree. If analyze table would read the whole table,
then we could get exact figures.

  No OPTIMIZE TABLE - Any table that you constantly insert and delete
  on is going to fragment and have data blocks with holes.  Since all
  Innobase data goes into a single global tablespace, there's currently
  no way to defrag the space as a while besides dropping and recreating
  everything.

Now I realize I should add to the manual a section on tablespace
management. InnoDB allocates file space to tables and indexes according
to the following algorithm:

- First 32 pages are allocated individually, though still trying to get them
physically contiguous.
- After that InnoDB will allocate whole contiguous 64-page chunks to
the table or index.
- You can defragment a table simply by dumping and dropping it, and then
recreating it.
- InnoDB contracts the indexes and data when rows are deleted from a table:
when the fillfactor of a database page drops below 25 %, InnoDB will try to
merge it to a neighboring page.

Suggested improvements would be the addition of the COALESCE TABLESPACE

Do you mean reorganization and compaction of a tablespace? The way to
do it is to dump and reload all tables in the tablespace.

and REBUILD INDEX commands,

This can be done by dropping the indexe(s) and adding them again.
But I agree that in some circumstances it would be nice to be able
to make an index physically contiguous by copying its pages in order
to another tablespace segment. This would help scans.

and a way to say this tablespace can only
be used for this table/index/database (rebuild index is easy to
implement; table coalescing is harder).

The support for many tablespaces is built in, but there is
currently no user interface to it: we should add parameters to
my.cnf and to the CREATE TABLE syntax. Many tablespaces would help
balance i/o between different physical disks.

 So far, MySQL is doing quite well at matching or exceding PostreSQL's
 performance, though oddly enough, MySQL is taking more memory to do its
 job.  Not complaining, mind you.

I have found that MySQL stays within the memory limits you give it in
my.cnf; you might want to lower some of the buffer settings depending
on your workload.  http://www.mysql.com/doc/S/e/Server_parameters.html
is a good starting point.

InnoDB does not normally allocate memory outside the chunks you
specify in my.cnf. If you have many tables, InnoDB may run out of
additional_mem_pool, and it will allocate memory from the OS:
in this case it prints a warning to the MySQL error log.

Thank you for the feedback! I will add a new section to the manual
today about tablespace management.

Best regards,

Heikki

-- 
   Dan Nelson
   [EMAIL PROTECTED]



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

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

Re: how to split database and index

[Heikki Tuuri]

Hi!

If you use the InnoDB table type, you can configure the InnoDB
tablespace to consist of several 2 GB files which you can put
on different disks or in different directories. Look at the online
manual at www.mysql.com or www.innobase.fi on how to specify the
my.cnf parameters for InnoDB.

Regards,

Heikki

 We have a database of size 10GB and its index is also
 almost of the same size. Now we want this database in MYSQL.
 Please let me know how we can slpit it across 3-4 hard
 disks.We are using Linux 6.2Hi there,

My self I have a machine runnig RH Linux 6.0 with a 70Gb database.
And it works just fine. What you need to do is to, recompile tha source
using --with-raidor download the -max version of mysql
Because what you should do is to use the raid option in create table. It
will then create several
subdirectorys in wich it puts the datafiles. (read more in the manual about
this feature (on CREATE TABLE)). And then just mount diffrent HD/partitions
to the diffrent subdirectoris (works fine for me)
The problem you will have is the indexfile Because as far as I know
no solution has been made to split the index file into smaler files. The
ext2 has a max filesize about 2Gb so you will have a problem.
So for your sake I hope this is not in one table.
Otherwise, my recomendation is to try to split the table into several
smaller tables and thus the indexfiles as well.-
For me that was not possible, so I had to drop all indexed columns (exept my
uniqe numric identifyer) in the main table, and create a kind of quick
serach system (187 tables) of the rest of the data. (so insted of having 1
tabled of 70Gb and 1 index on 50Gb, I have 188 tables total 250Gb and 188
indexes on about 90Gb), but I have some desent speed in on everything.-
/roger


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

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

Windows CE

[Comercial]

hi,
  
  is there a MYSQL Database for MS-Windows CE (for pocket pc
  ex.HP-Jornada)?

synopsis of the problem (one line)

[root]

Description:

How-To-Repeat:

Fix:


Submitter-Id:  submitter ID
Originator:root
Organization:
 
MySQL support: [none | licence | email support | extended email support ]
Synopsis:  
Severity:  
Priority:  
Category:  mysql
Class: 
Release:   mysql-3.23.22-beta (Source distribution)
Server: /usr/bin/mysqladmin  Ver 8.8 Distrib 3.23.22-beta, for redhat-linux-gnu on 
i386
TCX Datakonsult AB, by Monty

Server version  3.23.22-beta-log
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 5 hours 14 min 28 sec

Threads: 2  Questions: 4  Slow queries: 0  Opens: 6  Flush tables: 1  Open tables: 2 
Queries per second avg: 0.000
Environment:

System: Linux Bluetech 2.2.17-8wl2 #1 Sun Jan 14 22:01:31 KST 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.0)
Compilation info: CC='gcc'  CFLAGS='-O2 -march=i386 -mcpu=i686'  CXX='c++'  
CXXFLAGS='-O2 -march=i386 -mcpu=i686'  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   11  3¿ù 26 23:26 /lib/libc.so.6 - libc-2.2.so
-rwxr-xr-x1 root root  4761074 12¿ù 15 22:39 /lib/libc-2.2.so
-rw-r--r--1 root root 22855536 12¿ù 15 22:37 /usr/lib/libc.a
-rw-r--r--1 root root  178 12¿ù 15 22:37 /usr/lib/libc.so
Configure command: ./configure  i386-redhat-linux --prefix=/usr --exec-prefix=/usr 
--bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share 
--includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec 
--localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man 
--infodir=/usr/share/info --without-debug --without-readline --enable-shared 
--with-extra-charsets=complex --without-bench --localstatedir=/var/lib/mysql 
--with-unix-socket-path=/var/lib/mysql/mysql.sock --enable-assembler 
--with-mysqld-user=mysql











:'
q
q:
[21~





:q
:w
:q










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

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 Problem

[webmaster]

Hi 

I am facing great problems beacuse of Mysql server which is not 
able to take load.

My apache is working fine even when the load average shoots of to 
130 
but my mysql server goes sleep when the load of apache shoots 
above 30. I am on a dedicated server.

My Mysql Ver 3.22.32

I have red hat linux 6.2 as OS and memory of 256 MB .

I am attaching my my.cnf file , pls look into it and suggest ways for 
improving my server performance.

I greatly depend on Mysql for efficient running of my site

Hoping to hear from you all and thanks in advance for your support

with best wishes

Arun

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

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

InnoDB, BDB, and Gemini

[Kevin McBrearty]

I have re-read the appropriate manual sections several times, trying to
decide what is the best option for my database table types. I am using
3.32.37 on
Linux, and am torn between InnoDB, BDB, and Gemini table types. Transaction
handling is very important for my application (commit, rollback, etc.).

I am leaning toward InnoDB at this point but was wondering if anyone could
offer any information, other than what is in the manual, regarding the pros
and cons of these table types.

TIA

Kevin McBrearty
ATG Automation Technologies Group Ltd.


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

To 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 access mysql using vb as front end

[Eugénio Veiga]

Hi

Thanks to all of you. I've got the file already.

Regards

Eugénio

Robert Henkel wrote:

 Try going here for the file

 http://www.mysql.com/Downloads/Contrib/MyTool-DLL_for_VB_and_MySQL.zip
 and go to this page for some info on the dll
 http://www.icarz.com/mysql/
 Good Luck!
 -Original Message-
 From: Warren van der Merwe [mailto:[EMAIL PROTECTED]]
 Sent: Friday, May 11, 2001 7:37 AM
 To: 'Eugénio Veiga'
 Cc: [EMAIL PROTECTED]
 Subject: RE: how to access mysql using vb as front end

 Hi there

 Herewith is the DLL you require (sent on seperate email so as not to clog
 the group). This zip file includes the source for the dll as well as some
 documentation. Really easy to use and even more so if you already familiar
 with ADO.

 Regards
 Warren

 Some sample code

 Private Sub Form_Load()

 Dim rst as new MYSQL_RS
 Dim myDB as new MYSL_CONNECTION

 myDB.OpenConnection localhost, root, , Test
 if mydb.error.number 0 then goto errorrun

 set rst = mydb.execute(SELECT * FROM test ORDER BY id)
 if mydb.error.number 0 then goto errorrun

 while not rst.eof
 text1=trim(rst.fields(Name).value)
 rst.movenext
 wend

 rst.closerecordset
 mydb.closeconnection

 Exit Sub
 ErrorRun:
 msgbox Number :   mydb.error.number   Description :  
 mydb.error.description,vbcritical,Error!
 End Sub

 ~
 Warren van der Merwe
 Software Director
 PRT Trading (Pty) Ltd t/a RedTie
 Durban, South Africa
 Cell (+27-83) 262-9163
 Office (+27-31) 767-0249

  -Original Message-
  From: [EMAIL PROTECTED]
  [mailto:[EMAIL PROTECTED]
  ]On Behalf
  Of Eugénio Veiga
  Sent: 11 May 2001 12:54
  To: [EMAIL PROTECTED]
  Cc: [EMAIL PROTECTED]
  Subject: Re: how to access mysql using vb as front end
 
 
  Hi
 
  I've been looking in mysql.com and I didn't find myvbql.dll.
  The MySql website you
  talk is www.mysql.com?
  You know all the functions and Sub of the dll that can be used ?
 
  Thanks
 
  Eugénio Veiga
 
  Warren van der Merwe wrote:
 
   Hi
  
   I am successfully developing with VB and MYSQL using the
  MYSQL API, which
   can be found on the mysql website, look at the download
  section and it is
   called myvbql.dll
  
   Similar to ADO, but a little different.
  
   Works like a dream
   Warren
  
   ~
   Warren van der Merwe
   Software Director
   PRT Trading (Pty) Ltd t/a RedTie
   Durban, South Africa
   Cell (+27-83) 262-9163
   Office (+27-31) 767-0249
  
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
]On Behalf
Of phani krishna S.V
Sent: 11 May 2001 09:59
To: [EMAIL PROTECTED]
Subject: how to access mysql using vb as front end
   
   
hi,
i am using vb as frontend.can we use database as mysql.can we
access data using mysql ac database.if so how.pls send me teh
details at the earliest.
  regards,
  venkat
   
   
Join 18 million Eudora users by signing up for a free Eudora
Web-Mail account at http://www.eudoramail.com
   
   
  -
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)
   
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try:
  http://lists.mysql.com/php/unsubscribe.php
   
   
   
  
  
  -
   Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
  
   To request this thread, e-mail [EMAIL PROTECTED]
   To unsubscribe, e-mail
  [EMAIL PROTECTED]
   Trouble unsubscribing? Try:
  http://lists.mysql.com/php/unsubscribe.php
 
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
  [EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 
 

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

 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 

installation

[stephane parenton]

Hi everyone I'm back to the list...

I have a slight problem... I have downloaded the 3.23.37 in rpm. I installed it on a 
SuSE 7.0 box. At the end of the RPM -Uvh, i had the message you should enter a 
password /usr/bin/mysqladmin...

But after a quick look, I don't have any mysqladmin anywhere on the disk, and 
especially not on /usr/bin... 

anyone had the same problem ?...

TIA
Stephane Parenton

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

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

My Sql C_API(Urgent)

[VVM Ravikumar Sarma Chengalvala]

Hi,
I am using my_sql_real_escape_string and in that the
strmov function of mysqlclient library.
I am getting the following errors while compiling:

d:\program files\mysql\include\m_string.h(143) : error
C2061: syntax error : identifier 'uint'
d:\program files\mysql\include\m_string.h(146) : error
C2061: syntax error : identifier 'uint'
d:\program files\mysql\include\m_string.h(147) : error
C2061: syntax error : identifier 'uint'
d:\program files\mysql\include\m_string.h(149) : error
C2061: syntax error : identifier 'uint'
d:\program files\mysql\include\m_string.h(151) : error
C2061: syntax error : identifier 'pchar'
d:\program files\mysql\include\m_string.h(154) : error
C2061: syntax error : identifier 'my_string'
d:\program files\mysql\include\m_string.h(155) : error
C2146: syntax error : missing ';' before identifier
'strinstr'
d:\program files\mysql\include\m_string.h(155) : fatal
error C1004: unexpected end of file found
Error executing cl.exe.
I could not locate the identifiesrs strinstr etc in
any of the include files.

Can some one guide me for a way out.

Regards,
Ravi



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

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

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

mysql++ for Visual C++

[Gilfether, Ryan]

sorry you all, but I am new to Visual C++, I am trying to get some code
compiled using MySQL++ 1.7.1 for MS Visual C++ 6.0 but I keep getting an
error:

d:\docs\devel\epiware\mysql++\mysql\include\mysql_com.h(115) : error C2146:
syntax error : missing ';' before identifier 'fd'
d:\docs\devel\epiware\mysql++\mysql\include\mysql_com.h(115) : error C2501:
'SOCKET' : missing storage-class or type specifiers
d:\docs\devel\epiware\mysql++\mysql\include\mysql_com.h(115) : error C2501:
'fd' : missing storage-class or type specifiers
d:\docs\devel\epiware\mysql++\include\type_info1.hh(159) : warning C4800:
'unsigned int' : forcing value to bool 'true' or 'false' (performance
warning)


There are more errors, but I am assuming they are being caused by the first
few ... anyone have any clue as to why this is happening, here is the 
contents of mysql_com.h:

  my_socket fd; // line 115, I assume my_socket is not being defined...

Thanks

Ryan Gilfether
Programmer
Praxis, Inc.
www.pxi.com
(703)837-8400 x5412

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

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

Re: Help with MATCH AGAINST

[Bzdpltd]

Hi All,

I am new to this list, and will find it of excellent use to me.

I need help with the following:

What it is I have a cv database and it is working great, I use PHP and MySQL 
and have just come across this problem, the client has asked me to search 
lots of fields in the database. At present we are using the following search 
for searching keywords from 5 fields.

$SQL =  SELECT *, MATCH specific_work_profile,wxcdone, 
wxcdtwo,wxcdthree,wxcdfour AGAINST ('$keywords') AS score FROM cvtemplate 
HAVING score!=0 ORDER BY score DESC;

But the problem is I need the search to do the above as well as searching the 
following: 
'$employment_type' = employment_type
$related_discipline' = related_discipline
'$location' = location

Here is an example of which I thought might work?

$SQL =  SELECT * FROM cvtemplate WHERE employment_type = '$employment_type' 
AND location = '$location' AND related_discipline = '$related_discipline', 
MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST 
('$keywords') AS score FROM cvtemplate HAVING score!=0 ORDER BY score DESC;

But I keep getting a sql syntax error. If anyone can help??

Thanks

Barry

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

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

Re: InnoDB, BDB, and Gemini

[Steve Ruby]

InnoDB definately provides more features that BDB, and is probably
going to be faster, Gemini isn't available yet. BDB might be more
complete/stable.

So I'd say Gemini is out of the picture unless you are looking longer
term.  I'd do some testing with both we found some bugs in the 3.23.37
distribution with regard to BDB, Monty sais they are fix in .38


Kevin McBrearty wrote:
 
 I have re-read the appropriate manual sections several times, trying to
 decide what is the best option for my database table types. I am using
 3.32.37 on
 Linux, and am torn between InnoDB, BDB, and Gemini table types. Transaction
 handling is very important for my application (commit, rollback, etc.).
 
 I am leaning toward InnoDB at this point but was wondering if anyone could
 offer any information, other than what is in the manual, regarding the pros
 and cons of these table types.
 
 TIA
 
 Kevin McBrearty
 ATG Automation Technologies Group Ltd.
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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

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

Re: how to split database and index

[Thalis A. Kalfigopoulos]

On Thu, 10 May 2001, roger westin wrote:

  We have a database of size 10GB and its index is also
  almost of the same size. Now we want this database in MYSQL.
  Please let me know how we can slpit it across 3-4 hard
  disks.We are using Linux 6.2
 
 Hi there,
 My self I have a machine runnig RH Linux 6.0 with a 70Gb database.
 And it works just fine. What you need to do is to, recompile tha source
 using --with-raid
 or download the -max version of mysql
 Because what you should do is to use the raid option in create table. It
 will then create several
 subdirectorys in wich it puts the datafiles. (read more in the manual about
 this feature (on CREATE TABLE)). And then just mount diffrent HD/partitions
 to the diffrent subdirectoris (works fine for me)
 
 The problem you will have is the indexfile Because as far as I know
 no solution has been made to split the index file into smaler files. The
 ext2 has a max filesize about 2Gb so you will have a problem.
 
 So for your sake I hope this is not in one table.
 Otherwise, my recomendation is to try to split the table into several
 smaller tables and thus the indexfiles as well.
 
 -
 For me that was not possible, so I had to drop all indexed columns (exept my
 uniqe numric identifyer) in the main table, and create a kind of quick
 serach system (187 tables) of the rest of the data. (so insted of having 1
 tabled of 70Gb and 1 index on 50Gb, I have 188 tables total 250Gb and 188
 indexes on about 90Gb), but I have some desent speed in on everything.
 -

Which is better? Creating a MERGE table or using the RAID options on create?

TIA,
thalis


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

To 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++ for Visual C++

[Gilfether, Ryan]

I think I have narrowed the problem down to being the SOCKET is not defined
in mysql.h:

#ifndef my_socket_defined
#ifdef __WIN__
#define my_socket SOCKET
#else
typedef int my_socket;
#endif

In my application, i am include mysql++ just as I saw done in an example
that came with
the code  at the top of mysql++ windows.h is included ...

So what am I missing? Thanks 


--- Gilfether, Ryan [EMAIL PROTECTED] wrote: 
sorry you all, but I am new to Visual C++, I am
 trying to get some code
 compiled using MySQL++ 1.7.1 for MS Visual C++ 6.0
 but I keep getting an
 error:
 

d:\docs\devel\epiware\mysql++\mysql\include\mysql_com.h(115)
 : error C2146:
 syntax error : missing ';' before identifier 'fd'

d:\docs\devel\epiware\mysql++\mysql\include\mysql_com.h(115)
 : error C2501:
 'SOCKET' : missing storage-class or type specifiers

d:\docs\devel\epiware\mysql++\mysql\include\mysql_com.h(115)
 : error C2501:
 'fd' : missing storage-class or type specifiers

d:\docs\devel\epiware\mysql++\include\type_info1.hh(159)
 : warning C4800:
 'unsigned int' : forcing value to bool 'true' or
 'false' (performance
 warning)
 
 
 There are more errors, but I am assuming they are
 being caused by the first
 few ... anyone have any clue as to why this is
 happening, here is the 
 contents of mysql_com.h:
 
   my_socket fd; // line 115, I assume my_socket is
 not being defined...
 
 Thanks
 
 Ryan Gilfether
 Programmer
 Praxis, Inc.
 www.pxi.com
 (703)837-8400 x5412
 

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

[EMAIL PROTECTED]
 Trouble unsubscribing? Try:
 http://lists.mysql.com/php/unsubscribe.php
 



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

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

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

Hom many columns is too many?

[Richard Reina]

I am designing an in house database app. for sales/contact management.  
We've identified out about 75 things to know about a customer/contact
from there name all the way to where they went to highschool.  Should
all these attributes be in one table since they all describe the contact
or should they be broken up into seperate tables like education,
professional backround,  business backtound special interests?

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

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

RE: InnoDB, BDB, and Gemini

[Warren van der Merwe]

Goodday to you all

Gemini tables are busy being beta tested, and therefore are available. I
personally use them and so far so good. I really love having row level
locking in MYSQL, and it works like a dream. contact www.nusphere.com for
more info.

There are currently running with 3.23.36

Enjoy
Warren


~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Durban, South Africa
Cell (+27-83) 262-9163
Office (+27-31) 767-0249


 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]
 ]On Behalf
 Of Steve Ruby
 Sent: 11 May 2001 06:10
 To: Kevin McBrearty; [EMAIL PROTECTED]
 Subject: Re: InnoDB, BDB, and Gemini



 InnoDB definately provides more features that BDB, and is probably
 going to be faster, Gemini isn't available yet. BDB might be more
 complete/stable.

 So I'd say Gemini is out of the picture unless you are looking longer
 term.  I'd do some testing with both we found some bugs in the 3.23.37
 distribution with regard to BDB, Monty sais they are fix in .38


 Kevin McBrearty wrote:
 
  I have re-read the appropriate manual sections several
 times, trying to
  decide what is the best option for my database table types.
 I am using
  3.32.37 on
  Linux, and am torn between InnoDB, BDB, and Gemini table
 types. Transaction
  handling is very important for my application (commit,
 rollback, etc.).
 
  I am leaning toward InnoDB at this point but was wondering
 if anyone could
  offer any information, other than what is in the manual,
 regarding the pros
  and cons of these table types.
 
  TIA
 
  Kevin McBrearty
  ATG Automation Technologies Group Ltd.
 
 
 -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
 [EMAIL PROTECTED]
  Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php

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

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




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

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

RE: Hom many columns is too many?

[Robert Henkel]

With relational database design you can more then likely break that 75
column table down into many different tables.  Look up information on NORMAL
FORM  this will help you design an effective database.  Usually from what I
know and have been taught 3rd normal form is as low a level as you want to
go.  But this also depends on things such as how large your db will be.
Sometimes redundant data is not always a bad think.  In that case a lower
normal form would be fine too.  Its an art not a science:)

RH

-Original Message-
From: Richard Reina [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 1:26 PM
To: [EMAIL PROTECTED]
Subject: Hom many columns is too many?


I am designing an in house database app. for sales/contact management.  
We've identified out about 75 things to know about a customer/contact
from there name all the way to where they went to highschool.  Should
all these attributes be in one table since they all describe the contact
or should they be broken up into seperate tables like education,
professional backround,  business backtound special interests?

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

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: InnoDB, BDB, and Gemini

[Robert Henkel]

Have you noticed a significant speed decline using Gemini tables?
RH

-Original Message-
From: Warren van der Merwe [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 11:31 AM
To: 'Steve Ruby'; 'Kevin McBrearty'; [EMAIL PROTECTED]
Subject: RE: InnoDB, BDB, and Gemini


Goodday to you all

Gemini tables are busy being beta tested, and therefore are available. I
personally use them and so far so good. I really love having row level
locking in MYSQL, and it works like a dream. contact www.nusphere.com for
more info.

There are currently running with 3.23.36

Enjoy
Warren


~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Durban, South Africa
Cell (+27-83) 262-9163
Office (+27-31) 767-0249


 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]
 ]On Behalf
 Of Steve Ruby
 Sent: 11 May 2001 06:10
 To: Kevin McBrearty; [EMAIL PROTECTED]
 Subject: Re: InnoDB, BDB, and Gemini



 InnoDB definately provides more features that BDB, and is probably
 going to be faster, Gemini isn't available yet. BDB might be more
 complete/stable.

 So I'd say Gemini is out of the picture unless you are looking longer
 term.  I'd do some testing with both we found some bugs in the 3.23.37
 distribution with regard to BDB, Monty sais they are fix in .38


 Kevin McBrearty wrote:
 
  I have re-read the appropriate manual sections several
 times, trying to
  decide what is the best option for my database table types.
 I am using
  3.32.37 on
  Linux, and am torn between InnoDB, BDB, and Gemini table
 types. Transaction
  handling is very important for my application (commit,
 rollback, etc.).
 
  I am leaning toward InnoDB at this point but was wondering
 if anyone could
  offer any information, other than what is in the manual,
 regarding the pros
  and cons of these table types.
 
  TIA
 
  Kevin McBrearty
  ATG Automation Technologies Group Ltd.
 
 
 -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
 [EMAIL PROTECTED]
  Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php

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

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




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

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

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

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

SELECT TOP?

[Anthony Colli]

Hi all-
 I am really new to the list and mysql. Here is my Question.

 I am used to writing SELECT TOP [num] FROM [table]

 I have searched the documentation online and found no mention of how to do
this. But I did find info on LIMIT that limits the number of records
returned. Is this how mysql limits rows returned? I know it sounds like an
easy question but I am curious.

Thanks
-Anthony

Re: Hom many columns is too many?

[Eric Fitzgerald]

I would personally suggest they be broken up.  I've noticed in the past some
speed issues when you have too many columns.

- Original Message -
From: Richard Reina [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 11, 2001 11:26 AM
Subject: Hom many columns is too many?


 I am designing an in house database app. for sales/contact management.
 We've identified out about 75 things to know about a customer/contact
 from there name all the way to where they went to highschool.  Should
 all these attributes be in one table since they all describe the contact
 or should they be broken up into seperate tables like education,
 professional backround,  business backtound special interests?

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

 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: InnoDB, BDB, and Gemini

[Warren van der Merwe]

In all honesty, I have personally not done any testing of Gemini v.s. other
types as yet. I am busy converting my app from MS Access to MYSQL, once this
is finished I will then be in a better position to answer this as I can test
it.

Regards
Warren


~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Durban, South Africa
Cell (+27-83) 262-9163
Office (+27-31) 767-0249


 -Original Message-
 From: Robert Henkel [mailto:[EMAIL PROTECTED]]
 Sent: 11 May 2001 06:37
 To: '[EMAIL PROTECTED]'; 'Steve Ruby'; 'Kevin McBrearty';
 [EMAIL PROTECTED]
 Subject: RE: InnoDB, BDB, and Gemini


 Have you noticed a significant speed decline using Gemini tables?
 RH

 -Original Message-
 From: Warren van der Merwe [mailto:[EMAIL PROTECTED]]
 Sent: Friday, May 11, 2001 11:31 AM
 To: 'Steve Ruby'; 'Kevin McBrearty'; [EMAIL PROTECTED]
 Subject: RE: InnoDB, BDB, and Gemini


 Goodday to you all

 Gemini tables are busy being beta tested, and therefore are
 available. I
 personally use them and so far so good. I really love having row level
 locking in MYSQL, and it works like a dream. contact
 www.nusphere.com for
 more info.

 There are currently running with 3.23.36

 Enjoy
 Warren


 ~
 Warren van der Merwe
 Software Director
 PRT Trading (Pty) Ltd t/a RedTie
 Durban, South Africa
 Cell (+27-83) 262-9163
 Office (+27-31) 767-0249


  -Original Message-
  From: [EMAIL PROTECTED]
  [mailto:[EMAIL PROTECTED]
  ]On Behalf
  Of Steve Ruby
  Sent: 11 May 2001 06:10
  To: Kevin McBrearty; [EMAIL PROTECTED]
  Subject: Re: InnoDB, BDB, and Gemini
 
 
 
  InnoDB definately provides more features that BDB, and is probably
  going to be faster, Gemini isn't available yet. BDB might be more
  complete/stable.
 
  So I'd say Gemini is out of the picture unless you are
 looking longer
  term.  I'd do some testing with both we found some bugs in
 the 3.23.37
  distribution with regard to BDB, Monty sais they are fix in .38
 
 
  Kevin McBrearty wrote:
  
   I have re-read the appropriate manual sections several
  times, trying to
   decide what is the best option for my database table types.
  I am using
   3.32.37 on
   Linux, and am torn between InnoDB, BDB, and Gemini table
  types. Transaction
   handling is very important for my application (commit,
  rollback, etc.).
  
   I am leaning toward InnoDB at this point but was wondering
  if anyone could
   offer any information, other than what is in the manual,
  regarding the pros
   and cons of these table types.
  
   TIA
  
   Kevin McBrearty
   ATG Automation Technologies Group Ltd.
  
  
 
 -
   Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
  
   To request this thread, e-mail [EMAIL PROTECTED]
   To unsubscribe, e-mail
  [EMAIL PROTECTED]
   Trouble unsubscribing? Try:
 http://lists.mysql.com/php/unsubscribe.php

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

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




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

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




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

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 -- tee command ???

[Joseph Chow]

Hi, everyone,

I have a question about the tee command in MySQL.  I know one of its applications is 
to log everything from the screen to the outfile for debugging purpose.  But how do I 
redirect output ONLY to outfile instead of both standard output (screen) and outfile.  
Because I donot want to see millions of lines scolled down on the screen when I access 
to a huge database, but I still want to debug through looking at the content of the 
db.  I wish I make myself clearly.

Please reply to me directly, because I am not on the mailing list yet.

thanks,

Joe Chow

Re: SELECT TOP?

[Thalis A. Kalfigopoulos]

On Fri, 11 May 2001, Anthony Colli wrote:

 Hi all-
  I am really new to the list and mysql. Here is my Question.
 
  I am used to writing SELECT TOP [num] FROM [table]
 
  I have searched the documentation online and found no mention of how to do
 this. But I did find info on LIMIT that limits the number of records
 returned. Is this how mysql limits rows returned? I know it sounds like an
 easy question but I am curious.
 
 Thanks
 -Anthony
 
 

yes.

t.


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

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

My Sql 3.2.3 and real_escape_string in C API

[VVM Ravikumar Sarma Chengalvala]

Hi,
Does Mysql 3.2.3 support mysql_real_escape_string()?
I donot find it included in the Libmysql.

Regards,
Ravi



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

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

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

Re: MySQL -- tee command ???

[Eric Fitzgerald]

It sounds like you might be more interested in the SELECT * INTO OUTFILE
syntax...read http://www.mysql.com/doc/S/E/SELECT.html for more information.

- Original Message -
From: Joseph Chow [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 11, 2001 9:57 AM
Subject: MySQL -- tee command ???


Hi, everyone,

I have a question about the tee command in MySQL.  I know one of its
applications is to log everything from the screen to the outfile for
debugging purpose.  But how do I redirect output ONLY to outfile instead of
both standard output (screen) and outfile.  Because I donot want to see
millions of lines scolled down on the screen when I access to a huge
database, but I still want to debug through looking at the content of the
db.  I wish I make myself clearly.

Please reply to me directly, because I am not on the mailing list yet.

thanks,

Joe Chow



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

To 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 -- tee command ???

[Paul DuBois]

On Fri, May 11, 2001 at 10:57:51AM -0600, Joseph Chow wrote:
 Hi, everyone,
 
 I have a question about the tee command in MySQL.  I know one of its applications 
is to log everything from the screen to the outfile for debugging purpose.  But how 
do I redirect output ONLY to outfile instead of both standard output (screen) and 
outfile.  Because I donot want to see millions of lines scolled down on the screen 
when I access to a huge database, but I still want to debug through looking at the 
content of the db.  I wish I make myself clearly.
 
 Please reply to me directly, because I am not on the mailing list yet.

tee is for interactive use, so you'll always see the output if you use
it.  You probably want to tell mysql to execute queries from a script
and save the output in another file:

% mysql database_name  inputfile  outputfile

Batch mode changes the default output format to tab-delimited, though.
If you want tabular (table-format) output, use the -t option as well:

% mysql -t database_name  inputfile  outputfile

 
 thanks,
 
 Joe Chow

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

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

Re: Hom many columns is too many?

[ryc]

I dont think the problem was redudant data. He is talking about 75 distinct
fields that no other table contains and ALL data is related to the contact.

It makes sence that a table with more columns would have a higher overhead
when parsing the queries, but but other than that I dont _think_ there
should be a major problem having a table with that many columns. However 75
does seem like it is a very obscene amount for one table, so you may want to
consider creating one table that stores the contacts primary information
(name, address, phone #, business name, ect... ) that is imparative to
working with the contact, and then have another table that contains more
detailed background information. This way if you need the information from
the second table you can left join it, and if you dont need it you dont have
to. Or another scheme is only insert detailed data for the contacts you have
that information on, and leave the rest blank (in this case you wont be able
to use left join because if the column you join on is missing from the
details table the query will return empty, even though the contact is in the
primary table). Either way there are trade offs, decide what is best based
on how much detail information you have from the contacts, and how you want
to lay out your code.

Hope that helps,
ryan

 With relational database design you can more then likely break that 75
 column table down into many different tables.  Look up information on
NORMAL
 FORM  this will help you design an effective database.  Usually from what
I
 know and have been taught 3rd normal form is as low a level as you want to
 go.  But this also depends on things such as how large your db will be.
 Sometimes redundant data is not always a bad think.  In that case a lower
 normal form would be fine too.  Its an art not a science:)

 RH

 -Original Message-
 From: Richard Reina [mailto:[EMAIL PROTECTED]]
 Sent: Friday, May 11, 2001 1:26 PM
 To: [EMAIL PROTECTED]
 Subject: Hom many columns is too many?


 I am designing an in house database app. for sales/contact management.
 We've identified out about 75 things to know about a customer/contact
 from there name all the way to where they went to highschool.  Should
 all these attributes be in one table since they all describe the contact
 or should they be broken up into seperate tables like education,
 professional backround,  business backtound special interests?

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

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

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

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



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

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

2-way replication in MySQL (sql)

[Joseph Chow]

Hi, everyone,

This is my another question.  I have one master server and one slave
server now.  In case that the master is down for any reason, I want the
slave still accessible by clients.  Is that possible in my SQL?  by two way
replications?  This problem seems quiet complicated to me.

Please give me some detail ideas or point out the resources helpful.

thanks a lot,

Joe Chow




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

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

RE: Hom many columns is too many?

[Robert Henkel]

Well with tables not normalized you will more then likely at some point in
get redundant data at some point.  For instance I enter Joe smith with phone
of 123-123-1222 then Joe Smith buys a new home keeps the other home and now
has two active phone number with on table you would have to reenter
information already in the database on Joe Smith unless you keep adding more
columns to accommodate each new phone number(this would be very poor
database design).  Its basic normalizing of tables that will keep this from
happening.  Its is very dependent on the nature of the data on whether you
need to break that table up or not.  I would find it very hard to believe
that all the information needed for customer/contact data
from there name all the way to where they went to high school could be
stored in one table logically or more importantly efficiently.

-Original Message-
From: ryc [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 11:58 AM
To: 'Richard Reina'; [EMAIL PROTECTED]
Subject: Re: Hom many columns is too many?


I dont think the problem was redudant data. He is talking about 75 distinct
fields that no other table contains and ALL data is related to the contact.

It makes sence that a table with more columns would have a higher overhead
when parsing the queries, but but other than that I dont _think_ there
should be a major problem having a table with that many columns. However 75
does seem like it is a very obscene amount for one table, so you may want to
consider creating one table that stores the contacts primary information
(name, address, phone #, business name, ect... ) that is imparative to
working with the contact, and then have another table that contains more
detailed background information. This way if you need the information from
the second table you can left join it, and if you dont need it you dont have
to. Or another scheme is only insert detailed data for the contacts you have
that information on, and leave the rest blank (in this case you wont be able
to use left join because if the column you join on is missing from the
details table the query will return empty, even though the contact is in the
primary table). Either way there are trade offs, decide what is best based
on how much detail information you have from the contacts, and how you want
to lay out your code.

Hope that helps,
ryan

 With relational database design you can more then likely break that 75
 column table down into many different tables.  Look up information on
NORMAL
 FORM  this will help you design an effective database.  Usually from what
I
 know and have been taught 3rd normal form is as low a level as you want to
 go.  But this also depends on things such as how large your db will be.
 Sometimes redundant data is not always a bad think.  In that case a lower
 normal form would be fine too.  Its an art not a science:)

 RH

 -Original Message-
 From: Richard Reina [mailto:[EMAIL PROTECTED]]
 Sent: Friday, May 11, 2001 1:26 PM
 To: [EMAIL PROTECTED]
 Subject: Hom many columns is too many?


 I am designing an in house database app. for sales/contact management.
 We've identified out about 75 things to know about a customer/contact
 from there name all the way to where they went to highschool.  Should
 all these attributes be in one table since they all describe the contact
 or should they be broken up into seperate tables like education,
 professional backround,  business backtound special interests?

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

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

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

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



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

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

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

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

my sql _escape_string

[VVM Ravikumar Sarma Chengalvala]

Hi ,
Can some one send the exact function description of
the following CAPI function:

mysql_escape_string

I need to use mysql_escape_string as the
mysql-real_escape_string is not present in the .def
file and is giveing linker error while linking.

The C-API documentation says to refer
mysql_real_connect instead.

Regards,
Ravi


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

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

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

Re: 2-way replication in MySQL (sql)

[Jeremy Zawodny]

On Fri, May 11, 2001 at 11:50:27AM -0600, Joseph Chow wrote:
 Hi, everyone,
 
 This is my another question.  I have one master server and one slave
 server now.  In case that the master is down for any reason, I want
 the slave still accessible by clients.  Is that possible in my SQL?

Yes.

Just code your software to contact the slave if the master is dead.

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

MySQL 3.23.29: up 128 days, processed 793,208,768 queries (71/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

WEB ACCESS TUTORIAL

[Rainer, Robert]

I am very new to mysql.  I need to write a simple database applicatio that
will allow web access to enter a name and fill in a form.  are there any
good tutorials about using the web and mysql ???


thanks -- rr
 
DISCLAIMER:  The information in this message is confidential and may be
legally privileged.  It is intended solely for the addressee.  Access to
this message by anyone else is unauthorized.  If you are not the intended
recipient, any disclosure, copying, or distribution of the message, or any
action or omission taken by you in reliance on it, is prohibited and may be
unlawful.  Please immediately contact the sender if you have received this
message in error.  Thank you.

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

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

Remote Client Connectivity

[Brian]

I am trying to create an environment where the mysql db server is on one
box and my application server is on a second. The db server is running
on the first box and I can connect to it locally using the mysql
interface.

What needs to be installed from the mysql distribution on the
application server to enable connectivity to the db server?

Should I be able to initiate the mysql client on the app server and
connect to the db server on the first box?

Is there a way to verify the connectivity independent of the app server?


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

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++ visual C++

[Gilfether, Ryan]

i got my initial problem figured out ...but now i am getting a bunch of
linker errors:

msvcprtd.lib(MSVCP60D.dll) : error LNK2005: class
std::basic_ostreamchar,struct std::char_traitschar   __cdecl
std::operator(class std::basic_ostreamchar,struct std::char_traitschar
 ,char const *) (??6std@@YAAAV?$basic_ostream@DU?$cha
r_traits@D@std@@@0@AAV10@PBD@Z) already defined in
mysql++.lib(sql_query.obj)

the example program compiles fine though ... there must be a setting I am
missing in Visual C++ that is different in my project as opposed to the one
that comes with the example program, but I have no idea what it would be ..

Anyone have any ideas?

Ryan Gilfether
Programmer
Praxis, Inc.
www.pxi.com
(703)837-8400 x5412

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

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

Re: InnoDB, BDB, and Gemini

[Eric J. Schwertfeger]

On Fri, 11 May 2001, Kevin McBrearty wrote:

 I have re-read the appropriate manual sections several times, trying to
 decide what is the best option for my database table types. I am using
 3.32.37 on
 Linux, and am torn between InnoDB, BDB, and Gemini table types. Transaction
 handling is very important for my application (commit, rollback, etc.).
 
 I am leaning toward InnoDB at this point but was wondering if anyone could
 offer any information, other than what is in the manual, regarding the pros
 and cons of these table types.

Aside from what's in the manual, I have a little to offer.  I just got
InnoDB working yesterday, so take what I have to say with a grain of salt.

BDB:  I've worked with Berkley DB files (ver 1.8 and 2.? directly from C,
not through MySQL) for several years at work, and they're rather fast for
small databases, but the speed (for mixed inserts/lookups) drops off fast
when you start getting past 10K records.  By the time you've reached 100K
records, you're running at 1/10th the speed you were at 1K records.  For
the tests I was doing, BDB was the one MySQL table type that ran slower
than PostgreSQL (7.1.1) for 250K inserts, and dramatically slower than 
all others for selects that didn't involve an index.  I didn't even run
the rest of the tests.

Gemini: Currently in Beta testing, with no source code available.  You
might be able to get in on the beta program.  I did, I figured we could
test it using Linux emulation on FreeBSD.  Boy, was I wrong.  Not blaming
NuSphere, however.  I was just quite surprized when the remote install
hung.  After going into the area with the server, I found that some part
of the install had triggered a halt on the server.

InnoDB:  Some little voice inside my head is saying it's too good to be
true.  I wrote a program to take about a months worth of our live data
(750K records) and stuff it into a database with a perl script via
DBI.  InnoDB ran about 50% faster than MyISAM, and about 18 *TIMES* faster
than PostgreSQL.  I wasn't expecting InnoDB to be faster than MyISAM,
since InnoDB is transactional and MyISAM isn't, which is one of the
reasons everyone uses to explain why (and when) MySQL is faster than
PostgreSQL.

I'm not claiming that is a fair comparison, as I'm doing more 
comparisions, and won't decide until I've crammed an entire years worth of
data through both databases, including all necessary 
deletions/purges/lookups, etc, and it could be that the problem with
PostgreSQL was the Pg DBI interface.

A few other differences:  Gemini doesn't support BLOBs, and InnoDB is
limited to 8000 byte BLOBs.  Gemini is limited to 2G tables, and I'm not
sure about InnoDB.  You can have multiple InnoDB files, but I don't know
if a table has to reside entirely in one file.


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

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

Encode/Decode Problem

[Augusto Cesar Castoldi]

I'm using encode/decode with PHP to crypt my database.

Until now was OK, but I one string, and the MySQL return the string this
(without the []...):

[Oõ#M¼ô«~àý~ªÔbëÿ9S Z ]

The fact is I can't insert this encode string into MySQL table! My select:

select decode(Oõ#M¼ô«~àý~ªÔbëÿ9S Z , lPi1QzB5%!.dC;@);

I have a  in the middle of the encoded string. How can I solve this
problem?

regards,

Augusto Cesar Castoldi




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

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

group by (bug)

[Rodrigo Moreira Cardoso]

Hi,

   Using this script, you can see the problem.
   I want to receive only the records with string 'I am the first'
   The select will return one record with string 'I am the second'

   please, send me any suggestion or bug-fix.

   Rodrigo
   mailto:[EMAIL PROTECTED]
   
---

create database tabx;
use tabx;
create table abc (ID integer, field1 integer, field2 varchar(30));

insert into abc (ID, field1, field2) values (1, 1, 'I am the first');
insert into abc (ID, field1, field2) values (2, 1, 'I am the second');
insert into abc (ID, field1, field2) values (3, 2, 'I am the first');
insert into abc (ID, field1, field2) values (4, 2, 'I am the second');

insert into abc (ID, field1, field2) values (6, 3, 'I am the second');
insert into abc (ID, field1, field2) values (5, 3, 'I am the first');

select * from abc group by field1;



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

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

inserting into blob on an asp page using vb or javascript

[Nair, Anoop]

Hi All,

I have created a simple MySQL database with a blob field. I would
greatly appreciate it if someone could help me upload a file to a particular
BLOB field using a ASP page with JavaScript or VBScript.

Thanks in advance for all your help,

Anoop

The difficult we do immediately, 
the impossible takes a little longer

Anoop Nair
Southern Company Generation


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

To 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++ visual C++

[Gilfether, Ryan]

ok, i just tried to create a new project that was just a console
application, and everything seems to work there, it is only when I am trying
to build an MFC dialog application that I am getting the linker errors ...

the problem is below:

 // this is fine
Connection con(mysql_cpp_data);

// this causes linker error only for MFC app
Query query = con.query();

whats the problem?

ryan

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

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

simultaneous connections

[Don Pro]

Hi,

I'm reading in my documentation (I have a book) that MySQL allows up to
101 simultaneous connections.  Gadzooks!  How can MySQL claim to be at
the Enterprise level with this limit?  Is there any way around this?

Thanks,
Don


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

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

Update problem, or more likely and problem understanding how to do updates.

[Barry L. Jeung]

Ok, based on the given syntax from the mysql manual..

UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1, [col_name2=expr2, ...]
[WHERE where_definition]
[ORDER BY ...]
[LIMIT #]

I've been trying to update some records in a test database I've been
playing with. I'm inexperienced with MySQL, so I'm hoping someone out
there can enlighten me. When trying to update more than one field at a
time, I get the following error:

ERROR 1064: You have an error in your SQL syntax near 'set Notes =
'Test' where ID ='1'' at line 1

I was trying to perform the following query to change the data below.

mysql select * from Pictures;
+++---+--+---+-+
+---++
| ID | Category   | Title | Filename | Submitter | Date_Posted |
Poster | Notes | Updated|
+++---+--+---+-+
+---++
|  1 | Animal Funnies | pic1  | 0001.jpg | Kiwi  | 2001-05-08  |
WRC| aaa  | 0105111248 |
|  2 | Animal Funnies | asdfa | 0002.jpg | dsoTm | 2001-05-10  |
BLJ|   | 0105111036 |
|  3 | Animal Funnies | test  | 0003.jpg |   | 2001-05-10  |
BLJ|   | 0105102219 |
+++---+--+---+-+
+---++

update Pictures set Date_Posted = '2001-05-09', set Notes = 'Test' where
ID ='1';

It looks syntatically correct according to the example in the manual,
but no matter which combination of fields I try and update, I get that
error. Single field updates for all fields works fine. The table is
defined as follows:
ID = mediumint(8) unsigned NOT NULL auto_increment
Category and Poster = enumerated.
Title, Filename, Submitter = varchar
Date_Posted = date
Notes = tinytext
Updated = timestamp

Please reply directly as I am not on the list. Thanks for your time.


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

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

RE: simultaneous connections

[Robert Henkel]

PREVIOS THREAD ON THIS TOPIC: Hope it helps
Hi,

Make sure that MySQL on your OS supports 5000 connections !
Check OS specific restrictions in MySQL documentation.

Regards
--
Joseph Bueno
NetClub/Trader.com

John Barton wrote:
 
 Try putting a line like the following in your my.cnf file:
 This has always worked for me, including 3.23.37
 
 set-variable = max_connections=
 
 John Barton
 Unix Systems Administrator
 Primary Networks, Inc.
 [EMAIL PROTECTED]
 
 On Thu, 10 May 2001, Mark Lo (3) wrote:
 
  Hi,
 
   I would like to set a higher values in max_connections for mysql.
 
  I have tried to use the following command mysqld --set-variables
  max_connections=900 -u root -ppassword.  Then, it shows that I have
  successfully changed the variable of max_connections.  But, when I check
it
  with the command of mysqladmin variables -u root -ppassword.  The
  max_connections return to 100 which is the default value.  I wonder what
is
  wrong with mysql3.23.37.  Is this a bug, or I am using the wrong
command.
 
  In additions, Can I set the max_connections values higher than 5000.
 
  Thank you
 
  Mark
 
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
[EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 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




-Original Message-
From: Don Pro [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 2:37 PM
To: msql list
Subject: simultaneous connections


Hi,

I'm reading in my documentation (I have a book) that MySQL allows up to
101 simultaneous connections.  Gadzooks!  How can MySQL claim to be at
the Enterprise level with this limit?  Is there any way around this?

Thanks,
Don


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

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: Problem getting INNOBASE (3.23.37) working on FreeBSD (4.2)

[Dan Nelson]

In the last episode (May 11), Heikki Tuuri said:
 Dan Nelson wrote:
   No ANALYZE TABLE - correct key and subkey cardinality counts work
   wonders for complex queries (probably easy to add).
 
 InnoDB does the estimation of cardinalities required by the MySQL
 optimizer. But the counts are not exact, only estimates based on a
 few dives into the index tree. If analyze table would read the whole
 table, then we could get exact figures.

The myisam version of ANALYZE does scan the entire table; I have a
table with a 4-field PRIMARY and after an ANALYZE TABLE, I get the
following:

mysql show keys from ipsum;
+---++--+-+-+-+
| Table | Non_unique | Key_name | Seq | Column_name | Cardinality |
+---++--+-+-+-+
| ipsum |  0 | PRIMARY  |   1 | date|1979 |
| ipsum |  0 | PRIMARY  |   2 | ourip   |   65321 |
| ipsum |  0 | PRIMARY  |   3 | port|  130643 |
| ipsum |  0 | PRIMARY  |   4 | proto   |  130643 |
+---++--+-+-+-+
4 rows in set (0.00 sec)

(there are 130643 records total).  If I do the same on an InnoDB table,
I get:

mysql show keys from ipsum1;
+++--+-+-+-+
| Table  | Non_unique | Key_name | Seq | Column_name | Cardinality |
+++--+-+-+-+
| ipsum1 |  0 | PRIMARY  |   1 | date|NULL |
| ipsum1 |  0 | PRIMARY  |   2 | ourip   |NULL |
| ipsum1 |  0 | PRIMARY  |   3 | port|NULL |
| ipsum1 |  0 | PRIMARY  |   4 | proto   |  223145 |
+++--+-+-+-+
4 rows in set (0.01 sec)

So stats on key parts aren't calculated, and the stats on the index as
a whole are off by 2x.  I don't know if this affects how well the
upper-level SQL optimizer selects indexes.

Interestingly enough, a select count(distinct date) takes 5 seconds
with MyISAM but only 2 seconds with InnoDB, so exact key counts may not
matter if the DB engine is twice as fast :)

 Suggested improvements would be the addition of COALESCE TABLESPACE
 
 Do you mean reorganization and compaction of a tablespace? The way to
 do it is to dump and reload all tables in the tablespace.

During my tests I've found that a 100MB tablespace file gets filled up
even if I'm doing work on a 30MB table, and I can't add another table
without dropping and reloading the first.  It'd be nice if there was a
way to do this wihtout taking tables offline.  The current workaround
is just to allocate much more tablespace than you really need.

-- 
Dan Nelson
[EMAIL PROTECTED]

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

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

Re: simultaneous connections

[John Barton]

Mysql allows 101 connections by default, 100 client connections plut it
reserves one for administrator access. You can set your own maximum
connection limit in the my.cnf file by using the directive:

[mysqld]
set-variable = max_connections=

where xxx is the amount you want to set as the max. See the documentation
for information and recommendations on what to set the max as for your
particular OS.

John Barton
System Administrator
Mpower Communications
[EMAIL PROTECTED]


- Original Message -
From: Don Pro [EMAIL PROTECTED]
To: msql list [EMAIL PROTECTED]
Sent: Friday, May 11, 2001 2:37 PM
Subject: simultaneous connections


 Hi,

 I'm reading in my documentation (I have a book) that MySQL allows up to
 101 simultaneous connections.  Gadzooks!  How can MySQL claim to be at
 the Enterprise level with this limit?  Is there any way around this?

 Thanks,
 Don


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

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

[Steve Ruby]

Don Pro wrote:
 
 Hi,
 
 I'm reading in my documentation (I have a book) that MySQL allows up to
 101 simultaneous connections.  Gadzooks!  How can MySQL claim to be at
 the Enterprise level with this limit?  Is there any way around this?
 
 Thanks,
 Don


http://www.mysql.com/doc/T/o/Too_many_connections.html

The limit is build in to protect people from themselves.

If you wish to change the limit, have at it, note that you may also
need to ajust parameters on your system including number of open files
as well as mysql memory allocation.

It's pretty much just saying 100 is safe for any normal machine, if you
have the resources to go beyond that, read the manual, and change it.

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

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

Re: simultaneous connections

[Steve Ruby]

Don Pro wrote:
 
 Hi,
 
 I'm reading in my documentation (I have a book) that MySQL allows up to
 101 simultaneous connections.  Gadzooks!  How can MySQL claim to be at
 the Enterprise level with this limit?  Is there any way around this?
 
 Thanks,
 Don
 


http://www.mysql.com/doc/T/o/Too_many_connections.html

The limit is build in to protect people from themselves.

If you wish to change the limit, have at it, note that you may also
need to ajust parameters on your system including number of open files
as well as mysql memory allocation.

It's pretty much just saying 100 is safe for any normal machine, if you
have the resources to go beyond that, read the manual, and change it.


Don: fix you mail program, your reply-to is messed, up, how can you
expect
any replies.

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

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

RE: Update problem, or more likely and problem understanding how to do updates.

[Roger Karnouk]

I don't believe you need the second set

update Pictures set Date Posted = '2001-05-09', Notes = 'Test' where
ID ='1';

I think that should work 

-Original Message-
From: Barry L. Jeung [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 3:56 PM
To: [EMAIL PROTECTED]
Subject: Update problem, or more likely and problem understanding how to
do updates.


Ok, based on the given syntax from the mysql manual..

UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1, [col_name2=expr2, ...]
[WHERE where_definition]
[ORDER BY ...]
[LIMIT #]

I've been trying to update some records in a test database I've been
playing with. I'm inexperienced with MySQL, so I'm hoping someone out
there can enlighten me. When trying to update more than one field at a
time, I get the following error:

ERROR 1064: You have an error in your SQL syntax near 'set Notes =
'Test' where ID ='1'' at line 1

I was trying to perform the following query to change the data below.

mysql select * from Pictures;
+++---+--+---+-+
+---++
| ID | Category   | Title | Filename | Submitter | Date_Posted |
Poster | Notes | Updated|
+++---+--+---+-+
+---++
|  1 | Animal Funnies | pic1  | 0001.jpg | Kiwi  | 2001-05-08  |
WRC| aaa  | 0105111248 |
|  2 | Animal Funnies | asdfa | 0002.jpg | dsoTm | 2001-05-10  |
BLJ|   | 0105111036 |
|  3 | Animal Funnies | test  | 0003.jpg |   | 2001-05-10  |
BLJ|   | 0105102219 |
+++---+--+---+-+
+---++

update Pictures set Date_Posted = '2001-05-09', set Notes = 'Test' where
ID ='1';

It looks syntatically correct according to the example in the manual,
but no matter which combination of fields I try and update, I get that
error. Single field updates for all fields works fine. The table is
defined as follows:
ID = mediumint(8) unsigned NOT NULL auto_increment
Category and Poster = enumerated.
Title, Filename, Submitter = varchar
Date_Posted = date
Notes = tinytext
Updated = timestamp

Please reply directly as I am not on the list. Thanks for your time.


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

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

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

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

Re: Update problem, or more likely and problem understanding how to do updates.

[Eric Fitzgerald]

You only need to specify SET once.

update Pictures set Date_Posted = '2001-05-09', Notes = 'Test' where ID
='1';

- Original Message -
From: Barry L. Jeung [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 11, 2001 12:55 PM
Subject: Update problem, or more likely and problem understanding how to do
updates.


 Ok, based on the given syntax from the mysql manual..

 UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
 SET col_name1=expr1, [col_name2=expr2, ...]
 [WHERE where_definition]
 [ORDER BY ...]
 [LIMIT #]

 I've been trying to update some records in a test database I've been
 playing with. I'm inexperienced with MySQL, so I'm hoping someone out
 there can enlighten me. When trying to update more than one field at a
 time, I get the following error:

 ERROR 1064: You have an error in your SQL syntax near 'set Notes =
 'Test' where ID ='1'' at line 1

 I was trying to perform the following query to change the data below.

 mysql select * from Pictures;
 +++---+--+---+-+
 +---++
 | ID | Category   | Title | Filename | Submitter | Date_Posted |
 Poster | Notes | Updated|
 +++---+--+---+-+
 +---++
 |  1 | Animal Funnies | pic1  | 0001.jpg | Kiwi  | 2001-05-08  |
 WRC| aaa  | 0105111248 |
 |  2 | Animal Funnies | asdfa | 0002.jpg | dsoTm | 2001-05-10  |
 BLJ|   | 0105111036 |
 |  3 | Animal Funnies | test  | 0003.jpg |   | 2001-05-10  |
 BLJ|   | 0105102219 |
 +++---+--+---+-+
 +---++

 update Pictures set Date_Posted = '2001-05-09', set Notes = 'Test' where
 ID ='1';

 It looks syntatically correct according to the example in the manual,
 but no matter which combination of fields I try and update, I get that
 error. Single field updates for all fields works fine. The table is
 defined as follows:
 ID = mediumint(8) unsigned NOT NULL auto_increment
 Category and Poster = enumerated.
 Title, Filename, Submitter = varchar
 Date_Posted = date
 Notes = tinytext
 Updated = timestamp

 Please reply directly as I am not on the list. Thanks for your time.


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

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





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

To 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 Quota Support/DB Size Limitations

[Dan Nelson]

In the last episode (May 10), Nathan Boley said:
 Hi, I was interested in implementing size limitations on specific
 databases. I've searched the mysql docs for an mention of quota
 support, but I am not able to find any.  I found that by chown the
 individual database directories and their files and then chmod them
 to be world readable I can access the database.  My assumption (as of
 yet untested) is that given the databases group read permission would
 give me similar results. Then, I can make use of Linux's quota
 system.  The problem arises with the creation of new tables; mysql
 creates all new tables as the user mysql. It doesn't seem as if it

For mysql to create files with different userids, it would have to run
as root and link its user.db to your /etc/passwd file.  There's an
easier way to to it, though.

If you chgrp each database directory to a different group and also set
the suid-group bit (chmod g+s), then any file created in the
subdirectories will inherit the group id of the parent directory (most
other Unixes don't need the setuid-group bit set, but it doesn't hurt).

Then you can set group quotas and enforce space restrictions that way.

-- 
Dan Nelson
[EMAIL PROTECTED]

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

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

Adding columns/tables to mysql database

[Joshua J. Kugler]

I would like to be able to filter users based on other criteria than just 
their name/host.  Will mysql complain/refuse to work if I add columns to the 
mysql database user table, or any other table in the mysql database?  
If I could do that, it would greatly simplify things for me.

Thanks.

j- k-


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

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

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

RE: group by (bug)

[Chris Bolt]

This is not a bug. Why don't you just select * from abc where field2 = 'I am
the first';? Or:

mysql select *, min(field2) from abc group by field1;
+--++-++
| ID   | field1 | field2  | min(field2)|
+--++-++
|1 |  1 | I am the first  | I am the first |
|3 |  2 | I am the first  | I am the first |
|6 |  3 | I am the second | I am the first |
+--++-++
3 rows in set (0.00 sec)

 Hi,

Using this script, you can see the problem.
I want to receive only the records with string 'I am the first'
The select will return one record with string 'I am the second'

please, send me any suggestion or bug-fix.

Rodrigo
mailto:[EMAIL PROTECTED]


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

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

table options and performance

[Steve Ruby]

I've been doing some testing to determine tradeoffs with performance
for using the Innobase or BDB tables.  

The testing application contains bulk inserts which must be processed
as quickly as possible.  The results I'm getting look very bad for
innobase.  Am I doing something wrong?


I'm inserting 49,990 rows via file containing individual inserts
(1 insert per sql statement).  The table contains 7 columns and 6
indexes.  

Why is there so much difference on the time taken to insert the
files?

averages:
MyISAM45 seconds
INNODB1000 seconds
BDB   600 seconds


The machine is a development testing machine and is memory challenged
(192megs ram) these inserts were the only significant process on the
machine at the time (each ran 4 times).

Here are my innodb settings
---
innodb_data_file_path = ibdata:800M
innodb_data_home_dir = /usr/mysql/ibdata
set-variable = innodb_mirrored_log_groups=1
innodb_log_group_home_dir = /usr/mysql/iblogs
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=50M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_arch_dir = /usr/mysql/iblogs
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=20M
set-variable = innodb_additional_mem_pool_size=20M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
-

I expected some loss over MyISAM but the magnitude is much higher than
expected, especially in light of the fact that others have been seeing
innodb to be as fast or faster than MyISAM.

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

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

RE: RTFM - Show locks

[Patrick Calkins]

I too have wondered this... it looks like the manual just says (in your
case) user 'b' will wait indefinitely for the lock held by user 'a' to be
released. Maybe you could just have user 'a' hold a READ or READ LOCAL lock
and not a WRITE lock, therefore user 'b' will still be able to do SELECTS
ok... ??

Patrick

# -Original Message-
# From: Warren van der Merwe [mailto:[EMAIL PROTECTED]]
# Sent: Friday, May 04, 2001 3:39 AM
# To: [EMAIL PROTECTED]
# Subject: RTFM - Show locks
# Importance: High
# 
# 
# database, sql
# 
# Hi there
# 
# I have tried looking in the manual but can't see the solution to this.
# 
# user a issues a lock on table1, userb then tries to do a select and
# obviously the select will wait until the lock is released.
# 
# So my questions are :-
# 
# 1. How do you change the 'timeout' period that userb will wait for?
# 
# 2. When the timeout is reached, I want to give the user a 
# message box that
# shows them who is currently locking the table. How do I see 
# who is locking
# table1?
# 
# Regards
# Warren
# 
# ~
# Warren van der Merwe
# Software Director
# PRT Trading (Pty) Ltd t/a RedTie
# Durban, South Africa
# Cell (+27-83) 262-9163
# Office (+27-31) 767-0249
# 
# 
# 
# -
# Before posting, please check:
#http://www.mysql.com/manual.php   (the manual)
#http://lists.mysql.com/   (the list archive)
# 
# To request this thread, e-mail [EMAIL PROTECTED]
# To unsubscribe, e-mail 
# [EMAIL PROTECTED]
# Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
# 

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

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

MySQL 3.23.38 released

[Michael Widenius]

Hi!

This release includes mainly fixes for BDB and InnoDB tables.

You can now find MySQL-Max (MySQL binaries with support for the above
table types) for most supported platforms at
http://www.mysql.com/downloads/mysql-max-3.23.html

The windows binary is under testing and should hopefully be released
tomorrow (if we don't find any unexpected bugs in BDB or InnoDB under
windows).

Changes in release 3.23.38
--
 
   * Fixed a bug in `REPLACE()' when using the ujis character set.
 
   * Applied Sleepycat BDB patches 3.2.9.1 and 3.2.9.2.
 
   * Added option `--skip-stack-trace' to `mysqld'.
 
   * `CREATE TEMPORARY' now works with `InnoDB' tables.
 
   * `InnoDB' now promotes sub keys to whole keys.
 
   * Added option `CONCURRENT' to `LOAD DATA'.
 
   * Better error message when slave `max_allowed_packet' is to low to
 read a very long log event from the master
 
   * Fixed bug when too many rows where removed when using `SELECT
 DISTINCT ... HAVING'.
 
   * `SHOW CREATE TABLE' now returns `TEMPORARY' for temporary tables.
 
   * Added `Rows_examined' to slow query log.
 
   * Fixed problems with function returning empty string when using
 together with a group functions and a `WHERE' that didn't match
 any rows.
 
   * New program `mysqlcheck'.
 
   * Added database name to output for administrative commands like
 `CHECK', `REPAIR', `OPTIMIZE'.
 
   * Lots of portability fixes for InnoDB.
 
   * Changed optimizer so that queries like `SELECT * FROM
 table_name,table_name2 ... ORDER BY key_part1 LIMIT #' will use
 index on `key_part1' instead of `filesort'.
 
   * Fixed bug when doing `LOCK TABLE to_table WRITE,...; INSERT INTO
 to_table... SELECT ...' when `to_table' was empty.
 
   * Fixed bug with `LOCK TABLE' and BDB tables.

Regards,
Monty

PS: Please use a mirror for downloading (Note that it will probably
take 24 hours until our mirrors are up to date)

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

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

Re: Help with MATCH AGAINST

[Vadim P.]

 $SQL =  SELECT * FROM cvtemplate WHERE employment_type = '$employment_type'
 AND location = '$location' AND related_discipline = '$related_discipline',
 MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST
 ('$keywords') AS score FROM cvtemplate HAVING score!=0 ORDER BY score DESC;
 
 But I keep getting a sql syntax error. If anyone can help??

--

You have 2 FROM clauses - remove the 2nd one.

Also, don't forget that prior to using MATCH...AGAINST you should have created
a fulltext index *exactly* the way you list the fields in MATCH(). In your
case it would be 

FULLTEXT(specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour).

Vadim.

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

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

Re: Hom many columns is too many?

[ryc]

Just because one table has many columns does not mean it is not normalized.
The original message stated that there is all kinds of different information
about a contact from their first/last name to the high school they graduated
from. Given enough information about a person it would be easy to fill 75
columns of DIFFERNT data. Sure there may be a column to store phone
numbers... but that doesnt mean that in order to add another phone number
for a particular contact that you would insert a whole new row. Either a)
you decide not to keep more than one phone number per contact, and use an
update to change the phone number for that contact or b) create a phone
number table so you can create a one to many relationship (one row in the
contact table can have multiple rows in the phone number table).

In case b yes some information is taken out of the contact table and put
into another table, however that is just one column. For things like mothers
maden name and other unique and SINGLE data elements putting that data in
the contact table does not denormalize the table. The only situation in
which I can think to create a seperate table with this sort of information
is a) one contact may have many of column y or b) a majority of the contacts
dont have information for column y, so you create a seperate table for
column y to store the few rows you do have information for, so that your
contact table doesnt have a bunch of empty fields.

Hope this helps.

ryan

 Well with tables not normalized you will more then likely at some point in
 get redundant data at some point.  For instance I enter Joe smith with
phone
 of 123-123-1222 then Joe Smith buys a new home keeps the other home and
now
 has two active phone number with on table you would have to reenter
 information already in the database on Joe Smith unless you keep adding
more
 columns to accommodate each new phone number(this would be very poor
 database design).  Its basic normalizing of tables that will keep this
from
 happening.  Its is very dependent on the nature of the data on whether you
 need to break that table up or not.  I would find it very hard to believe
 that all the information needed for customer/contact data
 from there name all the way to where they went to high school could be
 stored in one table logically or more importantly efficiently.

 -Original Message-
 From: ryc [mailto:[EMAIL PROTECTED]]
 Sent: Friday, May 11, 2001 11:58 AM
 To: 'Richard Reina'; [EMAIL PROTECTED]
 Subject: Re: Hom many columns is too many?


 I dont think the problem was redudant data. He is talking about 75
distinct
 fields that no other table contains and ALL data is related to the
contact.

 It makes sence that a table with more columns would have a higher overhead
 when parsing the queries, but but other than that I dont _think_ there
 should be a major problem having a table with that many columns. However
75
 does seem like it is a very obscene amount for one table, so you may want
to
 consider creating one table that stores the contacts primary information
 (name, address, phone #, business name, ect... ) that is imparative to
 working with the contact, and then have another table that contains more
 detailed background information. This way if you need the information from
 the second table you can left join it, and if you dont need it you dont
have
 to. Or another scheme is only insert detailed data for the contacts you
have
 that information on, and leave the rest blank (in this case you wont be
able
 to use left join because if the column you join on is missing from the
 details table the query will return empty, even though the contact is in
the
 primary table). Either way there are trade offs, decide what is best based
 on how much detail information you have from the contacts, and how you
want
 to lay out your code.

 Hope that helps,
 ryan

  With relational database design you can more then likely break that 75
  column table down into many different tables.  Look up information on
 NORMAL
  FORM  this will help you design an effective database.  Usually from
what
 I
  know and have been taught 3rd normal form is as low a level as you want
to
  go.  But this also depends on things such as how large your db will be.
  Sometimes redundant data is not always a bad think.  In that case a
lower
  normal form would be fine too.  Its an art not a science:)
 
  RH
 
  -Original Message-
  From: Richard Reina [mailto:[EMAIL PROTECTED]]
  Sent: Friday, May 11, 2001 1:26 PM
  To: [EMAIL PROTECTED]
  Subject: Hom many columns is too many?
 
 
  I am designing an in house database app. for sales/contact management.
  We've identified out about 75 things to know about a customer/contact
  from there name all the way to where they went to highschool.  Should
  all these attributes be in one table since they all describe the contact
  or should they be broken up into seperate tables like education,
  professional backround,  business backtound 

New install failed on Linux, what the??

[Chris M]

010511 18:05:14  mysqld started
010511 18:05:14  /usr/local/libexec/mysqld: Table 'mysql.host' doesn't exist
010511 18:05:14  mysqld ended

These error messages above are in the log when I start mysql with:

/usr/local/bin/safe_mysqld --user=mysql 

I can't figure out why, I ran mysql_install_db  mysql doesn't have to be
started first before running that does it?).

Any ideas?

Thanks,
Chris


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

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

DATE for NOW() is incorrect for 64 bit compile

[root]

Description:
Linux Alpha build. NOW() returns correct date, year 2053.

How-To-Repeat:
rimmer:~ # mysql ufn;
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 69 to server version: 3.23.37-Max-log
 
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
 
mysql select NOW();
+-+
| NOW()   |
+-+
| 2053-05-11 17:27:40 |
+-+
1 row in set (0.00 sec)
 
mysql
Fix:

Submitter-Id:  [EMAIL PROTECTED]
Originator:root
Organization:  UserFriendly Media, Inc.
MySQL support: none 
Synopsis:  DATE for NOW() is incorrect for 64 bit compile. Breaks TIMESTAMP fields
Severity:  serious
Priority:  high
Category:  mysql
Class:  sw-bug 
Release:   mysql-3.23.37 (Official MySQL RPM)
Server: /usr/bin/mysqladmin  Ver 8.19 Distrib 3.23.37, for unknown-linux-gnu on 
alphaev56
Copyright (C) 2000 MySQL AB  MySQL Finland AB  TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version  3.23.37-Max-log
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 6 hours 58 min 43 sec

Threads: 16  Questions: 106724  Slow queries: 0  Opens: 22  Flush tables: 1  Open 
tables: 16 Queries per second avg: 4.248
Environment:

System: Linux rimmer 2.2.19 #1 SMP Thu May 10 16:10:11 PDT 2001 alpha unknown
Architecture: alpha

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/alpha-suse-linux/2.96/specs
gcc version 2.96 2731 (SuSE Linux/Alpha)
Compilation info: CC='gcc'  CFLAGS=' -O3'  CXX='c++'  CXXFLAGS=' -O3  
-felide-constructors -fno-exceptions -fno-rtti  '  LDFLAGS=''
LIBC: 
-rwxr-xr-x1 root root  2469003 Feb 28  2001 /lib/libc.so.6.1
-rw-r--r--1 root root  6499024 Feb 28  2001 /usr/lib/libc.a
-rw-r--r--1 root root  180 Feb 28  2001 /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

SCO and getrusage()

[F. Paul Menard]

Hello all,

I am having trouble compiling a client program on a SCO UNIX 5.0.4

I wrote a simple C program to connect to the mysql server which by the way
is  the binary distribution 3.23.36. I am using the SCO cc compiler and
linker. I know how to compile programs on this platform. At least I used to
think I knew what I was doing.

What I have receiving is an error at link time about an unresolved reference
to a symbol 'getrusage' in libmysqlclient.a.

The development system I am using is my main system at my company. My goal
is to migrate the development from using CTREE to mysql. I tried using
various flavors of GCC over the past few weeks after reading many posting
and suggestions. this produces more errors.

As a test I took one of my old system from home. Put the SCO 5.0.4 system on
it, added the default SCO development system, added the mysql distribution
and magically the program compiled!

Does anyone out there know where 'getrusage' lives. I see a reference to the
function in my /usr/include/sys/resources.h header but man show nothing. I
have also post a request to SCO about their libraries.

Any information/direction would be greatly appreciated.

Thanks,

Paul Menard
Houston, TX

Re: My Sql C_API(Urgent)

[Shambhu Kumar singh]

Hi,

Instead of working with the strmov function use pointers to work on it, like I had to
Ex:

char myQuery[1024]=;

CurrentAddress  = myQuery;
CurrentAddress+= mysql_real_escape_string( MysqlStruct,CurrentAddress, string, 
strlen(string) );

Best of Luck,
S.K. Singh.

- Original Message --
=?iso-8859-1?q?VVM=20Ravikumar=20Sarma=20Chengalvala?= [EMAIL PROTECTED] wrote:
To:[EMAIL PROTECTED]
From:=?iso-8859-1?q?VVM=20Ravikumar=20Sarma=20Chengalvala?= [EMAIL PROTECTED]
Date:Fri, 11 May 2001 16:35:21 +0100 (BST)
Subject: My Sql C_API(Urgent)

Hi,
I am using my_sql_real_escape_string and in that the
strmov function of mysqlclient library.
I am getting the following errors while compiling:

d:\program files\mysql\include\m_string.h(143) : error
C2061: syntax error : identifier 'uint'
d:\program files\mysql\include\m_string.h(146) : error
C2061: syntax error : identifier 'uint'
d:\program files\mysql\include\m_string.h(147) : error
C2061: syntax error : identifier 'uint'
d:\program files\mysql\include\m_string.h(149) : error
C2061: syntax error : identifier 'uint'
d:\program files\mysql\include\m_string.h(151) : error
C2061: syntax error : identifier 'pchar'
d:\program files\mysql\include\m_string.h(154) : error
C2061: syntax error : identifier 'my_string'
d:\program files\mysql\include\m_string.h(155) : error
C2146: syntax error : missing ';' before identifier
'strinstr'
d:\program files\mysql\include\m_string.h(155) : fatal
error C1004: unexpected end of file found
Error executing cl.exe.
I could not locate the identifiesrs strinstr etc in
any of the include files.

Can some one guide me for a way out.

Regards,
Ravi



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

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

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


_
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.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

Ordering of Dates

[Colt Ramsden]

I'm creating a Blogger-like system for my website and I have it check for
posts within the last 14 days using the following command:

$result = mysql_query(SELECT * FROM data WHERE TO_DAYS(NOW()) -
TO_DAYS(postdate) = 14,$db);

However, in the while loop and the printf's this is going to display it in
the format of Older to Newer proceeding down the page.

Example:
Yay
posted on 2001-05-11

Fun
posted on 2001-05-12

This is a problem. How would I get it to go in the opposite order...older
posts are last on list, while newer posts are at the beginning?


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

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

RE: Ordering of Dates

[Chris Bolt]

Add ORDER BY postdate DESC to the end of the query.

 I'm creating a Blogger-like system for my website and I have it check for
 posts within the last 14 days using the following command:

 $result = mysql_query(SELECT * FROM data WHERE TO_DAYS(NOW()) -
 TO_DAYS(postdate) = 14,$db);

 However, in the while loop and the printf's this is going to display it in
 the format of Older to Newer proceeding down the page.

 Example:
 Yay
 posted on 2001-05-11

 Fun
 posted on 2001-05-12

 This is a problem. How would I get it to go in the opposite order...older
 posts are last on list, while newer posts are at the beginning?


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

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