bug report

2005-10-04 Thread Pierre-Henry Perret
-- Pierre-Henry Perret

are concurent queries serialized ?

2005-09-28 Thread Bru, Pierre
mean, will 1 connection/queries be executed faster if there is at most 25 concurent queries than if there are 100 or more concurent connections/queries? (by queries, I mean a mix of select (lot) and update (few)) TIA, Pierre.

RE: Master Slave Problem.

2004-06-24 Thread Rousseau, Pierre
: 0 Relay_log_space: 4 1 row in set (0.00 sec) --- and my.ini file : [mysqld] master_host=164.23.43.160 master_user=Replikator master_password=hackmack23 master_port=3306 server_id=10 [WinMySQLAdmin] Server=D:/databank/bin/mysqld-nt.exe note : user/pw correct :( -Pierre Rousseau -x->-Ursprün

Master Slave Problem.

2004-06-24 Thread Rousseau, Pierre
/O thread exiting, read up to log 'FIRST', position 4 I have not found any support for this problem :( Your Faithfully Pierre Rousseau Deutsche Telekom AG T-Com, Technische Infrastruktur Niederlassung Nord Pierre Rousseau E-Mail: <mailto:[EMAIL PROTECTED]> Internet: <ht

Help about a db

2004-05-13 Thread Pierre-Etienne Mélet
Hi all, I have the following data Users : user(varchar), entreprise_1(int), entreprise_2(int) Entreprise: idx(int, prim, auto_incr), code(varchar) some users have one entreprise, and some two. if I decide that 'no entreprise x' is coded with entreprise_x=0, i have obviously a problem with

TIMESTAMP decimal year format available?

2004-04-07 Thread Pierre Didelon
t; yyy.ddd but AFA I understand the mysql doc, it seems not available? Any advice or information would be welcome, thanks in advance, -- Pierre -- DIDELON :@: pdidelon_at_cea.frPhone : 33 (0)1 69 08 58 89 CEA SACLAY

Commercial Licence

2004-03-10 Thread Pierre Luguern
I want to run a commercial product based on MySQL. I have one centralized server running MySQL in replication mode (master server). I have five clients running MySQL (each slave is running one MySQL daemon). Do I have to acquire only one commercial licence for my master server or do I have do get

Replication: Setting up a slave with LOAD DATA FROM MASTER

2004-02-19 Thread Pierre Luguern
ks in advance. Pierre LUGUERN IBM Business Consulting Services Tour Descartes 2 avenue Gambetta - La Défense 5 92066 Paris La Défense Ext: 01 49 05 55 63 Int: (33) 5563 Fax: 01 49 05 81 18 <mailto:[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://list

Replication: Setting up a slave

2004-02-17 Thread Pierre Luguern
fy, I use InnodB scheme for my databases in my master configuration file. I read that the LOAD MASTER FILE FROM MASTER command support will be available for Innodb. Is this command available in my version of mysql ( 4.0.16) If yes ,what is going wrong ? Thanks in advance. Pierre LUGUERN IBM Bus

Re: Replication

2004-02-04 Thread Pierre Luguern
ROTECTED] el.Com To: Pierre Luguern/France/[EMAIL PROTECTED]

Replication

2004-02-03 Thread Pierre Luguern
Is this configuration possible with MySQL ? Server A is acting as a master server for the A database. Server B is acting as a slave, replicating the A database from server A. Server B is acting as a master server for the B Database. Server A is acting as a slave, replicating the B database from

How to make a reminder ?

2003-12-16 Thread Pierre DELGOVE
Hello everybody ! Pierre DELGOVE from Rennes, FRANCE. I am studying a model of database adapted to the management of a veterinary clinic (in order to design perhaps a software that I could use on my own on a GPL license). I meet this practical problem : how could I get a reminder (i.e. after

Exportation

2003-12-08 Thread Pierre-Etienne Mélet
Hi, I have a question concerning the portability of the files of the database. Is there a way to export the content of a database from PC (win or *NIX) to Mac ? Great thanks -- Mélet Pierre-Etienne -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

currency precision with decimal row

2003-10-25 Thread Jean-Pierre Schwickerath
other better way to do it? Regards, Jean-Pierre -- Powered by Linux From Scratch - http://schwicky.net/ PGP Key ID: 0xEE6F49B4 - AIM/Jabber: Schwicky - ICQ: 4690141 Nothing is impossible... Everything is relative! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Re: does mysql supports russion language or any other language?

2003-10-24 Thread Jean-Pierre Schwickerath
u should try to transform the input with something like htmlentities() in PHP. This will translate all non ASCII characters to encoded full ASCII strings which will then be language independent. On the other side, you might try to use mysql-4.1.x with UTF8 rows Jean-Pierre -- Powered by

Re: SELECT Question

2003-10-20 Thread Jean-Pierre Schwickerath
keyw_id=62 AND temp2.keyw_id=16); > I'm not sure which one is more efficient but I'd do it this way: SELECT * FROM table WHERE KEYW_ID = 16 OR KEYW_ID = 62 GROUP BY TBL_IDX HAVING COUNT(TBL_IDX) = 2; Jean-Pierre -- Powered by Linux From Scratch - http://schwicky.net/ PGP

Re: might be a cilly question to u -execuse me.

2003-10-19 Thread Jean-Pierre Schwickerath
t;wher" instead of "where". And as Leonardo pointed out, the version you're using does probably not support subqueries. You might try to write your query as follows: select accounting.* from accounting left join user on accounting.uid = user.uid where user.gid="apswan&qu

Re: Problems with make test for 4.0.14

2003-09-11 Thread Pierre-Luc Soucy
probably disable that code from the test program and compile anyway, but would the resulting MySQL installation work? Also, there are currently RPMs of MySQL installed on the server. Should these be removed before compiling? Any help would be greatly appreciated. Pierre-Luc Soucy Pierre-Luc

Problems with make test for 4.0.14

2003-09-05 Thread Pierre-Luc Soucy
master.pid was not created in 30 seconds; Aborting" (full make test output at the bottom of this message). What's wrong, and what should I do to correct this? Thanks! Pierre-Luc Soucy Full make test output: [EMAIL PROTECTED] mysql-4.0.14]# make test cd mysql

Re: Problem with merge tables in 4.1

2003-08-14 Thread Pierre-Luc Soucy
Hi Dan, Ooops, this makes a lot of sense - it works now. Thanks for letting me know about the perror utility, it should help greatly to identify problems in the future. Regards, Pierre-Luc Dan Nelson wrote: In the last episode (Aug 06), Pierre-Luc Soucy said: I was working on some merge

Optimization question - enum vs tinyint

2003-08-14 Thread Pierre-Luc Soucy
-type field (say 1 for tinyint) make any difference on speed/storage issues? Thanks, Pierre-Luc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem with merge tables in 4.1

2003-08-06 Thread Pierre-Luc Soucy
ine. I am running 4.1.0 on dual-CPU debian box with SCSI RAID hard drives, if that can help. Thanks! Pierre-Luc Soucy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problem compiling mysql-connector-java 3.1.0-alpha

2003-05-30 Thread Pierre
Mark Matthews wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Pierre wrote: Hi, I try to compile mysql-connector-java-3.1.0-alpha on my GNU/Linux system with gcc-3.2, but for the make I got this : # ant Buildfile: build.xml Overriding previous definition of reference to non.test.sources

Problem compiling mysql 4.1.0

2003-05-30 Thread Pierre
be added in the configure script for it (there is already one for 'sed'). Regards, Pierre. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Errors configuring mysql 4.1.0

2003-05-29 Thread Pierre
cking "character sets"... default: latin1; compiled in: latin1 [...] I don't know if it's important but I wanted to report it. Regards, Pierre. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem compiling mysql-connector-java 3.1.0-alpha

2003-05-29 Thread Pierre
: cannot resolve symbol [javac] symbol : method fail () [javac] location: class testsuite.BaseTestCase [javac] fail(); [javac] ^ [...] It would be great if you could help me with this ! Best regards, Pierre. -- MySQL General Mailing List For list

Problem compiling MyODBC 3.51.06

2003-05-29 Thread Pierre
/driver' gmake: *** [all-recursive] Error 1 It would be great if you could help me with this ! Best regards, Pierre. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Database Market Information

2003-02-27 Thread Pierre-Yves Dyon
. Thank you very much. Pierre-Yves Dyon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EM

Segmentation fault

2003-02-08 Thread Pierre-Yves Saumont
Hello, I am using Version : 3.23.40 under Linux and 3.23.51-Max under Windows XP I get the following error message while dumping my database. The segmentation fault is caused by the -c option. (It also occurs under Windows XP). Pierre-Yves Saumont Red Hat Linux release 6.2 (Zoot) Kernel

Re: Problem compiling mysql-3.23.53

2002-12-08 Thread Pierre
I tried mysql-4.0.5a-beta, and same error... Pierre. On 2002.12.08 02:36 Pierre wrote: Hi, I try to compile mysql-3.23.53 on my GNU/Linux system with gcc-3.2 there was no problem with the configure, but for the make I got this : [...] gmake[3]: Entering directory `/tmp/mysql-3.23.53/sql&#x

Re: Error compiling mysql 3.23.53

2002-12-08 Thread Pierre
For information, same error with mysql-4.0.5a-beta Pierre. On 2002.12.09 02:11 Pierre wrote: Hi, I try to compile mysql-3.23.53 on my GNU/Linux system with gcc-3.2 there was no problem with the configure, but for the make I got this : [...] Making all in isam gmake[2]: Entering directory

Error compiling mysql 3.23.53

2002-12-08 Thread Pierre
turned 1 exit status gmake[2]: *** [isamchk] Error 1 gmake[2]: Leaving directory `/tmp/mysql-3.23.53/isam' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/tmp/mysql-3.23.53' gmake: *** [all-recursive-am] Error 2 It

Problem compiling mysql-3.23.53

2002-12-07 Thread Pierre
gmake[2]: *** [all-recursive] Error 1 gmake[2]: Leaving directory `/tmp/mysql-3.23.53/sql' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/tmp/mysql-3.23.53' gmake: *** [all-recursive-am] Error 2 It would be great if you could help me with this ! Best regards, Pierre.

Re: Problem compiling mysql 3.23.53

2002-12-07 Thread Pierre
I finally found the solution : I had bad old include files in /usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.2/include/ that come from a old gcc installation. I removed them and now it's ok. Pierre. On 2002.11.13 06:50 Pierre wrote: Hi, I try to compile mysql-3.23.53 on my GNU/Linux system

Problem compiling mysql 3.23.53

2002-11-15 Thread Pierre
(char*)::cchar_t' [...] I have ncurses-5.3 installed. It would be great if you could help me with this ! Best regards, Pierre. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.m

Problem compiling mysqlgui 1.7.5

2002-11-12 Thread Pierre
Hi, I try to compile mysqlgui-src-1.7.5 on my GNU/Linux system with gcc-3.2 but with the make I got this : # gmake gmake: *** No rule to make target `edfile.o', needed by `mysqlgui'. Stop. It would be great if you could help me with this ! Best regard

mysql OSX 10.2

2002-10-12 Thread Pierre Vaudrey
I just switched mysql from OSX 10.1.5 to 10.2.1with Marc Liyanage package but I ran with the following error : [Ordinateur-de-Pierre-Vaudrey:~] pierreva% mysql dyld: mysql Undefined symbols: /sw/lib/libreadline.4.2.dylib undefined reference to _tgetent expected to be defined in /usr/lib

Problem compiling mysql 4.0.4

2002-10-05 Thread Pierre
mysql-4.0.4-beta/isam' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/tmp/mysql-4.0.4-beta' gmake: *** [all-recursive-am] Error 2 It would be great if you could help me with this ! Best regards, Pierre. -

MySQL Bug: Outer Joins producing incorrect result on a single join referencing multiple tables

2002-09-20 Thread Jean-Pierre Pelletier
4, 'Device'); The following 2 rows should be returned Appliance_ID Health_NMID Health_DeviceOrPort --- --- 0 3 Device 0 4 Device >Fix: Create a temporary table with the result of the inner join and then use t

Maximum number of tables

2002-08-14 Thread Jean-Pierre Georgin
I saw in the MySQL documentation that the myISAM tables maximal size was 8 millions TB. But I couldn't find any information about the maximum number of tables it can support. Can you give me this information ? Thanks a lot ! -

Mysql on Mac OSX

2002-08-02 Thread Pierre Vaudrey
st:/usr/local/mysql] pierreva% Can you help me to find what I'm doing wrong ? Pierre Vaudrey email [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: M$ Acesss Front & MySql-Backend field datatype issues using Myodbc

2002-07-24 Thread Pierre du Parte
preferred development tool is Delphi. Hope this helps Pierre http://www.finalfiler.com chuck amadi wrote: > Hi again . I have a project whereby the client has a legacy M$ Access ( > as far as im concerned ) and i'm to design.build and construct a MySql > v4 Back-end and more tha

Re: Delphi MySQL Access Components

2002-07-24 Thread Pierre du Parte
mySQL somewhere as well. I could never get it work but if it could be made to work then you could use the ADO components distributed with D6 Pro and Enterprise. Pierre http://www.finalfiler.com Daniel Kiss wrote: > Hi, > > Can someone tell me what is the best MySQL native component set f

Re: Replication slave repeatedly gets error 1159 from master

2002-07-15 Thread Pierre Baridon
i have the same probem since i ugraded my slave from 3.23.50 to 3.23.51 Pierre - Original Message - From: "David Harper" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 15, 2002 1:26 PM Subject: Replication slave repeatedly gets error 1159 from m

slave server in readonly

2002-07-10 Thread Pierre Baridon
is it possible to start a server in 'read only' mode ? so that users cannot write in my slave server ? thanks, Pierre --sql,query - Before posting, please check: http://www.mysql.com/manual.php (

debian package

2002-07-10 Thread Pierre Baridon
is there any debian package of mysql supporting innodb ? thanks, Pierre -- sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Re: Implementing commit,transaction in isam table type

2002-07-10 Thread Pierre Baridon
why not using innodb tables ? smart chandar wrote: > I am using Mysql Db that contains Isam table types,I > am developing a project > that is using interrelated tables,unfortunatily isam > table type doesn't support > the commit and transaction,but i should implement > that,can anyone give a >

innodb database schema dump

2002-07-04 Thread Pierre Baridon
how can i dump innodb tables schema with foreign key references so that the tables are created in the right order ? thanks, Pierre -- sql,query - Before posting, please check: http://www.mysql.com/manual.php (the

remove foreign key constraint

2002-06-25 Thread Pierre Baridon
how to remove a foreign key constraint without recreating the innodb table ? thanks, Pierre sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: Unable to add/ edit records - Help needed!

2002-06-22 Thread Pierre du Parte
Nevermind- I just re-installed mySQL and rebooted. everything works again. Pierre Pierre du Parte wrote: > Hi, > > We have been using a simple mySQL database successfully for some time. > The database has a couple of tables and < 1000 records in the primary > table. It has

Unable to add/ edit records - Help needed!

2002-06-22 Thread Pierre du Parte
e mySQL installations, development environments etc. I have removed all keys (except and autoinc primary key) and restrictions on the records and fields. The problem persists. I'm stumped and I'd be most grateful if someone could point me in the direction of a solution. Thanks -- Pier

replication

2002-06-21 Thread Pierre Baridon
hanks Pierre -- sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To uns

replication

2002-06-14 Thread Pierre Baridon
i am trying to setup a slave server (3.23.50) on solaris 2.7 i follow the manual to set it up but when i start this slave server, i have the following error message from mysqld : bin/mysqld: option `--master' is ambiguous where does this --master come from thanks, Pierre -

on delete cascade

2002-06-11 Thread Pierre Baridon
does mysql-max 3.23.50 support the option on delete cascade for the foreign key, the documentation is not very clear on this point Pierre -- sql,query - Before posting, please check: http://www.mysql.com/manual.php

mysql 3.23.50

2002-06-11 Thread Pierre Baridon
where can i get the 3.23.50 packages with innodb support ? Pierre -- sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Indexing words

2002-05-23 Thread Pierre Cloutier
We have an application that needs to index every word (token) in a name, separately. Ex: "New York" must be indexed under "New" and "York". One solution is to create an auxiliary table, extract the tokens one word at a time, and cross-reference to the key of the original table. Ex: CREATE TAB

Re: HELP - Insight into dates, please

2002-05-19 Thread Pierre du Parte
I was a bit vague :-) But your example provided the clue- I had neglected the string delimiters :-( I had coded SET myDate = mmdd I should have coded SET mydate = 'mmdd' which worked. Again, many thanks Pierre --

HELP - Insight into dates, please

2002-05-19 Thread Pierre du Parte
rk out datemask should be -mm-dd but this doesn't work. what is the expected 'datemask'? Or have I got wrong? More importantly are there functions in mySQL I can call to convert a standard date, ie "mmdd" to the expected mySQL value? Any help to get me over thi

GUI for mySQL

2002-04-20 Thread Pierre du Parte
unter in one office tackled me on this - "In Access I can quickly create queries and export the results in all manner of ways. What do I do if we let you talk us into mySql?" Where indeed? Are there any nice, user friendly GUI available for mySQL ad-hoc query and report design? Thanks

Re: Problem with query

2002-04-17 Thread Pierre du Parte
, I've been with Access to long but I'm coming over quickly :-) Pierre Torkil Johnsen wrote: > I am having a small problem with a small mysql query... > > I want to make a list of: > "WHO HAS NOT PAID THEIR MEMBERSHIP FEE". > > I guess I could maybe s

Re: new windows Tool

2002-04-15 Thread Pierre du Parte
I have no objection to you promoting your wares in this group of to your entrepreneurial skills. But to get the message "This trial has expired" on the first run after installing the 9 meg plus download is a bit rough, isn't it? And definitely not the way to win customers! Pie

Re: Free Quote

2002-04-09 Thread Pierre du Parte
I don't know what this (below) is, but gee, it seems good :-) Best wishes -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 "If it feels good, do it!" J Williamson wrot

: myODBC and WinXP/ Access 2000

2002-03-31 Thread Pierre du Parte
tter spamfilter - below is my message... I had myODBC working reasonably well with mySQL under Win2K. However, under XP I now get a weird "unknown error" What's the experience? Should myODBC work with WinXP? -- Pierre du Parté Final Filer Software 349 Worrigee Road Worr

Re: New to MySQL - can't start server :-(

2002-03-17 Thread Pierre du Parte
Win2K, NT and XP very nicely, thank you :) If your mySQL is in c:\ then start c:\mysql\bin\mysqld-nt.exe --standalone should work But I could be wrong, I often am Pierre Alexander Hampel wrote: > Hi mailing list, > > I can't start mysqld-nt as I get the eror message 10

Delphi, ADO and SQL

2002-02-24 Thread Pierre du Parte
auses a 'field not found error' Anyone have any knowledge about this that may help me solve the problem (yeah, I know "don't use ADO") :-) TIA -- Pierre du Parté Final Filer Software Worrigee, NSW, Australia http://www.finalfiler.com 61 2 442204

Re: migrate Microsoft Access Data into MySQL

2002-02-24 Thread Pierre du Parte
and data to mySQL using a 'wizard' interface. It'll be offered in the spirit of mySQL, ie free. I'm nearly done, but need to work out how to handle Access' dbOLE fields. Pierre Admi

RE: Help doesn't work in mysqlgui

2002-02-13 Thread Peter Pierre
mysql Is there a manual for it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, 14 February 2002 10:46 AM To: Peter Pierre Subject: Re: Help doesn't work in mysqlgui Your message cannot be posted because it appears to be either spam or simpl

Foreign keys

2002-01-15 Thread Pierre Radulescu
=INNODB; The second table cannot be created (errno: 150) Thanks in advance for help! Pierre - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: ERROR 1044: Access denied

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

ERROR 1044: Access denied

2001-08-28 Thread Pierre-Yves
Hello, I have a problem with the access : I have created 2 users with no privileges in the user table (privileges are set in the db table, so those users can only access one particular db). the first user has all the privileges set to Y for the db "hello", this user works fine. the second user

Re: Recursive queries

2001-03-05 Thread Pierre-Alain Joye
> create table root( > create table subcats( > create table subsections( And now I need 230 levels, huh :). How about a simple tree structure ? hth pa - Before posting, please check: http://www.mysql.com/manual.php (the

write conflict with myodbc

2001-01-17 Thread LALLART Jean-Pierre
I use C++ Builder version 3 and myodbc to access a mysql database. As I want to update some record, I receive the message record is already in use by another user. I have defined a timestamp and an autoincremant field in the table to access, but the problem still remains. I made the tests with mys