Re: spamassassin database

2010-05-20 Thread Colin Streicher
90% writes, what database engine should I use? Postgres :p In seriousness though, go with whatever the rest of your database uses. There are probably some minor differences between database engines, but for maintenance, you will not regret keeping things consistent. Colin -- MySQL General

Re: Database Quotas

2010-05-20 Thread Colin Streicher
, if its full, its full. Use postgres, you can assign tablespaces to a partition of the size you want. When it gets full, writes are refused. I'm not sure how nicely that is handled ( in terms of error output ) but the advantage is that Pg is ACID compliant, so you won't lose data. Colin -- MySQL

Re: Database Quotas

2010-05-20 Thread Colin Streicher
have a better understanding of this issue than I do... just my .02 Colin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: compile 5.5.4-m3 on centos 5.0

2010-04-19 Thread Colin Streicher
done the right thing so far though and added a note, though you haven't specified what version of the source you are using. Colin On April 19, 2010 03:31:53 am Yang Wang wrote: Dear All, I hit belown problem when i compile(make install) 5.5.4-M3 on centos 5.0

Re: INSERT INTO multiple tables

2010-04-12 Thread Colin Streicher
do it is your option... I would suggest that you do not disconnect between inserts, this is terribly inefficient. Colin On April 12, 2010 05:57:42 pm Gary wrote: Michael Thank you for your response. It gave me the idea how to solve this, and it seemed to have worked! For those following

Re: INSERT INTO multiple tables

2010-04-11 Thread Colin Streicher
Seriously... I found the answer in the first result. http://lmgtfy.com/?q=mysqli+multiple+insert+statements Assuming mysqli, if you are using a different driver, then google that Colin On April 11, 2010 10:36:41 pm viraj wrote: is it mysqli query or 'multi_query'? http://php.net/manual/en

Re: mysqld_safe

2010-03-29 Thread Colin Streicher
Yeah, its just a shell script that acts as a wrapper around the mysql processes on debian systems( maybe others, I'm not sure) You can read it at 'less /usr/bin/mysqld_safe' Colin On March 29, 2010 11:51:36 am Glyn Astill wrote: --- On Mon, 29/3/10, Brown, Charles cbr...@bmi.com wrote

Re: I NEED HELP ON 'SOURCE(\.) MYSQL

2010-02-01 Thread Colin Streicher
what everyone else said... also, is there a longer version of the error? or is it literally error 2 or error 22? Colin On February 1, 2010 06:38:08 pm kebede teferi wrote: Hi, I'm very new to this and I need help. What I want to do is to execute a source command statement from cmd

Re: Image Store @ My SQL

2010-01-30 Thread Colin Streicher
I agree with Walter, a filesystem is far better suited for this. That said, mysql does have the ability to do what you are saying, you would just store it as a binary blob which is well documented and quite easy to use. See: http://dev.mysql.com/doc/refman/5.0/en/blob.html Colin On January

Re: Record old passwords ?

2010-01-18 Thread Colin Streicher
On January 18, 2010 01:34:15 pm Tompkins Neil wrote: Hi I'm in the process of designing a login system to a secure web page using MySQL. One of the features is we need to record and ensure that the user password is different from any of the last four passwords he/she has used. I was

Re: Query help

2009-12-13 Thread Colin Streicher
by columns but to no avail. Can someone help? Thanks, Richard select count(trans_no), comp_id from SEARCHES group by comp_id I think that should do it...haven't tested it though, Colin -- Living your life is a task so difficult, it has never been attempted before. -- MySQL General

Re: Query :: Finding Date Difference

2009-09-27 Thread Colin Streicher
contact admin Please tell the query , Thanks Getting answers to your questions is easier if you can show you have done a little backround work to try to find the answer. Case in point: http://lmgtfy.com/?q=datediff+in+mysql Colin -- MySQL General Mailing List For list archives: http

Re: 1 Machine with 4 GB RAM for Big Size MySQL Data Size

2009-09-04 Thread Colin Streicher
What sort of data? Is it currently stored in a database? If so, how many tables? 24GB of text data in a single table is quite a bit, but manageable if maintained properly. 24 GB of binary data on the other hand, is not very much at all. Colin On Friday 04 September 2009 12:48:18 pm

Re: 1 Machine with 4 GB RAM for Big Size MySQL Data Size

2009-09-04 Thread Colin Streicher
a single point of failure. Colin -- There is a 20% chance of tomorrow. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: sub query or something else

2009-09-03 Thread Colin Streicher
can probably be more helpful. Colin On Thursday 03 September 2009 11:47:17 pm sangprabv wrote: What I'm looking for is to SUM the price from partner A and B with each result. So the result I expect is like Partner A total's price 123, Partner B total's price 456. Can you give me the query

Re: Using Open Source Database

2009-08-27 Thread Colin Streicher
strongly encourage having a good look at Postgresql. In my opinion, it is better suited for a commercial database environment than mysql. If you are curious, join the Postgresql general mailing list and watch the traffic for a couple days, see what others are using it for. Colin -- MySQL

Re: How to use LIKE for detecting numbers with commas?

2009-07-07 Thread Colin Streicher
LIKE '%,8,%' ? Probably not as elegant as you were looking for, but it works :) Colin On Monday 06 July 2009 21:31:51 Highviews wrote: Hi, I have numbers separated with commas saved into a TEXT Field, for example: ROW1: 10,5,2,8, ROW2: 2,7,9,65 ROW3: 99,100,55,10,88, etc... Now i

Re: Patch for mysql

2008-09-22 Thread Colin Charles
this might be), I'd avoid this method of getting things done -- Colin Charles, http://bytebot.net/blog/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Migration from 32-bit to 64-bit MySQL

2008-04-28 Thread Colin Charles
32-bit and 64-bit? Is this a good idea? Can it be done? What would make this go wrong? Addressing more RAM currently is your only gain... On a 32-bit system, you tend to only have 2.5-2.7GB of RAM available to MySQL (your OS needs the remainder) Kind Regards -- Colin Charles

Re: Migration from 32-bit to 64-bit MySQL

2008-04-28 Thread Colin Charles
longer kind regards -- Colin Charles, Community Relations Manager, APAC Database Group, Sun Microsystems Inc., http://www.mysql.com/ Tel: +6012 204 3201 (Malaysia) | colincharles (Skype) Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List

Index usage for simple query

2007-10-25 Thread Colin Martin
| type | possible_keys | key | | 1 | SIMPLE | data_total | ALL | source| NULL | (Output chopped for better formatting) Thanks, Colin Martin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Index usage for simple query

2007-10-25 Thread Colin Martin
Baron Schwartz wrote: Hi, Colin Martin wrote: Hi there, Can someone please explain why when the query below uses one constant in the WHERE clause, MySQL decides to use the index on the 'source' column, and why in the second query where there are two constants, it decides

Re: Availability of 5.1 as production release ?

2007-03-27 Thread Colin Charles
this year, I believe -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Ekiga/Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Users Conference: http://www.mysqluc.com/ -- MySQL General Mailing List For list archives: http

Re: incompatible libmysqld.a

2007-02-26 Thread Colin Charles
is a problem. It compiles with glibc v2.5 on Fedora Core 6 This computer is a laptop Acer Aspire 5633WLMi, Intel Core Duo processor. Can you file a bug report at bugs.mysql.com? thanks -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12

Re: Error MYI 1016 - damaged database table

2007-02-14 Thread Colin Charles
of the MySQL installation, can be executed on the server when the database server is no longer running: myisamchk /path/to/database/directory/database table name.MYI Dans quel fichier devrais-je intervenir? -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile

Re: mysql_upgrade shows errors

2007-02-14 Thread Colin Charles
Yves Goergen wrote: On 14.02.2007 08:00 CE(S)T, Colin Charles wrote: The MySQL 5.0 release is available as a binary and is currently at 5.0.27. Grab it at: http://dev.mysql.com/downloads/mysql/5.0.html#downloads I read in the news some time ago that MySQL 5.0 is only going to be available

Re: incompatible libmysqld.a

2007-02-14 Thread Colin Charles
provide more details. Also, what version of gcc is this? thanks -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List

Re: Repairing a table

2007-02-13 Thread Colin Charles
(Falcon is meant to fix this)... Do you know why the disk is filling up so fast? What MySQL version is this? And how much *actual* free space do you have? -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http

Re: mysql_upgrade shows errors

2007-02-13 Thread Colin Charles
error messages mean? The upgrade script picked up on the fact that you had duplicate column names -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com

Re: Setting up multiple daemons

2007-02-13 Thread Colin Charles
might consider reading: http://dev.mysql.com/doc/refman/5.0/en/multiple-unix-servers.html There is also documentation if you wanted to do this on Windows -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http

Re: Log Warnings Level

2007-01-19 Thread Colin Charles
-- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: MySQL Administrator problem

2007-01-17 Thread Colin Charles
Ed Reed wrote: Unable to manage user accounts through MySQL Administrator 1.2.8. I've found that I'm not the only one with this problem but no one seems to have an answer for it. Have you reported a bug to bugs.mysql.com ? kind regards -- Colin Charles, Community Engineer MySQL AB

Re: Log Warnings Level

2007-01-17 Thread Colin Charles
the documentation there is on this? What kind of additional information are you looking about the --W (or --log-warnings=N) option? I'd pay attention to aborted connections, as MySQL Network's monitoring service actually does do so kind regards -- Colin Charles, Community Engineer MySQL AB

Re: mysqld_safe failing

2007-01-17 Thread Colin Charles
server can't access /var/run/mysqld I suggest making sure the permissions are correct (using chown will fix it) -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http

Re: Please help*

2007-01-17 Thread Colin Charles
://dev.mysql.com/doc/refman/5.0/en/installing-source.html -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives

Re: yum version 5.*

2007-01-17 Thread Colin Charles
is currently released -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

MySQL MiniConf at linux.conf.au 2007 CfP

2006-11-21 Thread Colin Charles
by Linux Australia. This means that you must register for LCA 2007 attendance to participate in the conference. For further details regarding registration and accommodation for LCA 2007, please visit LCA 2007. Speakers will be notified by 7th December 2007. -- Colin Charles, Community Engineer MySQL

MySQL Camp

2006-10-24 Thread Colin Charles
Hi all, Please note that MySQL Camp will be happening soon in San Francisco, and its being hosted at the Google campus. Do pay it a visit if you're nearby http://mysqlcamp.org/ Check out the interesting topics! -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia

Re: installing mysql

2006-08-30 Thread Colin Charles
read the 3-4 MySQL upgrade guide in our excellent documentation? best regards, -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype: colincharles MySQL Forge: http

Re: How does the federated engine table work

2006-08-30 Thread Colin Charles
? http://dev.mysql.com/doc/refman/5.0/en/federated-description.html http://www.oreillynet.com/pub/a/databases/2006/08/10/mysql-federated-tables.html hope this helps -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext

Re: MySQL App development

2006-08-30 Thread Colin Charles
[EMAIL PROTECTED] wrote: Is there anything called MySQL application development environment guide, as it is there DB2 (IBM) which explains how to work with MySQL and C++ together? Can you show me what DB2 does that's different from our C++ API? Or can I refer DB2 App guide? No -- Colin

Re: MySQL+OpenVPN

2006-08-30 Thread Colin Charles
is setup is a completely other matter -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype: colincharles MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list

Re: Drupal and MySQL

2006-08-30 Thread Colin Charles
broke (which really shouldn't affect Drupal, unless PHP itself is to be blamed) -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype: colincharles MySQL Forge: http://forge.mysql.com

Re: MySQL 5.1

2006-08-30 Thread Colin Charles
5.1, so you get disk as opposed to memory only based storage then -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype: colincharles MySQL Forge: http://forge.mysql.com/ -- MySQL

Re: Support for JDBC 4.0?

2006-08-30 Thread Colin Charles
being released by Sun till late October. So, we expect to start shipping after Sun's sorted things out hope this helps -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype

Re: Drupal and MySQL

2006-08-30 Thread Colin Charles
Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem wrote: On Thu, Aug 31, 2006 at 09:52:37AM +1000, Colin Charles wrote: Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem wrote: Has anyone heard of drupal breaking under a minor upgrade from

Re: measuring query time

2006-06-02 Thread Colin Charles
Deniz Ersoz wrote: Is there a way to get the time spent in the server for each query? Write it in a log or append it to the result ??? Will what is in the slow query log help? -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46

Re: /var/log/mysql.000001 Not Found?

2006-03-26 Thread Colin Charles
should be logging to /var/log/mysql/foo, and make sure that /var/log/mysql can be read/written to by the mysql server HTH -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype

Re: Error Messages

2006-03-26 Thread Colin Charles
and the my.cnf config file Also, is this with MySQL 5.0.19? -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype: colincharles Using MySQL for a FLOSS application? http://dev.mysql.com/doc

Re: Can MySQL jobs be posted to this list?

2006-01-23 Thread Colin Charles
Beau Gould wrote: Thank you, Beau Gould The best place for this would probably be the Jobs forum located at http://forums.mysql.com/list.php?8 -- Colin Charles, Community Engineer MySQL AB, Kuala Lumpur, Malaysia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Are you

Re: upgrade advice

2006-01-22 Thread Colin Charles
a visit as well. Hope this helps -- Colin Charles, Community Engineer MySQL AB, Kuala Lumpur, Malaysia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: How to create database in different location

2006-01-04 Thread Colin Charles
to replicate? Or use clustering? More details are required. Kind regards -- Colin Charles, Community Engineer MySQL AB, Kuala Lumpur, Malaysia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List

Re: which release of Mysql is compatible with fedora core3 ?

2005-12-10 Thread Colin Charles
the Fedora Project provided version, that caps of 3.23 (the RPM's available via yum) Hope this helps -- Colin Charles, Community Engineer MySQL AB, Kuala Lumpur, Malaysia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Are you MySQL certified? www.mysql.com/certification

.NET Connector Output Values

2005-12-04 Thread Colin Shreffler
I have the following code: ... query = INSERT INTO a_test_table (a_test_table_id,name,last_mod_date,create_date) VALUES (?a_test_table_id,?name,?last_mod_date,?create_date); ... command.Prepare(); ... command.Parameters.Add(?a_test_table_id, MySqlDbType.Int32);

Executing multiple queries at a time in Query Browser

2005-11-26 Thread Colin Shreffler
. Is there some other command that I need to add between queries? Thanks, Colin

calling procedures from the .NET provider

2005-11-22 Thread Colin Shreffler
anyone been able to get this to work? Thanks, Colin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: how to installing mysql5 on fc3?

2005-11-20 Thread Colin Charles
regards -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

User Accounts

2005-10-22 Thread Colin Shreffler
After installing MySQL on OS X, there don¹t appear to be any user accounts created by default. Does anyone know what user account to use or if there is a convention that I should use when creating an ŒAdmin¹ account? Cheers -c

Re: Moving Data

2004-09-10 Thread Colin Bull
ESS disks on SAN, and they're RAID 5. See www.baarf.com for comments against RAID 5 Colin Bull -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Foreign Key Constraints

2004-05-27 Thread Colin Bull
reports is easiest and no constraint. Colin Bull -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: unique values across more than one column

2004-03-01 Thread Colin Williams
to the user table using a foreign key. Regards, Colin. -Original Message- From: Anand Buddhdev [mailto:[EMAIL PROTECTED] Sent: 27 February 2004 08:50 To: [EMAIL PROTECTED] Subject: unique values across more than one column Hi everyone, I'm using mysql version 3.23.58, on Fedora core 1

Installing MySQL 4.1 on RedHat Linux 7.2

2004-02-26 Thread Colin Lawrence
? Colin Lawrence

Create database error

2004-02-23 Thread Colin O'Connor
, errno: 2 means No such file or directory. Does anyone know why it might be giving me that error? Thanks, Colin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Running mysql standalone

2004-02-10 Thread Colin O'Connor
that option out, it says Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist. This, to me, suggests I need to install MySQL properly. But I don't want it to have to be installed! Any suggestions? Thank you, Colin O'Connor -- MySQL General Mailing List For list archives: http

Re: count max days

2003-10-20 Thread Colin Kettenacker
Whenever you use the Max() function on a column while accessing other columns at the same time you need a GROUP BY statement so that the MAX() function knows how to group it's results. I suggest you look into the manual for this. In fact it has a tutorial showing you options on how to do exactly

error loading mod_auth_mysql

2003-07-23 Thread Colin Prince
load /usr/libexec/httpd/libphp4.so into server: (reason unknown) Is there a particular order that this had to go in the httpd.conf file? I can't understand why it is complaining about libphp4. What do you think I'm doing that I should be doing differently? Thanks very much. Colin. -- MySQL

mysql fails at strat

2003-06-16 Thread Colin Knowles
not find anything in the documentation about this I thought I better contact you. Best regards Colin Knowles How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: Colin

Problems returning a row count with rows() function

2003-02-24 Thread Harbison, Colin
you can provide... Colin - 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

Sequential read on a file

2003-02-19 Thread Colin
? My main concern is that, with the key being auto-increment, as records are added and removed from the database, as simple +1/-1 may fall over. -Colin - Before posting, please check: http://www.mysql.com/manual.php (the manual

RE: Sequential read on a file

2003-02-19 Thread Colin
a bit here as we look to move towards web-based systems. Regards, Colin K Heaps -Original Message- From: Jerry [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 3:01 PM To: Colin; [EMAIL PROTECTED] Subject: Re: Sequential read on a file Use and id column, like an auto

Re: MySQL3.23.52 with snort-1.9.0

2002-12-12 Thread Colin . Slevin
Hi there , I am problems with snort logging to Mysql and I am wondering if this is a permissions problem . If any of you have worked on the snort IDS technology could you please help because I having severe difficulty with the product. The permissions I have given the User snort are GRANT

Re: Formatting data in a query

2002-09-25 Thread Colin Anderson
want to use the SUBSTRING function. E.g. SELECT password, SUBSTRING(username, 1, 6) FROM my_table WHERE ... See the MySQL manual for more info: http://www.mysql.com/doc/en/String_functions.html Thanks, Colin Anderson [EMAIL PROTECTED

For all you people looking for mysql shirts ;-)

2002-08-16 Thread Colin Faber
in advance if anyone is offended by this post. FILTER FODDER{ SQL, SELECT, DATABASE } -- Colin Faber (303) 736-5160 fpsn.net, Inc. * Black holes are where God divided by zero. * - Before posting, please check: http

repeated crashes (buffer overrun?)

2002-07-31 Thread Colin Anderson
to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 670938 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Any ideas? - Colin - Before posting, please check: http://www.mysql.com/manual.php

Re: a newserver would be better than this mailing list

2002-07-30 Thread Colin Faber
? See http://groups.google.com/groups?hl=enlr=ie=UTF-8safe=offgroup=mailing.database This list is already fed to a usenet group. -- Colin Faber (303) 736-5160 fpsn.net, Inc. * Black holes are where God divided by zero

Re: Bash to remote MySql Server

2002-07-18 Thread Colin Faber
/ (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 -- Colin Faber (303) 736-5160 fpsn.net, Inc

Re: copy question

2002-07-17 Thread Colin Faber
/ (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 -- Colin Faber (303) 736-5160 fpsn.net, Inc

Re: Opposite of --skip-networking?

2002-07-17 Thread Colin Faber
(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 -- Colin Faber (303) 736-5160 fpsn.net, Inc

Re: MySQL on a Cobalt RAQ4

2002-07-16 Thread Colin Faber
unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Re: Read-Only MySQL

2002-07-09 Thread Colin Faber
[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: ROOT Access Denied !!

2002-06-11 Thread Colin Cooler
Thank you Ray, this worked! Colin on 6/11/02 2:59 PM, Ray at [EMAIL PROTECTED] wrote: mysql --password (or just -p) On Tuesday 11 June 2002 7:30, you wrote: When I try to connect to mysql as 'root' I get the following: [localhost:/Users/cooldaze] root# mysql ERROR 1045: Access denied

Re: Newbie MySQL installation problems (specific)

2002-06-09 Thread Colin Cooler
understand is not a good idea) or under my normal login, I get the same error, i.e., that the socket can't be found. Very puzzling and I'm quickly approaching the point of concluding that the amount of time trying to troubleshoot this mess not warranting the potential benefits. Colin Have you tried

Re: MySQL and DBI remote access

2002-06-07 Thread Colin Faber
) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please

Re: Get message

2002-06-03 Thread Colin Faber
) 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 -- Colin Faber (303) 736-5160 fpsn.net, Inc

Re: Tab delimited dump?

2002-05-29 Thread Colin Faber
) 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 -- Colin Faber (303) 736-5160 fpsn.net, Inc

Re: Demande d'inscription à mysql-france

2002-05-28 Thread Colin Faber
/ (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 -- Colin Faber (303) 736-5160 fpsn.net, Inc

Re: apparent bug

2002-05-20 Thread Colin Faber
Hi Buff, Try under the optimization section. Though keep in mind the impact on speed shouldn't be that great.. By the way.. in an ideal design your primary key will be an integer ;-) Buff Smith wrote: Colin, Where can I read about the impact of having Primary Keys as VARCHAR

Re: apparent bug

2002-05-18 Thread Colin Faber
) 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 -- Colin Faber (303) 736-5160 fpsn.net, Inc

Re: Database's Disappear from phpMyAdmin

2002-05-17 Thread Colin Faber
this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check

Re: Is there MySQL version 4.0.2 ?

2002-05-15 Thread Colin Faber
something wrong or I shall forget about BitKeeper as I am using the Windown 2000? Any suggestion? Thanks, Viliam Batka -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com

Re: mysql error

2002-05-15 Thread Colin Faber
in version 3.23.49 if yes what is the alternate command for it. Would appreciate any help you can give me. Tristan -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com

Re: empty?

2002-05-15 Thread Colin Faber
, 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 -- Colin

Re: Temp Table size?

2002-05-15 Thread Colin Faber
/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 -- Colin Faber (303) 736-5160 fpsn.net, Inc

Re: Load data command?

2002-05-15 Thread Colin Faber
] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: source code

2002-05-14 Thread Colin Faber
/ (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 -- Colin Faber (303) 736-5160 fpsn.net, Inc

Re: mixed up variables || solution found

2002-05-14 Thread Colin Faber
, 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 -- Colin

Re: mysql uses 99% cpu under freebsd 4.3

2002-05-13 Thread Colin Faber
] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: Is there MySQL version 4.0.2 ?

2002-05-13 Thread Colin Faber
://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 -- Colin Faber (303) 736-5160 fpsn.net, Inc

Re: Perl-Mysql manual (.chm version)

2002-05-10 Thread Colin Faber
] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php

Re: My Query is TOOOOOOOOOOOO Slow :(

2002-05-03 Thread Colin Faber
, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http

  1   2   3   >