Security fix for 4.0.27?

2006-06-05 Thread Ken Williams
Anyone know if 4.0.27 will be fixed for the mysql_real_escape issue? (http://lists.mysql.com/announce/364) 4.1 and 5 have been already, kinda wondering why 4.0 hasn't. Thanks. [EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the

UPDATE from one server to another

2006-06-05 Thread Jason Dimberg
I am working on an application where data will be collected on laptops and then uploaded to a central database once the laptop is able to connect to the network after being in the field. I was initially thinking of using MS Access as a front end with linked tables through MySQL ODBC. I am now

yum repos for mysql 5.[1] for FC5

2006-06-05 Thread Brendan Bouffler
Hi all, hate to ask a question that probably has a really obvious answer, but does anyone know of the existence of a mysql 5.1 yum repo that I can point my FC5 box at? -- brendan bouffler Architect, HPC & New Technology APJ ESS Competency Lab x: Sydney, Australia, v: +61 404 097 837 mtb: 2003

Re: procedure analyse() returns bad type?

2006-06-05 Thread Jeremy Cole
Hi Gaspar, The following command returns recommended type FLOAT(3,6) for a double(10,6) column: mysql CAT -t -u catadmin -p -e \ "select * from temp procedure analyse(16,8192)" > temp.log Optimal_fieldtype = FLOAT(3,6) NOT NULL. The trouble is that FLOAT(3,6) does not make sense, with

Re: Moving database files to larger partition?

2006-06-05 Thread Daniel da Veiga
On 6/5/06, Jay Paulson <[EMAIL PROTECTED]> wrote: I'm currently setting up MySQL 4.1.2 on RHEL 4.1 and I have found the /etc/my.cnf file. I'm trying to find out if I change the "basedir" from: Basedir=/var/lib To Basedir=/other/path Will that move the actual data files that have all my datab

Re: Broken Mac pref panel

2006-06-05 Thread Jeff Shapiro
On Sunday 04 June 2006 20:38, Marcus Bointon scribble on about: > On 4 Jun 2006, at 23:25, Marcus Bointon wrote: > > I'm having trouble with the prefpane in OS X > > It seems I'm not alone - there are several reports of this in the > MySQL bug tracker. Looks like a bug in the prefpane: > > http://b

Moving database files to larger partition?

2006-06-05 Thread Jay Paulson
I'm currently setting up MySQL 4.1.2 on RHEL 4.1 and I have found the /etc/my.cnf file. I'm trying to find out if I change the "basedir" from: Basedir=/var/lib To Basedir=/other/path Will that move the actual data files that have all my databases? Do I need to move any of the things that are

Re: hierarchical sql

2006-06-05 Thread Peter Brawley
João Cândido de Souza Neto wrote: Hi everyone, Someone know if mysql 5 has hierarchical sql? http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html PB Thanks. -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 26

hierarchical sql

2006-06-05 Thread Jo�o C�ndido de Souza Neto
Hi everyone, Someone know if mysql 5 has hierarchical sql? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

sad asd as

2006-06-05 Thread sunaram patir
dsa dsad

mysql@lists.mysql.com

2006-06-05 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release:

Re: Subquery Problem With mysql-4.0 (Works with mysql-5.0)

2006-06-05 Thread Pooly
2006/6/5, MySQL Nexeia <[EMAIL PROTECTED]>: I face one problem with mysql4.0 I've two tables, one called company and the other called favorites. The relation between those two tables is CO_ID on the company table and MASTER_CO_ID on the favorites table. When I run the following query it works f

Subquery Problem With mysql-4.0 (Works with mysql-5.0)

2006-06-05 Thread MySQL Nexeia
I face one problem with mysql4.0 I've two tables, one called company and the other called favorites. The relation between those two tables is CO_ID on the company table and MASTER_CO_ID on the favorites table. When I run the following query it works fine on mysql-5.0 but it give error with mysql