Strange behaviour with replication and NO_BACKSLASH_ESCAPES mode

and line also the server argues about a sintax error. It seems that the binary log does not honour the NO_BACKSLASH_ESCAPES mode. Am I missing something or maybe this could be a bug? If you need more detailed explanation please ask. -- Andrea Gangini, Mimesi S.r.l. [EMAIL PROTECTED] Tel. 0521/463811 Cell. 3

bind (listen) question

Hi All, I have a linux box with 2 ethenet interfaces let's say one public 10.10.10.10 and one private 192.168.1.1. How can I configure my.cfg to listen on 192.168.1.1 and 127.0.0.1 but not 10.10.10.10? Thanks in advance. Andrea Sodomaco -- MySQL General Mailing List For list arc

Multiple indexes on same column

dexes were different... is it really so? Could I use only the UNIQUE index also for speeding up the queries? -- Andrea Gangini, Mimesi S.r.l. [EMAIL PROTECTED] Tel. 0521/463811 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.

Slow query log?

uring my server? -- Andrea Gangini, Mimesi S.r.l. [EMAIL PROTECTED] Tel. 0521/463811 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Help with apostrophe and FTS

t yourself. :-) Is that an option for you? Well yes, it's an option. I really need this functionality. But on mysql site, under source downloads, there's this warning: " For maximum stability and performance, we recommend that you use the binaries we provide. " Is it really tru

Help with apostrophe and FTS

Is there the possibility of making the apostrophe char ( ' ) a stopword in mysql? Full text search queries in italian or other European language are greatly affected by that; for example searching "amore" will not return "dell'amore" as a match.... Any workaround sug

Re: Load Data

THAT WORKED! Thanks - that was too easy! Andrea --- Kevin Carlson <[EMAIL PROTECTED]> wrote: > Try this (untested) : > > update table set column=LEFT(column, > LENGTH(column)-1) > > > > Andrea Broerman wrote: > > >I have successfully loaded data from a

Re: Load Data

I am running in Windows. --- dan orlic <[EMAIL PROTECTED]> wrote: > sounds like the difference between a windows system > and a linux > system. If you are doing the > load on a linux system, a simple dos2unix > should set you > straight. > > dan > >

Load Data

data command and not get that symbol stored at the end of the text? Thanks, Andrea __ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com

MySQL Cluster on Windows

I'm trying to understand whether setting up a MySQL cluster running on Windows 2000/2003 is possible. I am not a cluster expert, actually I have only read the MS white papers about it and done some Google search, but still not tried to do it in practice, so forgive me if I make silly questions. S

RE: problem with 4.0.18

Andrea Riela wrote: > Could you help me? well, I've tryed with ktrace, see my kdump: http://www.nesys.it/kdump It's possible, a pid file problem? thanks for your support Regards Andrea -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubsc

RE: problem with 4.0.18

t; Nothing. Could you help me? thanks for support Regards Andrea -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Can't connect

ECTED]' (Using password: NO)' N:\mysql\bin>mysql test ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) Where is the problem? With kind regards, Andrea Beyreuther

problem with 4.0.18

t.pid ib_arch_log_00 ibdata1 observe.log training ib_logfile0 mysql observe.nesys.it.err what about this? where's my mistake? I hope you could help me, now all is down. thanks for support Regards Andrea -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySql bugs?

The original problem is because MySql dosen't support "deferrable constraint". I "solve" this problem with this workaround: UPDATE Prova SET Prog=Prog*-1 WHERE Gruppo=16 AND Prog>=1; UPDATE Prova SET Prog=ABS(Prog)+1 WHERE Gruppo=16 AND ABS(Prog)>=1; > Use ORDER BY clause in UPDATE statement: > h

MySql bugs?

Hi. In MySql I create this table: CREATE TABLE `prova` ( `Gruppo` int(11) NOT NULL default '0', `Prog` int(11) NOT NULL default '0', `Descrizione` varchar(100) default '', PRIMARY KEY (`Gruppo`, `Prog`) ) TYPE=MyISAM; Running this: UPDATE Prog SET Prog=Prog+1 WHERE Gruppo=16 AND Prog>=1

Problems with & (FTS)

AGAINST ( 'at&t' IN BOOLEAN MODE ) returns nothing. I think that the words with the & symbol are splitted while indexing; that explains why "AT&T" is never found (AT is a stopword and T is less than 2 character). Is it possible to instruct mysql to treat words with

Re: WHERE clouse

All the test I've made shows that the first query is faster . I can't believe my eyes. Andrea - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Error 1104 (too many records)

problem is that this query used to work perfectly with previous versions of Mysql and that using SET OPTINION SQL_BIG_SELECTS=1 doesn't help : Does anyone have a clue ? Best Regards Andrea Forghieri Emmegi S.p.A. - Before po

Re: Need help installing PHP (Linux) with MySQL and Apache

che2/modules Then I added the following lines in httpd.conf LoadModule php4_module modules/libphp4.so AddType application/x-httpd-php php SetOutputFilter PHP Have fun Andrea Forghieri - Before posting, please check:

help displaying results from a mysql query with php

Instead of echo htmlspecialchars( stripslashes($row["$i"])); use echo htmlspecialchars( stripslashes($row[0])); In fact , if you increase $i you increase the column thus , in the first cycle you see col 0 , in the second col 1 for more information visit http://www.php.net

Temporary disk tables

table_size | 104857600 | Is there a way of knowing which are the queries that end up creating a temporary disk table and/or how big should the tmp_table_size so to have everything (or at least most of it) in memory? -- - .a.c. - Andrea Carpani - <[EMAIL PROT

Re: Mysql 4.0.4 + InnoDB leads to corrupted tables ?

grown orchards in there ;-) ). After restoring the AC, MySql and InnoDb are back to businness !! As far as I am concerned everithing is running fast and safe an smooth. Bye Andrea Forghieri Andrea, - Original Message - From: ""Andrea Forghieri"" <[EMAIL

Mysql 4.0.4 + InnoDB leads to corrupted tables ?

YISAM tables "linked" (ln -s) from another DB. Could this be the tricky combo ? The following is the configuration of the cpu that runs mysql : OS : Linux (Mandrake 8.2) kernel 2.4.3-20 Mysql : 4.0.4 CPU : Pentium III 800 RAM : 127 Mb Best Regards

Mysql fails a test if compiled with 64 bit gcc on HP-UX 11.00

FROM "1999-01-02 10:11:12") 210 extract(DAY_MINUTE FROM "02 10:11:12") 21011 extract(DAY_SECOND FROM "225 10:11:12") 225101112 extract(HOUR FROM "1999-01-02 10:11:12") 10 extract(HOUR_MINUTE FROM "10:11:12") 1011

Mysql fails a test if compiled with 64 bit gcc on HP-UX 11.00

FROM "1999-01-02 10:11:12") 210 extract(DAY_MINUTE FROM "02 10:11:12") 21011 extract(DAY_SECOND FROM "225 10:11:12") 225101112 extract(HOUR FROM "1999-01-02 10:11:12") 10 extract(HOUR_MINUTE FROM "10:11:12") 1011

Bug in FLOOR() function

Dear Sirs, please try this with Mysql 4.0.2 SELECT 25*9.54; -> 238.5 (so far so good) then SELECT (25*9.54)+0.5; -> 239.000 (still OK ) SELECT FLOOR((25*9.54)+0.5); -> 238 (ouch !!) Best Regards Andrea Forghieri Emm

Mysql hangs on HP-UX 11.00 if queried through jdbc (bug ?)

available and everything seems fine. I've tested the same script with a linux bound server an everything works fine. -- - .a.c. - Andrea Carpani - <[EMAIL PROTECTED]> http://www.vitaminic.[it|com|co.uk|de|es|fr|nl|se|dk|ie] http://www.peoplesound.com http://www.iuma.com

Re: Mysql hangs on HP-UX 11.00 under medium load

mory, you can consult the manual for a possible OS-dependent bug' When this happens the only way out is to reboot mysql. > and you should also use tools like mtop or mytop to monitor what happens during the query inside mysql server. > > My opinion is a matter of query or table desig

Re: Mysql hangs on HP-UX 11.00 under medium load

rrno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug' At first I thought this was a thread problem so I decided to stress the db a little, but the java program is very simple. Anyone has ever seen this error ? -- - .a.c. - Andre

Mysql hangs on HP-UX 11.00 under medium load

bug", and the scripts remain blocked. If I stop the scripts and I wait some time (2 minutes) everything seems to come back to normality. Is there anyone who uses mysql on HP-UX under heavy load that can give me a hint? Thanks. -- - .a.c. - Andrea Carpani - <[EMAIL PROTEC

Create ... select bug

ize 33554432 tmpdir /home/mysql/tmp/ version 4.0.2-alpha-log wait_timeout 28800 Note : You did a great job with multi-table delete !!! THX for existing! Best Regards Andrea Forghieri Project Manager Emmegi S.p.A. - Before posting

Create ... select bug

ize 33554432 tmpdir /home/mysql/tmp/ version 4.0.2-alpha-log wait_timeout 28800 Note : You did a great job with multi-table delete !!! THX for existing! Best Regards Andrea Forghieri Project Manager Emmegi S.p.A. - Before posting

HELP ME!!!

Hello, I have a Sun Os 5.8 with gcc version 2.95.3. When i try to compile mysql with the following command: CC=gcc CFLAGS="-O6" CXX=gcc CXXFLAGS="-O6 -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/usr/local/mysql I have this result: [skip] checking for inline... inline

Problem with Sun Os

This is perl, version 5.005_03 built for sun4-solaris Thanks in advanced Andrea Soracchi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the li

Problem with Sun OS 5.8

Hello, I must installer mysql into a server with SPARC processor and Sun Os 5.8. Which is the correct version that I try to download from mysql site? Thanks in advanced. - Before posting, please check: http://www.mysql.com

Unique indexes and case sensitivity bug(?)

>Description: >How-To-Repeat: >Fix: THANX >Submitter-Id: <[EMAIL PROTECTED]> >Originator: root >Organization: >MySQL support: [none ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release: mysql-4.0.1-alpha (Official MySQL RPM) >Server: /usr/bin/mysqladmin Ver 8.18 Di

mysql_insert_id error

estions? The auto_num field in the database is updating and everything else is working fine Thanks in advance for any help! ~Andrea - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://l

Secure connection with SSH

Hi, Depending on manual, i have information about conecting to a remote MySql from windows with SSH and there a site http://www.doc.ic.ac.uk/~ci2/ssh/ But this site is gone.. :( Where i can download a free ssh ? Thanks - Be

Password routine

Hi all I am interesting on password routine in mysql Could some body help about this routine ? I download the source code of MySql, but i am not yet found about this routine Maybe some body have this routine in Delphi / pascal code Help me please Regards --