--
Pierre-Henry Perret
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.
: 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
/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
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
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
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
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
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
ROTECTED]
el.Com To: Pierre Luguern/France/[EMAIL
PROTECTED]
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
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
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
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
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
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
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
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
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
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
-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]
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]
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
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]
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]
:
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
/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]
.
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
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
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
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
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
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.
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
(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
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
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
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.
-
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
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 !
-
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
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
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
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
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 (
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
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
>
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
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
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
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
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
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
-
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
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
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
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
--
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
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
, 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
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
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
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
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
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
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
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
=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
- 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
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
> 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
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
72 matches
Mail list logo